Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

On a master-slave replication I have some shared tables which are written by master only.

In addition to the shared data, I have some "log tables" which are only relevant for the single machine, not to be shared and not to be backed-up.

If there is no mistake in the application on the server, it will not directly write into the slave machine - except the un-shared log tables. Isn't it possible to set the readonly flag for the shared tables explicitely? I found some similar questions, but no trustworthy solution yet :-(

share|improve this question
have you looked into setting more explicit grants on the slave so the connecting user is only allowed select grant on those tables. – Mike Jun 21 '12 at 14:10
OK, limiting the users is possible. A "global" setting overall users who are connected with this slave directly can not be set? – ledy Jun 21 '12 at 14:37
nope.. you are stuck doing user grants to solve the problem – Mike Jun 21 '12 at 15:15

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.