We have a three node percona cluster configured. On all of the 3 nodes we can see the wsrep_local_state = 4 and wsrep_local_state_comment = Synced.
when we actually look at the database sizes they are different on each nodes. Also to justify , i have investigated the last time one the of user database table was updated was 10 days ago.
how do we fix the database sync issue also why does the galera cluster shows a false status when it is actually isn’t in SYNC?