How to set mariadb read_write for some specific tables while starting as read_only=1
1
vote
1
answer
350
views
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 ?
Asked by SkyRar
(125 rep)
Jan 2, 2019, 06:42 AM
Last activity: Aug 7, 2024, 12:03 AM
Last activity: Aug 7, 2024, 12:03 AM