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
