Experiments and Descriptive Analysis in The MariaDB Database Cluster System to Prepare Data Availability
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
[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].
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
Copyright Notice
The Authors submitting a manuscript do so on the understanding that if accepted for publication, copyright of the article shall be assigned to journal IJETS, University Of Technology Yogyakarta as publisher of the journal, and the author also holds the copyright without restriction.
Copyright encompasses exclusive rights to reproduce and deliver the article in all form and media, including reprints, photographs, microfilms and any other similar reproductions, as well as translations. The reproduction of any part of this journal, its storage in databases and its transmission by any form or media, such as electronic, electrostatic and mechanical copies, photocopies, recordings, magnetic media, etc. , are allowed with a written permission from journal IJETS, University Of Technology Yogyakarta.
Jurnal IJETS Board, University Of Technology Yogyakarta, the Editors and the Advisory International Editorial Board make every effort to ensure that no wrong or misleading data, opinions or statements be published in the journal. In any way, the contents of the articles and advertisements published in the journal IJETS, University Of Technology Yogyakarta are sole and exclusive responsibility of their respective authors and advertisers.
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0