demand:
Our system has twelve use units, they each have data servers and web servers, and our system can be distributed
General Administration
Unit 1 unit 2 ... unit 11
In the system, there are data exchanges between the State Administration and units, so they ask us to synchronize, and consider both real-time and timing, and the network will be disconnected.
The method we use is:
Generate Trigger all in the system, record all CUD operations in a specified table
The SQL record of the specified table is filed, and the Socket is sent to other units (General Administration), and SQL is executed over there.
There are many problems in this:
Trigger Unstable Socket mode is not good to solve the controllability is very poor ...
Headache ...
