This blog post will discuss how to use theMySQL super_read_only system variable.
It is well known that replica servers in a master/slaveconfiguration, to avoid breaking replication due to duplicatekeys, missing rows or other similar issues, should not receivewrite queries. It’s a good practice to set
on slave servers to prevent any (accidental) writes.Servers acting as replicas will NOT be in read-only modeautomatically by default.
has an historical issue: users with the SUPER privilegecan override the setting and could still run DMLqueries. Since Percona Server 5.6.21 and MySQL 5.7.8, however,you can use the
feature to extend the
read_only …[Read more]