Re: Circular Replication

[Devananda]

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