ClickHouse：Mission Critical Audit Logs
· 17 min read ·
A single change to a schedule, a single toggle of permissions—at the moment, it’s just another ordinary entry in the system; but a few months later, it might suddenly become the question everyone is asking: “Who changed this restaurant’s menu three months ago?” The answer lies in the audit log, but ensuring that it’s preserved and retrievable requires a revolution in storage and querying
This article covers the following topics:
- ClickHouse and Audit Log
- Two issues I ran into in production, and the thinking they prompted