Tuning and scaling a project on MySQL

Don't know what to do with the project? Does the base constantly slow down and crash? Is the boss yelling? We can’t help with management, but we know how to install and configure MySQL correctly and find out which queries are slowing down! In a series of master classes on setting up and operating the MySQL DBMS, Vladimir Fedorkov, an expert in the field of MySQL performance, a regular speaker at conferences in Russia, Europe and the USA, told what exactly to set up so that everything works perfectly, how to find slow queries and make them fast.

Three master classes. Each duration is 1 hour.

We install and tune MySQL to work with high loads

• MySQL versions and forks
• How to configure MySQL? Important aspects during installation and initial setup
• How does MySQL work? InnoDB architecture and settings
• Other storage subsystems
• What you never need to configure
• MySQL tuner and other automatic configuration scripts

Learning to write the world's fastest queries for MySQL

• Queries in MySQL: what affects performance?
• How to optimize SELECT?
• MySQL Optimizer
• Selectivity and Cardinality are the main words that no one knows
• Query cache in MySQL
• Optimization records
• Working with schema changes

Building a fault-tolerant infrastructure for MySQL

• MySQL running under high loads
• MySQL Scaling
• Functional sharding
• Horizontal sharding
• Replication in MySQL
• Master-Master replication
• MySQL clustering tools (Galera, Group Replication)
• Query routing and ProxySQL
• Replication management: MHA and Orchestrator
• Backup and recovery