MySQL listen notify equivalent

Question

Is there an equivalent of PostgresQL's notify and listen in MySQL? Basically, I need to listen to triggers in my Java application server.

Answer 1

Ok, so what I found is that you can make UDF functions in mysql that can do anything but need to be written in C/C++. They can be then called from triggers on updates in database and notify your application when update happened. I saw that there are some security concerns. I did not use it myself but from what I can see it looks like something that could accomplish what you want to do and more.

http://dev.mysql.com/doc/refman/5.6/en/adding-udf.html

Answer 2

The github project mysql-notification provides a MySQL user defined function MySQLNotification() as a plugin to MySQL that will send notification events via a socket interface. This project includes a sample NodeJS test server that receives the notification events that could be adapted for Java or any other socket service.

Example use:

$ DELIMITER @@ $ CREATE TRIGGER <triggerName> AFTER INSERT ON <table>    FOR EACH ROW    BEGIN       SELECT MySQLNotification(NEW.id, 2) INTO @x;    END@@ 

Project includes full source code and installation instructions for OSX and Linux. License is GNU v3.