AMBIENTE DE ALTA DISPONIBILIDADE PARA BANCO DE DADOS UTILIZANDO MYSQL EM CONTAINERS ORQUESTRADOS PELO KUBERNETES

Abstract

In a 24-hour connected world, a system failure can lead to the bankruptcy of a company, which is why high availability is an extremely important factor for a company, however many companies apply high availability in tools and leave aside databases, which can result in a major catastrophe in the event of failures. This work aims to develop a high availability database environment using containers orchestrated by the Kubernetes tool in a computational cloud. For the work, an architecture was created using the MySQL database and open-source tools that assist in the implementation of a master-slave database replication group in the Kubernetes cluster, in order to obtain high availability, fault tolerance and high scalability, the entire architecture was exposed in the Google Cloud. With the assembled architecture, failure tests were performed to verify how much the structure would be able to remain highly available and consistent, even in cases of failure, the scalability of the application was also analyzed, changing the size of the architecture in order to meet the new requests without construction of a new cluster. As a result, it is expected that through Kubernetes it will be possible to achieve a fully scalable and fault tolerant high availability architecture in the MySQL database.