I am trying to set a mariadb slave which is exact replica of master db. As per the suggestion I start my slave with command --relay-log=mysql-relay-bin" "--log-slave-updates=1" "--read-only=1" . But as I use my slave db as a stage server of my website, I need some tables like cache_* writable to make my stage server work perfectly.

Can you please help me if it is possible or not ? If not then is there any workaround for it ?

1 Answer 1


Plan A: Turn off read_only and hope that no one abuses it (accidentally or deliberately).

Plan B: Run the 'cache' stuff as some user with SUPER so that it can bypass read_only. This seems more secure than Plan A, but opens up other risks.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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