[MXS-190] Automatic FAILOVER for MULTI MASTER Created: 2015-06-11 Updated: 2016-10-17 Resolved: 2016-10-17 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | Core |
| Affects Version/s: | None |
| Fix Version/s: | N/A |
| Type: | New Feature | Priority: | Major |
| Reporter: | VAROQUI Stephane | Assignee: | Unassigned |
| Resolution: | Won't Do | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||||||
| Description |
|
There is 2 scenarios to consider : 1 - The master was ok (normal shutdown or unreachable ) 1 - How to detect a normal shutdown or unreachable ? 2 - We can avoid provisioning for automatic failover when master is crashed if we can fail over on an already up to date candidate master to preserve consistency of the cluster We have again 2 scenarios: 2.1 - Proxy maintain backlog
2.2 - Proxy track synchronous replication state and failover on state ok
2.1.2 - We add a backlog of WRITE queries and their respective GTID Failover do:
The backlog architecture is not 100% safe because keeping track of all writes queries and replaying them does not guaranty that it produce the same state on the candidate master except in serialize mode 2.1.3 - Binlog server and semi-sync replication, the back log is all the bin logs not yet applied to the candidate master 2.2.1 - Do not use backlog but track semi-sync replication state Failover do:
For delegating failover to external script we need to pass backlog and or last _rpl_semi_sync_master_timeout status |
| Comments |
| Comment by Johan Wikman [ 2016-10-17 ] |
|
This seems to belong to the realm of the MariaDB Replication Manager. |