PENINGKATAN AKSESIBILITAS DATA DENGAN MENERAPKAN GEO-REPLICATION DATABASE
Abstract
Database replication is a critical technology that needs to be implemented to improve database performance for applications that require fast data access and high reliability with many users. Very large data query process requests by applications impact decreasing database server performance because many applications use only one database resource. One solution to this is replication, placing the database server and several replications in different locations, which allows database performance to be maximized. This requires a study of research related to replication strategies, especially the implementation of multi-location database geo-replication mechanisms, which aim to ensure the availability of services and replication processes run well and that consistency between database servers can be achieved. The increasing number of replicated databases with different geographic locations will make data access load requests from applications can be directed to several replication servers and reduce the delay time to user responses (low latency). This research implemented a geo-replication database for three database servers on the Ubuntu 22.04.4 LTS Virtual Private Server located in Singapore, West Jakarta, and South Jakarta, using the MariaDB database version 10.6.18. To measure the replication results related to time, consistency, and accessibility, a database replication query processing time test was carried out using queries with data from 250 to 150,000 records. The test results from the consistency side can be seen from the same number of data records on the master and slave replication databases, and from the accessibility side, data query requests can be served from three database server locations.
References
Azizah, N., Hartajaya, V., & Riady, S. (2022). Comparison of replication strategies on distributed database systems. International Journal of Cyber and IT Service Management, 2(1), 20–29.
Campêlo, R. A., Casanova, M. A., Guedes, D. O., & Laender, A. H. F. (2020). A brief survey on replica consistency in cloud environments. Journal of Internet Services and Applications, 11, 1–13.
Isiaka, F. M., Audu, S. A., & Umar, M. A. (2020). Developing a fail-safe culture in a cyber environment using MySQL replication technique. International Journal of Crowd Science, 4(2), 149–170.
Khan, W., Kumar, T., Zhang, C., Raj, K., Roy, A. M., & Luo, B. (2023). SQL and NoSQL database software architecture performance analysis and assessments—a systematic literature review. Big Data and Cognitive Computing, 7(2), 97.
Lestariningsih, E., Redjeki, R. S., Supriyanto, E., Murti, H., Ardhianto, E., Wahyudi, E. N., & Handoko, W. T. (2024). Studi Literasi Tersistematis Implementasi Metode-Metode Pengembangan Sistem Informasi Berbasis Basis Data Terdistribusi. Jurnal Informatika Dan Rekayasa Perangkat Lunak, 6(1), 56–61.
Nama, P., Bhoyar, M., Chinta, S., & Reddy, P. (2023). Optimizing Database Replication Strategies through Machine Learning for Enhanced Fault Tolerance in Cloud-Based Environments. Machine Learning (ML), 63(3).
Nookala, G., Gade, K. R., Dulam, N., & Thumburu, S. K. R. (2022). The Shift Towards Distributed Data Architectures in Cloud Environments. Innovative Computer Sciences Journal, 8(1).
Patra, S. S., & Goswami, V. (2022). Performance Enhancement of Cloud Datacenters Through Replicated Database Server. Journal of Information Technology Research (JITR), 15(1), 1–23.
Pohanka, T., & Pechanec, V. (2020). Evaluation of replication mechanisms on selected database systems. ISPRS International Journal of Geo-Information, 9(4), 249.
Pratama, B. P. A., Hardianto, B. G., & Dharmayanti, D. (2024). Implementation of High Availability Based on Load Balancing and Failover Method in E-commerce Using MySQL Database. Asian Journal of Engineering, Social and Health, 3(10), 2226–2239.
Putra, T. O. D., Ansyah, A. S. S., Arifin, M., & Ijtihadie, R. M. (2023). Geo-Replication Dalam Tinjuaun Latensi Dan Efektifitas Biaya. Jurnal Ilmiah Teknologi Informasi, 21(2), 98–108. https://doi.org/10.12962/j24068535.v21i2.a1165
Ramu, V. B. (2023). Optimizing Database Performance: Strategies for Efficient Query Execution and Resource Utilization. International Journal of Computer Trends and Technology, 71(7), 15–21.
Shrestha, R., & Tandel, T. (2023). An Evaluation Method and Comparison of Modern Cluster-Based Highly Available Database Solutions. CLOSER, 131–138.
Sugiharto, W. H., Ghozali, M. I., Susanto, H., Budihardjo, M. A., & Suryono, S. (2020). Database replication method for real-time measurement pH parameter of fishery using a wireless sensor system. Journal of Physics: Conference Series, 1524(1), 012021.
Šušter, I., & Ranisavljević, T. (2023). Optimization of MySQL database. Journal of Process Management and New Technologies, 11(1–2), 141–151.
Vignesh, R., Deepa, D., Anitha, P., Divya, S., & Roobini, S. (2020). Dynamic enforcement of causal consistency for a geo-replicated cloud storage system. International Journal of Electrical Engineering and Technology, 11(3).
Wulandari, S., & Adji, G. S. (2021). Distributed Database Implementation in Point of Sale System with Method Synchronous Replication. International Journal of Engineering Technology and Natural Sciences, 3(2), 47–51.
Zambrano, M., & Gonzalez, V. (2024). Database’s Disaster Recovery Meets a Ransomware Attack. 19th International Conference on Accelerator and Large Experimental Physics Control Systems (ICALEPCS’23), Cape Town, South Africa, 09-13 October 2023, 280–284.
Zmaranda, D. R., Moisi, C. I., Győrödi, C. A., Győrödi, R. Ş., & Bandici, L. (2021). An analysis of the performance and configuration features of MySQL document store and elasticsearch as an alternative backend in a data replication solution. Applied Sciences, 11(24), 11590.
