InnoDB: What you didn’t know about the storage engine that powers most of the Web
InnoDB is the most commonly used storage engine for MySQL 8.0 and Percona Server for MySQL, and is the focus for the majority of storage engine development by the MySQL and Percona teams.
In this tutorial, we will look at the InnoDB architecture, including new developments in MySQL 8.0 as well as Percona Server for MySQL. We will explain how InnoDB should be used to get the best performance from your application. We will provide specific advice on server configuration, schema design, application architecture and hardware choices.
Peter Zaitsev co-founded Percona and assumed the role of CEO in 2006. As one of the foremost experts on MySQL strategy and optimization, Peter leveraged both his technical vision and entrepreneurial skills to grow Percona from a two-person shop to one of the most respected open source companies in the business. With over 140 professionals in 30 plus countries, Peter’s venture now serves over 3000 customers – including the “who’s who” of internet giants, large enterprises and many exciting startups. Percona was named to the Inc. 5000 in 2013, 2014, 2015 and 2016. Peter was an early employee at MySQL AB, eventually leading the company’s High Performance Group. A serial entrepreneur, Peter co-founded his first startup while attending Moscow State University where he majored in Computer Science. Peter is a co-author of High Performance MySQL: Optimization, Backups, and Replication, one of the most popular books on MySQL performance.