Re:Outage post-mortem
by eli on Sunday January 12, 2014 @11:26PM
(#7048913)
I thought Percona's Xtrabackup already supported parallelized recovery using binary logs: http://www.percona.com/doc/percona-xtrabackup/2.1/ (Though I'll admit I've never tried to do so)
[ Parent
| on HN ]
This is the same problem as to why slaves were single-threaded for so long:
Statement based replication (default) is tricky to apply in parallel, since you can't easily figure out ordering dependencies.
In MySQL 5.6 replication is now parallel per-schema, and in MySQL 5.7 it will be parallel intra-schema.