Step-by-Step Installation and Configuration Guide for MySQL Orchestrator (v3.2.6)
This article provides a comprehensive tutorial on installing and configuring the MySQL Orchestrator high‑availability tool, covering required host environments, software download, extraction, backend MySQL user setup, configuration file editing, service startup, and web UI access.
This article provides a detailed installation and configuration guide for the MySQL Orchestrator high‑availability tool (example version 3.2.6), including required host environments, software download, extraction, backend MySQL user creation, configuration file editing, and service startup.
Environment: three orchestrator hosts (10.186.65.5, 10.186.65.11, 10.186.65.26) and a MySQL backend at 10.186.65.29:3307.
Installation steps:
# Download specified version
yum -y install wget jq
dir_software="/opt/software/"
mkdir -p ${dir_software}
cd ${dir_software}
wget -c https://github.com/openark/orchestrator/releases/download/v3.2.6/orchestrator-3.2.6-linux-amd64.tar.gz# Install
cd /
tar -zxvf /${dir_software}/orchestrator-3.2.6-linux-amd64.tar.gz# Create MySQL schema and users for each orchestrator host
CREATE DATABASE IF NOT EXISTS orchestrator;
CREATE USER 'orchestrator'@'10.186.65.5' IDENTIFIED BY 'Orch@123';
GRANT ALL PRIVILEGES ON orchestrator.* TO 'orchestrator'@'10.186.65.5';
CREATE USER 'orchestrator'@'10.186.65.11' IDENTIFIED BY 'Orch@123';
GRANT ALL PRIVILEGES ON orchestrator.* TO 'orchestrator'@'10.186.65.11';
CREATE USER 'orchestrator'@'10.186.65.26' IDENTIFIED BY 'Orch@123';
GRANT ALL PRIVILEGES ON orchestrator.* TO 'orchestrator'@'10.186.65.26';# Configure orchestrator.conf.json (example excerpt)
"MySQLOrchestratorHost": "10.186.65.29",
"MySQLOrchestratorPort": 3307,
"MySQLOrchestratorDatabase": "orchestrator",
"MySQLOrchestratorUser": "orchestrator",
"MySQLOrchestratorPassword": "Orch@123",
...
"RaftEnabled": true,
"RaftBind": "10.186.65.26",
"RaftDataDir": "/usr/local/orchestrator",
"RaftNodes": ["10.186.65.5","10.186.65.11","10.186.65.26"]# Start the service
cd /usr/local/orchestrator
nohup ./orchestrator -config /etc/orchestrator.conf.json http &# Add orchestrator binaries to PATH
export PATH=$PATH:/usr/local/orchestrator/:/usr/local/orchestrator/resources/bin/# Access the web UI at the following URLs:
http://10.186.65.5:3000
http://10.186.65.11:3000
http://10.186.65.26:3000Aikesheng Open Source Community
The Aikesheng Open Source Community provides stable, enterprise‑grade MySQL open‑source tools and services, releases a premium open‑source component each year (1024), and continuously operates and maintains them.
How this landed with the community
Was this worth your time?
0 Comments
Thoughtful readers leave field notes, pushback, and hard-won operational detail here.