Article Sidebar

Submitted
18 December 2023
Accepted
21 May 2024
Published
14 June 2024
Download
PDF (Bahasa Indonesia)
Statistic
Read Counter : 37 Download : 20

Downloads

Download data is not yet available.

Main Article Content

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

Keywords

serangan gangguan database Disaster Recovery Plan (DRP) Master to Master MySQL Replication attacks disruptions databases Disaster Recovery Plan (DRP) Master to Master MySQL Replication

Article Details

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

Author Biographies

Rahmat Suhatman, Politeknik Caltex Riau

Dosen Tetap pada Prodi Teknik Informatikadi Politeknik Caltex Riau

Muhammad Arif Fadhly Rida, Politeknik Caltex Riau

Teknik Informatika Politeknik Caltex Riau

Ibnu Surya, Politeknik Caltex Riau

Teknik Informatika Politeknik Caltex Riau

Raudatul Tasya, Politeknik Caltex Riau

D4 - Teknik InformatikaPoliteknik Calte Riau
How to Cite
Suhatman, R., Fadhly Rida, M. A., Surya, I., & Tasya, R. (2024). Penerapan Disaster Recovery Plan Pada Database MySQL Menggunakan Metode Master to Master Replication Berbasis Docker . Jurnal Komputer Terapan, 10(1), 78–85. https://doi.org/10.35143/jkt.v10i1.6226
Download Citation
Endnote/Zotero/Mendeley (RIS)
BibTeX

References

  1. Connolly dan Begg. (2020). Implementasi virtualisasi server berbasis docker container. PROSISKO: Jurnal Pengembangan Riset dan Observasi Sistem Komputer, 7(2), 165-175
  2. Apridayanti, Isnawati, & Sputra, (2018). Desain dan Implementasi Virtualisasi Berbasis Docker untuk Deployment Aplikasi Web. Jurnal Semantik Vol.4 No.2 2018.
  3. Husen, Z., & Surbakti, M. S. (2020). Membangun Server dan Jaringan Komputer dengan Linux Ubuntu. Syiah Kuala University Press.
  4. Jasweni, (2018)“Implementation of MariaDB Database Replication by Using Cluster Technology”, https://opac.pcr.ac.id.
  5. 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.
  6. Purwanto, E, (2012). Perbandingan Strategi Replikasi Pada Sistem Basis Data Terdistribusi. JURNAL MAHASISWA TI S1,1-8.
  7. Sipahutar, C. (2019). Implementasi Disaster Recovery Plan Menggunakan Cloud Computing Pada Web Server, https://opac.lib.pcr.ac.id.
  8. Yuliadi,B, (2016). Rancangan Disaster Recovery Pada Instansi Pendidikan Studi Kasus Universitas Mercu Buana, JURNAL TEKNIK INFORMATIKAVOL. 9 NO. 1, APRIL 2016
  9. Huang, J., Fitrisia, Y., & Fadhly Ridha, M. A. (2018). Implementasi Multi Server Data Storage Pada Cloud Computing. Jurnal Komputer Terapan, 4(2), 1–9.
  10. 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.
  11. Ridha, M. A. F., & Suhatman, R. . (2022). Kubernetes Cluster Performance Comparison with KVM, Vagrant and LXD Virtualization. Jurnal Komputer Terapan, 8(1), 151–157.
  12. 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.
  13. 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.
  14. 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