> -----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.
> Devananda vdv
Nope, all tables are MyISAM.