Database Scaling on Kubernetes

Kubernetes is a hot topic in the field of Software Engineering and Distributed Computing. When compared to previous methods, the principle underlying Kubernetes, which is containerization, has altered how applications are created and delivered. However, when considering the state, particularly the databases, with Kubernetes, there is a scalability and data synchronization barrier. The most frequently used approach is to host the database outside of Kubernetes and maintain connectivity with the cluster. Kubernetes inherent capabilities are sufficient for hosting databases. But that requires high domain knowledge to do the configurations and maintain the databases on Kubernetes. The purpose of this research is to fulfil that gap by introducing a solution for managing highly available databases on Kubernetes. The solution is limited to managing PostgreSQL databases on Kubernetes using auto-scaling. A novel algorithm is proposed for auto-scaling, as previous algorithms do not take database requests into account when determining the scaling need. The drawbacks of data synchronization and auto-scaling will be solved in this research, and the end user will be able to access the service without interruption for the majority of the time, as the final solution makes the database cluster highly available for the service layer.