Ignition Redundance and Database failover

[PGriffith]

Going to copy and paste this comment over:

Database Redundancy ( Failover Datasource )

In almost all scenarios, I would recommend relying on your RDBMS’s failover rather than Ignition’s failover settings. Many RDBMS failover scenarios offer some kind of ‘virtual IP’ or hostname; Ignition connects to that as a client, and if there’s a problem with DB A, queries will automatically be rerouted to DB B. Ignition’s failover is basically the same idea, but it’s “dumb”; all it does is see that a query to DB A failed and immediately attempt to run the same query on DB B. You don’t need …