MySQL Replication fails periodically

Hi,

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
Ignition 7.8.2
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:

ryadel.com/en/mysql-master-m … asy-steps/

I confirmed that replication is running then I start the Master Ignition service.

It seems to fail if one of the computers is off for too long.

Has anyone done this successfully?

Edited to add:

Moved to Database board.

1 Like