Percona Server has ported a new option,
super_read_only from WebScaleSQL, which is like the read-only option, but affecting users with
SUPER privileges as well. This means that server will not allow any updates even for the users that have
SUPER privilege. If slave replication repositories are tables (when
master-info-repository variable is set to
relay-log-info-repository variable is set to
TABLE), any implicit updates to them (as performed by
START SLAVE, or
STOP SLAVE) are allowed regardless of
super_read_only setting. Enabling
super_read_only implies regular
read-only as well.
When enabled the server will not allow any updates, beside updating the replication repositories if slave status logs are tables, even for the users that have
For general inquiries about our open source software and database management tools, please send us your question and someone will contact you.