Jeff wrote:
-----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
There could be problems with that.
See http://dev.mysql.com/doc/mysql/en/replication-compatibility.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]