Triggers usage and potential issues

[Gonzalo Garcia]

I would like to use a trigger for auditing some tables data. Every time there is a change in any of these tables, a trigger would execute an insert in an audit/historical table.

This table would be located in a different mysql database.

Given this scenario, is there any potential issue in achieving it via Mysql triggers? If so, any advise on alternatives solutions to archive audit/historical data?

Thanks