MySQL Logo.png
Screenshot of the default MySQL command-line banner and prompt
Screenshot of the default MySQL command-line banner and prompt
Original author(s)MySQL AB
Developer(s)Oracle Corporation
Initial release23 May 1995 (1995-05-23)
Stable release
8.0.21[1] / 2020-07-13[±]
Repository Edit this at Wikidata
Written inC, C++[2]
Operating systemLinux, Solaris, macOS, Windows, FreeBSD[3]
Available inEnglish
LicenseGPLv2 or proprietary[4]

MySQL (/ˌmˌɛsˌkjuːˈɛl/ "My S-Q-L")[5] is an open-source relational database management system (RDBMS).[5][6] Its name is a combination of "My", the name of co-founder Michael Widenius's daughter,[7] and "SQL", the abbreviation for Structured Query Language. A relational database organizes data into one or more data tables in which data types may be related to each other; these relations help structure the data. SQL is a language programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.

MySQL is free and open-source software under the terms of the GNU General Public License, and is also available under a variety of proprietary licenses. MySQL was owned and sponsored by the Swedish company MySQL AB, which was bought by Sun Microsystems (now Oracle Corporation).[8] In 2010, when Oracle acquired Sun, Widenius forked the open-source MySQL project to create MariaDB.[9]

MySQL has stand-alone clients that allow users to interact directly with a MySQL database using SQL, but more often MySQL is used with other programs to implement applications that need relational database capability. MySQL is a component of the LAMP web application software stack (and others), which is an acronym for Linux, Apache, MySQL, Perl/PHP/Python. MySQL is used by many database-driven web applications, including Drupal, Joomla, phpBB, and WordPress. MySQL is also used by many popular websites, including Facebook,[10][11] Flickr,[12] MediaWiki,[13] Twitter,[14] and YouTube.[15]

  1. ^ "MySQL 8.0 Release Notes". Retrieved 14 July 2020.
  2. ^ "MySQL: Project Summary". Ohloh. Black Duck Software. Retrieved 17 September 2012.
  3. ^ "Supported Platforms: MySQL Database". Oracle. Retrieved 24 March 2014.
  4. ^ "Downloads". MySQL. Retrieved 3 August 2014.
  5. ^ a b "What is MySQL?". MySQL 8.0 Reference Manual. Oracle Corporation. Retrieved 3 April 2020. The official way to pronounce "MySQL" is "My Ess Que Ell" (not "my sequel"), but we do not mind if you pronounce it as "my sequel" or in some other localized way.
  6. ^ "DB-Engines Ranking of Relational DBMS". DB-Engines. solidIT consulting & software development GmbH. Retrieved 3 April 2020.
  7. ^ "History of MySQL". MySQL 8.0 Reference Manual. Oracle Corporation. Retrieved 3 April 2020. MySQL is named after co-founder Monty Widenius's daughter, My.
  8. ^ "Sun Microsystems Announces Completion of MySQL Acquisition; Paves Way for Secure, Open Source Platform to Power the Network Economy" (Press release). Sun Microsystems. 26 February 2008. Archived from the original on 28 February 2008. Retrieved 17 September 2012.
  9. ^ Pearce, Rohan (28 March 2013). "Dead database walking: MySQL's creator on why the future belongs to MariaDB". Computerworld. Retrieved 3 April 2020. The day the Sun purchase was announced, Widenius responded […] — he forked MySQL, launching MariaDB […]
  10. ^ Sobel, Jason (21 December 2007). "Keeping Up". The Facebook Blog. Facebook. Archived from the original on 18 June 2009. Retrieved 18 June 2009. […] Facebook's data is stored in MySQL database servers […]
  11. ^ Matsunobu, Yoshinori (31 August 2016). "MyRocks: A space- and write-optimized MySQL database". Facebook Engineering. Archived from the original on 7 March 2020. Retrieved 7 March 2020. At Facebook we use MySQL to manage many petabytes of data, along with the InnoDB storage engine […]
  12. ^ Elliott-McCrea, Kellan (8 February 2010). "Using, Abusing and Scaling MySQL at Flickr". Retrieved 3 April 2020. […] at Flickr, MySQL is our hammer, and we use it for nearly everything. It’s our federated data store, our key-value store, and our document store.
  13. ^ "Manual:MySQL". MediaWiki, The Free Wiki Engine. Retrieved 3 April 2020. The MySQL and MariaDB database engines are the most commonly-used database backends for MediaWiki.
  14. ^ Hashemi, Mazdak (19 January 2017). "The Infrastructure Behind Twitter: Scale". Retrieved 3 April 2020. SQL: This includes MySQL, PostgreSQL and Vertica. MySQL/PosgreSQL are used where we need strong consistency […]
  15. ^ "MySQL Customer: YouTube". Oracle. Retrieved 17 September 2012.

Powered by 654 easy search