REPLICATION OF COMPARATIVE METHODS FOR SINGLE DATABASE PERFORMANCE IN CENTOS OPERATION SYSTEM WITH MAXSCALE

Merinda Lestandy; Mochammad Arif Hidayatullah; Amrul Faruq; Machmud Effendy; Muhammad Irfan

doi:10.22373/cj.v4i2.7753

REPLICATION OF COMPARATIVE METHODS FOR SINGLE DATABASE PERFORMANCE IN CENTOS OPERATION SYSTEM WITH MAXSCALE

Merinda Lestandy, Mochammad Arif Hidayatullah, Amrul Faruq, Machmud Effendy, Muhammad Irfan

Abstract

Processing data in an institution or organization has become an activity or routine for each meeting. In processing data, of course there are various kinds of problems, ranging from missing data, either because of an error in entering data or the result of a system failure. To overcome these problems, in an agency or company must have data backup, so as to create problems that occur in the data, the institution still has data backup. To call, another method of database replication is used. From the test results obtained data on the value of RTA (Round Trip Average) that is the time required for one time sending and receiving data from the replication database is 5426.22 ms and for compilation service diagrams a query attack occurs with a percentage of 29% in the database applications that produce 1774.45 ms results and for service diagrams at a query attack percentage of 29% a single database estimates the server down.

Keywords

Database, Maxscale, Replication

Full Text:

PDF

References

R. Ramakrishnan and J. Gehrke, “Database Management Systems solution,” Database Manag. Syst. Solut. Man. Third Ed., vol. 8, no. 4, pp. 65–68, 2003, doi: 10.1300/J115v06n04_07.

Gat, “Perancangan Basis Data Perputakaan Sekolah dengan Menerapkan Model Data Relasional,” Citec, vol. 2, No. 4, pp. 304–315, 2015.

J. Grov, L. Soares, A. Correia, J. Pereira, R. Oliveira, and F. Pedone, “A pragmatic protocol for database replication in interconnected clusters,” Proc. - 12th Pacific Rim Int. Symp. Dependable Comput. PRDC 2006, no. iii, pp. 230–237, 2006, doi: 10.1109/PRDC.2006.11.

A. Rahmatulloh and F. MSN, “Implementasi Load Balancing Web Server menggunakan Haproxy dan Sinkronisasi File pada Sistem Informasi Akademik Universitas Siliwangi,” J. Nas. Teknol. dan Sist. Inf., vol. 3, no. 2, pp. 241–248, 2017, doi: 10.25077/teknosi.v3i2.2017.241-248.

S. Khotijah, “DESAIN DATABASE SISTEM INFORMASI AKADEMIK PADA Program Studi Teknik Informatika Fakultas Teknik , Matematika dan Ilmu Pengetahuan Alam Universitas Indraprasta PGRI,” Khotijah –Desain Database Sist. Inf., vol. 9, no. 2, pp. 154–165, 2016.

S. Sapate and M. Ramteke, “Survey on Comparative Analysis of Database Replication Techniques,” Int. J. IT, Eng. Appl. Sci. Res., vol. 2, no. 3, pp. 2319–4413, 2013.

M. Data, G. Ramadhan, and K. Amron, “Analisis Availabilitas dan Reliabilitas Multi-Master Database Server Dengan State Snapshot Transfers (SST) Jenis Rsync Pada MariaDB Galera Cluster,” J. Teknol. Inf. dan Ilmu Komput., vol. 4, no. 1, p. 69, 2017, doi: 10.25126/jtiik.201741288.

A. Mubarak, A. Lawi, and M. Niswar, “Sistem Replikasi Basisdata Terdistribusi Untuk Data Center,” pp. 1–14, 2012.

S. Sucipto, “Perancangan Active Database System pada Sistem Informasi Pelayanan Harga Pasar,” Intensif, vol. 1, no. 1, p. 35, 2017, doi: 10.29407/intensif.v1i1.562.

I. WARMAN and R. RAMDANIANSYAH, “ANALISIS PERBANDINGAN KINERJA QUERY DATABASE MANAGEMENT SYSTEM (DBMS) ANTARA MySQL 5.7.16 DAN MARIADB 10.1,” J. Teknoif, vol. 6, no. 1, pp. 32–41, 2018, doi: 10.21063/jtif.2018.v6.1.32-41.

S. P. Ramadhan and Teknik, “PERANCANGAN DAN IMPLEMENTASI SISTEM MONITORING JARINGAN MENGGUNAKAN ICINGA DAN POWERDNS DI PT . PACIFIC TELEMATIKA INDONESIA Selamet Puji Ramadhan Teknik Informatika – Universitas Komputer Indonesia,” p. 10111381, 2016.

A. Wicitra, D. Utomo, and H. K. Wardana, “Membangun Infrastruktur Komputasi Awan Privat Single Cluster dan Multi Cluster dengan menggunakan Linux Centos,” pp. 185–194.

M. H. Darmawan, Isnawaty, and Subardin, “Perancangan dan Implementasi Sistem Replikasi Database Terdistribusi pada Fakultas Teknik Universitas Halu Oleo,” semanTIK, vol. 4, no. 2, pp. 91–98, 2018.

H. Maulana, “Analisis Dan Perancangan Sistem Replikasi Database Mysql Dengan Menggunakan Vmware Pada Sistem Operasi Open Source,” InfoTekJar (Jurnal Nas. Inform. dan Teknol. Jaringan), vol. 1, no. 1, pp. 32–37, 2016, doi: 10.30743/infotekjar.v1i1.37.

A. Heryanto and A. Albert, “Implementasi Sistem Database Terdistribusi Dengan Metode Multi-Master Database Replication,” J. Media Inform. Budidarma, vol. 3, no. 1, p. 30, 2019, doi: 10.30865/mib.v3i1.1098.

DOI: http://dx.doi.org/10.22373/cj.v4i2.7753