Distributed System Design book recommendations?

So I work at a FAANG company where the ‘durrr relational databases’ don’t scale cult is preeminent. We draw fancy boxes and arrows and sweep the split brain problems under the rug. All literature I have read so far treat the topic very naively — I want something that airs out all the dirty laundry — split brain issues, failure recovery, etc and provides suggestions how to deal with it. I’ve already and enjoyed “data-intensive” but looking for something a little broader.