Distributed system design

Question 1

Is using triggers a good idea? what is the impact of triggers if they are used to capture the change data

Answer 1

Triggers should not be used to capture the change data (i.e. insert, update and delete) operation on a table. Triggers are executed synchronously whenever any of these operations are executed which impacts the performance of database. If trigger fails then the corresponding insert, update or delete operation also fails.

So triggers should not be used as a change data capture method.