I have two PC each one have Ignition and MYSQL DB. As per attached(1) Diagram .
1- when i try to define MYSQL(1) in Ignition(2) it give me fault jdbc:mysql://192.168.3.3:3306/test
and same when i defined MYSQL(2) in ignition (1) jdbc:mysql://192.168.3.2:3306/test
I don’t know .Is there any trick to do this inside MYSQL??.I still new in DB.Please advise and give me steps to do this.
Actually i have one project with 30 remote sites and i need to collect data from these site. And my plan to install Ignition (Vision)+OPCUA+SQL Module+ opc-com in each site and we will use store-forward Engine to save the data if the connection failed between each site and Main computer(Hub And Spoke inductiveautomation.com/prod … ubandspoke)
. as per attached(2) Layout.