← Back to team overview

maria-discuss team mailing list archive

Re: Table Change notification to all Clients?



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.


On Thu, Nov 14, 2013 at 3:19 PM, SARTrack Admin <info@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp

Follow ups