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.