Synchronization of local and remote database

Question

MySQL

There is a local database on the user's computer, and a remote database on the hosting. Using the desktop program, records are added/edited/deleted to the local database. Using the web interface, such changes are made to the remote database. They need to be synchronized somehow. Are there any means? If not, give advice on how to organize it.

Do not offer to use a remote database in the program, but a local one on the site. Reason: poor internet connection, constant data transfer slows down the program.

I use mysql (both local and remote).

Answer 1

Something similar was described on Habré

Answer 2

If in the forehead - MySQL Workbench - Revere / Forward engendering

Answer 3

As a Windows solution, SQLyog can come up, only it is paid.