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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]