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

Authors

  • Merinda Lestandy Universitas Muhammadiyah Malang
  • Mochammad Arif Hidayatullah Universitas Muhammadiyah Malang
  • Amrul Faruq Universitas Muhammadiyah Malang
  • Machmud Effendy Universitas Muhammadiyah Malang
  • Muhammad Irfan Universitas Muhammadiyah Malang

DOI:

https://doi.org/10.22373/cj.v4i2.7753

Keywords:

Database, Maxscale, Replication

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.

Author Biographies

  • Mochammad Arif Hidayatullah, Universitas Muhammadiyah Malang

    Universitas Muhammadiyah Malang

  • Amrul Faruq, Universitas Muhammadiyah Malang

    Universitas Muhammadiyah Malang

  • Machmud Effendy, Universitas Muhammadiyah Malang
    Universitas Muhammadiyah Malang
  • Muhammad Irfan, Universitas Muhammadiyah Malang
    Universitas Muhammadiyah Malang

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.

Downloads

Published

2020-10-17

Issue

Vol. 4 No. 2 (2020)

Section

Articles

License

Authors who publish with Cyberspace Journal agree to the following terms:

  1. Authors retain copyright 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 are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
  3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).