Fast synchronization of two databases, how to do it?

Question

Data synchronization

There are 2 databases on the local computer (windows ms.access) that use an intermediate database on the hosting to synchronize data (linux mysql)
how can I speed up database synchronization? ideally without delay.
You can initiate a database update on the hosting after changing the data in the local database without any problems (ODBC driver, REST API) How can I launch it after updating the data on the remote database?

Answer 1

Option 1: Throw out mysql and set up / program replication through an intermediate file. The replication start trigger is the appearance of a data file. The frequency of polling for the presence of a data file is up to the taste of the programmer. Hosting to use as storage for an intermediate file.
Option 2: Switch from Access to ms sql and set up replication directly between servers. Throw out My sql again.