High Availability Analysis with Database Cluster, Load Balancer and Virtual Router Redudancy Protocol

Abstract

The purpose of this paper is to analyze high availability by using MariaDB Galera Cluster, then the performance will be compared if added load balancer HAProxy and Virtual Router Redundancy Protocol (VRRP) using Keepalived. The purpose of this research is to design high availability reliability using MariaDB Galera Cluster, HAProxy and Keepalived, and get results from high availability test of MariaDB Galera Cluster, HAProxy and Keepalived. Analytical methods are used using the down time scenario and compare the performance of Threads, Transaction Per Second (TPS) and Response Time. The results of this study are high availability analysis and performance comparison between the default configuration database clustering using load balancer and VRRP running on virtual machine and cloud. Based on test results that run on virtual machine and cloud, it can be concluded that testing with load balancer configuration has better performance, compared with without using load balancer.