MySQL InnoDB Cluster is the High Availability solution for MySQL.
It delivers automatic fail-over and guarantees zero data loss
RPO: Recovery Point Objective describes the interval of time that might pass during a disruption before the quantity of data lost during that period exceeds the Business Continuity Plan’s maximum allowable tolerance.
Example: our business architecture needs to have RPO=2 minutes. This means that in case of failure, 2 minutes of data can be lost.
However, and we saw this recently in Europe, an entire data center can “disappear” instantaneously… So it’s also important to have a Disaster Recovery plan.
One solution, is to have an InnoDB Cluster (Group Replication) that spans across multiple regions. However, this is often not feasible because of high latency across regions.
Another solution is InnoDB Cluster in one region with Asynchronous …[Read more]