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.
Related documentation:
High Availability (FortiNAC-OS)
Troubleshooting Tip: Solve database or replication issues in the secondary node
