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.