Multi master cluster question

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hello,

I apologize for the following question but I am starting out with XtraDB cluster.

I have a scenario where I run 4 servers with different sites (so 4 masters), now I need to add one server where all 4 databases would consolidate. I need the setup to be flexible where I could add more servers to replicate the database for Server2.

Also is it possible select which database gets replicated instead of the cluster trying to replicate everything?

Again, I apologize for the noob questions.

2

Theoretically PXC cluster could act as a consolidation point for many asynchronous masters, but you need at least as many nodes as the async masters. If you want to consolidate to just one server, then this would be another solution:
[url]https://www.percona.com/blog/2013/10/02/mysql-5-7-multi-source-replication/[/url]