COMPARATION OF DISTRIBUTED DATABASE MODEL BY CLUSTERING METHOD IN E-GOVERNMENT SYSTEM. STUDY AT KEMENKEU RI
Abstract
MySQL is one of the most popular open source database in the world based on its performance, its reliability, and its easiness that has been proved. MySQL is categorized into community version and commercial version. The commercial version has standalone architecture models and clusters.Database Clustering is one of distributed database model. The case study used is Kemenkeu Learning Center (KLC) Application which is an e-government application in Ministry of Finance. KLC application used for interactive learning media for all ASN especially ASN in Ministry of Finance. This makes the KLC application being categorized into a very high critical application, so it takes a good response time and has high availability. One of the most important factors to fulfill this need is by deciding the appropriate MySQL database architecture for KLC application. This research was conducted by creating 3 (three) database architecture models according to best practice from MySQL, namely the Standalone architecture model, InnoDB Cluster and NDB Cluster. Then tested with several different scenarios to get results in the form of response time and percentage of errors that indicate high availability capabilities. The tools used in testing are Apache JMeter. From the test results, it is found that the MySQL NDB Cluster is the right database architecture model in an effort to realize the need for database services with the best response time and high availability capabilities.
Downloads
References
H. Atthahara, "Inovasi pelayanan publik berbasis e-government: studi kasus aplikasi Ogan Lopian Dinas Komunikasi dan Informatika di Kabupaten Purwakarta," Jurnal Politikom Indonesiana, vol. 3, no. 1, pp. 66-66, 2018.
A. Fadli, M. I. Zulfa, A. W. W. Nugraha, A. Taryana, and M. S. Aliim, "Analisis Perbandingan Unjuk Kerja Database SQL dan Database NoSQL Untuk Mendukung Era Big Data," Jurnal Nasional Teknik Elektro, pp. 154-158, 2020.
M. S. Rana, M. K. Sohel, and M. S. Arman, "Distributed Database Problems Approaches and Solutions-A Study," International Journal of Machine Learning and Computing (IJMLC), 2018.
A. Misbullah, N. Nazaruddin, R. Rasudin, Z. Zulfan, "ANALISA PROSES MIGRASI MYSQL NON-CLUSTER KE CLUSTER DALAM MENANGANI FAIL-OVER SISTEM AKADEMIK UNIVERSITAS SYIAH KUALA,"Cyberspace: Jurnal Pendidikan Teknologi Informasi, vol. 4, no. 1, pp. 40-49, 2020.
C. Bell, Introducing the MySQL 8 Document Store, 2018.
C. Bell, Introducing InnoDB Cluster, 2018.
W. Krogh, and M. Okuno, Pro MySQL NDB Cluster, 2017.
S. Samidi, F. Fadly, Y. Virmansyah, R. Y. Suladi, and A. B. Lesmana, "Optimasi Database dengan Metode Index dan Partisi Tabel Database Postgresql pada Aplikasi E-Commerce. Studi pada Aplikasi Tokopintar," Jurnal Pendidikan Tambusai, vol. 6, no. 1, pp. 2094-2102, 2022.
A. D. Riawati, M. Irfan, K. Khaeruddin, and A. Faruq, "High Availability Dynamic Sharding Database Server Dengan Metode Fail Over Dan Clustering," Jurnal Manajemen Informatika dan Sistem Informasi, vol. 5, no. 1, pp. 1-10, 2022.
S. Widiono, "Experiments and Descriptive Analysis in The Mariadb Database Cluster System To Prepare Data Availability," International Journal of Engineering Technology and Natural Sciences, vol. 1, no. 1, pp. 42-48, 2019.
G. Ramadhan, and K. Amron, "Analisis Availabilitas dan Reliabilitas Multi-Master Database Server Dengan State Snapshot Transfers (SST) Jenis Rsync Pada MariaDB Galera Cluster," Jurnal Teknologi Informasi dan Ilmu Komputer (JTIIK) p-ISSN, 2355, 7699, 2017.
R. K. Laday, H.Sukoco, and Y. Nurhadryani, "Distributed System and Multimaster Replication Model on Reliability Optimation Database," TELKOMNIKA Indonesian Journal of Electrical Engineering, vol. 13, no. 3, pp. 529-536, 2015.
Z. Hayat, and T. R. Soomro, "Implementation of oracle real application cluster", Review of Computer Engineering Studies, vol. 3, no. 4, pp. 81-85, 2016.
I. P. Andhikha, "Implementasi Dan Analisis Kinerja Mysql Cluster Menggunakan Metode Load Balancing," Jurnal Manajemen Informatika, vol. 8, no. 1, 2017.
J. H. Lubis, "Analisa Performansi Query Pada Database Smell," Jurnal Mantik Penusa, vol. 21, no. 1, 2017.
K. Xiang, "An improvement in MySQL cluster in e-commerce scenarios," In Proceedings of 2nd International Conference on Information Technology and Electronic Commerce, IEEE, pp. 286-289, 2014.
Copyright (c) 2022 Adinda Krida Wicaksono, Fauzie Nurrakhman, Samidi
This work is licensed under a Creative Commons Attribution 4.0 International License.
