List:General Discussion« Previous MessageNext Message »
From:Jeff Date:September 16 2005 3:40pm
Subject:RE: Circular Replication
View as plain text  

> -----Original Message-----
> From: Dan Nelson [mailto:dnelson@stripped] 
> Sent: Friday, September 16, 2005 11:34
> To: Jeff
> Cc: mysql@stripped
> Subject: Re: Circular Replication
> 
> 
> In the last episode (Sep 16), Jeff said:
> > Does anyone use circular replication with MySQL 4.x?  For instance:
> > 
> >  A to B
> >  B to A
> > 
> > I know it's possible as long as you're carefull with your client 
> > applications and the way they write/update the db.  Just 
> wondering if 
> > anyone has had success or problems with this type of situation.
> 
> Works just fine here.
> 
> -- 
> 
> 	Dan Nelson
> 	dnelson@stripped
> 
> -- 
> 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?> unsub=jmckeon@stripped
> 
> 

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


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