Improving Moodle Performance Using HAProxy and MariaDB Galera Cluster
Abstract
Moodle is a widely used Learning Management System in various educational institutions worldwide. However, frequent reports on internet forums indicate performance degradation when massive simultaneous users access Moodle. One of the most resource-intensive components supporting Moodle is the database, as all user-accessed data is stored in it. This study aims to optimize Moodle’s performance through distributed databases. Distributing the database into multiple database servers allows the database load to be distributed across all the database servers, resulting in an overall improvement in Moodle performance. This study compares the performance of Moodle installed on a single server with that installed on multiple database servers. Various testing parameters are employed to get valid results. Namely, course read, course write, and database performance, utilizing the server performance plugin available in Moodle. This research reveals a performance improvement of 384% in course read, 193% in course write, and 260% in the Moodle database in the multi-server scenario compared to the single-server scenario. This result validates that the database is the most crucial part of Moodle.
Keywords
Full Text:
PDFReferences
S. B. Dias, S. J. Hadjileontiadou, J. Diniz, and L. J. Hadjileontiadis, “DeepLMS: a deep learning predictive model for supporting online learning in the Covid-19 era,” Sci Rep, vol. 10, no. 1, Dec. 2020, doi: 10.1038/s41598-020-76740-9.
S. A. Raza, W. Qazi, K. A. Khan, and J. Salam, “Social isolation and acceptance of the learning management system (LMS) in the time of COVID-19 pandemic: An Expansion of the UTAUT Model,” Journal of Educational Computing Research, vol. 59, no. 2, pp. 183–208, Apr. 2021, doi: 10.1177/0735633120960421.
A. H. Mujianto, C. Mashuri, G. S. Permadi, and R. Wiratsongko, “Analisa pemanfaatan learning management system schoology menggunakan HOT fit model terhadap pembelajaran di masa pandemi covid 19,” Applied Information System and Management (AISM), vol. 5, no. 1, pp. 45–52, Apr. 2022, doi: 10.15408/aism.v5i1.24767.
T. Y. Aikina and L. M. Bolsunovskaya, “Moodle-based learning: motivating and demotivating factors,” International Journal of Emerging Technologies in Learning, vol. 15, no. 2, pp. 239–248, 2020, doi: 10.3991/ijet.v15i02.11297.
A. S. Mustafa and N. Ali, “The adoption and use of moodle in online learning: a systematic review,” Information Sciences Letters, vol. 12, no. 1, pp. 341–351, Jan. 2023, doi: 10.18576/isl/120129.
K. Wiechork and A. S. Charão, “Investigating the performance of moodle database queries in cloud environments,” in ICEIS 2020 - Proceedings of the 22nd International Conference on Enterprise Information Systems, SciTePress, 2020, pp. 269–275, doi: 10.5220/0009792202690275.
A. H. Ali and M. Z. Abdullah, “A survey on vertical and horizontal scaling platforms for big data analytics,” International Journal of Integrated Engineering, vol. 11, no. 6, pp. 138–150, 2019, doi: 10.30880/ijie.2019.11.06.015.
P. Singh, P. Gupta, K. Jyoti, and A. Nayyar, “Research on auto-scaling of web applications in cloud: Survey, trends and future directions,” Scalable Computing, vol. 20, no. 2, pp. 399–432, Jun. 2019, doi: 10.12694/scpe.v20i2.1537.
A. Zaini, H. Santoso, and M. P. T. Sulistyanto, “Fault tolerance strategy to increase moodle service reliability,” in Journal of Physics: Conference Series, IOP Publishing Ltd, Apr. 2021. doi: 10.1088/1742-6596/1869/1/012095.
M. Sadikin, R. Yusuf, and D. Arif Rifai, “Load balancing clustering on moodle LMS to overcome performance issue of e-learning system,” Telkomnika (Telecommunication Computing Electronics and Control), vol. 17, no. 1, pp. 131–138, 2019, doi: 10.12928/TELKOMNIKA.v17i1.10284.
S. Rajagopalan, “An overview of layer 4 and layer 7 load balancing,” Lecture Notes on Data Engineering and Communications Technologies, vol. 66, 2021, doi: 10.1007/978-981-16-0965-7_51.
S. Ebneyousef and A. Shirmarz, “A taxonomy of load balancing algorithms and approaches in fog computing: a survey,” Cluster Comput, vol. 26, no. 5, pp. 3187–3208, Oct. 2023, doi: 10.1007/s10586-023-03982-3.
A. H. Fathulloh and H. I. Adauwiyah, “Perbandingan tingkat efisiensi waktu query select pada database interface navicat dan SQLYog di MySQL DBMS,” Applied Information System and Management (AISM), vol. 4, no. 2, pp. 101–105, Oct. 2021, doi: 10.15408/aism.v4i2.18369.
K. P. Bhattarai, K. Visai, R. Ito, K. Sato, and B. P. Gautam, “Monitoring of e-learning system servers using the MariaDB galera cluster,” in Proceedings - 2019 International Conference on Networking and Network Applications, NaNA 2019, 2019. doi: 10.1109/NaNA.2019.00058.
R. Shrestha, “High availability & performance of database in the cloud: Traditional master-slave replication versus modern cluster-based solutions,” in CLOSER 2017 - Proceedings of the 7th International Conference on Cloud Computing and Services Science, 2017. doi: 10.5220/0006294604130420.
T. Pohanka and V. Pechanec, “Evaluation of replication mechanisms on selected database systems,” ISPRS Int J Geoinf, vol. 9, no. 4, Apr. 2020, doi: 10.3390/ijgi9040249.
S. Widiono, “Experiments and descriptive analysis in the mariadb database cluster system to prepare data availability,” 2019. [Online]. Available: www.codepolitan.com.
G. Slavko and S. Serhiienko, “Optimization of LMS moodle configuration and education technologies on the example of electrical engineering education,” in 2021 IEEE International Conference on Modern Electrical and Energy Systems (MEES), IEEE, Sep. 2021, pp. 1–5. doi: 10.1109/MEES52427.2021.9598719.
R. Yusuf and H. Kusniyati, “The analyst model performance multi-tier for increase of efficiency virtual machine in moodle application,” International Journal of Scientific Research in Computer Science, Engineering and Information Technology, pp. 94–101, Sep. 2020, doi: 10.32628/CSEIT206473.
Z. Zdravev, A. Velinov, and S. Spasov, “Migration of moodle instance to the cloud – case study at Goce Delchev University,” in South East European Journal of Sustainable Development, A. Pollozhani, Ed., Skopje: Mother Teresa University, Feb. 2021, pp. 99–106.
A. H. da S. Marcondes, C. C. Miers, M. A. Pillon, and G. P. Koslovski, “SDN4Moodle: an SDN-based toolset to enhance qos of moodle platform,” in 2018 IEEE Symposium on Computers and Communications (ISCC), IEEE, Jun. 2018, pp. 00627–00632. doi: 10.1109/ISCC.2018.8538523.
F. Cardoso, A. Godinho, J. Rosado, F. Caldeira, and F. Sa, “Proposal of a technological cluster to support eLearning platform,” in 2022 31st Annual Conference of the European Association for Education in Electrical and Information Engineering (EAEEIE), IEEE, Jun. 2022, pp. 1–5. doi: 10.1109/EAEEIE54893.2022.9820369.
H. Triangga, I. Faisal, and I. Lubis, “Analisis perbandingan algoritma static round-robin dengan least-connection terhadap efisiensi load balancing pada load balancer haproxy,” InfoTekJar (Jurnal Nasional Informatika dan Teknologi Jaringan), vol. 4, no. 1, 2019, doi: 10.30743/infotekjar.v4i1.1688.
A. Setiawan and W. M. Kansha, “Pembuatan sistem database cluster menggunakan aplikasi galera cluster di sekolah vokasi ipb university,” Jurnal Sains Terapan, vol. 11, no. 2, 2021, doi: 10.29244/jstsv.11.2.49-59.
M. Data, 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, vol. 4, no. 1, 2017, doi: 10.25126/jtiik.201741288.
DOI: https://doi.org/10.15408/aism.v7i1.34871 Abstract - 0 PDF - 0
Refbacks
- There are currently no refbacks.
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
EDITORIAL ADDRESS:
Department of Information Systems, Faculty of Science and Technology,
Universitas Islam Negeri (UIN) Syarif Hidayatullah Jakarta
Faculty of Science and Technology Building, 3rd Floor, 1st Campus, Universitas Islam Negeri (UIN) Syarif Hidayatullah Jakarta
Jl. Ir. H. Juanda No. 95, Ciputat Timur, Kota Tangerang Selatan, Banten 15412, Indonesia.
Tlp/Fax: +622174019 25/+62217493315.
E-mail: aism.journal@apps.uinjkt.ac.id, Website: https://journal.uinjkt.ac.id/index.php/aism
Applied Information System and Management (AISM) by the Department of Information Systems, Faculty of Science and Technology, Universitas Islam Negeri (UIN) Syarif Hidayatullah Jakarta, Indonesia is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Based on a work at https://journal.uinjkt.ac.id/index.php/aism.