Re:Jetpants: a MySQL toolkit for managing billions of rows a...
by Andys on Friday June 08, 2012 @02:47AM
(#4083060)
I got the impression because I didn't see any discussion about the handling of bringing new slaves online (other than how to make it fast). Do you pause one of the slaves to get a consistent dump?
[ Parent
| on HN ]
Re:Jetpants: a MySQL toolkit for managing billions of rows a...
by evanelias on Friday June 08, 2012 @09:26AM
(#4084036)
Slave cloning is performed by shutting down mysqld on a standby slave and copying its raw data files. There's no dump involved. This is widely regarded to be the fastest possible way to clone a slave in MySQL.
This is explained in the deeper doc files -- didn't want to bog down the top-level README with implementation details.
Meanwhile, data exporting (for shard splits or table defragmentation) is done on a standby slave with replication stopped.