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