List:General Discussion« Previous MessageNext Message »
From:Devananda Date:September 16 2005 7:28pm
Subject:Re: Circular Replication
View as plain text  
Jeff wrote:
>>-----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
> 
> 
> 
There could be problems with that.
See http://dev.mysql.com/doc/mysql/en/replication-compatibility.html
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