# Cluster / Redundancy / Database Indication **URL:** \ **Category:** Archived Topics\ **Created:** [March 4, 2010, 8:57pm UTC](https://forum.inductiveautomation.com/t/cluster-redundancy-database-indication/1603 "2010-03-04T20:57:12Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![sydneydean](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sydneydean/32/4234_2.png) [@sydneydean](https://forum.inductiveautomation.com/u/sydneydean)\ **Post date:** [March 4, 2010, 8:57pm UTC](https://forum.inductiveautomation.com/t/cluster-redundancy-database-indication/1603/1 "2010-03-04T20:57:12Z")
We are using two identical servers in our configuration. Clustering is set up through FPMI. Redundancy is set up though FPMI. There is also a MYSQL database server on each machine which failover in the event one of the machines fail. I am wanting to try to do two things. 1. Display the cluster status for FPMI, redundancy status for FSQL, and hopefull the database connectivity status on the PMI screens. 2. Use Alerting in PMI to generate alarm messages if one node in the cluster is down, the FSQL warm backup is not available, or the database has failed over. Anybody done this before or have any ideas? Thanks, Syd ---
**Author:** ![sydneydean](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sydneydean/32/4234_2.png) [@sydneydean](https://forum.inductiveautomation.com/u/sydneydean)\ **Post date:** [March 19, 2010, 3:01pm UTC](https://forum.inductiveautomation.com/t/cluster-redundancy-database-indication/1603/2 "2010-03-19T15:01:04Z")
FSQL status: I queried the fsql\_responsibility table for the node\_ip based upon the responsibility state to determine which node was the master and which was the backup, additionally select the node\_state and the project\_state to see that they are running and active. FPMI: Thanks to Bobby’s help, I got a script that goes out to the gateway addresss and then the cluster map page. I search for master and member for each node and determine that status that way. Database: Do basically the same thing as FPMI except this time look at the datasources tab and determine the status from there. I added a global script event that runs every 15 seconds that calls the FPMI script and the database script and then just writes the status returned to a database tag. ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [March 19, 2010, 3:54pm UTC](https://forum.inductiveautomation.com/t/cluster-redundancy-database-indication/1603/3 "2010-03-19T15:54:10Z")
Thanks for posting your solutions back here, that is helpful.