需要设计建议 [英] Design advice required

问题描述

我的系统有36个表.客户端将把其中的6个更改实时通知服务，而该服务随后会将所有实时数据分发给其他客户端.该服务将每晚向所有客户端分发对其他30个表的更新.

现在，我可以在每个表上维护导出标志，并通过其自己的线程对每个表进行轮询，或者可以触发一个触发器以将行添加到变更日志表中，然后对其进行轮询.

My system has 36 tables. The client will notify the service of changes to 6 of them in real time, while the service will then distribute all that real time data to the other clients. Nightly the service will distribute updates to the other 30 tables to all clients.

Now I can maintain export flags on each table and poll each one via its own thread, or I can fire a trigger to add a row to a changelog table and just poll it.

Are there practical considerations or is this just a question of style?

推荐答案

我了解的是，您在客户端计算机上具有单独的数据库，并且需要与中央服务器数据库进行同步.

如果您的客户端数量或客户端位置没有变化，则可以更新中央数据库，该数据库可以在那时更新客户端数据库.当我们在MSSQL中使用链接服务器时，可以使用类似的方法使用 MySQL FEDERATED存储引擎 [^ ].您也可以使用镜像.但是请提供更多信息，以适合您的情况.

谢谢

Hi,

What i understand is, you have separate databases on client computer and you need to synchronize with central server database.

If you do not have changes in number of client or location of the client then you can update your central database that can update your client databases at that time. As we are using Linked server in MSSQL the similar way you can use MySQL FEDERATED Storage Engine[^]. You can also use mirroring. But Please provide more information what can be suitagle on your scenario.

Thanks

这篇关于需要设计建议的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！