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 <[email protected]> > 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 <[email protected]>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 : [email protected] >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >> > > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > > -- Roberto Spadim SPAEmpresarial
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
