How SQL Supports: ACID Properties
A: Atomicity --> MySQL Achieves this by using undo logs
C: Consistency --> Before and after data is consistent (double write buffer)
I: Isolation --> MYSQL uses Locks and Isolation Level
D: Durability ->MySQL uses Redo Logs
How NoSQL supports: ACID P...
pranshuadhwaryu.hashnode.dev1 min read
Abhisekh Mukherjee
Sr Software Engineer @ Wipro Technologies
This article is very high level and doesn't explain how it actually does. What lock it uses as there are many option to choose form and how it deals with dirty reads and all.