Sync only one database

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hello everybody,

I have one little question, maybe someone have a idea :slight_smile:
I want to set up a XtraDB Cluster with 3 or more nodes.

Is it possible to sync only one database in the cluster, like a master-slave replication ?
On one node we have the “mother” database and we would like to have it on x nodes.

Maybe someone of you have a hint for me ? :slight_smile:

Thanks in advanced.

regards
Pathet

PS: Sorry, my englisch is bad… :-/

2

By default Pxc replicates everything, and using replication filters are not supported, just point your application to write to only master node!, rest of the nodes will sync automatically and act like slaves!.

3

ok, thank for your reply =)