I have used/dev'd Ignition in the past, but it has always been a single node operation for the plants. I am now working on a much larger plant and we have the fail over setup. Can MySQL be configured on both nodes for fail over or would I have to install actual SQL? I could not find much about this topic for fail over installs via MySQL. Thanks!
MySQL is "actual SQL" - not sure what you mean by that.
You would probably want to install it on a 3rd server and then just point both Gateways at that server. Any additional redundancy from there would be transparent to Ignition and specific to whatever database vendor, whether it's MySQL or you move on to another one.
MySQL has lots of limitations where as the regular versions have failover, etc, options. I just didn't know if BOTH nodes get MySQL installed and they both write to thier own local DB's and stay synced so when the master node dies, the slave node takes over and still has alarm history and trends.
The regular versions of what?