search

openark / orchestrator

MySQL replication topology management and HA
Apache License 2.0
5.61k stars 926 forks source link

Binlog saving, parsing and transfer from failed server to new master #45

Open leeparayno opened 7 years ago

leeparayno commented 7 years ago

Hello,

I'm comparing MHA to Orchestrator and I was wondering if in non-GTID replicated environments in cases where the master fails, does Orchestrator make any effort to save, parse and transfer binlog entries from the failed MySQL master to the new MySQL master to coalesce any data that was not captured on the new master through normal MySQL replication?

If not, is this something that would ever been attempted/on the roadmap for the future?

shlomi-noach commented 7 years ago

What we have under development right now is https://github.com/github/orchestrator/pull/48 (see also #42 , #32) -- which is MHA-like behavior of syncing the relaylogs of all replicas, potentially mitigating lost entries.

But this isn't what you were asking for: you were asking for those last remaining binlog entries from the master itself, assuming it is available. This isn't being worked on, though #32 and #42 make it quite easy to implement.

So I'd suggest after #48 is good to go we can proceed with copying binlog entries from master.

Thank you for the suggestion!

leeparayno commented 7 years ago

Nice Shlomi!

Looks like the scaffolding is all in place. Great to hear; looking forward to future iterations implementing the new code into failover scenarios.

Lee Parayno Sent from my iPhone

On Jan 11, 2017, at 10:23 PM, Shlomi Noach notifications@github.com wrote:

What we have under development right now is #48 (see also #42 , #32) -- which is MHA-like behavior of syncing the relaylogs of all replicas, potentially mitigating lost entries.

But this isn't what you were asking for: you were asking for those last remaining binlog entries from the master itself, assuming it is available. This isn't being worked on, though #32 and #42 make it quite easy to implement.

So I'd suggest after #48 is good to go we can proceed with copying binlog entries from master.

Thank you for the suggestion!

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

shlomi-noach commented 7 years ago

@leeparayno as quick update that at this time this isn't being on our focus. We took a shot at relay-log synching and found there are many complications to running that. We took a step back and will continue to consider it, but right now focusing on other stuff. FYI

leeworker commented 2 years ago

Hello, is this function still planned to be implemented