Attempting to reliably integrate data from remote facility with intermittent connectivity…
A. I have two licensed instances of Ignition running as Historians, both logging OPC tags of PLC process data. Each to their own respective local MySQL database servers. One at a main facility (the Works with Vision) and one at a geographically remote facility (without the vision module) connected by a private VPN and residing in different subnets. There are times with poor connectivity between the facilities, outages may last up to a day and a half.
B. With phpMyAdmin I created a new database user with all rights on the remote MySQL instance that is connected to the remote instance of Ignition and allows connections from the IP address of the main facility MySQL and Ignition instance. (probably needs some less rights, but have started with all, limited only by IP address for now)
C. I have commented out the MySQL localhost only binding on the remote server
D. Connected the main facility instance of Ignition successfully to the remote MySQL database instance
E. I set up a new historical transaction group to Execute (thinking to try to read the remote MySQL database history tags) once per minute with the data source being the remote MySQL database connection. (the default use normally being to connect OPC-UA tags to MySQL database tags)
F. I unchecked ‘Automatically create table’. I also changed the OPC data mode to ‘Read,’ should I ‘Bypass the Store and Forward system’ and/or change any other options as well ??
G. What do I have to do next, to collect the tags from the remote MySQL database Historian to be placed in a Vision window at the main facility? Write a script of some kind or another? I suppose that I need to manually create local copies of the remote MySQL tags with different names?
H. Have I used the available metaphors correctly here? … or done something lame, as in tried to connect a water hose directly to a light socket without a hydroelectric generator in between them …or am I on the right track here?
I. I have not been able to find anything about a configuration like this. Should I have been trying to connect OPC connections instead of MySQL connections perhaps? Looking at
Post subject: Re: Combining data from several servers viewtopic.php?f=23&t=3427&p=5615
it would seem so. Perhaps I have begun reinventing the store and forward model needlessly?
J. I can see some of my remote tag values by browsing the table of the month, but can see that this not an out of the box configuration and is probably going to need some kind of scripting.