Write-ahead logging

Here is the wiki article I like to read again.

I read the book design large data intensive application, and one of the topic is about logging. How the logging is used to design Kafka and support distributed system like database, keep ACID properties. But what I do not remember is that every transaction in database is to use write-ahead logging to allow undo/ redo feature.

By checking the log, or put transaction into log first, it is easy to do, but also a good design to keep database table record ACID.