Fast Master Promotion
Summary
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.
Patch Origin
Google (Mark Callaghan), updates and fixes by Percona and Open Query.
Options
- 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.
Status
- Failover_deny_access - Indicates whether a non-SUPER users are currently blocked from connecting.
| No Comments »
RSS feed for comments on this post. TrackBack URL
