MySQL Forums
Forum List  »  Replication

Mysql replication by cloning disk
Posted by: Alberto Garcia-Baquero
Date: September 19, 2016 09:26AM

Hello,
We have to setup a Mysql replication by cloning disk. By searching in Internet i have found that we can do by setting the following due to image clone proccess:
The simplest way to get the binlog positon is:
-SHOW MASTER STATUS to get master bin log file
-Stop the master server.
-Take a copy of the entire data directory --> clone to slave.
-Remove or replace the auto.cnf file with the UUID. (at slave)
-Take note of the the replication position. It will be the next binlog file, offset 4. (The master will start a new binlog file when you restart it.)
-Start the slave with skip-slave-start in the config file.
-Do the CHANGE MASTER TO using the binlog position from step 1-3.
-Double check the replication using SHOW SLAVE STATUS;
-Remove the skip-slave-start from the config file.

The question is .. anyone has tried this...is this ok?? ... do you know any more datails about the proccess?
may be some of you have been facing the same problem ..

Thanks in advance.

MA.

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql replication by cloning disk
1078
September 19, 2016 09:26AM
575
October 04, 2016 06:01PM


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.