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.

One Response to “Fast Master Promotion”

  1. Matt’s Blog » Blog Archive » Mastering Technology Says:

    […] which distributes various patched versions of MySQL. Some are especially intersting to me, like Fast Master Promotion which is designed to allow a slave MySQL box to be promoted to master pretty much instantly, or the […]