I am working on a fully redundant Ignition and MySQL system, but it seems to fail if one of the servers is turned off too long.
Both machines have:
Windows 7 Pro
MySQL 5.7.12 Community Server
I have Ignition installed with redundancy working, but turn off the Ignition service while setting up the SQL replication.
I have MySQL installed on both servers with master-master replication setup according to this:
I confirmed that replication is running then I start the Master Ignition service, then the backup Ignition service.
It seems to fail if one of the computers is off for too long.
Has anyone setup redundant SQL DBs with Ignition running on the same two machines?