Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
1  
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
add comment

1 Answer

Your Answer

 
discard

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.