What are the options for multi source replication in mysql?

Question

MySQL

You need to sketch an architecture for data aggregation with the following conditions:

* The organization has a mysql server
* There are sales representatives with laptops that do not appear in the office
* Laptops have applications that can be used to place orders (as well as mysql)
* Access to the Internet and vpn is not always

necessary It is necessary to synchronize "local" databases with the central one.

At the moment, I found the following options:

* Active-Active Cluster
* Tungsten (Java here and this is a minus)
* Simple backups
* Wait forge.mysql.com/worklog/task.php?id=1697
* Time-Shared replication Tell me the

working options. What solutions were applied?

Answer 1

As an option, run as many mysqld on the server as there are managers and set up the usual master-slave replication. Further, having received many “actual” databases on one server, write a synchronization script.
PS I've been tired of waiting for a year forge.mysql.com/worklog/task.php?id=1697

Answer 2

Write a simple software that would post orders to the main database? So, in my opinion, all the sales representatives with whom I dealt work, even from a laptop, even from a PDA, even from a mobile phone.