MySQL Forums
Forum List  »  InnoDB clusters

Re: MySQL native replication between InnoDB clusters in different data centers
Posted by: Frederic Descamps
Date: February 05, 2018 05:24AM

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,

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL native replication between InnoDB clusters in different data centers
948
February 05, 2018 05:24AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.