Database replication. Update at the Subscriber (Replica). How to implement?

Question

SQL

Hello.
There is a desktop application written by me for work (Qt). The data is stored remotely in MySQL. There was a need to make the program work without the Internet.
Thought to fasten SQLite and to configure replication. If there are no ready-made solutions, then tell me, what are the approaches for replication with the ability to write on a replica?
PS Base up to 10,000 records. 3 users (= 3 replicas), i.e. update/insert is not a frequent occurrence. The Internet channel is sometimes very narrow.

Answer 1

There is no normal and easy solution here. There are many pitfalls in bidirectional replication.
If you use ORM to access data, store the data locally in the same mysql under the application, when there is a connection with the main server, write down the changes, then download all the data.