Re: 1 Master -> Many slaves, need to update dump file
Don't create a new slave from the Master; create it from an existing Slave.
1. Stop users from connecting to slave A.
2. Stop mysqld on A.
3. Copy the entire directory tree for mysql to slave B.
4. Set up a similar my.cnf (my.ini) on B -- everything the same, except server-id.
5. Start mysqld on A and B.
6. Wait for replication to catch up (on A and B)
7. Allow users to use A and B.
You don't touch the Master at all.
Subject
Views
Written By
Posted
2840
July 10, 2012 03:55PM
1084
July 11, 2012 03:20PM
Re: 1 Master -> Many slaves, need to update dump file
1116
July 11, 2012 04:16PM
1078
July 12, 2012 11:09AM
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.