A high availability (HA) MariaDB Galera Cluster across data center with optimized WRR scheduling algorithm of LVS - TUN

Abstract

Data availability and reliability is very important along with the growth of information and communication technology services today. Needs of the powerful and affordable database system infrastructure to be the most considered thing by the application service provider. This paper presents the powerful and scalable database open source solution infrastructure which can be distributed across the data center in the world to provide any application or content services. Database infrastructure in this paper using MariaDB Galera Cluster which geographically distributed across data center and Linux Virtual Server (LVS)-Tunnel with optimized weighted round robin algorithm as the load balancer. Optimization in this weighted round robin algorithm are focused on assignment value of weight, based on the condition of database server status. The condition include total active thread (active connected client) and Query per Second Average.