Set slave to read only

[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?

[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.

[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