Penerapan Disaster Recovery Plan Pada Database MySQL Menggunakan Metode Master to Master Replication Berbasis Docker

Authors

DOI:

https://doi.org/10.35143/jkt.v10i1.6226

Keywords:

attacks, disruptions, databases, Disaster Recovery Plan (DRP), Master to Master MySQL Replication

Abstract

Data stored in the database must have protection against attacks and interference. Attacks and disruptions have been experienced by the Caltex Riau Polytechnic (PCR), which only has one database. A database that experiences an attack or disruption results in the information system being inaccessible to users. Currently, PCR does not have an information system recovery plan so that information system recovery will take a long time so that it can be accessed again by users. Therefore, PCR requires a recovery plan if the database experiences an attack or disruption. Based on these problems, this research will create a recovery plan so that the information system can be accessed more quickly when the database experiences an attack or disruption. In this research, database replication was carried out using a Disaster Recovery Plan (DRP) to respond to emergencies, provide backup operations during disruptions, and manage recovery and rescue processes afterwards. The method used is Master to Master MySQL Replication. This method uses 2 servers as master 1 and master 2. If the database on master 1 experiences changes, it will be copied to master 2 in real time. By applying the Master to Master Replication method to the DRP, the PCR information system can provide a directly updated backup for the database, when it experiences an attack or damage

Downloads

Download data is not yet available.

Author Biographies

  • Rahmat Suhatman, Caltex Riau Polytechnic
    Dosen Tetap pada Prodi Teknik Informatikadi Politeknik Caltex Riau
  • Muhammad Arif Fadhly Rida, Caltex Riau Polytechnic
    Teknik Informatika Politeknik Caltex Riau
  • Ibnu Surya, Caltex Riau Polytechnic
    Teknik Informatika Politeknik Caltex Riau
  • Raudatul Tasya, Caltex Riau Polytechnic
    D4 - Teknik InformatikaPoliteknik Calte Riau

References

Connolly dan Begg. (2020). Implementasi virtualisasi server berbasis docker container. PROSISKO: Jurnal Pengembangan Riset dan Observasi Sistem Komputer, 7(2), 165-175

Apridayanti, Isnawati, & Sputra, (2018). Desain dan Implementasi Virtualisasi Berbasis Docker untuk Deployment Aplikasi Web. Jurnal Semantik Vol.4 No.2 2018.

Husen, Z., & Surbakti, M. S. (2020). Membangun Server dan Jaringan Komputer dengan Linux Ubuntu. Syiah Kuala University Press.

Jasweni, (2018)“Implementation of MariaDB Database Replication by Using Cluster Technology”, https://opac.pcr.ac.id.

Kurniadi, W., Djusmin, V. B., & Yasir, F. N. (2021). Implementasi Sistem Replikasi Database Terdistribusi pada Server Sistem Informasi Data Wisuda Universitas Cokroaminoto Palopo. PROSIDING SEMANTIK, 3(1), 258-262.

Purwanto, E, (2012). Perbandingan Strategi Replikasi Pada Sistem Basis Data Terdistribusi. JURNAL MAHASISWA TI S1,1-8.

Sipahutar, C. (2019). Implementasi Disaster Recovery Plan Menggunakan Cloud Computing Pada Web Server, https://opac.lib.pcr.ac.id.

Yuliadi,B, (2016). Rancangan Disaster Recovery Pada Instansi Pendidikan Studi Kasus Universitas Mercu Buana, JURNAL TEKNIK INFORMATIKAVOL. 9 NO. 1, APRIL 2016

Huang, J., Fitrisia, Y., & Fadhly Ridha, M. A. (2018). Implementasi Multi Server Data Storage Pada Cloud Computing. Jurnal Komputer Terapan, 4(2), 1–9.

Edy Suranta G.S, S. P. (2017). Distributed Replicated Block Device (DRBD) sebagai Alternatif High Availability Data Replication pada Cloud Computing. Jurnal Komputer Terapan, 3(1), 59–68.

Ridha, M. A. F., & Suhatman, R. . (2022). Kubernetes Cluster Performance Comparison with KVM, Vagrant and LXD Virtualization. Jurnal Komputer Terapan, 8(1), 151–157.

D. Dhining, Y. Rokhayati, and D. Kurniawan, (2017). Penerapan Replikasi Data pada Aplikasi Ticketing Menggunakan Slony PostgreSQL, JAIC, vol. 1, no. 2, pp. 9-18, Dec. 2017.

M. H. Alifian dan D. Priharsari, (2021). Penyusunan Disaster Recovery Plan (DRP) menggunakan framework NIST SP 800-34 (Studi Kasus pada Perusahaan IT Nasional), J-PTIIK, vol. 5, no. 10, hlm. 4673–4679, Okt 2021.

Suprianto, adi. (2019). Penyusunan Disaster Recovery Plan (DRP) berdasarkan framework NSIT SP 800-34 studi kasus departemen teknologi informasi PT Pupuk Kalimantan Timur. S1. Universitas Brawijaya

Published

14-06-2024

How to Cite

Penerapan Disaster Recovery Plan Pada Database MySQL Menggunakan Metode Master to Master Replication Berbasis Docker . (2024). Jurnal Komputer Terapan, 10(1), 78-85. https://doi.org/10.35143/jkt.v10i1.6226

Similar Articles

1-10 of 45

You may also start an advanced similarity search for this article.

Most read articles by the same author(s)