MySQL Forums
Forum List  »  Backup

Backup from slave instance (error in the doc?)
Posted by: eureka eureka
Date: August 20, 2012 02:32AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Backup from slave instance (error in the doc?)
2221
August 20, 2012 02:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.