Sample Header Ad - 728x90

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