Table changes listener

[vsirghii]

Hello,

I'm looking for MySQL server plugin (or utility, or service) which would monitor database tables changes. Say, if a table was changed by means of DELETE, UPDATE or INSERT, this plugin would send a notification (across http or tcp): what table (table name), what field and what data in case of UPDATE, from what place/user this change came. I'll be interested in buying such a plugin if it exists in your library.
In other words, something that behaves similar to “MS SQL Server Service Broker” or “Oracle Listener”.
Is Nagios XI capable for doing this kind of things?

Thank you,

Victor.

[sreinhardt]

Offhand, I cannot think of anything that would directly interface with mysql in this way. However from doing some quick research it seems that mysql logs most if not all the insert\delete and permission changes to the database, and you almost definitely could monitor this log for items that you wish to catch. I would suggest taking a look at some of the mysql health and log plugins that are available.
http://exchange.nagios.org/index.php?op ... ysql%20log

[tmcdonald]

You would of course need to enable logging by default first:

http://stackoverflow.com/questions/5441 ... s-in-mysql

If this isn't something we have currently you could certainly talk to sales about doing some custom development. Other than that, it shouldn't be too hard to write a simple parser for the log file and run it at a set interval through cron.