blocks|key|5531401|text|对于对缓存无效技术感兴趣的主动连接客户端：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5531402|5531403|SQL+Server支持Continuous+Query+Notifications.|unordered-list-item|offset|length|5531404|MySQL支持复制流，但它们与更新通知不同:它们不能为客户端动态设置和拆卸，并且不能很好地监视特定应用程序感兴趣的单个行。|5531405|5531406|对于对数据同步感兴趣的断开连接的客户端，所有供应商都支持某种类型的复制。|5531407|entityMap|0|LINK|mutability|MUTABLE|url|http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28424/adfns_cqn.htm^0|0|0|C|U|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|V|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|W|8|@]|9|@$F|X|G|Y|1|Z]]|A|$]]|$1|H|3|I|5|E|7|10|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|11|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

For an actively connected client interested in cache invalidation techniques:

<ul>
<li>SQL Server support <a href="http://rusanu.com/2006/06/17/the-mysterious-notification/" rel="nofollow noreferrer">Query Notifications</a></li>
<li>Oracle support <a href="http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28424/adfns_cqn.htm" rel="nofollow noreferrer">Continuous Query Notifications</a>.</li>
<li>MySQL supports replication streams, but they're not the same as update notification: they cannot be set up and tear down dynamically for a client and they do not work well for monitoring individual rows a particular application is interested in.</li>
</ul>

For a disconnected client interested in data sync, all vendors support some sort of replication.

blocks|key|417452|text|没有回调机制，但是如果你创建了一个其他人用来进行更新的服务，那么你可以手工制作该服务来推送你想要的通知。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|417453|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

No Callback mechanism, but if you made a service that others used to make the update, then you could craft that service to push the notification that you want.

blocks|key|2329364|text|我的建议是使用计时器服务来随机轮询数据库中的任何变化，或者使用消息队列，每次队列的大小大于0时，向任何应该发现它的人发送一条消息。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2329365|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

My recommendation is to either use a timer service that randomly polls the db for any changes or to use a message queue and every time the size of the queue is greater than 0 send out a message to whomever should find out about it.

blocks|key|414459|text|今天早些时候，我刚刚回复了a+similar+question关于PostgreSQL的问题。简而言之，它是：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|414460|414461|用Java语言编写一个TRIGGERed存储过程，并使该过程通过套接字连接到达某个监听套接字外部程序。|blockquote|414462|414463|414464|在被PostgreSQL和Java存储过程搞得焦头烂额之后，我不敢去猜测MySQL是否“做”了Java存储过程。如果不是，也许您可以从存储的proc中运行一些其他程序来实现类似的功能。到目前为止，这是一个do帮助答案。|414465|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/1771350/postgresql-and-jms-or-other-pub-sub-callback-mechanism/1771431#1771431^0|D|I|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@$A|U|B|V|1|W]]|C|$]]|$1|D|3|-4|5|6|7|X|8|@]|9|@]|C|$]]|$1|E|3|F|5|G|7|Y|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|Z|8|@]|9|@]|C|$]]|$1|I|3|-4|5|6|7|10|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|11|8|@]|9|@]|C|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|C|$]]]|M|$N|$5|O|P|Q|C|$R|S]]]]

I just answered <a href="https://stackoverflow.com/questions/1771350/postgresql-and-jms-or-other-pub-sub-callback-mechanism/1771431#1771431">a similar question</a> earlier today about PostgreSQL. In a nutshell, it was:

<blockquote>
 Write a TRIGGERed stored procedure in Java, and have that procedure reach out via a socket connection to some external program listening on a socket.
</blockquote>

After getting burned on the matter of PostgreSQL and Java stored procedures, I won't dare to speculate on whether MySQL "does" Java stored procedures. If not, perhaps there's some other program you can run from within the stored proc that will accomplish something similar. So far, this is a do-it-yourself assistance answer.

blocks|key|3419811|text|在PostgreSQL+(开源)中有触发器。触发器可以用任何语言编写，并且可以向您的应用程序发送通知。不幸的是，我不知道有没有这样的通知的现有应用程序接口，但是使用PostgreSQL你可以构建你自己的。Documentation+for+PostgreSQL+triggers|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3419812|entityMap|0|LINK|mutability|MUTABLE|url|http://www.postgresql.org/docs/8.4/static/trigger-definition.html^0|2U|11|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

In PostgreSQL (which is open source) has triggers. Triggers can be written in any language and can send a notification to your application. Unfortunately I do not know of an existing API for such notifications, but with PostgreSQL you can build your own.
<a href="http://www.postgresql.org/docs/8.4/static/trigger-definition.html" rel="nofollow noreferrer">Documentation for PostgreSQL triggers</a>

blocks|key|414477|text|在Firebird和Interbase中，我们有客户端应用程序可以监听事件。但是对于MySQL来说，这样的事件是不存在的。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|414478|entityMap|0|LINK|mutability|MUTABLE|url|http://www.firebirdsql.org/doc/whitepapers/events_paper.pdf^0|1|8|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

In <a href="http://www.firebirdsql.org/doc/whitepapers/events_paper.pdf" rel="nofollow noreferrer">Firebird</a> and Interbase, we have event than can be listened by client application. But for MySQL event like this don't exist.

A typical scenario: imagine a user is feeding data to MySQL, while a client is connected to MySQL remotely. Whenever the user updates a field in the DB, I would like for the client to be notified immediately.

Think this as the 'push-mail' function from Blackberry.

What I do NOT want, is that the client has to 'ping' MySQL server once in a while to see if there is any update. I believe this will be to expensive, computation wise.

How can I implement such an idea? Is there any MySQL-based CALLBACK mechanism? If not, is there any other database (better be open-source) that support this kind of mechanism?

Is there any way to let MySQL server 'push' DB updates to a client program?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

一个典型的场景是:假设一个用户正在向MySQL提供数据，而一个客户端远程连接到MySQL。每当用户更新数据库中的字段时，我希望立即通知客户端。把这看作是黑莓的“推送邮件”功能。我不想要的是，客户端必须偶尔'ping‘MySQL服务器，看看是否有任何更新。我相信这将是昂贵的，计算明智的。我该如何实现这样的想法呢？是否有基于MySQL的回调机制？如果没有，有没有其他数据库(最好是开源的)支持这种机制？

问有没有办法让MySQL服务器“推送”数据库更新到客户端程序？
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问有没有办法让MySQL服务器“推送”数据库更新到客户端程序？EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问有没有办法让MySQL服务器“推送”数据库更新到客户端程序？
EN