How soon does Ignition send queries to the fail-over database and how can I delay the timing.
I have two MySQL databases arranged in a Master/Slave relationship. When the master fails a utility program will detect the failure and change the Slave into the new master. This takes up to 15 seconds to occur.
I would like the Ignition database fail-over to wait for more than 15 seconds before writing to the new master database.
In the meantime I will use the Ignition Store and Forward to ensure the data is not lost.