MySQL

The world’s most popular open source database.

From Wikipedia, the free encyclopedia…

MySQL (officially pronounced as “My S-Q-L”) is an open-source relational database management system (RDBMS); in July 2013, it was the world’s second most widely used RDBMS, and the most widely used open-source client–server model RDBMS.  It is named after co-founder Michael Widenius‘s daughter, My.  The SQL acronym stands for Structured Query Language. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements.  MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.  For proprietary use, several paid editions are available, and offer additional functionality.

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open-source web application software stack (and other “AMP” stacks).  LAMP is an acronym for “Linux, Apache, MySQL, Perl/PHP/Python“.  Free-software open-source projects that require a full-featured database management system often use MySQL.  Applications that use the MySQL database include: TYPO3MODx, Joomla, WordPress, phpBB, MyBB, Drupal and other software.  MySQL is also used in many high-profile, large-scale websites, including Google (though not for searches), FacebookTwitter, Flickr, and YouTube.

On all platforms except Windows, MySQL ships with no GUI tools to administer MySQL databases or manage data contained within the databases.  Users may use the included command line tools, or install MySQL Workbench via a separate download.  Many third party GUI tools are also available.

History

MySQL was created by a Swedish company, MySQL AB, founded by David Axmark, Allan Larsson and Michael “Monty” Widenius.  The first version of MySQL appeared on 23 May 1995.  It was initially created for personal usage from mSQL based on the low-level language ISAM, which the creators considered too slow and inflexible.  They created a new SQL interface, while keeping the same API as mSQL.  By keeping the API consistent with the mSQL system, many developers were able to use MySQL instead of the (proprietarily licensed) mSQL antecedent.

MySQL + Open Source Freedom = 24 x 7 Support

Many companies are hesitant to commit to and employ open source software.  The belief is they are left without recourse, that there is insufficient technical support on which they can rely.  For most, proprietary software provides comfort level, perceived or not, it’s compulsory, any other consideration is an overwhelming gamble to the success of their key applications.  MySQL is not typical open source software as it is owned and supported by Oracle, and because of this, a unique cost and support model are available, providing a unique combination of open source freedom and trusted software with support.

So go ahead make My(SQL) database!

moorescode