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.
- 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.
- Datacenter/physical location awareness.
- MySQL-Pool association.
- HTTP security/authentication methods.
- An orchestrator-mysql Google groups forum to discuss topics related to orchestrator.
|New to Linux? Read our Linux for Starters series.|
|The largest compilation of the best free and open source software in the universe. Supplied with our legendary ratings charts.|
|Hundreds of in-depth reviews offering our unbiased and expert opinion on software.|
|Alternatives to Google's Products and Services examines your options to migrate from the Google ecosystem with open source Linux alternatives.|
|Essential Linux system tools looks at small, indispensable utilities, useful for system administrators as well as regular users.|
|Linux utilities to maximise your productivity. Small, indispensable tools, useful for anyone running a Linux machine.|
|Home computers became commonplace in the 1980s. Emulate home computers such as the ZX81, Amstrad CPC, and ZX Spectrum.|
|Now and Then examines how promising open source software fared over the years.|
|Linux at Home looks at a range of home activities where Linux can play its part, making the most of our time at home, keeping active and engaged.|
|Linux Candy opens up to the lighter side of Linux. Have some fun!|
|Best Free Android Apps. There's a strict eligibility criteria for inclusion in this series|
|These best free books accelerate your learning of every programming language|
|These free tutorials offer the perfect tonic to the free programming books series|
|Stars and Stripes is an occasional series looking at the impact of Linux in the USA|