ANALISA PROSES MIGRASI MYSQL NON-CLUSTER KE CLUSTER DALAM MENANGANI FAIL-OVER SISTEM AKADEMIK UNIVERSITAS SYIAH KUALA
DOI:
https://doi.org/10.22373/cj.v4i1.7246Keywords:
MySQL cluster, data akademik, sistem informasi, migrasi, waktu aksesAbstract
Jumlah data akademik yang terus meningkat pada institusi perguruan tinggi perlu dikelola dengan efektif sehingga pengaksesan data melalui sistem informasi akademik menjadi lebih mudah dan cepat. Salah satu teknologi Database Management System (DBMS) yang masih sering digunakan pada institusi perguruan tinggi adalah MySQL. Umumnya, aplikasi MySQL yang digunakan untuk memproses query dari pengguna masih bersifat tunggal pada sebuah server sehingga overload akses pada waktu tertentu dapat menyebabkan sistem informasi menjadi tidak stabil bahkan sering mengalami timeout. Penelitian ini bertujuan untuk menganalisa proses migrasi MySQL non-cluster ke MySQL cluster dalam menangani fail-over sistem akademik. Hasil penelitian yang diperoleh yaitu berupa dokumen konfigurasi yang tepat pada MySQL cluster sehingga dapat digunakan secara umum pada berbagai MySQL server. Selain itu, load-balancing juga diuji dalam penelitian ini untuk mendistribusikan request antara MySQL server.References
T. Coughlin, “175 Zettabytes By 2025”, Forbes Publishing,
https://www.forbes.com/sites/tomcoughlin/2018/11/27/175-zettabytes-by-2025
Portal Data, “Mahasiswa Aktif”, Universitas Syiah Kuala,
https://data.unsyiah.ac.id/mahasiswa-aktif
S. Kedar, “Database Management System”, Technical Publications; 2009.
V. Alex, “Linux cluster architecture. Sams”, 2002 Jul 1.
P. DuBois, “MySQL”, Addison-Wesley Professional, ISBN: 9780768678673, 2008
M. Rouse, “High-Availability Proxy (HAProxy)”, WhatIs.com,
https://searchnetworking.techtarget.com/definition/HAProxy
Ramirez, Nick. “Load Balancing with HAProxy: Open-source technology for better scalability, redundancy and availability in your IT infrastructure”. Independently published, 2016.
Prasetijo, Agung B., Eko D. Widianto, and Ersya T. Hidayatullah. "Performance comparisons of web server load balancing algorithms on HAProxy and Heartbeat." In 2016 3rd International Conference on Information Technology, Computer, and Electrical Engineering (ICITACEE), pp. 393-396. IEEE, 2016.
Downloads
Published
Issue
Section
License
Authors who publish with Cyberspace Journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).