0

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?

1 Answer 1

1

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"?

6
  • Other tables are regular tables, and in this scenario, they don't need any sync mechanism. By old-fashioned replication, you mean master-slave replication, right? My goal is for each server to be a master and replica simultaneously.
    – Roham
    Commented Dec 5, 2021 at 20:31
  • @Roham - What is the harm in letting the "intact" tables replicate?
    – Rick James
    Commented Dec 5, 2021 at 22:57
  • It will violate GDPR law.
    – Roham
    Commented Dec 6, 2021 at 9:04
  • @Roham you may be able to use two-way master-slave replication, i.e. master-master replication instead. Just note there are a couple of "gotchas" with that approach.
    – dbdemon
    Commented Dec 6, 2021 at 13:27
  • @dbdemon - I assumed he was talking about replication within the cluster -- Galera only replicates everything from every node to every other node. (I think.)
    – Rick James
    Commented Dec 6, 2021 at 17:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.