maria-discuss team mailing list archive
Mailing list archive
Re: Table Change notification to all Clients?
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 <greenlion@xxxxxxxxx>
> 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
>> 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?
>> Bart Kindt
>> SARTrack Limited
>> 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
> 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