For anyone interested in general advice regarding scaling traditional SQL databases, check out my article [0] where I collected various techniques when I investigated this topic in my last workplace.

[0] https://stribny.name/blog/2020/07/scaling-relational-sql-dat...