Everyone records audit logs. Almost nobody reads them, because reading them means grep on the database server, a cursor with no WHERE clause, or a log pipeline that costs thousands a year. There is a cheaper shape: keep the answer, not the log. And you do not need an audit plugin to get it. The post Everyone Records the MySQL Audit Log. Nobody Reads It. appeared first on dbtrail .
Standard support for MySQL 8.0 on RDS ends on July 31. The in-place upgrade to 8.4 takes minutes and there is no way back. Here is how I checked, on a real RDS instance with every MySQL data type I could think of, that it did not change a single row. The post MySQL 8.0 to 8.4 upgrade on RDS: how to prove your data survived appeared first on dbtrail .
PostgreSQL now lets you ask what a row contained at any moment in the past, using a normal SELECT. This post shows the idea with one small example,… The post Time-travel for PostgreSQL: one SELECT vs a full restore vs replaying the WAL appeared first on dbtrail .