I am trying to make a MariaDB slave instance read only. From what I understand, read_only option is not truly readonly as users with super privilege can still write to the database.

super_read_only is not yet supported by MariaDB, but there is an open feature request for it.

I also came across innodb_read_only. But innodb_read_only is set to OFF, even when I add -innodb-read-only=1 to mysqld arguments.

Is innodb_read_only allowed on a slave server?

  • This doesn't make a lot of sense. If a replication master is writing to the slave, it can't be read only! Dec 29, 2018 at 18:55
  • I don't want the server to be readonly. I just want to prevent someone (with super privilege) from writing to the slave by mistake. Not granting super privilege to users is the obvious answer. I am interested in finding out whether there is another solution.
    – Joyce Babu
    Dec 29, 2018 at 19:26
  • The various flavors of read_only apply to users, not the Replication stream.
    – Rick James
    Jan 2, 2019 at 4:58
  • What version of MariaDB are you using? There are several mentions of those flags in the Changelogs.
    – Rick James
    Jan 2, 2019 at 5:01
  • I am using 10.2.
    – Joyce Babu
    Jan 2, 2019 at 8:13


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.