FOSDEM is the biggest free and non-commercial event organized by and for the community. Its goal is to provide Free and Open Source developers a place to meet. No registration necessary.

   
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.

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