-1
Daily
5,768
stars
952
forks
3
watchers
742
prs
756
issues
32
releases
README
Repository archived [!IMPORTANT] This repository has been archived. If you are using Orchestrator for MySQL and want to collaborate with other users in maintaining the code base, please fork https://github.com/percona/orchestrator and send pull requests there. --- orchestrator [[Documentation]](https://github.com/openark/orchestrator/tree/master/docs) !Orchestrator logo orchestrator is a MySQL high availability and replication management tool, runs as a service and provides command line access, HTTP API and Web interface. orchestrator supports: Discovery orchestrator actively crawls through your topologies and maps them. It reads basic MySQL info such as replication status and configuration. It provides you with slick visualization of your topologies, including replication problems, even in the face of failures. Refactoring orchestrator understands replication rules. It knows about binlog file:position, GTID, Pseudo GTID, Binlog Servers. Refactoring replication topologies can be a matter of drag & drop a replica under another master. Moving replicas around is safe: orchestrator will reject an illegal refactoring attempt. Fine-grained control is achieved by various command line options. Recovery orchestrator 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. Configurable, it may choose to perform automated recovery (or allow the user to choose type of manual recovery). Intermediate master recovery achieved internally to orchestrator. Master failover supported by pre/post failure hooks. Recovery process utilizes _orchestrator's_ understanding of the topology and of its ability to perform refactoring. It is based on _state_ as opposed to _configuration_: orchestrator picks the best recovery method by investigating/evaluating the topology at the time of recovery itself. The interface orchestrator supports: - Command line interface (love your debug messages, take control of automated scripting) - Web API (HTTP GET access) - Web interface, a _slick_ one. !Orcehstrator screenshot Additional perks - Highly available - Controlled master takeovers - Manual failovers - Failover auditing - Audited operations - Pseudo-GTID - Datacenter/physical location awareness - MySQL-Pool association - HTTP security/authentication methods - There is also an orchestrator-mysql Google groups forum to discuss topics related to orchestrator - More... Read the Orchestrator documentation Authored by Shlomi Noach: - 2020- as https://github.com/openark/orchestrator - 2016-2020 at GitHub as https://github.com/github/orchestrator - 2015 at Booking.com as https://github.com/outbrain/orchestrator - 2014 at Outbrain as https://github.com/outbrain/orchestrator Related projects - Orchestrator Puppet module: https://github.com/github/puppet-orchestrator-for-mysql - Orchestrator Chef Cookbook (1): https://github.com/silviabotro
Top issues
#46Who is the new intermediate master?32 comments · 2017-01-10#1203bug report,InstanceWriteBufferSize cant be more than about 100023 comments · 2020-07-03#472FR: Improve audit logging and provide quick link to Audit, Latest Recovery Steps22 comments · 2018-04-17#253orchestrator-raft: are IP addresses really required?22 comments · 2017-08-07#1288"timed out enqueuing operation" when orchestrator-client -c forget -i "ip:port"19 comments · 2021-01-07#426Maybe a bug during recovery.19 comments · 2018-03-05#1009Auto switching master, when main master not available18 comments · 2019-11-06#981The orchestrator-client AuthenticationMethod problem17 comments · 2019-09-19
Latest release
GA release v3.2.6 v3.2.6 2021-07-27Changes since https://github.com/openark/orchestrator/releases/tag/v3.2.5: https://github.com/openark/orchestrator/compare/v3.2.5...v3.2.6 Notable: - EnforceSemiSyncReplicas & RecoverLockedSemiSyncMaster - actively enable/disable semi-sync replicas to match master's wait count 1373, thanks @binwiederhier - ReasonableInstanceCheckSeconds: allows configuring the time that Orchestrator allows for a check to take before considering an instanced failed 1368, thanks @binwiederhier - ReplicationCredentialsQuery: flexible whether the query returns 2 or 5 values 1378 (bugfix) - Handle MariaDB