Martin Kleppmann's "Designing Data-Intensive Applications" discusses this https://dataintensive.net/ https://dataintensive.net/ Besides being a good read overa

Martin Kleppmann's "Designing Data-Intensive Applications" discusses this https://dataintensive.net/ https://dataintensive.net/ Besides being a good read overall, the book discusses topics like this one in detail and with a healthy attitude (people tend to have strong opinions on this)