Practical Orchestrator Tutorial

Monday 1:30PM-4:30PM

@ Goldsmith 1

MySQL / MariaDB

3 hours tutorial



Orchestrator is a MySQL topology manager and a failover solution, used in production on many large MySQL installments. It allows for detecting, querying and refactoring complex replication topologies, and provides reliable failure detection and intelligent recovery & promotion.

This tutorial walks through Orchestrator's setup, deployment and usage best practices. We will focus on major functionality points and share authoritative advice on practical production use.

Our cheat sheet covers:

- Detection: resolving, classification, pools, inspection.
- Topologies: Pseudo GTID, refactoring, querying for info.
- Failovers: configuration, promotion preferences, hooks, downtime, acknowledgements, planned failovers.
- Scripting: putting-it-all-together use case for automating failover tests.
- HA: Making orchestrator highly available, including recent consensus development.

This tutorial will be hands off, and open to discussion and examples by/for the attendees.


Shlomi Noach

Shlomi Noach (GitHub)

Senior Infrastructure Engineer


Shlomi is an engineer and a database geek. He is an active MySQL community member, authors gh-ost, orchestrator, common_schema and other open source tools, and blogs at Shlomi works at GitHub on the database infrastructure team keeping the data flowing. Previously he managed high availability of X,000 of MySQL servers at, and prior to that solved infrastructure problems at Outbrain. He is recipient of Oracle ACE, Oracle Technologist of the Year, and MySQL Community Member of the Year awards.


  Download Slides  

Percona Live

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@)
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA