In order to use a heartbeat/monitoring feature of a popular load balancer, I implemented a table called “db_status” with single column “status_cd” and single row, either “up” or “down”. But the replication scheme defeats the purpose of this table since it propagates the value to the other nodes of the cluster. I’ve attempted using the standard MySQL “replicate-ignore-table” and “replicate-wild-ignore-table” in my.cnf:
replicate-wild-ignore-table=mysql.db_status
or:
replicate-ignore-table=mysql.db_status
But it doesn’t work. The table’s “up” or “down” value is still transmitted.
Is there a way to filter out tables while using Percona Xtradb Cluster?
Using PXC 5.7.12 on RHEL7