Set slave to read only
Posted:
Tue Jan 20, 2015 9:48 amby boybawang
Hi guys,
is it alright to set the slave to read only if your main purpose is just to lessen the load of the main database server when viewing reports?
Re: Set slave to read only
Posted:
Tue Jan 20, 2015 3:13 pmby okli
I would say yes, definitely.
1) There still might be some reports breaking replication when attempt to write to the slave
2) Piece of mind against human errors- running write queries on the slave by mistake, instead on the master. Avoiding that lovely "ohh sh*t", followed by slave rebuilding, for the Nth time, lol.
Re: Set slave to read only
Posted:
Fri Jan 23, 2015 7:15 amby DomeDan
I didnt know about the slave read only option, before making the change I had to rebuild the slave now and then
(
http://www.eflo.net/VICIDIALforum/viewt ... =3&t=26231)
this is the link geoff3dmg sent to me:
https://mariadb.com/blog/looking-slave- ... kip-errors