@cohult - The notifications and subscriptions feature will tell you that secondary has been updated by primary or not, but is there a way that the secondary can access the last trans-id of the primary or other nodes, so that it can check whether a secondary is completely upto date.
The use-case is:
P is primary and S1,S2 are secondaries
Let’s say connection between P and S1 is broken and something is committed in P (tid=t1)
Now, the replication mode by default is ‘sync’, but since S1 connection is broken so P would not know about S1.
So end result is S1 is out-of-sync (does not have t1) but S2 is in-sync (has t1)
Now, P dies and S1 becomes Primary so it will replicate to other nodes and the t1 is lost(config is lost)
I want to check if I can compare transaction-ids across nodes or any other way where I am able to determine that S1 is out-of-sync so when HAFW chooses S1 to be primary, I can do these additional checks in the code and reject the ‘primary’ status since the instance is out-of-sync.
I have read about Active-Active and tried the demo as referenced in Multiple confD instances running standalone shared CDB - Installation - ConfD User Community (tail-f.com) but I want to solve this problem with Active-Standup setup.