Running Redundant Gateways and running my historian on the Backup Gateway
Windows 10 Pro
Intel(R) Xeon(R) CPU E3-1240 v6 @ 3.70GHz
Have 2 Hard Drives:
ST1000DM003-1SB102 -Use this one for my data
Java Version -1.8.0_161-b12
The problem im having is using mysql for my historian. Whenever Ignition pushes the data to mysql every 10 seconds it almost pegs out my disk usage. (Shown in picture below). The issue is that a few times its hit 100% disk usage and drops the connection to mysql and never establishes itself even tho my instance of mysql says everything is good. So i end up having to make a new schema for it to start logging again. I dont know why the disk usage is so high using mysql. Dont know if its a hardware issue or the configuration of mysql is wrong. Any help would be greatly appreciated.
P.S. : I have two systems setup the same way(hardware/software) and they are both doing the same thing.