Read-Write Splitting: Techniques, Challenges, and Solutions

Read-write splitting is a great way to scale your workload, but it isn’t as simple as you might think at first. Going from one to many servers adds complexity to your application architecture, infrastructure, and code. You need to be prepared for these changes.

This session will teach you common read-write splitting design patterns, and how to decide which one is best for your application. You’ll learn what changes you need to make in your code. We’ll see how to compute the capacity increase you can expect in your systems as a result. We’ll look at how to handle common problems such as replication delay, unavailability of a slave, and more. And you’ll learn good practices for preventing problems such as accidentally writing to a slave instead of the master (hey, mistakes happen).