Postgrespro's blog ( https://habr.com/en/company/postgrespro/blog/ ) and http://www.interdb.jp/pg/index.html are incredible resources to learn about Postgres internals in depth.
Are there resources of similar quality available for MySQL / MariaDB internals ?