List:General Discussion« Previous MessageNext Message »
From:Jeff McKeon Date:September 16 2005 5:19pm
Subject:RE: Circular Replication
View as plain text  
> -----Original Message-----
> From: Devananda [mailto:karnah805@stripped] 
> Sent: Friday, September 16, 2005 11:55
> To: Jeff
> Cc: mysql@stripped
> Subject: Re: Circular Replication
> 
> 
> 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

Nope, all tables are MyISAM.

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