MySQL audit logging using triggers

https://ift.tt/332iUP3

Introduction In this article, we are going to see how we can implement an audit logging mechanism using MySQL database triggers to store the old and new row states in JSON column types. Database tables Let’s assume we have a library application that has the following two tables: The book table stores all the books that are found in our library, and the book_audit_log table stores the CDC (Change Data Capture) events that happened to a given book record via an INSERT, UPDATE, or DELETE DML statement. The book_audit_log table is created… Read More

The post MySQL audit logging using triggers appeared first on Vlad Mihalcea.

technology

via Planet MySQL https://ift.tt/2iO8Ob8

July 29, 2020 at 10:43AM