The History and Future of the MySQL ecosystem

Circa 2013 - This document provides an overview of the history and ecosystem of MySQL. It discusses how MySQL originated in Sweden in the 1990s and was later acquired by Sun Microsystems and Oracle. It describes major versions and features added over time. It also summarizes the various distributions, storage engines, patches, and alternatives that have emerged, including Percona Server, MariaDB, MySQL Cluster, and NoSQL options. The document concludes with predictions that MySQL 5.7 may make InnoDB the only storage engine and notes MariaDB will continue to diverge from Oracle MySQL.

Transcript

1. The History and Future of the MySQL Ecosystem New York Linux User Group (NYLUG) Ronald Bradford http://ronaldbradford.com 2013.06
2. Image from http://livelikeliam.blogspot.com Spaghetti and MySQLBalls (with a side of greens)
3. EffectiveMySQL.com - Performance, Scalability & Business Continuity ABOUT MySELF Enterprise Data Architecture & Developer 24 years with RDBMS - 13 years with MySQL Published author - 4 books Accomplished presenter - 8 years Work at Independent MySQL Consultant Seeking new clients Ronald BRADFORD
4. EffectiveMySQL.com - Performance, Scalability & Business Continuity covering MySQL Some history Distributions/Variants Patches Storage Engines Alternatives Vendors
5. EffectiveMySQL.com - Performance, Scalability & Business Continuity A long time ago(*), in a small nordic country far, far away ... (*) 10,000,000 seconds and counting
6. 1994 1996 MySQL (.com) 1998 2001 v3.23 v4.0 2003 2004 v4.1 v5.0 2005 2008 BEFORE
7. 1994 1996 MySQL (.com) 1998 2001 v3.23 v4.0 2003 2004 v4.1 v5.0 2005 2008 BEFORE
8. 1994 1996 MySQL (.com) 1998 2001 v3.23 v4.0 2003 2004 v4.1 v5.0 2005 Sun (.com) 2008 BEFORE
9. 1994 1996 MySQL (.com) 1998 2001 v3.23 v4.0 2003 2004 v4.1 v5.0 2005 Sun (.com) 2008 BEFORE 1995 Innobase 2005
10. 1994 1996 MySQL (.com) 1998 2001 v3.23 v4.0 2003 2004 v4.1 v5.0 2005 Sun (.com) 2008 BEFORE 1995 Innobase Oracle (.com) 2005
11. EffectiveMySQL.com - Performance, Scalability & Business Continuity popularity MySQL - the world's most widely use open source RDBMS Inclusion in Linux distributions The ‘M’ of LAMP Stack
12. MySQL (.com) 2008 v5.1 v5.0 2005 Sun (.com) 2008 During v5.2 v6.0 X X 4/21/2009 v5.4 beta X
13. MySQL (.com) 2008 v5.1 v5.0 2005 Sun (.com) 2008 During v5.2 v6.0 X X 4/21/2009 v5.4 beta X
14. MySQL (.com) 2008 v5.1 v5.0 2005 Sun (.com) 2008 During v5.2 v6.0 X X 4/21/2009 v5.4 beta X Oracle (.com) 4/20/2009 Acquisition announcement
15. MySQL (.com) 2008 v5.1 v5.0 2005 Sun (.com) 2008 During v5.2 v6.0 X X 4/21/2009 v5.4 beta X Oracle (.com) 4/20/2009 Acquisition announcement Proven Scaling 2006 2009
16. MySQL (.com) 2008 v5.1 v5.0 2005 Sun (.com) 2008 During v5.2 v6.0 X X 4/21/2009 v5.4 beta X Oracle (.com) 4/20/2009 Acquisition announcement Proven Scaling Our Delta 2006 2009 2008 2011
17. Now 12/2010 v5.5 3/2013 v5.6 Sun (.com) July 2013 4/2009 1/2010
18. Now Oracle (.com) 12/2010 v5.5 3/2013 v5.6 Sun (.com) July 2013 4/2009 1/2010
19. Now Oracle (.com) 12/2010 v5.5 3/2013 v5.6 Sun (.com) Percona Server 2006 4/2011 v5.5 4/2009 v1.0.3 7/2010 v5.1 ? July 2013 ???? v5.6 4/2009 1/2010
20. Now Oracle (.com) 12/2010 v5.5 3/2013 v5.6 Sun (.com) Percona Server Maria DB 2006 2009 4/2011 v5.5 4/2009 v1.0.3 7/2010 v5.1 ? July 2013 ???? v5.6 4/2009 1/2010 4/12 v5.5 11/10 v5.2 2/12 V5.3 2/10 v5.1 ? ???? v10.0
21. https://en.wikipedia.org/wiki/MySQL
22. EffectiveMySQL.com - Performance, Scalability & Business Continuity truths MySQL to Sun Acquisition (~ 6 weeks) Sun to Oracle Acquisition (~9 months) Oracle did not acquire MySQL It was part of Sun MySQL is and always will be in some form (*) available as GPL
23. EffectiveMySQL.com - Performance, Scalability & Business Continuity Distributions/Variants
24. EffectiveMySQL.com - Performance, Scalability & Business Continuity Recap 1. Oracle/MySQL Community/Enterprise (2 years) 2. Percona Server 3. MariaDB Moving away from full compatibility Most flexible for community 4. Storage Engine specific (*) Distributions/V ariants
25. EffectiveMySQL.com - Performance, Scalability & Business Continuity Distros Moving to MariaDB Fedora 19 SUSE 12.3 Ubuntu (currently both) Expanding ‘M’ in LAMP
26. EffectiveMySQL.com - Performance, Scalability & Business Continuity Storage Engines
27. EffectiveMySQL.com - Performance, Scalability & Business Continuity Storage Engines A storage engine provides a means to store and/or retrieve data via the MySQL SQL interface.
28. EffectiveMySQL.com - Performance, Scalability & Business Continuity storage engines Different locking strategies Indexing algorithms Transactional capabilities ACID characteristics Improving Performance
29. EffectiveMySQL.com - Performance, Scalability & Business Continuity Storage Engines MyISAM (Default before 5.5) InnoDB (Default since 5.5) Memory/Archive/Federated/Merge/ Blackhole/CSV/Example/BDB stock
30. EffectiveMySQL.com - Performance, Scalability & Business Continuity PSEA Pluggable Storage Engine Architecture (PSEA) Enabling third party providers Since 5.1 (circa 2006) http://dev.mysql.com/doc/refman/5.1/en/pluggable-storage-overview.html
31. EffectiveMySQL.com - Performance, Scalability & Business Continuity storage engines Why develop a storage engine?
32. EffectiveMySQL.com - Performance, Scalability & Business Continuity Base variants InnoDB InnoDB built-in (3.2.23 - v 5.1) InnoDB plugin (v 5.1+) XtraDB (Percona/MariaDB) Schooner MyISAM Aria
33. EffectiveMySQL.com - Performance, Scalability & Business Continuity early PSE NitroEDB PBXT Blob Streaming Kickfire File System Akiban (***) SolidDB Spider Falcon More...
34. EffectiveMySQL.com - Performance, Scalability & Business Continuity TODAY Tokutek DeepDB Data Warehousing Infobright - Brighthouse Calpont - InfiniDB
35. EffectiveMySQL.com - Performance, Scalability & Business Continuity Other PSE Sphinx IBM DB/2 Cassandra OQGraph <your name here>?
36. EffectiveMySQL.com - Performance, Scalability & Business Continuity Ecosystem
37. EffectiveMySQL.com - Performance, Scalability & Business Continuity patches Proven Scaling Google Facebook eBay Twitter Storage Engine Providers
38. EffectiveMySQL.com - Performance, Scalability & Business Continuity Alternatives Drizzle libdrizzle Galera Percona XtraDB Cluster Maria Galera ScaleDB Tungsten Replicator
39. EffectiveMySQL.com - Performance, Scalability & Business Continuity Cloud AWS RDS for MySQL Google Cloud SQL HP/Openstack DBaaS Percona Server Drizzle???
40. EffectiveMySQL.com - Performance, Scalability & Business Continuity imitators Use the MySQL protocol Clustrix Xeround Unclear of internals GenieDB ClearDB
41. EffectiveMySQL.com - Performance, Scalability & Business Continuity connectivity Scale Base Parelastic Thu June 20 http://www.meetup.com/EffectiveMySQL/
42. EffectiveMySQL.com - Performance, Scalability & Business Continuity Support Ecosystem now provides options Oracle Support Percona Support Monty Program/SkySQL Freedom of per incident not subscription
43. EffectiveMySQL.com - Performance, Scalability & Business Continuity Today
44. EffectiveMySQL.com - Performance, Scalability & Business Continuity mysql 5.6 http://effectivemysql.com/presentation/mysql-5-6-features-for- nosql-big-data-and-the-cloud/ http://effectivemysql.com/presentation/new-mysql-5-6- replication-features/
45. EffectiveMySQL.com - Performance, Scalability & Business Continuity tokutek Well Established Boston/New York Team Now Open source Community/Enterprise http://www.tokutek.com/ http://effectivemysql.com/article/understanding-tokutek-fractal-tree-indexes/
46. EffectiveMySQL.com - Performance, Scalability & Business Continuity deepDB Recently released Commercial only Formally called CloudTree http://deep.is/
47. EffectiveMySQL.com - Performance, Scalability & Business Continuity Going Green
48. EffectiveMySQL.com - Performance, Scalability & Business Continuity NO SQL MySQL Cluster MySQL [NDB] Cluster My(SQL) + NDB Cluster Handler Socket Memcache API (MySQL & MySQL Cluster)
49. EffectiveMySQL.com - Performance, Scalability & Business Continuity No SQL Key/Value Store Document Store Graph Memcache/Redis/Mongo/Cassandra/ Riak/CouchDB/Tokyo Cabinet/..... Most companies use multiple products
50. EffectiveMySQL.com - Performance, Scalability & Business Continuity Why not both?
51. EffectiveMySQL.com - Performance, Scalability & Business Continuity Akiban DBaaS platform for developers One data model, document and relational access REST (JSON) , SQL, FullText Import from MySQL http://www.akiban.com/
52. EffectiveMySQL.com - Performance, Scalability & Business Continuity Tips for SysAdmin
53. EffectiveMySQL.com - Performance, Scalability & Business Continuity for sysadmins Keep versions up to date Tune for memory Storage Engine specifics Replication is not Backup & Recovery Be prepared for a disaster
54. EffectiveMySQL.com - Performance, Scalability & Business Continuity Size/Engines DB Size / Storage Engines $ wget http://ronaldbradford.com/mysql-dba/allschemas.sql $ mysql -uroot -p -vvv < allschemas.sql http://ronaldbradford.com/mysql-dba/
55. EffectiveMySQL.com - Performance, Scalability & Business Continuity Essential config MyISAM Key Buffer (Indexes Only) InnoDB Buffer Pool (Data + Indexes) Query Cache (High Read/Write ratio)
56. EffectiveMySQL.com - Performance, Scalability & Business Continuity FOR SYSADMINS Binary logging is essential for backup and recovery #my.cnf [mysqld] server-id=1 log-bin
57. EffectiveMySQL.com - Performance, Scalability & Business Continuity Tomorrow
58. EffectiveMySQL.com - Performance, Scalability & Business Continuity
59. EffectiveMySQL.com - Performance, Scalability & Business Continuity Tomorrow NOTE: The following are only wild guesses with no basis of FACT 5.7 Will happen, will be better InnoDB only (MyISAM/Memory) replaced, others dropped Maria will continue to diverge What of MySQL 5.7
60. EffectiveMySQL.com - Performance, Scalability & Business Continuity http://effectiveMySQL.com Ronald Bradford