3 ms·

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

by Andys 14y ago

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?

evanelias 14y ago
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.