MySQL from MySQL developers

Many large projects that withstand millions of loads every day work on a MySQL database. How to set up a DBMS, what's the secret, which gears do you need to tighten and which levers to pull? These questions will be answered by several speakers at the professional HighLoad ++ web developers professional conference.

Several years ago, Peter Zaitsev headed the department of high loads at MySQL Inc, the developer of the database of the same name. Peter now runs a consulting firm specializing in MySQL optimization. Peter submitted two applications for participation in the conference - “Overview of storage systems in MySQL” and “Innodb scaling”.

MySQL has long been distinguished from other DBMS by the presence of multiple data storage systems (Storage Engines), which have different characteristics and are useful in specific cases. In recent years, even more storage systems have emerged, both suitable for typical needs and for special cases.
')
In the first report, Peter will introduce us to MySQL storage systems, both currently available (such as MyISAM, Innodb) and actively developed (Falcon, Maria, PBXT). He will tell you what the distinctive design concepts of these systems are, what their current status and performance parameters are.

The second talk is about Innodb, which is the most popular data storage system for Web applications. It's not a secret, however, that Innodb often scales poorly on high-performance servers that have a large number of processors or disk drives.

In this presentation, Peter will tell us how well Innodb scales at the moment, and how to customize Innodb and the application to get the best scalability. In addition, it will talk about the work being done to improve Innodb's scalability, both by Percona, as well as by Oracle and Google.

Another report directly from MySQL developers is “Scale-up of the MySQL server part: architecture, benchmarks, bottlenecks and their solutions” from Konstantin Osipov, who participates in designing the server part of the DBMS.

Grigory Rubtsov submitted an application for the report “MySQL Cluster Architecture” - the possibilities of using this solution for building fault-tolerant loaded applications (NDB storage mechanism, performance, fault tolerance, replication).

You can hear these and many other reports by booking a place at the conference of web developers HighLoad ++ , which will be held on October 6 and 7 in Moscow.