Thanks for your answer.
There two boxes are used for different purposes. Say Box 1 contains Database A which is replicated to Box 2. Box 2 contains database B which is replicated to Box 1. So both databases are on both boxes. some applications send update database A on Box 1. Other applications update database B on box 2. replication is configured for recovery availability. Now I have to change Box 1. So everything that updates database A will stop until all data is copied. I try to avoid this problem. Any ideas?
Ryan Fox wrote:
On Tuesday 17 June 2003 03:35 am, George Chelidze wrote:
Hello,
I have two RH boxes with mysql on them and replication is enabled from box 1 to box 2 and from box 2 to box 1. The amount of data on each of them is round 400-500MB. Now I have to replace one of them with new box. As both boxes are productional ones, I'd like to replace one of them online without stopping them. I know I can tar the tables (MyISAM) and move to a new box but I have to make sure the data won't change, so I have to offline the boxes. Is there any way to do this replace transparetely? Any recommendations would be great. Thanks in advance.
For replacing box 1:
1. Direct requests to box 2 2. Stop slave on box 2
3. Record log file and position on box 1 using show slave status
3. Stop mysql on box 1
4. Move tables from old box 1 to new box 1
5. On new box 1, run CHANGE MASTER TO MASTER_HOST='<master host name>',
MASTER_USER='<replication user name>',
MASTER_PASSWORD='<replication password>',
MASTER_LOG_FILE='<recorded log file name>',
MASTER_LOG_POS=<recorded log offset>;
filling in box 2's name, and the log name and position recorded in step 3.
6. Start slave on box 1.
7. Start slave on box 2.
8. Verify box 1 looks ok
9. Direct requests to both boxes again.
-- George Chelidze
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
