Hello all,
I am about to set up backup from a Slave replicated instance using the following method:
On Slave:
mysql> FLUSH TABLES WITH READ LOCK;
mysql> SET GLOBAL read_only=ON;
backup
mysql> SET GLOBAL read_only=OFF;
mysql> UNLOCK TABLES;
This is from :
http://dev.mysql.com/doc/mysql-backup-excerpt/5.5/en/replication-solutions-backups-read-only.html
Scneario 2:Backup with a Read-Only Slave
They suggest using mysqldump for backup step. Instead of using mysqldump I wanted to directly backup datafiles (Myisam engine) plus master.info & relay-log.info.
But at the top of the documentation they say: "You should not attempt to use these instructions to make a binary backup by copying files directly because the server may still have modified data cached in memory and not flushed to disk."
I don't understand why this is not possible as we are flushing tables.
Could someone please clarify for me?
Please note this is a 5.1.34 community-log version runing on Windows Server 2003 cluster, using exclusively MyISAM engine.
Thanks in advance for your answers!
Eureka
Edited 1 time(s). Last edit at 08/20/2012 09:39AM by eureka eureka.