This blog post series explores ACID properties in databases and touches upon the implementation side which is not usually covered anywhere.
Other posts in the series:
https://arpitbhayani.me/blogs/consistency/
https://arpitbhayani.me/blogs/isolation/
https://arpitbhayani.me/blogs/durability/ - Shortly explains how databases achieve durability