Replication between two clusters

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hello,

Please advise how to configure replication between two independent clusters?
I have two fully operatable pxc cluster with 3 nodes in each.
Each cluster have its own and different databases and configured inner replication (sst xtrabackup).
I need to replicate only one database from pxc1 to pxc2.
Is it possible to achieve this type of replication?

Thanks.

1 Like
2

Yes, you can do this. You need to set up traditional async replication between two nodes, one in each cluster. Use replication filtering (ie: replicate-do-db) to limit which databases replicate to the other cluster.

2 Likes