Technical Tip: A quick method to verify database synchronization in an HA cluster
Description
This article describes a simple method to quickly verify database synchronization between two nodes in a High Availability (HA) cluster.
Scope
FortiNAC.
Solution
When the primary node is in control and the cluster is healthy, database synchronization from the primary to the secondary node occurs almost instantly. In this case, the Events table will be used to check the synchronization status.
In the primary node's Admin interface, go to Logs -> Events & Alarms.
 
In the secondary node CLI, run the following commands:
fnac74s # execute db-shell
MariaDB [bsc]> SELECT FROM_UNIXTIME(`time` / 1000) AS time_readable, name, elementName FROM EVENTS ORDER BY `time` DESC LIMIT 10;
 
The list of events, depending on how quickly the command was executed on the secondary node, should display the same events that appear in the primary node’s Admin UI.
Note:
In newer versions of FortiNAC starting from v7.6.3, the command to check database replication is as follows:
On a primary node:
execute enter-shell
RunClient FailoverConsole checkDBSyncUpToDate primary
On a secondary node:
execute enter-shell
RunClient FailoverConsole checkDBSyncUpToDate secondary
Related documentation: