Difference between revisions of "MySQL"
Shawndouglas (talk | contribs) m (Added internal link.) |
Shawndouglas (talk | contribs) m (Added rank info) |
||
| 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 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== | ||
Revision as of 15:20, 30 May 2014
 | |
| Developer(s) | Oracle Corporation |
|---|---|
| Initial release | May 23, 1995 |
| Stable release |
8.0.37 (April 30, 2024) [±] |
| Preview release | 8.0.3 RC (September 21, 2017) [±] |
| 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[update], 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
- "MySQL Documentation Library". Oracle Corporation. http://dev.mysql.com/doc/index.html.
External links
- MySQL at the Open Directory Project
- Planet MySQL, an aggregation of MySQL-related blogs
- DB-Engines Ranking of Relational DBMS
References
- ↑ "MySQL - Ohloh". Black Duck Software, Inc. http://www.ohloh.net/p/mysql/analyses/latest. Retrieved 19 March 2012.
- ↑ "MySQL :: Market Share". Oracle Corporation. http://www.mysql.com/why-mysql/marketshare/. Retrieved 19 March 2012.
- ↑ 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.
- ↑ "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.
- ↑ "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.
- ↑ Urlocker, Zack (13 December 2005). "Google Runs MySQL". TheOpenForce. http://zurlocker.typepad.com/theopenforce/2005/12/googles_use_of_.html. Retrieved 19 March 2012.
- ↑ 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.
- ↑ 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.
- ↑ "MySQL Editions". Oracle Corporation. http://www.mysql.com/products/. Retrieved 19 March 2012.
- ↑ "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.
- ↑ "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.
- ↑ "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.
- ↑ 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.
- ↑ "DB-Engines Ranking of Relational DBMS". solid IT. http://db-engines.com/en/ranking/relational+dbms. Retrieved 30 May 2014.
