Re: slave to master
Reindl Harald <[email protected]>
| Newsgroups | gmane.comp.db.mysql.general |
|---|---|
| Organization | the lounge interactive design |
| Message-ID | <[email protected]> |
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
signature.asc
(application/pgp-signature, 181 B)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iEYEARECAAYFAlckHX4ACgkQhmBjz394AnkOAgCgjnL3IxedhjvNBTpRe3fcRkpu DqIAnRr9UFsxXprM4ujngoaXqBb+3Jo7 =rfu5 -----END PGP SIGNATURE-----