Cannot enable innodb_read_only on slave

Asked Dec 29 '18 at 14:00

Active Dec 29 '18 at 14:00

Viewed 222 times

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?

asked Dec 29 '18 at 14:00

Joyce Babu

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 '18 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 '18 at 19:26
The various flavors of `read_only` apply to users, not the Replication stream. – Rick James Jan 02 '19 at 04:58
What version of MariaDB are you using? There are several mentions of those flags in the Changelogs. – Rick James Jan 02 '19 at 05:01
I am using 10.2. – Joyce Babu Jan 02 '19 at 08:13

Cannot enable innodb_read_only on slave

0 Answers0