conferences | speakers | series

Keeping the slave’s buffer pool warm for failover with Percona Playback

home

Keeping the slave’s buffer pool warm for failover with Percona Playback
FOSDEM 2013

Many applications are using MySQL’s built in replication to provide high availability with either manual or automated failover. One issue with this is that after failover, the former slave's buffer pool may be cold, and it becomes IO bound.

This talk is about how we solved this issue and provided fast failover for a high traffic site using Percona Playback to replay the database traffic continuously on the failover hosts.

This talk is about the solutions we used there, and the measurements we performed to choose the appropriate solution for the issue.

Speakers: Peter Boros