Im currently evaluating our future MySQL Architecture. We already had an Percona Consultant here, so we decided to stick with asynchronous write replication.
Therefore we are currently looking to introduce MHA or Orchestrator. Because MHA is itself not trivial runnable in HA mode and because of:
I’m highly interested in Orchestrator at the Moment, but also the setup is more complicated.
Now I also took a look at PMM and it is bundled with an Orchestrator version. Is the bundled Orchestrator meant as a fully blown Replication Manager which also handles failovers?
If yes, is it possible to “cluster” two instances of PMM together somehow?