The invention discloses a
data synchronization method and
system and a storage medium, the
system comprises a main
database, a
database trigger, a synchronization
queue and at least one
client database, a plurality of synchronization data are stored in the main database, and the synchronization
queue is provided with database tables corresponding to the synchronization data; wherein the
database trigger is used for monitoring a main database, triggering to generate trigger information when a synchronous data sending event operation of the main database is monitored, and sending the trigger information to a corresponding database table; wherein the synchronization
queue is used for acquiring synchronization data from the main database in combination with the trigger information and the database table, and performing synchronization operation on the
client database according to the acquired synchronization data. Synchronization is carried out in a monitoring and queue
synchronizing mode,namely
data synchronization is carried out on the basis of a database layer, performance is high,
fault tolerance is good, data can be prevented from being lost in
data synchronization, and the method can be widely applied to the technical field of data synchronization.