Re: MySQL native replication between InnoDB clusters in different data centers

[Frederic Descamps]

Hi Dimitre,

Will you replicate in both way ? from DC1 to DC2 and from DC2 to DC1 ?
If so, this is not recommended. Conflicts won't be resolved and asynchronous replication might break.

If not, you can indeed use async between both servers and you can also replicate the innodbmetada without filtering if your clusters have a different cluster and replicaset id:


*************************** 1. row ***************************
cluster_id: 2 <---
cluster_name: fred
default_replicaset: 2 <---
description: Default Cluster
mysql_user_accounts: NULL
options: null
attributes: {"default": true}

so you can setup your second dc (dc2) from a backup of one of the member of the cluster in dc1.

regards,