Disaster Recovery 101: Architecting Auto-Failovers for MySQL and PHP Deployments on Linode

Establishing a High-Availability MySQL Cluster with Orchestrator

For mission-critical applications, a single MySQL instance is a single point of failure. Architecting for high availability (HA) necessitates a robust failover strategy. We’ll leverage Orchestrator, a popular open-source tool, to manage a MySQL replication topology and automate failover. This approach focuses on a primary-secondary (master-slave) setup, which is simpler to implement and manage for many use cases compared to multi-primary solutions, while still providing significant resilience.

Our target environment is Linode, chosen for its cost-effectiveness and straightforward cloud infrastructure management. We’ll assume three Linode instances: one for the Orchestrator service, and two for MySQL nodes (one primary, one replica). In a production scenario, you’d likely have more MySQL nodes for redundancy and read scaling, and potentially a separate, highly available Orchestrator cluster itself.

Orchestrator Installation and Configuration

First, install Orchestrator on its dedicated Linode instance. We’ll use `wget` and `dpkg` for a Debian/Ubuntu system. Ensure your Orchestrator node can reach your MySQL nodes via SSH (using key-based authentication is highly recommended) and MySQL ports (default 3306).

Download the latest stable release:

wget https://github.com/openark/orchestrator/releases/download/v3.2.7/orchestrator_3.2.7_linux_amd64.deb
sudo dpkg -i orchestrator_3.2.7_linux_amd64.deb

Next, configure Orchestrator. The primary configuration file is typically located at /etc/orchestrator/orchestrator.conf.json. We need to define how Orchestrator connects to MySQL and how it discovers topology. For simplicity, we’ll use a MySQL backend for Orchestrator’s internal state. This requires a separate MySQL instance for Orchestrator itself, or you can use one of your application MySQL nodes if you accept the risk.

Create a dedicated MySQL database for Orchestrator:

-- On the MySQL instance designated for Orchestrator's backend
CREATE DATABASE orchestrator;
CREATE USER 'orchestrator'@'%' IDENTIFIED BY 'your_strong_password';
GRANT ALL PRIVILEGES ON orchestrator.* TO 'orchestrator'@'%';
FLUSH PRIVILEGES;

Now, edit Orchestrator’s configuration file. Replace placeholders with your actual credentials and hostnames/IPs.

{
  "Debug": false,
  "ListenAddress": ":3000",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLOrchestratorHost": "your_orchestrator_backend_mysql_host",
  "MySQLOrchestratorPort": 3306,
  "MySQLOrchestratorDatabase": "orchestrator",
  "MySQLOrchestratorUser": "orchestrator",
  "MySQLOrchestratorPassword": "your_strong_password",
  "DiscoveryByCategory": true,
  "InstancePollSeconds": 30,
  "FailureDetectionPeriodBlockSeconds": 600,
  "RecoveryPeriodBlockSeconds": 300,
  "DetectClusterAliasConflicts": true,
  "DetectClusterAliasGroupConflicts": true,
  "SlaveLagQuery": "SELECT * FROM mysql.slave_lag_master_info",
  "SlaveLagQueryError": "Slave is not running",
  "SlaveLagQueryWhenLagging": "SELECT * FROM mysql.slave_lag_master_info",
  "SlaveLagQueryWhenLaggingError": "Slave is not running",
  "PromotionForgetMasterSeconds": 3600,
  "PromotionForgetSlaveSeconds": 3600,
  "SnapshotTopologiesIntervalHours": 24,
  "SnapshotTopologiesCommand": "/usr/bin/orchestrator-client --snapshot-this-cluster",
  "PostUnsuccessfulFailoverProcesses": [
    "echo 'Failover failed for {{.ClusterAlias}}'"
  ],
  "PostSuccessfulFailoverProcesses": [
    "echo 'Failover succeeded for {{.ClusterAlias}}'"
  ],
  "PreFailoverProcesses": [],
  "PostFailoverProcesses": [],
  "PrePromotionProcesses": [],
  "PostPromotionProcesses": [],
  "PreResynchronizationProcesses": [],
  "PostResynchronizationProcesses": [],
  "PreIntermediateMasterDetectionProcesses": [],
  "PostIntermediateMasterDetectionProcesses": [],
  "PreIntermediateMasterRecoveryProcesses": [],
  "PostIntermediateMasterRecoveryProcesses": [],
  "PreIntermediateMasterPromotionProcesses": [],
  "PostIntermediateMasterPromotionProcesses": [],
  "PreIntermediateMasterDemotionProcesses": [],
  "PostIntermediateMasterDemotionProcesses": [],
  "PreIntermediateMasterDeactivationProcesses": [],
  "PostIntermediateMasterDeactivationProcesses": [],
  "PreIntermediateMasterReactivationProcesses": [],
  "PostIntermediateMasterReactivationProcesses": [],
  "PreIntermediateMasterResynchronizationProcesses": [],
  "PostIntermediateMasterResynchronizationProcesses": [],
  "PreIntermediateMasterDecommissionProcesses": [],
  "PostIntermediateMasterDecommissionProcesses": [],
  "PreIntermediateMasterRecommissionProcesses": [],
  "PostIntermediateMasterRecommissionProcesses": [],
  "PreIntermediateMasterReplacementProcesses": [],
  "PostIntermediateMasterReplacementProcesses": [],
  "PreIntermediateMasterReplacementDiscoveryProcesses": [],
  "PostIntermediateMasterReplacementDiscoveryProcesses": [],
  "PreIntermediateMasterReplacementPromotionProcesses": [],
  "PostIntermediateMasterReplacementPromotionProcesses": [],
  "PreIntermediateMasterReplacementDemotionProcesses": [],
  "PostIntermediateMasterReplacementDemotionProcesses": [],
  "PreIntermediateMasterReplacementDeactivationProcesses": [],
  "PostIntermediateMasterReplacementDeactivationProcesses": [],
  "PreIntermediateMasterReplacementReactivationProcesses": [],
  "PostIntermediateMasterReplacementReactivationProcesses": [],
  "PreIntermediateMasterReplacementResynchronizationProcesses": [],
  "PostIntermediateMasterReplacementResynchronizationProcesses": [],
  "PreIntermediateMasterReplacementDecommissionProcesses": [],
  "PostIntermediateMasterReplacementDecommissionProcesses": [],
  "PreIntermediateMasterReplacementRecommissionProcesses": [],
  "PostIntermediateMasterReplacementRecommissionProcesses": [],
  "PreIntermediateMasterReplacementProcesses": [],
  "PostIntermediateMasterReplacementProcesses": [],
  "PreIntermediateMasterReplacementDiscoveryProcesses": [],
  "PostIntermediateMasterReplacementDiscoveryProcesses": [],
  "PreIntermediateMasterReplacementPromotionProcesses": [],
  "PostIntermediateMasterReplacementPromotionProcesses": [],
  "PreIntermediateMasterReplacementDemotionProcesses": [],
  "PostIntermediateMasterReplacementDemotionProcesses": [],
  "PreIntermediateMasterReplacementDeactivationProcesses": [],
  "PostIntermediateMasterReplacementDeactivationProcesses": [],
  "PreIntermediateMasterReplacementReactivationProcesses": [],
  "PostIntermediateMasterReplacementReactivationProcesses": [],
  "PreIntermediateMasterReplacementResynchronizationProcesses": [],
  "PostIntermediateMasterReplacementResynchronizationProcesses": [],
  "PreIntermediateMasterReplacementDecommissionProcesses": [],
  "PostIntermediateMasterReplacementDecommissionProcesses": [],
  "PreIntermediateMasterReplacementRecommissionProcesses": [],
  "PostIntermediateMasterReplacementRecommissionProcesses": [],
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyCredentialsFile": "/etc/orchestrator/orchestrator-mysql-credentials.txt",
  "MySQLTopologyUser": "orchestrator",
  "MySQLTopologyPassword": "your_mysql_password",
  "MySQLTopologyCredentialsConfigFile":