Backing up slave
Posted by:
Benny Pei
Date: March 25, 2006 11:02PM
Hi,
I am running 5.0.15 on Sun with one master and one slave. Could someone tell me whether I am going to the right direction to backup our slave database. We are going to take a read lock on the slave and backup all the files from the directory and resume slave. We have both MYISAM and Innodb engines tables in the databases.
This is the plan I would like to follow:
1. stop slave thread
2. flush table with readlock
3. tar/zip up all the files in datadir and innodb_data_home_dir + innodb_log_group_home_dir
4. flush logs
5. unlock tables
6. start slave
Could someone tell me whether this is correct? anything else I need to copy?
thanks,
benny
Subject
Views
Written By
Posted
Backing up slave
2990
March 25, 2006 11:02PM
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.