Scaling databases
Scaling the database is one of the challenging parts of architectural design. Here, we will discuss some database scaling techniques to scale our application.
Vertical scaling
As we discussed earlier, in the application server level we can also utilize the scaling up technique for our database servers. Adding more power, such as CPU and RAM, will bring better performance in querying databases. By using vertical scaling techniques, we can get consistent performance, and it's also easy to debug when things go wrong. Also, vertical scaling offers increased efficiency compared to horizontal scaling. However, vertical scaling might require downtime regularly to install new hardware, and it is limited by the hardware capacity.
Horizontal scaling
As we discussed with horizontal scaling in the application level, we can do the same for database servers by adding more machines to our cluster to take care of the database load. Compared to vertical scaling, it is significantly cheaper...