Experiments and Descriptive Analysis in The MariaDB Database Cluster System to Prepare Data Availability

  • Suyud Widiono Universitas Teknologi Yogyakarta
Keywords: server, database, replication, cluster, node, MariaDB

Abstract

A database server called the Database Management System (DBMS) that relates tables in a database is called the Relational Database Management System (RDBMS). DBMS/RDBMS is a computer program that provides data services for computers or other computer programs. One of the RDBMS type database server (hereinafter referred to as a database server) is MariaDB. The database server is in charge of managing and providing data, so data must always be ready, fast presented, accurate, and safe, it cannot be damaged or even lost. One way to provide this data is to install several database servers using the concept of replication in the Multiple Server Database system. Replication in a cluster server database is a method of installing several database server nodes that allow between node servers to copy each other and distribute data from one node to another database server node, which then synchronizes data between server nodes to maintain data consistency. This study looks for the most optimal number of minimal database server nodes to provide accurate, fast and safe data on the MariaDB Cluster RDBMS. From the results of the replication test from the cluster server database, it can be concluded that the number of 3 (three) node servers can be known to always synchronize and consistency of data between server nodes, so there are 3 (three) nodes of minimum database node with MariaDB RDBMS.

References

[1] ADITYA, B. & JUHANA, T., 2015. A high availability (HA) MariaDB Galera Cluster across data center with optimized WRR scheduling algorithm of LVS - TUN, in 2015 9th International Conference on Telecommunication Systems Services and Applications (TSSA).
[2] Arikunto, S., 2006. Prosedur Penelitian Suatu Pendekatan Praktik Edisi Revisi VI. Jakarta : Rineka Cipta.
[3] Elmasri R. & Navathe B.S., 2011. undamental of Database Systems (6th ed.)., Pearson Education, Inc., publishing as Addison-Wesley.
[4] Moh. Nazir, 2003. Metode Penelitian. Cetakan Kelima, Jakarta, Ghalia Indonesia.
[5] Satzinger, John W, Jackson, Robert B, Burd, Stephen D., 2005, Object-Oriented Analysis and Design With The Unified Process. Thomson Course Technology.
[6] Sugiyono, 2014. Metodologi Penelitian Bisnis. Bandung: CV Alfabeta.
[7] Williams, B. K., & Sawyer, S. C., 2007. Using Information Technology: Practical Introduction to the World of Computers and Communication (7th ed.) (Translator: Nur Wijayaning Rahayu & Th. Arie Prabawati). Yogyakarta: ANDI.
[8] CODEPOLITAN, 2019. Mengenal MariaDB. Available in: https://www.codepolitan.com/mengenal-mariadb/, [Accessed July 01, 2019].
[9] MARIADB, 2019. What is MariaDB Galera Cluster? Available in: https://mariadb.com/kb/en/library/what-is-mariadb-galera-cluster/, [Accessed June 04, 2019].
[10] MARIADB, 2019. About MariaDB. Available in: https://mariadb.org/about/, [Accessed June 04, 2019].
[11] VTECHIE, 2019. Install MariaDB Galera Cluster on Centos 7. Available in: http://vtechie.com/2016/03/15/mariadb-galera-cluster-centos-7/, [Accessed July 01, 2019].
Published
2019-07-12

Article Metrics

Abstract view : 178 times