From: Devananda
Date: September 16 2005 3:55pm
Subject: Re: Circular Replication
List-Archive: http://lists.mysql.com/mysql/189183
Message-Id: <432AEAEA.3000805@yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Jeff wrote:
> 
> Am I correct in this setup process:
> 
> Server A exists
> Server B to be built
> 
> Stop Server A, take snapshot, record Master info.
> Start Server A
> 
> Setup server B, Install snapshot from A
> Set B up as a master
> Set B up as a slave to A
> 
> Set A up as a slave to B, no need for binlog file or position info as it
> will start at the default 001 and pos 4
> 
> Circular replication is now running...
> 
> Did I mis anything?
> 
> Thanks,
> 
> Jeff
> 
> 
> 
If you are using InnoDB, then you do not need to stop server A to take a 
snapshot. (see http://dev.mysql.com/doc/mysql/en/mysqldump.html)

"The simultaneous use of --master-data and --single-transaction works as 
of MySQL 4.1.8. It provides a convenient way to make an online backup 
suitable for point-in-time recovery if tables are stored in the InnoDB 
storage engine."

As far as setting up the replication, that looks ok. Each server needs 
to have binary logging enabled, and needs to have the other server as 
it's master.

Regards,
Devananda vdv