As you know, MySQL InnoDB Cluster is a High Availability solution for MySQL. However more and more people are trying to use it as a Disaster Recovery solution with 2 data centers. Natively, this is not yet supported. But it’s already possible to realize such setup if we agree with the following points:
- a human interaction is required in case of Disaster Recovery which, by my own experience, is often acceptable
- a human interaction is required if the any Primary-Master acting as asynchronous slave leaves its group (crash, network problem, …) or becomes secondary
These are not big constraints and it’s relatively easily to deal with them.
The situation is as follow:
- 2 data centers (one active, one inactive, only used for disaster recovery)
- 2 MySQL InnoDB Clusters (one in each DC)
- 3 members in each …