在两个数据库之间同步 [英] Syncing between two databases

问题描述

我有一个应用程序也有一个网络界面，其中的一个要求是能够在应用程序上工作，即使没有可用的互联网连接。
这些数据库之间是否需要同步？

这些数据库应该是相当大的磁盘空间。
如果有这样的需要怎么办呢？我应该使用什么数据库？

目标操作系统是windows，但服务器可以在windows或linux上运行。

I have an application that also has a web interface, one of the requirements is to be able to work on the application even if there isn't an internet connection available. Is there a need to sync between those databases?
Those databases are ought to be pretty big disk space wise. If there is such a need how should it be done? What database should I use?
The target OS is windows but the server could run on windows or linux.<

推荐答案

你是说你需要能够通过网络应用程序工作，即使在离线时？听起来您需要 Google Gears 或其他 HTML5结构化存储实施。

如果你在离线时使用本地应用程序，那么是的，听起来你想要一个本地数据库。

If you using a native app when offline, then yes, it sounds like you'll want a local database for that too.

用户通常知道要离线？如果是这样，您可以让他们检出他们需要的数据库的子集，然后上线并同步。否则，您可能需要同步他们最近使用的数据，但会清除本地数据库中长时间未使用的数据。

Do the users typically know when they're going to go offline? If so, you could let them "check out" the subset of the database they're going to need, then later "go online" and synchronize. Otherwise, you may want to synchronize data that they've used recently, but purge the local database of data they haven't used for a long time.

很难这将取决于你的确切应用。多个用户需要同时处理同一组记录，例如？

Quite how hard that will be will depend on your exact application. Do multiple users need to be able to work on the same set of records simultaneously, for example?

这篇关于在两个数据库之间同步的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！