Le 30/12/14 00:18, Kiran Ayyagari a écrit : > On Tue, Dec 30, 2014 at 6:55 AM, Joe Hughes <[email protected]> wrote: > >> Hello, >> >> Looking through the documentation I saw a TODO on the replication >> instructions on how to make a Slave server Read Only. Has anyone >> successfully done this? I have done a good amount of searching and have not >> been successful so far. I imagine the trick would be to make every >> connection read only but I can't seem to find the config option to do so. >> >> this option/feature is not available yet
I think it's feasable, but it's a kind of tricky Basically, you just want the replication user to be able to update the slave, and all other users to just being able to read it. The way to do that is : - first to make the salve a replication consumer, accepting updates from the master - second add an ACI that forbid everyone but the replication user to write or update. I guess that at some point, we should setup such a config and update the doco...
