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 <info@sartrack.co.nz> 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