Difference between revisions of "MySQL"

From LIMSWiki
Jump to navigationJump to search
(Corrected internal link; added users section.)
m (Added rank info)
 
(5 intermediate revisions by the same user not shown)
Line 24: Line 24:
'''MySQL''' is the world's most used<ref>{{cite web |url=http://www.mysql.com/why-mysql/marketshare/ |title=MySQL :: Market Share |publisher=Oracle Corporation |accessdate=19 March 2012}}</ref> relational [[database management system]] (RDBMS)<ref>{{cite web |author=Schumacher, Robin; Arjen Lentz |title=Dispelling the Myths |publisher=Oracle Corporation |url=http://dev.mysql.com/tech-resources/articles/dispelling-the-myths.html |archiveurl=http://web.archive.org/web/20110606013619/http://dev.mysql.com/tech-resources/articles/dispelling-the-myths.html |archivedate=6 June 2011 |accessdate=19 March 2012}}</ref> that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My.<ref>{{cite web |url=http://dev.mysql.com/doc/refman/5.1/en/history.html |title=1.3.3. History of MySQL |work=MySQL 5.1 Reference Manual | publisher=Oracle Corporation |accessdate=19 March 2012}}</ref> The phrase "SQL" stands for "structured query language."<ref>{{cite web |url=http://dev.mysql.com/doc/refman/5.1/en/what-is-mysql.html |title=1.3.1. What is MySQL |work=MySQL 5.1 Reference Manual | publisher=Oracle Corporation |accessdate=19 March 2012}}</ref>
'''MySQL''' is the world's most used<ref>{{cite web |url=http://www.mysql.com/why-mysql/marketshare/ |title=MySQL :: Market Share |publisher=Oracle Corporation |accessdate=19 March 2012}}</ref> relational [[database management system]] (RDBMS)<ref>{{cite web |author=Schumacher, Robin; Arjen Lentz |title=Dispelling the Myths |publisher=Oracle Corporation |url=http://dev.mysql.com/tech-resources/articles/dispelling-the-myths.html |archiveurl=http://web.archive.org/web/20110606013619/http://dev.mysql.com/tech-resources/articles/dispelling-the-myths.html |archivedate=6 June 2011 |accessdate=19 March 2012}}</ref> that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My.<ref>{{cite web |url=http://dev.mysql.com/doc/refman/5.1/en/history.html |title=1.3.3. History of MySQL |work=MySQL 5.1 Reference Manual | publisher=Oracle Corporation |accessdate=19 March 2012}}</ref> The phrase "SQL" stands for "structured query language."<ref>{{cite web |url=http://dev.mysql.com/doc/refman/5.1/en/what-is-mysql.html |title=1.3.1. What is MySQL |work=MySQL 5.1 Reference Manual | publisher=Oracle Corporation |accessdate=19 March 2012}}</ref>


[[:Category:Open-source software|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<ref name="mysqlatgoogle">{{cite web |url=http://zurlocker.typepad.com/theopenforce/2005/12/googles_use_of_.html |title=Google Runs MySQL |author=Urlocker, Zack |publisher=TheOpenForce |date=13 December 2005 |accessdate=19 March 2012}}</ref> (though not for searches), Facebook,<ref name="mysqlatfacebook">{{cite web |url=http://www.youtube.com/watch?v=Zofzid6xIZ4 |title=O'Reilly MySQL CE 2010: Mark Callaghan, "MySQL at Facebook" |author=Callaghan, Mark; O'Reilly Media |publisher=YouTube |date=13 April 2010 |accessdate=19 March 2012}}</ref> and Twitter.<ref name="mypopescu1">{{cite web |url=http://nosql.mypopescu.com/post/4687379038/big-and-small-data-at-twitter-mysql-ce-2011 |title=Big and Small Data at Twitter: MySQL CE 2011 |author=Popescu, Alex |publisher=myNoSQL |date=17 April 2011 | accessdate=19 March 2012}}</ref>
[[:Category:Open-source software|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<ref name="mysqlatgoogle">{{cite web |url=http://zurlocker.typepad.com/theopenforce/2005/12/googles_use_of_.html |title=Google Runs MySQL |author=Urlocker, Zack |publisher=TheOpenForce |date=13 December 2005 |accessdate=19 March 2012}}</ref> (though not for searches), Facebook,<ref name="mysqlatfacebook">{{cite web |url=http://www.youtube.com/watch?v=Zofzid6xIZ4 |title=O'Reilly MySQL CE 2010: Mark Callaghan, "MySQL at Facebook" |author=Callaghan, Mark; O'Reilly Media |publisher=YouTube |date=13 April 2010 |accessdate=19 March 2012}}</ref> and Twitter.<ref name="mypopescu1">{{cite web |url=http://nosql.mypopescu.com/post/4687379038/big-and-small-data-at-twitter-mysql-ce-2011 |title=Big and Small Data at Twitter: MySQL CE 2011 |author=Popescu, Alex |publisher=myNoSQL |date=17 April 2011 | accessdate=19 March 2012}}</ref>


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.<ref>{{cite web |url=http://www.mysql.com/products/ |title=MySQL Editions |publisher=Oracle Corporation |accessdate=19 March 2012}}</ref>
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.<ref>{{cite web |url=http://www.mysql.com/products/ |title=MySQL Editions |publisher=Oracle Corporation |accessdate=19 March 2012}}</ref>
Line 33: Line 33:


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<ref name="sunacquire">{{cite web |url=http://www.information-management.com/news/10000940-1.html | title=Sun Microsystems Announces Completion of MySQL Acquisition |publisher=Information Management | date=26 February 2008 |accessdate=19 March 2012}}</ref>, but Sun was then acquired by Oracle Corporation in 2010.<ref>{{cite web |url=http://europa.eu/rapid/pressReleasesAction.do?reference=IP/10/40 |title=Mergers: Commission clears Oracle's proposed acquisition of Sun Microsystems |publisher=EUROPA |date=21 January 2010 |accessdate=19 March 2012}}</ref> Oracle assured users the open-source community edition would still be actively supported, and "core features will end up in community edition."<ref>{{cite web |url=http://www.thestreet.com/story/10724728/2/the-future-of-mysql-according-to-oracle.html |title=The Future Of MySQL According To Oracle |author=International Data Group |publisher=The Street |date=13 April 2010 |accessdate=19 March 2012}}</ref>
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<ref name="sunacquire">{{cite web |url=http://www.information-management.com/news/10000940-1.html | title=Sun Microsystems Announces Completion of MySQL Acquisition |publisher=Information Management | date=26 February 2008 |accessdate=19 March 2012}}</ref>, but Sun was then acquired by Oracle Corporation in 2010.<ref>{{cite web |url=http://europa.eu/rapid/pressReleasesAction.do?reference=IP/10/40 |title=Mergers: Commission clears Oracle's proposed acquisition of Sun Microsystems |publisher=EUROPA |date=21 January 2010 |accessdate=19 March 2012}}</ref> Oracle assured users the open-source community edition would still be actively supported, and "core features will end up in community edition."<ref>{{cite web |url=http://www.thestreet.com/story/10724728/2/the-future-of-mysql-according-to-oracle.html |title=The Future Of MySQL According To Oracle |author=International Data Group |publisher=The Street |date=13 April 2010 |accessdate=19 March 2012}}</ref>
{{As of|May 2014}}, DB-Engines' Ranking of Relational DBMS ranked PostgreSQL as the 2nd most popular RDBMS out of 83.<ref name="DBERanks">{{cite web |url=http://db-engines.com/en/ranking/relational+dbms |title=DB-Engines Ranking of Relational DBMS |publisher=solid IT |accessdate=30 May 2014}}</ref>


==Features==
==Features==
Line 71: Line 73:
* [http://www.youtube.com/playlist?list=PLFC1903317C74C043&feature=plcp PrimeTuber's YouTube channel]
* [http://www.youtube.com/playlist?list=PLFC1903317C74C043&feature=plcp PrimeTuber's YouTube channel]


==Companies using MySQL==
==Entities using MySQL==


Examples of companies that use MySQL include:
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 Scientific|Thermo Fisher Scientific]], Toyota France and South Africa, UNICEF, UPS, Westone Laboratories, Yamaha
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 Scientific|Thermo Fisher Scientific]], Toyota France and South Africa, UNICEF, UPS, Westone Laboratories, Yamaha
Line 87: Line 89:
* [http://www.dmoz.org/Computers/Software/Databases/MySQL/ MySQL] at the Open Directory Project
* [http://www.dmoz.org/Computers/Software/Databases/MySQL/ MySQL] at the Open Directory Project
* [http://planet.mysql.com/ Planet MySQL], an aggregation of MySQL-related blogs
* [http://planet.mysql.com/ Planet MySQL], an aggregation of MySQL-related blogs
* [http://db-engines.com/en/ranking/relational+dbms DB-Engines Ranking of Relational DBMS]


==References==
==References==
Line 93: Line 96:
<!---Place all category tags here-->
<!---Place all category tags here-->
[[Category:Database management software (open source)]]
[[Category:Database management software (open source)]]
[[Category:Software development tool (open source)]]

Latest revision as of 15:20, 30 May 2014

MySQL
MySQL Logo.png
Developer(s) Oracle Corporation
Initial release May 23, 1995 (1995-05-23)
Stable release

5.7.38, 8.0.29  (April 26, 2022; 29 days ago (2022-04-26))

[±]
Preview release 8.0.3 RC  (September 21, 2017; 4 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.