MySQL trigger from one host to another host

Ignition
1

Hi,

In one of our projects that was moved to production six months ago, the customer requested an additional cloud database. They want to transfer data from a specific table in the production MySQL database to the cloud database with minimal downtime. What are the possibilities to achieve this?
Note: Both Ignition and db are in same server.

2

Do you mean they want to change the database for this table and then use the new one, or do you mean sync the 2 tables so that they have 2 up to date tables in 2 places ?

3

If you can live with "temporarily unable to access some historical data", just duplicate the local database, then update the ignition database settings, at last synchronize the missing data.

4

They need sync between 2 tables !.

5

Then I suggest you read this:
https://dev.mysql.com/doc/mysql-replication-excerpt/8.0/en/replication-solutions.html

4 Likes
6

So the Tag History Splitter is best choice. If you want to log new historydata to both database, all your tags config need to update.
https://docs.inductiveautomation.com/display/DOC81/Tag+History+Providers

7

I need replication for a specific table not the historian table

8

You might also find helpful tools in MySQL workbench:

https://dev.mysql.com/doc/workbench/en/wb-database-synchronization.html

2 Likes
9

I have no experience with this. Follow Pascal's advice.

2 Likes