Technologies

MySQL

MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP web application software stack—LAMP is an acronym for "Linux, Apache, MySQL, Perl/PHP/Python".

Many programming languages with language-specific APIs include libraries for accessing MySQL databases. These include MySQL Connector/Net for integration with Microsoft's Visual Studio (languages such as C# and VB are most commonly used) and the ODBC driver for Java. In addition, an ODBC interface called MyODBC allows additional programming languages that support the ODBC interface to communicate with a MySQL database, such as ASP or ColdFusion. The HTSQL - URL based query method also ships with a MySQL adapter, allowing direct interaction between a MySQL database and any web client via structured URLs. The MySQL server and official libraries are mostly implemented in ANSI C/ANSI C++.

Features

Cross-platform support
Stored procedures
Triggers
Cursors
Updatable Views
True support
Information schema
Strict mode further explanation needed
distributed transaction processing (DTP) support; two phase commit as part of this, using Oracle's InnoDB engine
Independent storage engines for read speed, InnoDB for transactions and referential integrityMySQL Archive for storing historical data in little space)
Transactions with the InnoDB, BDB and Cluster storage engines; savepoints with InnoDB
SSL
Query caching
Replication support (i.e. Master-Master Replication & Master-Slave Replication) with one master per slave, many slaves per master, no automatic support for multiple masters per slave.
Full-text indexing and searching using MyISAM engine
Embedded database library
Partial Unicode support
Partial ACID compliance (full compliance only when using the non-default storage engines InnoDB, BDB and Cluster)
Partititoned tables with pruning of partitions in optimiser
clustering through MySQL Cluster
Hot backup under certain conditions