1. MySQL does not prevent any other updates to the slave. You can do this
yourself by only allowing SELECT privileges to users.
2. You really need not do anything, unless you have restricted users access
like mentioned in above.
Syncing the slave up to the master upon recovery is an entirely different
story. This is not easy to accomplish. There are several options for this
though and it is not impossible.
If High Availability is your goal you should consider other easier to manage
HA solutions such as DRBD.
Ed Pauley II
MySQL DBA - CMDBA
From: Andy Smith [mailto:a.smith@stripped]
Sent: Tuesday, March 18, 2008 9:13 AM
Subject: Basic questions on slave servers
hopefully a couple of easy to answer fundamental questions on a simple
master slave setup.
1) When a DB is in slave mode, does MySQL prevent any other updates to the
DB other than those from the master?
ie, can someone accidentally update the slave with data that doesnt match
the master DB or is this prevented, or put
another way, is the slave effectively in read-only mode whilst it is running
as a slave?
2) If the master should fail and I want my slave to run as a normal
standalone read/write DB what do I have to do? Is it
thanks in advance! Andy.