Scaling Relational SQL Databases

Recently I was researching what are all the possible options when it comes to scaling workloads with relational SQL databases. I think other people can find it helpful.

Feel free to suggest other ideas!