I have a pair of FactorySQLs running in redundant mode. Since redundancy is dependant on the database i.e. its using DB table to monitor and be Active/Standby, if the Database goes down, how will the systems know which is Active? Can you kindly explain
If the database goes down, it will indeed be impossible to determine who should be master. Instead, both nodes will run as “provisional master”, meaning that both nodes will operate, but historical data will be cached. When the database is available again, they will determine who should be master based on the standard criteria as well as the amount of cache data. When the decision is made, the master will write its data cache to the database, and the backup will delete its cache.
Hope this answers your question,