Databases 5 min read

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.

Aikesheng Open Source Community
Aikesheng Open Source Community
Aikesheng Open Source Community
Step-by-Step Installation and Configuration Guide for MySQL Orchestrator (v3.2.6)

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:3000
High AvailabilityconfigurationMySQLInstallationOrchestrator
Aikesheng Open Source Community
Written by

Aikesheng 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.

0 followers
Reader feedback

How this landed with the community

login Sign in to like

Rate this article

Was this worth your time?

Sign in to rate
Discussion

0 Comments

Thoughtful readers leave field notes, pushback, and hard-won operational detail here.