read_only from command line not working

  • Filter
  • Time
  • Show
Clear All
new posts

  • read_only from command line not working

    See [URL="http://bugs.mysql.com/bug.php?id=58669"]http://bugs.mysql.com/bug.php?id=58669[/URL="http://bugs.mysql.com/bug.php?id=58669"];

    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?


  • #2

    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,

    "This variable is off by default. When it is enabled, the server permits no updates except from users that have the SUPER privilege or (on a slave server) from updates performed by slave threads."
    Last edited by niljoshi; 05-13-2013, 02:37 AM.