My Oracle Support Banner

How To Setup And Maintain InnoDB Cluster Geo-Redundancy Across Different Data Centers? (Doc ID 2604104.1)

Last updated on APRIL 08, 2021

Applies to:

MySQL Server - Version 5.7 and later
Information in this document applies to any platform.

Goal

Disclaimer: Starting from v8.0, some terms have been deprecated. Older releases will only use the deprecated terminology, and new releases will only use new terminology. Please see https://dev.mysql.com/doc/mysqld-version-reference/en/ for a complete list of those changes, and in which minor versions it happened.

Understand how to maintain a geographically redundant setup with InnoDB Cluster or Group Replication cluster across different sites or data centers.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 DC: InnoDB Cluster -> MySQL Router -> DR: Standalone MySQL Server
 DC: Group Replication -> DR: Group Replication
 Setup
 Failover of primary instance in DR
 Failover of primary instance in DR with Consul
 Stretch InnoDB Cluster across 2 or more data centers with dedicated network with extremely low latency
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.