I am currently using a MySQL DB located within the intranet. Only the people within the LAN can access the information.
I'm trying to re-create the MySQL DB in a cloud provider. This can be accessed by other people from a different location.
When people update the MySQL DB in the cloud, is there a way to synchronize the information to the MySQL DB located within the intranet and vice versa?
I was thinking of using MySQL Job Event, like exporting data to an insert/update script file then dumping the file onto a local intranet folder. The intranet MySQL will also have a Job Event checking for this file if there's a new dump.
I am not sure if this is the right way to do such a task.
Any helpful tips are really appreciated.