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 is set to
OFF, even when I add
-innodb-read-only=1 to mysqld arguments.
innodb_read_only allowed on a slave server?
read_onlyapply to users, not the Replication stream.