List:General Discussion« Previous MessageNext Message »
From:Devananda Date:September 16 2005 3:55pm
Subject:Re: Circular Replication
View as plain text  
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
Thread
Circular ReplicationJeff16 Sep
  • Re: Circular ReplicationDan Nelson16 Sep
    • RE: Circular ReplicationJeff16 Sep
      • Re: Circular ReplicationDevananda16 Sep
  • Re: Circular ReplicationStefan Kuhn16 Sep
    • Re: Circular ReplicationRaphaĆ«l 'SurcouF' Bordet27 Oct
      • Re: Circular ReplicationStefan Kuhn27 Oct
        • Re: Circular ReplicationJigal van Hemert27 Oct
          • Re: Circular ReplicationDevananda28 Oct
RE: Circular ReplicationJeff McKeon16 Sep
  • RE: Circular ReplicationJeff16 Sep
    • Re: Circular ReplicationDevananda16 Sep
      • Re: Circular ReplicationSid Lane19 Sep
        • Re: Circular ReplicationAlec.Cawley19 Sep
          • Re: Circular ReplicationSid Lane19 Sep
          • RE: Circular ReplicationJeff20 Sep
            • Re: Circular ReplicationDevananda20 Sep
    • Re: Circular ReplicationBruce Dembecki21 Sep
RE: Circular ReplicationJeff20 Sep
RE: Circular ReplicationJeff21 Sep
  • Re: Circular ReplicationBruce Dembecki22 Sep
    • Re: Circular ReplicationHank26 Sep
      • Re: Circular ReplicationHank26 Sep