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
Giuseppe Maxia
Schedule
Day Saturday
Room H.2213
Capacity 100
Start time 17:00
End time 17:25
Duration 00:25
Info
Track MySQL & friends devroom

Seamless MySQL replication failover with Tungsten

Replication fail over and fail back are the most common occurrences in MySQL database operations. And yet, they are still among the most difficult tasks to perform, all because MySQL lacks the ability of matching master transactions with the ones stored in the slaves. Since Tungsten has the global transaction ID, promoting a slave to master and synchronizing the other slaves is a painless operation. This session will show the difference between switching between master and slave in two scenarios: using MySQL regular replication, and using Tungsten replication.

Replication fail over and fail back are the most common occurrences in MySQL database operations. And yet, they are still among the most difficult tasks to perform, all because MySQL lacks the ability of matching master transactions with the ones stored in the slaves. Since Tungsten has the global transaction ID, promoting a slave to master and synchronizing the other slaves is a painless operation. This session will show the difference between switching between master and slave in two scenarios: using MySQL regular replication, and using Tungsten replication.

Next (up to 3) talks in the same room (H.2213):

When Event Track
17:30-17:55 Multimaster MySQL failover MySQL & friends
18:00-18:25 Multi-Master Replication Approaches MySQL & friends
18:30-18:55 A practical overview of Maatkit MySQL & friends