Implementation of MariaDB Database Replication by Using Cluster Technology
Abstract
In using database, we will be faced with the risk of disturbance in the database such as the occurrence of data loss and also database can not be accessed (downtime). When database server fails, all services will stop and all business processes will not work. The way to anticipate the risk in using database is to use replication technique. One of the cluster technology that used to perform database replication is Galera Cluster. Galera Cluster uses a multi-master replication type in database duplication method. It allows data to be stored in a number of servers and updated from all servers. In addition, another method is also applied such as load balancing by using a tool called HAProxy to distribute the workload across multiple servers. Based on the results of the research, it was found that the success rate of database replication by using Galera Cluster was 100%. In addition, the greater the data sent to the database, the higher the value of replication pause time. Meanwhile, HAProxy is able to divide workload evenly and handle server failures with a 100% success rate.Published
2020-09-10
Issue
Section
Artikel
License
Copyright info for authors
1. Authors hold the copyright in any process, procedure, or article described in the work and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
2. Authors retain publishing rights to re-use all or portion of the work in different work but can not granting third-party requests for reprinting and republishing the work.
3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) as it can lead to productive exchanges, as well as earlier and greater citation of published work.
