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:
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