> -----Original Message----- > From: Devananda [mailto:[EMAIL PROTECTED] > Sent: Friday, September 16, 2005 11:55 > To: Jeff > Cc: mysql@lists.mysql.com > 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]