Looking for some ideas, or perhaps best practice. I am working on a system with a redundant pair of Ignition servers. Each server has its own SQL server instance. As I was setting this up, I was wondering about the best way to set up the database failover. The database is nothing fancy, so I opt…

[image] Dustin_VanKeuren: Each server has its own SQL server instance Ewww! [image] Dustin_VanKeuren: basic availability groups in SQL Server 2019 (acts like a failover pair in earlier versions). I'm not terribly familiar with these options, but my customers using SQL Server do the DB…

I am not really familiar with the new methods for this is SQL server. Since their is only one database, and it is small, I was trying to go as simple as possible. I am proceeding with (trying to) setting up the db fail-over and have the Ignition config point to both. Will just have a fail-over co…

Going to copy and paste this comment over: [image] Database Redundancy ( Failover Datasource ) Ignition 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 ‘…

Ignition Redundance and Database failover

Ignition

paul-griffith May 25, 2022, 3:35pm 4

Going to copy and paste this comment over: