> -----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
