0

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?

Improve this question
5
  • This doesn't make a lot of sense. If a replication master is writing to the slave, it can't be read only!
    – Michael Hampton
    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

0

Reset to default

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.