read_only from command line not working

MySQL & MariaDB Other MySQL® Questions
1

See [URL=“MySQL Bugs: #58669: read_only not enforced on 5.5.x”]MySQL Bugs: #58669: read_only not enforced on 5.5.x;

The server ignores the read_only flag when it is provided in the my.cnf file. The variable READ_ONLY is displayed as ON, but it does not stop an insert from happening. If set it via “set global read_only=1;” it properly stops writes (but it does not work if it was set in my.cnf. I assume because it sees that it is already set, and does not set it properly).

I have confirmed that this is happening on percona 5.5.30-rel30.2

What should I do to make sure the slave is read only?

jt

2

Hi,

Can you please provide how you are setting variable in my.cnf? I have also tested the same on my laptop and it works fine with percona 5.5.30-rel30.2 version. I hope, you are not trying to insert with the user which has SUPER privilege. Can you provide the steps that how you are testing it? As per Doc,