Bundled Orchestrator as HA Solution?

[Alwin_Mark]

Hello,

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:

It does check a broken node’s

slaves replication state to determine if Orchestrator isn’t the only one losing connectivity (in

which it should just do nothing with the production servers). This is already a big improvement

compared to MySQLFailover, MHA or even MaxScale’s failoverscripts.

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?

[Michael_Coburn]

Hi Alwin Mark ,

Orchestrator is bundled as part of PMM, but by default is left unconfigured. We document the steps to get Orchestrator functional.
https://www.percona.com/doc/percona-monitoring-and-management/using.html#orchestrator
https://github.com/github/orchestrator

Regarding clustering of PMM, at this time we do not support any interaction between multiple PMM server instances. Since your post focuses on Orchestrator, in what use case would you like to see Orchestrator “clustered”? for HA? If that is the concern, have you reviewed: https://github.com/github/orchestrator/blob/master/docs/high-availability.md

Which parts of this HA plan would you like to see supported by PMM?

[harrison]

A little over a year after the original post, I would like to see if there is still any interest or if any work concerning this has been done.

I personally would like to see HA for Orchestrator via a shared backend because that seems pretty straightforward to me, though I do not know how/if multiple orchestrator instances could work on a single PMM Docker instance.

The HA raft option seems interesting too.

I would also be interested in what efforts can be made to make PMM itself (docker container especially) highly available.

[Michael_Coburn]

Hi harrison

These are great points! Percona is also interested in making PMM Server highly available - what approaches do you think we ought to consider for PMM docker container?

Specifically for Orchestrator we are still shipping with PMM Server but we are disabling by default, since our attention is primarily on the Monitoring component of PMM, and this isn’t forecasted to change over the coming months.