I have a series of applications that save data to a MySQL Server.
I wish to keep a second MySQL server on standby, being continuously updated from the Master, so as to keep in sync with it.
If the 'Master' server were to fail, the clients would be informed and would begin to store there data on the backup server.
Once the Master was repaired, this would again take over and would automatically be updated with the additional/updated data taken during its downtime.
Is this a posible scenario using REPLICATION services provided with MySQL 4.0.14 servers ?
If so, could someome give me a simple example of how to configure the two machines...