Are MySQL Triggers Asynchronous

Question

When an AFTER UPDATE or AFTER INSERT trigger is fired is it a synchronous or asynchronous event? In other words does it hold up the total execution time of the query that tripped the trigger?

Answer 1

Yes, triggers are synchronous. However if you need to implement asynchronous MySQL triggers you can utilize Maxwell + custom code to easily read MySQL binary log and launch your own logic on interesting events.

Answer 2

Trigger are not asynch. Yes, they will increase the time it takes for an update or insert to complete.