List:General Discussion« Previous MessageNext Message »
From:Jeff Date:September 16 2005 6:07pm
Subject:RE: Circular Replication
View as plain text  
> -----Original Message-----
> From: Jeff McKeon 
> Sent: Friday, September 16, 2005 13:19
> To: Devananda
> Cc: mysql@stripped
> Subject: RE: Circular Replication
> 
> 
> > -----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.
> 

There shouldn't be a problem if:

server A is ver 4.0.x 
server B is ver 4.1.x 

should there?

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