mysql trigger on a federated table
Federated tables are not transactional by nature, so you don't want to put a trigger on it. Alternative would be to put a trigger to post to another local table. 
See: Federated tables and triggers