Vengala Vinay

Having 9+ Years of Experience in Software Development

Home » Disaster Recovery 101: Architecting Auto-Failovers for MySQL and Magento 2 Deployments on DigitalOcean

Disaster Recovery 101: Architecting Auto-Failovers for MySQL and Magento 2 Deployments on DigitalOcean

Establishing a Highly Available MySQL Cluster with Orchestrator

For a Magento 2 deployment, a robust and highly available MySQL infrastructure is paramount. We’ll architect an automated failover solution using Orchestrator, a popular MySQL replication topology manager. This setup will involve a primary (leader) instance and at least two replicas (followers), with Orchestrator monitoring their health and orchestrating failovers when necessary. We’ll deploy this on DigitalOcean using managed MySQL or self-hosted Droplets.

Our primary goal is to ensure that if the primary MySQL instance becomes unavailable, a replica is automatically promoted to become the new primary with minimal data loss and downtime. Orchestrator handles the complex task of detecting failures, identifying the best candidate for promotion, and reconfiguring replication.

Orchestrator Deployment and Configuration

Orchestrator itself needs to be highly available. A common pattern is to run multiple Orchestrator instances in an active/passive or active/active configuration. For simplicity in this example, we’ll focus on a single Orchestrator instance, but in production, you’d want to consider its own HA strategy (e.g., using a load balancer and multiple instances).

First, install Orchestrator on a dedicated Droplet. We’ll use a Linux distribution like Ubuntu 22.04.

Installing Orchestrator on Ubuntu

Download the latest Orchestrator release. You can find the latest version on the Orchestrator GitHub releases page.

wget https://github.com/openark/orchestrator/releases/download/v3.2.7/orchestrator-3.2.7-linux-amd64.tar.gz
tar xvfz orchestrator-3.2.7-linux-amd64.tar.gz
sudo mv orchestrator-3.2.7-linux-amd64 /usr/local/orchestrator
sudo ln -s /usr/local/orchestrator/orchestrator /usr/local/bin/orchestrator

Orchestrator Configuration File

Create the Orchestrator configuration file, typically located at /etc/orchestrator.conf.json. This file defines how Orchestrator interacts with your MySQL instances and its own behavior.

{
  "Debug": false,
  "ListenAddress": ":3000",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_orchestrator_db_password",
  "MySQLOrchestratorHostPort": "127.0.0.1:3306",
  "MySQLOrchestratorDatabaseName": "orchestrator",
  "MySQLOrchestratorUser": "orchestrator",
  "MySQLOrchestratorPassword": "your_orchestrator_db_password",
  "DiscoveryPeriodSeconds": 10,
  "PromotionUser": "root",
  "PromotionPassword": "your_mysql_root_password",
  "RecoveryPeriodBlockSeconds": 3600,
  "FailureDetectionPeriodBlockSeconds": 3600,
  "DetectClusterPrimaryFailuresPeriodSeconds": 5,
  "DetectClusterReplicaFailuresPeriodSeconds": 5,
  "SlaveLagQuery": "SELECT * FROM mysql.slave_master_info",
  "SlaveLagQueryError": "SELECT * FROM mysql.slave_master_info",
  "SlaveLagQuerySlaveStatus": "SHOW SLAVE STATUS",
  "SlaveLagQuerySlaveSQLRunning": "Yes",
  "SlaveLagQuerySlaveIORunning": "Yes",
  "SlaveLagQuerySecondsBehindMaster": "Seconds_Behind_Master",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_UUID",
  "SlaveLagQueryMasterHost": "Master_Host",
  "SlaveLagQueryMasterPort": "Master_Port",
  "SlaveLagQueryMasterUser": "Master_User",
  "SlaveLagQueryMasterPassword": "Master_Password",
  "SlaveLagQueryMasterLogFile": "Master_Log_File",
  "SlaveLagQueryMasterLogPos": "Master_Log_Pos",
  "SlaveLagQueryRelayLogFile": "Relay_Log_File",
  "SlaveLagQueryRelayLogPos": "Relay_Log_Pos",
  "SlaveLagQueryReadMasterLogFile": "Read_Master_Log_File",
  "SlaveLagQueryReadMasterLogPos": "Read_Master_Log_Pos",
  "SlaveLagQueryMasterServerID": "Master_Server_ID",
  "SlaveLagQueryMasterUUID": "Master_