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?