Change's Notification...

[Ramiro]

hello there,
I have several machines, each running a client process, talking to a central MySQL server over ODBC. Some clients write data to the database, some read that data. All the clients run continuously. The writing clients write data sporadically, to log-like tables that grow, but no previously written data is ever changed.
How can the reading clients can be told when there is more data available?
Thanks -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Yadira]

Each writing client should post notifications to a messaging bus, which the reading clients read.

In Java, the standard API is JMS:
[java.sun.com]

The writing clients should post their notifications after confirmation that their database writes succeeded, and their transactions committed.

use UDF's to post the messages automatically from MySQL triggers, but the messages get posted when the data is inserted, which may be some time before it is committed. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --