MySQL Scaling and High Availability

1 . MySQL: Scaling & High Availability Production experience for the last decade(s) Peter Zaitsev, CEO, Percona February 3nd, 2018 FOSDEM © 2018 Percona. 1 

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

3 .1999 © 2018 Percona. 3 

4 .My First MySQL Experience © 2018 Percona. 4 

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

6 .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. 6 

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

8 .MySQL in 2000 MySQL goes Open Source, GPL License © 2018 Percona. 8 

9 .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. 9 

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

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

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

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

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

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

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

17 .Blogging on MySQL © 2018 Percona. 17 

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

19 .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. 19 

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

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

22 .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. 22 

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

24 .MySQL in 2009 Oracle Acquires Sun and so MySQL “Oracle will kill MySQL” rumors MariaDB started by Michael “Monty” Widenius as MySQL Alternative Amazon RDS MySQL is available Initial version of MongoDB released © 2018 Percona. 24 

25 .MySQL in 2010 MySQL 5.5 Scalability, Performance Schema OpenStack Initial Release © 2018 Percona. 25 

26 .Percona in 2010 Percona Server 5.1 Percona Xtrabackup © 2018 Percona. 26 

27 .MySQL Challenges 2010 Scaling MySQL with CPU Cores MySQL Deployment Automation Getting MySQL Ready for Cloud Automated Replication Failover © 2018 Percona. 27 

28 .2012 • Percona XtraDB Cluster 5.5 is Available • New Generation, Cloud Friendly High Availability Technology for MySQL © 2018 Percona. 28 

29 .MySQL in 2013 MySQL 5.6 is available Better Scalability, Performance Schema, GTID, Optimizer SSDs are mainstream Initial release of Docker © 2018 Percona. 29