Which choice supports better cross DC setup?

[supple shuttle]

According to https://github.com/openark/orchestrator/blob/master/docs/raft.md, raft is good for cross DC.

But what about the MySQL replicas? The transaction replication data is fully controlled by MySQL, NOT by Orchestrator, right?

What kind of mysql replication should I choose to work with Raft for better cross DC support?

Thank you so much! Looking forward for your help on this!

[supple shuttle]

I found this: https://github.blog/2018-06-20-mysql-high-availability-at-github/

Maybe it can answer my question.

[Simon Mudd]

Hi,

> On 5 May 2021, at 03:43, supple shuttle <sea...@gmail.com> wrote:
>
> I found this: https://github.blog/2018-06-20-mysql-high-availability-at-github/
>
> Maybe it can answer my question.

Another option is to make the orchestrator backend run GR / InnoDB Cluster and ensure that orchestrator app is redirected to the primary
when it changes.
This option also works well.

Simon