As MySQL Driven Application growths, requiring to handle larger and larger load with increasing database size there are several Architectural methods to get the performance you need:
Caching Buffering and Queueing -- using supplemental systems to reduce the amount of reads or writes MySQL Server needs to handle or change them from being synchronous (users waiting for response) to background
Replication is a technique to scale the read load by being able to read from multiple copies of your data
Functional Partitioning and Sharing are techniques to split your database in the smaller portions which can be served by individual servers or group of Servers
In this tutorial we will go into details of how to understand what solutions are best for your application, how to design architecture to take the best advantage of these approaches as well as go into practical details/tips/tricks implementing them in production.
- Title: Scaling Applications with Caching, Sharding, and Replication
- Release date: July 2010
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781449396268
You might also like
Grokking Algorithms Video Edition
"This book does the impossible: it makes math fun and easy!" Sander Rossel, COAS Software Systems …
51+ hours of video instruction. Overview The professional programmer’s Deitel® video guide to Python development with …
Microservices designs require you to change how you build and deploy applications. Instead of creating a …
Learning Data Structures and Algorithms
In this Learning Data Structures and Algorithms video training course, Rod Stephens will teach you how …