MariaDB Galera cluster: are replicate-do-db filters applied before or after data sent?

578 views Asked by At

I would like to synchronize only some databases on a cluster, with replicate-do-db.

→ If I use the Galera cluster, are all data sent over the network, or are nodes smart enough to only fetch their specific databases?

On "classic" master/slave MariaDB replication, filters are made by the slave, causing network charge for nothing if you don't replicate that database. You have to configure a blackhole proxy to filter binary logs to avoid this (setup example), but the administration after is not really easy. So it would be perfect with a cluster if I can perform the same thing :)

1

There are 1 answers

1
Rick James On

binlog_... are performed in the sending (Master) node.

replicate_... are performed in the receiving (Slave) node.

Is this filtered server part of the cluster? If so, you are destroying much of the beauty of Galera.

On the other hand, if this is a Slave hanging off one of the Galera nodes and the Slave does not participate in the "cluster", this is a reasonable architecture.