These commands allow fast promotion of a slave to a master. It is fast because it can be done without restarting the slave. Storage engines with dirty pages, such as InnoDB, can take a long time (more than a minute) to shutdown.
This patch was introduced in patchset d7.
Google (Mark Callaghan), updates and fixes by Percona and Open Query.
- MAKE MASTER REVOKE SESSION [WITH KILL] – This prevents non-SUPER users from connecting. When the WITH KILL option is used, current non-SUPER connections are killed.
- MAKE MASTER GRANT SESSION – This allows non-SUPER users to connect.
- Failover_deny_access – Indicates whether a non-SUPER users are currently blocked from connecting.