Sistem Replikasi Basis Data berdasarkan MySQL  menggunakan Container Docker

Ilmiyatus Sholihah; Cahyo Darujati

doi:10.24843/MITE.2022.v21i02.P08

Ilmiyatus Sholihah Universitas Narotama
Cahyo Darujati Universitas Narotama, Fakultas Ilmu Komputer http://orcid.org/0000-0001-8996-6386

##plugins.pubIds.doi.readerDisplayName## https://doi.org/10.24843/MITE.2022.v21i02.P08

Abstrak

This study aims to implement database replication using the master-slave technique. The main focus of this research is to run data replication on the master server so that it can be copied automatically on the slave server. Master-slave replication techniques aim to prevent data loss from system failure events or device damage on the main server. The concept of master-slave replication is to copy data from the master server database to the slave server so that users do not need to manually backup data from the database. Master-slave database replication is one of the features provided by the MySQL database application in the Docker container. Still, to run the replication system, some adjustments and configurations are required for the database application to establish a replication infrastructure automatically. In this study, the replication was run on a MySQL database application with 20 multimedia data files capacity of 100MB. Testing is done by entering data into the database on the master server. The test scenario in this study was to upload data and delete data. The test results show that the data changes automatically: the data on the slave server is the same as on the master server, even though the data on the master server has gone through data uploads and deletions. And vice versa, data changes made on the master server are also directly replicated on the slave server.

##plugins.generic.usageStats.downloads##

##plugins.generic.usageStats.noStats##

Referensi

[1] M. Johnson et al., “Impact of big data and artificial intelligence on industry: Developing a workforce roadmap for a data driven economy,” Glob. J. Flex. Syst. Manag., vol. 22, no. 3, hal. 197–217, 2021.
[2] G. Aceto, V. Persico, dan A. Pescapé, “Industry 4.0 and health: Internet of things, big data, and cloud computing for healthcare 4.0,” J. Ind. Inf. Integr., vol. 18, hal. 100129, 2020.
[3] F. Zamzami, N. D. Nusa, dan I. A. Faiz, Sistem Informasi Akuntansi. UGM PRESS, 2021.
[4] S. Arni, “Penerapan Perintah MySQL dalam Backup Database,” PROGRES, vol. 5, no. 2, hal. 19–26, 2013.
[5] A. Meier dan M. Kaufmann, SQL & NoSQL databases. Springer, 2019.
[6] H. Maulana, “Analisis Dan Perancangan Sistem Replikasi Database MySQL dengan menggunakan VMware pada Sistem Operasi Open Source,” InfoTekJar J. Nas. Inform. dan Teknol. Jar., vol. 1, no. 1, hal. 32–37, 2016.
[7] Z. Jiang, H. Da, Y. Qiu, dan J. Pan, “Overview of Data Synchronization and Fault Recovery Technology in Multi Active Data Center,” in 2021 IEEE 4th International Conference on Automation, Electronics and Electrical Engineering (AUTEEE), 2021, hal. 113–118.
[8] R. Shrestha, “High Availability and Performance of Database in the Cloud-Traditional Master-slave Replication versus Modern Cluster-based Solutions,” 2017.
[9] Z. M. Subekti, S. Subandri, dan G. Rakasiwi, “Perancangan Infrastruktur Web Server dan Database menggunakan Metode Replication Mirror dan Failover Clustering,” J. Cendikia, vol. 18, no. 1, hal. 359–370, 2019.
[10] A. Gupta, M. Saxena, dan R. Gill, “Performance Analysis of RDBMS and Hadoop Components with their File Formats for the development of Recommender Systems,” in 2018 3rd International Conference for Convergence in Technology (I2CT), 2018, hal. 1–6.
[11] I. M. Sukarsa, “Aplikasi Konversi Flowchart ke Kode Program Bahasa Pemrograman PL/SQL MYSQL,” Maj. Ilm. Teknol. Elektro, vol. 8, no. 2, hal. 44–53, 2009.
[12] F. Y. Putra, I. M. A. Suyadnya, dan I. P. R. Agung, “Reservation Application System Of Private Lesson At Easyspeak Denpasar Based On Web And Android,” Maj. Ilm. Teknol. Elektro, vol. 15, no. 1, hal. 79–83, Jun 2016, doi: 10.24843/MITE.1501.14.
[13] X. Yu, X. Cai, S. Su, J. Han, dan R. F. Mansour, “The Technical Design and Implementation of Cross-Platform Industrial Product Order System,” J. Cybersecurity, vol. 3, no. 1, hal. 1, 2021.
[14] A. Amarudin dan Y. Atri, “Analisis Penerapan Mikrotik Router Sebagai User Manager Untuk Menciptakan Internet Sehat Menggunakan Simulasi Virtual Machine,” J. TAM (Technology Accept. Model., vol. 9, no. 1, hal. 62–66, 2018.
[15] Z. Aalam, V. Kumar, dan S. Gour, “A review paper on hypervisor and virtual machine security,” in Journal of Physics: Conference Series, 2021, vol. 1950, no. 1, hal. 12027.
[16] M. Idhom, R. Alit, H. Endah, dan A. Fauzi, “Implementation System Telegram Bot for Monitoring Linux Server,” 2018.
[17] L. Mercl dan J. Pavlik, “The Comparison of Container Orchestrators,” in Third International Congress on Information and Communication Technology, 2019, hal. 677–685.
[18] Y. C. Giap et al., Cloud Computing: Teori dan Implementasi. Yayasan Kita Menulis, 2020.
[19] N. K. Malik, A. T. P. A. Ramadani, N. A. Karlina, dan D. R. Lestyarini, “Replikasi Database dengan Model Master-Master dan Master-Slave MariaDB,” Universitas Siliwangi, 2020.
[20] E. Darwis, “Implementasi Basis Data Terdistribusi menggunakan MySQL pada PT Thamrin Brothers Palembang,” Universitas Bina Darma, 2012.