Steve,
There isn't an automated way, but you can at least semi-script this. To
switch the slave to the master after the old master has failed and then
brought back up do this:
Shut down MySQL on the NEW master
mysqladmin -u root -p shutdown
Snapshot all the data on your NEW master server.
Steve,
Are the two servers roughly equal in terms of hardware?
Scott Helms
>
> Please help, I've read through the manual and this case is suggested but
> not really
> laid out. I'm using mysql 3.23.37 and can't upgrade to 4.0 yet.
>
> Okay, I've got replication on 2 machines with a on
Please help, I've read through the manual and this case is suggested but
not really
laid out. I'm using mysql 3.23.37 and can't upgrade to 4.0 yet.
Okay, I've got replication on 2 machines with a one-way failover setup:
Master fails, slave takes over.
Now the slave has been recording updates
Please help, I've read through the manual and this case is suggested but
not really
laid out. I'm using mysql 3.23.37 and can't upgrade to 4.0 yet.
Okay, I've got replication on 2 machines with a one-way failover setup:
Master fails, slave takes over.
Now the slave has been recording updates f
