Write-ahead logging

2020-07-26

write-ahead logging (WAL) is a family of techniques for providing atomicity and durability (two of the ACID properties) in database systems. The changes are first recorded in the log, which must be written to stable storage, before the changes are written to the database.

write the log records associated with a particular modification before it writes the page to the disk.

I think it has similar characteristic of event sourcing pattern where event can be store and result can be calculated by event evaluation sum.

reference

- https://en.wikipedia.org/wiki/Write-ahead_logging\

Buy Me A Coffee