TLDR: Decoding Durability - The D in ACID

Date: 2021-07-19 Source: https://arpitbhayani.me/blogs/durability

Overview

Explore database durability, the "D" in ACID. Learn how databases ensure data survives failures & the role of transaction logs. After discussing the “A”, the “C”, and the “I”, it is time to take a look at the “D” of ACID - Durability).

Key Points

• After discussing the “A”, the “C”, and the “I”, it is time to take a look at the “D” of ACID - Durability).
• Durability seems to be a taken-for-granted requirement, but to be honest, it is the most important one.
• Let’s deep dive and find why it is so important?
• How do databases achieve durability in the midst of thousands of concurrent transactions?
• And how to achieve durability in a distributed setting?
• In the context of Database, Durability ensures that once the transactions commit, the changes survive any outages, crashes, and failures, which means any writes that have gone through as part of the successful transaction should never abruptly vanish.