Multi-user Relational Database System
MySQL (pronounced "my ess cue el") is a free open source relational database management system (RDBMS) that uses Structured Query Language (SQL), the most popular language for adding, accessing, and processing data in a database.
It is a multithreaded, multi-user, database management
system with an estimated six million installations. MySQL is open source software available either under the GNU General Public License
(GPL) or under other licenses when the GPL is inapplicable to the intended use.
In conjunction with the PHP scripting language, it is the database system used in the osCommerce engine that
is the basis of our AeroCART online shopping cart system (see
Being open source, anyone can download MySQL and tailor it to their needs in accordance with the general public license. MySQL is noted mainly for its speed, reliability, and flexibility.
Most developers would agree that it works best when managing content and not executing transactions.
Unlike projects where the software is developed by a public community, and is essentially not owned by anyone, MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB. The company develops and maintains the system, selling support and service contracts, as well as commercially-licensed copies of MySQL, and employing people all over the world who work together via the Internet. Two Swedes and a Finn founded MySQL AB: David Axmark, Allan Larsson and Michael "Monty" Widenius.
MySQL is popular for web applications like Wikipedia and PHP-Nuke and acts as the database component of LAMP. The popularity as a web application is closely tied to the popularity of PHP, which is often combined with MySQL and nicknamed the Dynamic Duo. It is easy to find many references that combine the two in websites and books (PHP and MySQL for Dummies, PHP and MySQL Bible, Beginning PHP and MySQL, etc.) The claim made in many books is that MySQL is easier to learn and use than many other database applications.
As of 2005, MySQL offers production version 4.1.14. It includes the following features:
* A broad subset of ANSI SQL 99, as well as extensions
* Cross-platform support
* Independent storage engines (MyISAM for read speed, InnoDB for transactions and referential integrity)
* Transactions, including savepoints
* SSL support
* Query caching
* Sub-SELECTs (or nested SELECTs)
* Replication with one master per slave, many slaves per master
* Full-text indexing and searching using MyISAM engine
* Embedded database library
* Full Unicode support
* ACID compliance using InnoDB engine
* Shared-nothing clustering through MySQL Cluster
It does not include the following features:
* Stored procedures
* Multi-master replication