MySQL: Scaling and High Availability

1 . MySQL: Scaling & High Availability Production experience for the last decade(s) Peter Zaitsev, CEO, Percona June 19, 2018 Percona Technical Webinars © 2018 Percona. 1 

2 .Lets go to the start of my MySQL story Going back almost 2 decades © 2018 Percona. 2 

3 .My S-Q-L: Wikipedia MySQL (/ˌmaɪˌɛsˌkjuːˈɛl/ "My S-Q-L")[5] Its name is a combination of "My", the name of co-founder Michael Widenius's daughter,[7] and "SQL", the abbreviation for Structured Query Language. © 2018 Percona. 3 

4 .July 1997 - MySQL Early Days © 2018 Percona. 4 

5 .1999 © 2018 Percona. 5 

6 .My First MySQL Experience © 2018 Percona. 6 

7 .MySQL in 1999 MySQL 3.23 Alpha MyISAM storage engine just introduced Michael “Monty” Widenius personally reply to most MySQL issues © 2018 Percona. 7 

8 .MySQL Challenges in 1999 MyISAM Table Locks Frequent Crashes (using Alpha software) 2GB File Size Limit on Linux MyISAM Table Checks and Repairs take very long time © 2018 Percona. 8 

9 .MySQL “Tricks” in 1999 Sharding for Scalability Single Node Sharding to avoid Table Locks Building Lots of Summary Tables © 2018 Percona. 9 

10 .MySQL in 2000 © 2018 Percona. 10 

11 .MySQL in 2001 MySQL 3.23 is “Stable” MySQL 3.23-Max with Innodb (and BDB) Storage Engines Initial release of MySQL Replication MySQL is sued by Progress/Nusphere, Countersues © 2018 Percona. 11 

12 .2001-03-12: InnoDB and Transactions! The MySQL Story, Page 75 © 2018 Percona. 12 

13 .2001-07-15: lawsuit filed On 15 June 2001, NuSphere sued MySQL AB, TcX DataKonsult AB and its original authors Michael ("Monty") Widenius and David Axmark in U.S District Court in Boston for "breach of contract, tortious interference with third party contracts and relationships and unfair competition".[55][56] Source: wikipedia © 2018 Percona. 13 

14 .… GPL lawsuit filed In 2002, MySQL AB sued Progress NuSphere for copyright and trademark infringement in United States district court. NuSphere had allegedly violated MySQL's copyright by linking MySQL's GPL'ed code with NuSphere Gemini table without being in compliance with the license.[57] After a preliminary hearing before Judge Patti Saris on 27 February 2002, the parties entered settlement talks and eventually settled.[58] After the hearing, FSF commented that "Judge Saris made clear that she sees the GNU GPL to be an enforceable and binding license."[59] Source: wikipedia © 2018 Percona. 14 

15 . Dual license model GPL + Commercia l © 2018 Percona. 15 

16 .MySQL Challenges in 2001 Making initial release of MySQL Stabilizing Innodb Replication to work © 2018 Percona. 16 

17 .2002 I Joined MySQL AB Did a little bit of Development Moved to do Support and Consulting Manager “High Performance Group” © 2018 Percona. 17 

18 .MySQL Challenges in 2002 Scaling MySQL for Web 2.0 Query Optimization MySQL Sharding is becoming common bugs.mysql.com © 2018 Percona. 18 

19 .MySQL in 2003 • MySQL 4.0 is released • Improved Replication • Query Cache © 2018 Percona. 19 

20 .LiveJournal “Reference Architecture” © 2018 Percona. 20 

21 .MySQL Tricks in 2003 MemcacheD Massive Replication © 2018 Percona. 21 

22 .MySQL in 2004 MySQL 4.1 is available First “Checkbox” Release Subqueries and Prepared Statements MySQL Cluster (NDB) is first available © 2018 Percona. 22 

23 .Blogging on MySQL © 2018 Percona. 23 

24 .MySQL in 2005 MySQL 5.0 Second “Checkbox” Release Stored Procedures, Views, Triggers Oracle Acquires Innobase (creator of Innodb) First Puppet Release © 2018 Percona. 24 

25 .MySQL in 2006 Scrambling with Innobase Acquisition fallout Buys “Netfrastracture” Jim Starkey (Firebird founder) Joins MySQL “Falcon” Storage Engine Hadoop is First Available © 2018 Percona. 25 

26 .2006 – Started MySQL Performance Blog © 2018 Percona. 26 

27 .Started Percona with Vadim Tkachenko • Performance Consultants • Helping Companies to Scale MySQL © 2018 Percona. 27 

28 .MySQL in 2008 MySQL 5.1 is released Partitioning and Row Based Replication Sun Microsystems Acquires MySQL AB Amazon Web Services EC2 Available as GA © 2018 Percona. 28 

29 .Percona in 2008 • Helping Customers requires writing code • Percona XtraDB (fork of Innodb) • 2nd edition of High Performance MySQL Book © 2018 Percona. 29