Difference between revisions of "MySQL"

From LIMSWiki
Jump to navigationJump to search
m (Added internal link.)
m (Added internal link.)
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>

Revision as of 00:30, 11 January 2013

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

8.0.37  (April 30, 2024; 6 months ago (2024-04-30))

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

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

  • MySQL at the Open Directory Project
  • Planet MySQL, an aggregation of MySQL-related blogs

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. 
Retrieved from "https://www.limswiki.org/index.php?title=MySQL&oldid=9608"