Hi, I am having trouble with database failover. I have set up 3 connections: “a” (primary db) which is ok, “b” (secondary db) which is ok (and connecting to a different machine) and c which connects to the same db as “a”, but fails over to connection “b” on failure of the primary db. Now the problem I am having is “c” is not failing over to “b” when I kill the primary.
I know it has nothing to do with the db, because I can connect to either database individually with at least two connections to each server from ignition, and the connection to the “b” server is still valid when the “c” database fails. It is as though it doesn’t realise it has failed to initiate a failover, even though it goes into fault. I have also tried restarting the gateway.
Any ideas what could be causing this? Given the simplicity of what I am trying to do, (i.e selecting the failover source from a combo box is not something that is easy to get wrong), I am out of ideas on what else to look at.