3 ms·
The way we do initial synchronization with MyISAM: * Everything is on LVM * Run FLUSH TABLES WITH READ LOCK * Take an LVM snapshot then record binary log fil
by chrisbolt 16y ago
The way we do initial synchronization with MyISAM:
* Everything is on LVM
* Run FLUSH TABLES WITH READ LOCK
* Take an LVM snapshot then record binary log filename and position
* Run UNLOCK TABLES
* Mount snapshot, rsync to new server and bring up replication with recorded file and position
Very fast and only locks tables for a short time.
- LiveTheDream 16y agoBeware of FLUSH TABLES WITH READ LOCK potentially causing an exclusive lock. The percona guys give an explanation: http://www.mysqlperformanceblog.com/2010/04/24/how-fast-is-flush-tables-with-read-lock/ http://www.mysqlperformanceblog.com/2010/04/24/how-fast-is-f...
- mmt 16y agoEverything is on LVM An excellent idea, which I, too, have advocated. It is, of course, external and not integrated with MySQL.
- sandGorgon 16y agoWith a live snapshot, doesnt MySQL performance take a massive hit ? I have seen benchmark numbers from the MySQL Performance Blog people.