I read Learning PostgreSQL from Its Internal Structure: Principles of Design and Operation Planning.
It covers everything you want to know about operating PostgreSQL from the perspective of design and operation, which is great.
I wonder if there’s a similar book for MySQL. There probably is.