Am 29.04.2016 um 20:49 schrieb william drescher:
On 4/28/2016 5:20 PM, Thomas wrote:Hi, I have setup an master slave replication. This works fine. I have running an Apache webserver and some other programms accessing the master. Whats the standard pocedure if master fail? I want to start up the programms on the slave by hand and then they are accessing the mySQL slave. Can they write to the slave or do I have to change something before in the mysql slave configuration? The simple answer is that you don't have to do anything.At some point you will want to stop the slave so that it will not start replicating when the master comes back up.
it won'tfrankly crash the master and replication will break and stop after reboot in most cases - no way that it just starts again just because the master comes back later
hence you normally have "read-only" on your slaves to prevent breaking replication
signature.asc
Description: OpenPGP digital signature