What is SUPER read only in MySQL?
Percona Server for MySQL 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.
Why MySQL read only?
A primary reason for setting a MySQL database as read-only is to ensure no updates are lost during a backup. The MySQL Documentation Library provides instructions for backing up master and slave servers in a replication setup via a global read lock and manipulation of the read_only system variable.
How can I tell if a database is read only?
SELECT name, is_read_only FROM sys. databases WHERE name = ‘MyDBNAme’ GO –returns 1 in is_read_only when database is set to read-only mode. Querying sys. databases for checking a DB’s Read-Only property will only give the right information if the database has been explicitly set to Read-Only mode.
What does Super read only mean in MySQL?
Setting read_only = OFF also sets super_read_only = OFF. Setting super_read_only = ON also sets read_only = ON. All other changes to either of these variables have no effect on the other.
How to set MySQL to read only mode?
1) Basic functionality The following command sets the server to a read/write mode: SET GLOBAL READ_ONLY=0 The following command sets the server to a read-only mode: SET GLOBAL READ_ONLY=1 (This is the current behavior, no change) 2) SUPER privilege Both SET GLOBAL READ_ONLY=0 SET GLOBAL READ_ONLY=1 require the SUPER privilege to execute.
When to enable or disable Super read only?
Setting super_read_only = ON also sets read_only = ON. All other changes to either of these variables have no effect on the other. This behavior does seem logical, as when disabling read_only you probably also want to disable super_read_only, and vice-versa, when enabling super_read_only you probably also want to enable read_only.
Do you need global read only in MySQL?
Rationale: The implementation of SET GLOBAL READ_ONLY needs to acquire the global read lock.