calling script upon replication

[boomer]

I use mysql replication to keep to servers up to date in a fake clustered environment. when some databases change, I need to run a shell script to update some server side information

Does anyone know how to or if it is possible to have mysql execute a script each time a table or database replicates?

Thanks!

[Rawhide]

Trigger implementation in MySQL is rudimentary at best. You can create a trigger that performs some script every time there is an update, insert, and/or delete. I'm not sure if replication will fire triggers or not in MySQL.

In MS SQL Server, you can specify whether or not a trigger gets fired by replication and you can also query the triggering transaction to see if it was from replication or not.

To use this method, you would have to put a trigger on every table that you want to track.