将数据库从多个位置同步到中央数据库的策略，反之亦然 [英] Strategy on synchronizing database from multiple locations to a central database and vice versa

问题描述

我有几个位于不同位置的数据库和一个位于数据中心的中央数据库.都具有相同的架构.所有这些都在每个位置使用不同的数据(包括中央数据库)进行更改(插入/更新/删除).

I have several databases located in different locations and a central database which is in a data center. All have the same schema. All of them are changed(insert/update/delete) in each location with different data including the central database.

我想同步中央数据库中的所有数据.我还希望中央数据库中的所有数据同步到所有位置.我的意思是位置 1 的数据库更改也应该反映在位置 2 数据库中.

I would like to synchronise all the data in the central database. I would also like all data in the central database synchronise to all locations. What I mean is that database change in location 1 should also be reflected in location 2 database.

关于如何解决这个问题的任何想法?

Any ideas on how to go about this?

推荐答案

看看 SymmetricDS.它是一个支持多订阅者和双向同步的数据复制软件.

Just look at SymmetricDS. It is a data replication software that supports multiple subscribers and bi-directional synchronization.

这篇关于将数据库从多个位置同步到中央数据库的策略，反之亦然的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！