Database is MySQL. I am looking to implement a trigger that updates an aggregate rating table whenever a new rating is placed. Then there are some other similar use cases where I'm looking to implement triggers.
These triggers may be updating federated tables. So my question is: whether a php script that inserts a new rating will need to wait for the trigger to complete before the php script completes?
PS: I understand triggers is not a good idea to put logic, and may be I would be better off with some messaging such as RabbitMQ.