SQL

orchestrator – MySQL high availability and replication management tool

orchestrator is a MySQL high availability and replication management tool, runs as a service and provides command line access, HTTP API and Web interface.

It requires its own MySQL database as a backend server to store all information related to the Orchestrator managed database cluster topologies.

Orchestrator only needs a MySQL user with limited privileges (SUPER, PROCESS, REPLICATION SLAVE, RELOAD) to connect to the database servers.

The original openark/orchestrator repository was archived in February 2025 and is no longer maintained there. Percona provides a fork containing changes developed primarily for its Kubernetes Operators. Percona does not present itself as the general public maintainer of the original project, so administrators should assess the available fork and maintenance arrangements before adopting the software for new deployments.

Key Features

  • Discovery – actively crawls through your topologies and maps them. It reads basic MySQL info such as replication status and configuration.
  • Refactoring – understands replication rules. It knows about binlog file:position, GTID, Pseudo GTID, Binlog Servers.
  • Recovery – uses a holistic approach to detect master and intermediate master failures. Based on information gained from the topology itself, it recognizes a variety of failure scenarios.
  • Interface that supports:
    • Command line interface.
    • Web API (HTTP GET access).
    • Web interface.
  • Topology and status of the replication tree is automatically detected and monitored
  • Highly available.
  • Supports many different types of topologies, from a single master -> slave to complex multi-layered replication trees consisting of hundreds of servers
  • Controlled master takeovers.
  • Supports automatic failover of the master, and the replication tree can be fixed when servers in the tree fail – either manually or automatically.
  • Manual failovers.
  • Failover auditing.
  • Audited operations.
  • Pseudo-GTID.
  • Datacenter/physical location awareness.
  • MySQL-Pool association.
  • HTTP security/authentication methods.
  • An orchestrator-mysql Google groups forum to discuss topics related to orchestrator.

Website: github.com/openark/orchestrator
Support:
Developer: Shlomi Noach and many contributors
License: Apache License 2.0

orchestrator

orchestrator is written in Go. Learn Go with our recommended free books and free tutorials.


Related Software

MySQL Tools
DBeaverUniversal database tool
phpMyAdminMySQL web administration tool
MySQL WorkbenchComplete visual database design tool
mycliCommand line interface for MySQL, MariaDB, and Percona
gh-ostGitHub's Online Schema Migrations for MySQL
Beekeeper Studio Cross-platform SQL editor and database manager
usqlCommand-line database client
sqlitlazygit of SQL databases
MySQLTunerAnalyse MySQL performance and suggest configuration changes
HarlequinEasy, fast, and beautiful database client for the terminal
DbGateDatabase manager for MySQL, PostgreSQL, MongoDB
Percona ToolkitEssential command-line utilities for MySQL
SQuirreL SQL ClientGraphical SQL client written in Java
AdminerFull-featured tool for managing content in MySQL database
dblabInteractive client for PostgreSQL, MySQL, SQLite3, and more
MyDumperParallel utilities for fast MySQL database backups and restores
AntaresSQL client based on Electron.js and Vue.js
XtraBackupBackup utility for MySQL
innotopReal-time, advanced investigation tool
SkeemaManage MySQL and MariaDB schema changes
vi-sqlTerminal SQL client for browsing, querying and editing databases
MySQL ShellAdvanced MySQL console for scripting and database administration
SequelerNative Linux SQL client built in Vala and Gtk

Read our verdict in the software roundup.


Best Free and Open Source Software LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.

We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more.

Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion.

Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README.
Subscribe

Please read our Comment Policy before commenting.

Notify of
guest
0 Comments
Oldest
Newest Most Voted