maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

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>

> 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@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
>>
>
>
> _______________________________________________
> 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
>
>


-- 
Roberto Spadim
SPAEmpresarial