Mysql Handlers: Possible to run local Ubuntu script on table change?

Question

Does mysql support some kind of table listeners? It would be nice if I could tell mysql to trigger external script with some options when table is changed.

For example i have some script or daemon running on background and when mysql table is changed script is called script -opt1 opt2 etc

Is it possible? Is there anything like that already?

The problem is, that i need to renew cache on my app when mysql tables are changed.

Thanks ;)

What does not suffice with the 'normal' triggers calling a stored procedure? — Bobby
– Bobby, Commented Jul 4, 2011 at 9:37

Brian Hooper · Accepted Answer · 2011-07-04 09:56:42Z

1

You can call up any piece of code from inside a trigger, as suggested by Bobby; this can be a stored procedure or an external function. See here for how to create external functions (it looks a bit fraught to me though).

answered Jul 4, 2011 at 9:56

Brian Hooper

22.2k25 gold badges91 silver badges146 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mysql Handlers: Possible to run local Ubuntu script on table change?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related