MySQL

From LIMSWiki
Jump to: navigation, search
MySQL
MySQL Logo.png
Developer(s) Oracle Corporation
Initial release May 23, 1995 (1995-05-23)
Stable release

5.7.29, 8.0.19  (January 13, 2020; 39 days ago (2020-01-13))

[±]
Preview release 8.0.3 RC  (September 21, 2017; 2 years ago (2017-09-21)) [±]
Written in C, C++[1]
Operating system Cross-platform
Type Database management software
License(s) GNU General Public License or proprietary EULA
Website MySQL.com

MySQL is the world's most used[2] relational database management system (RDBMS)[3] that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My.[4] The phrase "SQL" stands for "structured query language."[5]

Open source projects that require a full-featured database management system often use MySQL. Applications which use MySQL databases include: TYPO3, Joomla, WordPress, phpBB, Drupal, and other software built on the LAMP software stack. MySQL is also used in many high-profile, large-scale Web products, including Wikipedia, Google[6] (though not for searches), Facebook,[7] and Twitter.[8]

The free open-source version of MySQL is commonly referred to as the MySQL Community Edition. For commercial use, several paid editions are also available, offering additional functionality.[9]

Product history

Michael Widenius and David Axmark first began coding MySQL in 1994[10] The MySQL development project originally 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. Sun Microsystems completed its acquisition of MySQL in February 2008[11], but Sun was then acquired by Oracle Corporation in 2010.[12] Oracle assured users the open-source community edition would still be actively supported, and "core features will end up in community edition."[13]

As of May 2014, DB-Engines' Ranking of Relational DBMS ranked PostgreSQL as the 2nd most popular RDBMS out of 83.[14]

Features

Primary features of MySQL Server Community Edition include:

  • a broad subset of ANSI SQL 99, as well as extensions
  • cross-platform support
  • stored procedures
  • triggers and cursors
  • updatable views
  • information schema
  • X/Open XA distributed transaction processing (DTP) support
  • independent storage engines
  • transactions with the InnoDB, and Cluster storage engines; savepoints with InnoDB
  • SSL support
  • query caching
  • sub-SELECTs (i.e. nested SELECTs)
  • replication support
  • full-text indexing and searching using MyISAM engine
  • embedded database library
  • partial Unicode support (UTF-8 and UCS-2 encoded strings are limited to the BMP)
  • partitioned tables

More about the features of the open-source MySQL Community Edition are available on Oracle's site.

Hardware/software requirements

Check the MySQL Reference Manual for help with installation and system requirements for MySQL 5.5.

Additional installation help can be found here.

Videos, screenshots, and other media

Several YouTube sources exist for beginner video tutorials:

Entities using MySQL

Examples of entities that use MySQL include:

ABS Nautical Systems LLC, Alstom, Argonne National Laboratory, BASE: BioArray Software Environment, Bayer, Bio-Rad Laboratories, Cardinal Health, Center for Biological Sequence Analysis, Colgate, Eli Lilly, ENERCON, Finnish National Public Health Institute, Genome Sciences Center (GSC), Institut Curie, Lafarge, Smurfit-Stone, Swisslog, SYNNEX Corporation, Thermo Fisher Scientific, Toyota France and South Africa, UNICEF, UPS, Westone Laboratories, Yamaha

A full directory of MySQL users and case studies can be found at the MySQL website.

Further reading

External links

References

  1. "MySQL - Ohloh". Black Duck Software, Inc. http://www.ohloh.net/p/mysql/analyses/latest. Retrieved 19 March 2012. 
  2. "MySQL :: Market Share". Oracle Corporation. http://www.mysql.com/why-mysql/marketshare/. Retrieved 19 March 2012. 
  3. Schumacher, Robin; Arjen Lentz. "Dispelling the Myths". Oracle Corporation. Archived from the original on 6 June 2011. http://web.archive.org/web/20110606013619/http://dev.mysql.com/tech-resources/articles/dispelling-the-myths.html. Retrieved 19 March 2012. 
  4. "1.3.3. History of MySQL". MySQL 5.1 Reference Manual. Oracle Corporation. http://dev.mysql.com/doc/refman/5.1/en/history.html. Retrieved 19 March 2012. 
  5. "1.3.1. What is MySQL". MySQL 5.1 Reference Manual. Oracle Corporation. http://dev.mysql.com/doc/refman/5.1/en/what-is-mysql.html. Retrieved 19 March 2012. 
  6. Urlocker, Zack (13 December 2005). "Google Runs MySQL". TheOpenForce. http://zurlocker.typepad.com/theopenforce/2005/12/googles_use_of_.html. Retrieved 19 March 2012. 
  7. Callaghan, Mark; O'Reilly Media (13 April 2010). "O'Reilly MySQL CE 2010: Mark Callaghan, "MySQL at Facebook"". YouTube. http://www.youtube.com/watch?v=Zofzid6xIZ4. Retrieved 19 March 2012. 
  8. Popescu, Alex (17 April 2011). "Big and Small Data at Twitter: MySQL CE 2011". myNoSQL. http://nosql.mypopescu.com/post/4687379038/big-and-small-data-at-twitter-mysql-ce-2011. Retrieved 19 March 2012. 
  9. "MySQL Editions". Oracle Corporation. http://www.mysql.com/products/. Retrieved 19 March 2012. 
  10. "Five Questions With Michael Widenius - Founder And Original Developer of MySQL". Opensourcereleasefeed.com. 2009. Archived from the original on 12 February 2009. http://web.archive.org/web/20090211104630/http://www.opensourcereleasefeed.com/interview/show/five-questions-with-michael-widenius-founder-and-original-developer-of-mysql. Retrieved 19 March 2012. 
  11. "Sun Microsystems Announces Completion of MySQL Acquisition". Information Management. 26 February 2008. http://www.information-management.com/news/10000940-1.html. Retrieved 19 March 2012. 
  12. "Mergers: Commission clears Oracle's proposed acquisition of Sun Microsystems". EUROPA. 21 January 2010. http://europa.eu/rapid/pressReleasesAction.do?reference=IP/10/40. Retrieved 19 March 2012. 
  13. International Data Group (13 April 2010). "The Future Of MySQL According To Oracle". The Street. http://www.thestreet.com/story/10724728/2/the-future-of-mysql-according-to-oracle.html. Retrieved 19 March 2012. 
  14. "DB-Engines Ranking of Relational DBMS". solid IT. http://db-engines.com/en/ranking/relational+dbms. Retrieved 30 May 2014.