Web lists-archives.com

Re: slave to master






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't

frankly 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

Attachment: signature.asc
Description: OpenPGP digital signature