Speakers | |
---|---|
Petya Kohts | |
Schedule | |
Day | Saturday |
Room | H.2213 |
Capacity | 100 |
Start time | 17:30 |
End time | 17:55 |
Duration | 00:25 |
Info | |
Track | MySQL & friends devroom |
Multimaster MySQL failover
I propose the algorithm and proof of concept tool which solve one of key aspects of scaling mysql read load with multiple read slaves: failover in case of master failure. Algorithm works in common configuration with master serving writes and one or more slaves serving reads and replicating from master. The algorithm allows any of read slaves to become new master and guarantees full consistency of all the slaves which were available during its work. In short: algorithm allows the same degree of consistency as a popular dual master (master-master) mysql replication scheme adding the ability to use a number of slaves for read load and failover as compared to one in the dual master replication scheme.
I propose the algorithm and proof of concept tool which solve one of key aspects of scaling mysql read load with multiple read slaves: failover in case of master failure. Algorithm works in common configuration with master serving writes and one or more slaves serving reads and replicating from master. The algorithm allows any of read slaves to become new master and guarantees full consistency of all the slaves which were available during its work. In short: algorithm allows the same degree of consistency as a popular dual master (master-master) mysql replication scheme adding the ability to use a number of slaves for read load and failover as compared to one in the dual master replication scheme.
Concurrent events:
Next (up to 3) talks in the same room (H.2213):
When | Event | Track |
---|---|---|
18:00-18:25 | Multi-Master Replication Approaches | MySQL & friends |
18:30-18:55 | A practical overview of Maatkit | MySQL & friends |