Hi,
I was wondering if there is any option to exclude some databases from cluster, that is private to only that node.?
I tried “replicate-ignore-db” in my.cnf but it didn’t work!.
Replication filters are working with standard MySQL replication, but not with Galera based replication. The XtraDB Cluster is designed to work best with identical data sets on each node, and any node that is suspected to have different data then others will be suspended.
Theoretically, on your own risk, you can create MyISAM tables just on single node where wsrep_replicate_myisam is OFF on all nodes.
So its not supported officially by the cluster!.
would love to have this option as it will be more customizable…
anyway thanx for the information.