In a failover configuration, is there a tool/script we can use to verify that all the files are properly sync between the Main and Failover agent ?
In Cube there is possiblity for force sync but there is no way to verify that the DMA are sync together
Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 11th July 2023
There is a basic Cube GUI that can run some checks:
System Center> Agents >( rightclick or select agent)> Failover > Sync Status
it has option to check boxes and force the sync of a given data table, but I guess deploy squads can use something more advanced locally - depending on the DB environment (I think this is less relevant in Cassandra deplyment).
HTH,
A.
Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 11th July 2023
PS: that window has two tabs – Database/Sync
This is related to the data set though – e.g. if you need to check that the users file is actually in sync, this is part of inter-DMA file sync, I don’t know if the main to stand-by (intra-DMA) sync handles that aspect too. At times the best option is to failover and test.