I’m new to ignition and i decided to take on a big learning curve by also installing the software on Ubuntu server machines. I’m not all too familiar with linux but i’ve managed to get some Ubuntu 14.04 VM’s running with Ignition gateway running on two of them. I’m just “playing” around with the features at the moment so I’m not too worried about correct setup and architecture. My current setup is as follows:
VM 1 - Main Ignition Gateway. Will be used for development of everything from visuals to reports.
VM 2 - Ignition Gateway. Will be used mainly as an OPC-UA server.
VM 3 - MySQL. Used as the database server.
My question is if I want to use SQLTags and need to connect to the SQL database which gateway machine should I be using to connect to the database machine? VM1 or VM2? I read the SQLTag section in the manual about providers and driving providers but i’m still unclear about which machine should connect to the DB. Do I connect both?