PENERAPAN REPLIKASI DATA PADA BASIS DATA MYSQL UNTUK MENJAGA KETERSEDIAAN DATA
Keywords:
Implementation, Data Replication, Mysql DatabaseAbstract
Data availability is a crucial parameter in information system infrastructure, where single server failure is a major risk. To mitigate this risk, database replication is recognized as an effective solution because it can increase data availability and enable the distribution of the same data across multiple locations. This study aims to implement and analyze the effectiveness of MySQL data replication techniques to ensure data continuity and availability. The method used is an experimental study by building a Master-Slave replication architecture using an asynchronous replication mechanism. Testing focused on two main metrics: replication lag time as an indicator of synchronization, and handover time as an indicator of system recovery speed. The implementation results show stable system operation with a minimal average replication lag of 0.00-0.01 seconds in a 1 Gbps network environment. In a failure simulation, the failover process to the replica server was successfully completed within 12-15 seconds. This implementation proves that MySQL data replication is effective in increasing fault tolerance and ensuring continuous data availability.
Downloads
References
Belluano, P. L. L. (2017). Penerapan sistem replikasi dan integrasi basis data terdistribusi pada pangkalan data pendidikan tinggi (PDPT). ILKOM Jurnal Ilmiah, 9(1), 42–48.
Muliawan, D., & Iskandar, D. (2023). Penerapan replikasi synchronous pada aplikasi data KRS online pada Universitas Jabal Ghafur menggunakan PostgreSQL. Future Academia: The Journal of Multidisciplinary Research on Scientific and Advanced, 1(1), 31–45.
Rahayu, S., & Yunitasari, L. (2018). Analisis kinerja replikasi database MySQL menggunakan metode Master-Slave. Prosiding Seminar Nasional Teknologi Informasi dan Komunikasi.
Riadi, I., & Erpani, R. (2020). Implementasi replikasi database MySQL untuk menjaga integritas data pada sistem informasi. INTECOM: Jurnal Information Technology and Computer Science, 3(2), 178–186.
Widyasto, D. (2016). Penerapan replikasi asynchronous pada basis data terdistribusi untuk keamanan data. Jurnal Ilmiah Teknologi dan Informasi, 6(1), 62–74.
Yuliansyah, H. (2014). Perancangan replikasi basis data MySQL dengan mekanisme pengamanan menggunakan SSL Encryption. Jurnal Informatika, 8(1), 826–836.
Downloads
Published
Issue
Section
License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
