As your MySQL-driven application grows in size and complexity, the amount of data your system holds will certainly increase, but so will client demands on the server -- demands that could slow the performance of the entire application. In this video tutorial, you'll learn several architectural methods to increase MySQL performance and reliability.
Peter Zaitsev, CEO of Percola and co-author of High Performance MySQL (O'Reilly), will introduce three basic solutions that you can use, depending on the type of application you have deployed:
Caching, buffering, and queuing. These methods use supplemental systems either to reduce the amount of reads or writes your MySQL Server is required to handle, or change them from being synchronous (users waiting for response) to background.
Functional partitioning and sharding. These techniques split your database into smaller portions that can be served by individual servers or a group of servers.
Replication. This technique scales the read load so that users can read from multiple copies of your data
This insightful presentation helps you explore which solutions are best for your application. You'll learn how to design architecture to take advantage of these approaches, and pick up practical details, tips, and tricks for implementing them in production.
A former manager of the High Performace Group at MySQL AB, Peter Zaitsev now runs the mysqlperformanceblog.com site. He specializes in helping administrators fix issues with Web sites handling millions of visitors a day, dealing with terabytes of data using hundreds of servers. He is used to making changes and upgrades both to hardware to software (such as query optimization) in order to find solutions. He also speaks frequently at conferences.