MySQL: Difference between revisions
imported>Michael Cooper (Added a little more history to the article) |
imported>Eric M Gearhart (Cleaned up some wording, fixed Apache link) |
||
| Line 1: | Line 1: | ||
'''MySQL''' is a popular cross-platform Database Management System. It uses the [[SQL]](Structured Query Language) syntax for scripting queries. | '''MySQL''' is a popular cross-platform Database Management System. It uses the [[SQL]] (Structured Query Language) syntax for scripting queries. | ||
MySQL's primary use is in storing data for websites that need to have dynamically generated content. It is commonly used with the [[Apache | MySQL's primary use is in storing data for websites that need to have dynamically generated content. It is commonly used with the [[Apache HTTP Server|Apache Wen Server]] and the [[PHP]] or [[perl]] programming languages. | ||
It is an integral component of the '''LAMP''' application stack | |||
([[Linux]]/Apache/MySQL/PHP or perl) | |||
The popularity of [[PHP]], which commonly supports MySQL, makes it a popular choice for many developers. Until recently it was not seen as a serious contender against [[MSSQL]] and [[Oracle]], but with the recent additions of an enterprise level server with [[clustering]] support it has started gaining acceptance as a robust [[database]] server solution that large businesses can rely on. | |||
An [[Open Source]] [[SQL]] [[Server]], MySQL is developed, distributed and supported by the [[Swedish]] for-profit company [[MySQL AB]] who holds the copyright on the software. Unlike other SQL servers, MySQL is pronounced "My ESS Que Ell", not "My See Kwell". | An [[Open Source]] [[SQL]] [[Server]], MySQL is developed, distributed and supported by the [[Swedish]] for-profit company [[MySQL AB]] who holds the copyright on the software. Unlike other SQL servers, MySQL is pronounced "My ESS Que Ell", not "My See Kwell". | ||
Revision as of 09:07, 8 April 2007
MySQL is a popular cross-platform Database Management System. It uses the SQL (Structured Query Language) syntax for scripting queries.
MySQL's primary use is in storing data for websites that need to have dynamically generated content. It is commonly used with the Apache Wen Server and the PHP or perl programming languages. It is an integral component of the LAMP application stack (Linux/Apache/MySQL/PHP or perl)
The popularity of PHP, which commonly supports MySQL, makes it a popular choice for many developers. Until recently it was not seen as a serious contender against MSSQL and Oracle, but with the recent additions of an enterprise level server with clustering support it has started gaining acceptance as a robust database server solution that large businesses can rely on.
An Open Source SQL Server, MySQL is developed, distributed and supported by the Swedish for-profit company MySQL AB who holds the copyright on the software. Unlike other SQL servers, MySQL is pronounced "My ESS Que Ell", not "My See Kwell".
History
Initially developed by Michael (Monty) Widenius in the mid 1990s to provide functionality that was missing from mSQL (one of the few Open Source databases available at the time), MySQL’s goal was to provide a foundation for developers looking to create web-based applications. The first version of the server was developed in May of 1995 with the release to the Open Source community made sometime after that (date needed).
MySQL moved to the GNU General Public License (GPL) in June of 2000.
The addition of MySQL in Red Hat Linux 7 in September of 2000 was a significant event in the increasing popularity of the database server, though even at that time (according to Michael Widenius of MySQL AB) it was the most used database server in the Linux world.
Version 4 of the MySQL Server was released in October of 2001.
Version 5 of the MySQL Server was released in December of 2003 and included such enterprise additions as the MySQL Enterprise and MySQL Cluster Server. This was a new direction for MySQL AB as both of these versions of the server require per CPU licensing similar to MSSQL.