Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
As far as I can see, there are no do_table or ignore_table configs in MariaDB Galera multi-master (master-master) to skip or ignore specific tables. And there are only binlog_do_db and binlog_ignore_db options, which only work for databases.
I have multiple servers in my formation, and I only want to sync two tables in each server database. Other tables' data should be intact.
What do you suggest?
By "intact", do you mean that they never change? And are already "in sync"? In that case, it does not matter whether you let Galera handle them.
Galera is not designed for partial replication. Galera and any other true multi-master needs to have all tables existing on the Masters, ready for failover.
Old-fashioned Replication is designed for partial replication, but you must use it with caution. Cf replicate-do-table.
Engine
Do some research. Since Galera cannot correctly handle MyISAM or MEMORY engines, see if they are completely excluded from replication by default. Consider creating the 'intact' tables as ENGINE=MyISAM.
Definition
To get around the GDPR without really violating it, can you consider the "Cluster" as a "single computer"?
