This script is designed to be used on mulit-master mysql setups. It can get the status of the read_only and event scheduler variables as well as the slave status of any hosts passed to it. It can also perform a fail over between two host. It changes the read_only variable to ON for the current primary host and disables the events in the event scheduler by setting them to SLAVESIDE_DISABLED. On the new primary host, it sets the read_only variable to OFF and enables the events that were enable on the current primary host.
-
Notifications
You must be signed in to change notification settings - Fork 0
joegrasse/multi_master
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
About
Script for swapping master db server
Resources
Stars
Watchers
Forks
Packages 0
No packages published