Change notification Best Practice?

[Massimo Cicognani]

Hi everybody,
it's a while I'm developing with C# and MySQL NET connector, but I've never found a solution for a requirement that I believe is very common.

Is there a way to implement something like a Change Notification Service usually found on other RDBMs?

I'd like to being notified by the server itself that something on the server has changed, at row-level if not at column-level...
I'd like to stop checking at time intervals to refresh data grids and I'm almost there to start developing a peer-to-peer notification system to allow my client applications to notify each other if some changes occured.
Maybe there is something faster and better to use?

Thank you,

Max