If you enjoy this post, you'll love Martin Kleppmann's book Designing Data-Intensive Applications. Chapter 7 covers exactly this topic in more depth.

http://dataintensive.net/

https://www.safaribooksonline.com/library/view/designing-dat...