I have seen a few of these go into production. What behavior is desired? 1) user gets table name when table changes 2) user gets table name and PK for row when that row changes 3) user gets table name and all columns when row changes Also, how reliable must the notification be? If the notification subscriber is disconnected when the change happens will they miss a notification? Below I use "persistent subscription" to mean that change notification is not lost when a subscriber is disconnected. The systems I used usually did #2 (user gets table name and PK) and then the user can query the table to get the other columns. This can be inefficient because of the extra queries but it was simple. These systems also made notification subscription persistent. One example is: https://www.facebook.com/notes/facebook-engineering/wormhole-pubsub-system-m... I think this type of system can make it a lot easier to integrate MySQL/MariaDB with other systems. Row-based replication makes it much easier. On Tue, Nov 19, 2013 at 8:10 AM, Sergei Golubchik wrote:

Hi, SARTrack!

You might want to look at Q4M storage engine, http://q4m.github.io/ perhaps it'll help.

Or you can emulate the notification with locks or replication.

But directly - no, there are no plans at the moment to implement the notifications like this. Of course, plans might change...

On Nov 15, SARTrack Admin wrote:

...

I develop a Windows application for Search and Rescue (using Delphi and MyDAC components), which gets a stream of "APRS" data packets, up to 10 per second. These are saved in the SQL database, but all Clients which are connected to the database MUST be notified when a Table change has occured, so that they then can update their internal tables. Which in turn update their Maps (GPS location of moving items) and other data, which MUST be up-to-date.

Currently I am having all Clients polling the database every 5 seconds, which really sucks, and causes all kinds of other problems.

Is there any chance that MariaDB will have some kind of Client Notification system when a Table has changed, as some other SQL databases seem to have?

Regards, Sergei

_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

-- Mark Callaghan mdcallag@gmail.com

maybe the easier way is the plugin api, check the audit plugin, maybe it's do what you need, when you got a table change, mark some variable or other struct about that change, and a information schema plugin could allow a SELECT command to check what table have changed 2013/11/21 Justin Swanhart

Hi,

You can use FlexCDC (an open source script for this) with some minor modifications. You can run it under cygwin on Windows. You would simply make it send notifications (via whatever method you like) regarding the data in the binary log. It will automatically read binary log and keep processing it as it arrives.

You could do homegrown binary log trolling. A simple script to just scans the binary log for table maps (or DML containing requested table names if you don't need contents) if you just want table name notifications is pretty trivial.

There is a C binary log API that can be read, but constructing an app using the binary log API is complex.

You could use triggers with Gearman UDF calls. Most message queues support notifications to all listeners when an event arrives. The trigger could pack up the details in a simple comma separated list of values, json encode the new/old values, whatever you want.

--Justin

On Thu, Nov 14, 2013 at 3:19 PM, SARTrack Admin wrote:

...

I develop a Windows application for Search and Rescue (using Delphi and MyDAC components), which gets a stream of "APRS" data packets, up to 10 per second. These are saved in the SQL database, but all Clients which are connected to the database MUST be notified when a Table change has occured, so that they then can update their internal tables. Which in turn update their Maps (GPS location of moving items) and other data, which MUST be up-to-date.

Currently I am having all Clients polling the database every 5 seconds, which really sucks, and causes all kinds of other problems.

Is there any chance that MariaDB will have some kind of Client Notification system when a Table has changed, as some other SQL databases seem to have?

Thanks

Bart Kindt SARTrack Limited http://www.sartrack.co.nz/

--

SARTrack Developer and CEO

_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

-- Roberto Spadim SPAEmpresarial