The bash slave-prefetch oneliner

3 April 5:30PM - 8:20PM @ Community Networking Welcome Reception

Experience level: 
Lightning talks
Slave prefetchers can speed up replication but only work within very limited boundaries. As Domas described it two years ago: "Please don’t use mk-slave-prefetch on MySQL unless you are Facebook. Or at least don’t tell your friends, so they won’t use it." We are not Facebook, but we certainly like to stand in their shadow! Besides that we were suffering from slave lag on a slave that never could catch up with its current pace and I was convinced it could help in our (corner) case. So I installed maatkit next to the Percona-toolkit only to find out we are running.......row based replication... But, being a smart-ass, I immediately thought of mysqlbinlog being able to extract queries from row-based replication and I could use sed and awk to extract and replace the correct queries and then it only started to go downhill...


Head of database engineering, Spil Games
Worked over eight years at Spil Games and contributed as a developer, IT Architect, Database Administrator, Database Specialist and now Head of Database Engineering to the growth of the company. Spil Games is a world leader in casual gaming that pursues growth through constant innovation.