Synchronization of two databases, options?

Question

PHP

Backend warehouse in php with mysql database. Frontend workplace in python directly sends data to the server with rest requests.
Everything works but there is a dependence on the Internet.
What scheme to use to store data on the frontend and synchronize with the server?
Synchronize with python or database?
If using python, then how to check that the data has been synchronized?

Answer 1

The best solution is to reserve the Internet channel from both sides.
You can use asynchronous master-master database replication, but there are many pitfalls, for example, you cannot use AUTO_INCREMENT if the table is being written to on both sides.

Answer 2

I agree with previous speakers - duplicate the channel, it's easier and cheaper.