How to achieve data synchronization?

lq521cf

Use trigger
You can also use events to achieve the same function.
When the Server data is updated, all customers are notified. We can even encapsulate the data records updated on the server side in this notification. When the client knows the notification, it can know the specific data update and so on. . .

xppeng110

Through homework, synchronize the two databases regularly. Search for this

adyiyi

This is a very common model. For large supermarket chains, look at how the data of each store is synchronized with the head office.
1. If the network is connected, the data is transmitted online.
2. The network is disconnected, and the data is stored in a U disk and updated with the head office.

810123123

mark learning ha ha

I thought that the client doesn’t need a database. Ha ha~~~

In addition, I think to realize the synchronization of data at both ends of c/s, you can refer to the TCP three-way handshake protocol. Ha ha~~~

btdiablo

If it is for data storage safety, use RAID

Synchronous replication of the two databases cannot guarantee complete data consistency.

Synchronous replication of data cannot be continuous in time. If a problem occurs between the two replications, it will cause data inconsistency.

烈法丹伦

Use triggers, easy and convenient

hai5322460

Use trigger

西関大少

I think the trigger is ok, but it has a flaw. It must be real-time. If there is a problem with the network or the client machine shuts down, the server data cannot be updated.
If you want to do non-real-time, it is a bit troublesome, you need to mark whether to publish, or do data comparison.

huwei0521

There is a JOB in the oracal database to achieve data synchronization, and perform data synchronization operations at a fixed time according to the MARK you generate.

风在挽留谁

Why does the client need to use a database? Is this wrong?