Hacker News new | past | comments | ask | show | jobs | submit login

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.




Beware 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-f...


Everything is on LVM

An excellent idea, which I, too, have advocated. It is, of course, external and not integrated with MySQL.


With a live snapshot, doesnt MySQL performance take a massive hit ?

I have seen benchmark numbers from the MySQL Performance Blog people.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: