ADVANTAGE OF INSTALLING MOODLE LEARNING MANAGEMENT SYSTEM UNDER IIS/MARIADB OVER APACHE/MYSQL

Irina Poghosyan

doi:10.24234/miopap.v11i2.49

Authors

Irina Poghosyan French University in Armenia https://orcid.org/0009-0004-6833-512X

DOI:

https://doi.org/10.24234/miopap.v11i2.49

Keywords:

Moodle, Learning Management System (LMS), MySQL, MariaDB, Apache, Internet Information Services (IIS), Cybersecurity, Galera Cluster, Database Performance, Educational Technology Infrastructure

Abstract

This article examines the advantages and disadvantages of installing Moodle's popular learning management system using MySQL, MariaDB, Apache, and Internet Information Services. It considers the impact of these choices on performance, database server speed, and cyber security, which is critical for dealing with many users and students whose numbers have increased dramatically since the onset of the global pandemic caused by the SARS-CoV-2 virus. It has been determined that IIS/MariaDB represents the optimal configuration for Windows-based systems, while Apache/MySQL is optimal for Linux distributions. The selection of specific solutions should be based on the particular needs of the educational institution in question, the available infrastructure, and the financial capabilities of the institution in question. MariaDB's functionality is enhanced by including the Galera Cluster, which offers a higher throughput than MySQL's. Both IIS and Apache have some advantages and disadvantages. The decision to use one or the other is made based on the choice of operating system.

References

Cardoso, F., Godinho, A., Rosado, J., Caldeira, F., & Sa, F. (2022). Proposal of a technological cluster to support eLearning platform. 2022 31st Annual Conference of the European Association for Education in Electrical and Information Engineering (EAEEIE), 1–5. https://doi.org/10.1109/EAEEIE54893.2022.9820369 DOI: https://doi.org/10.1109/EAEEIE54893.2022.9820369

Friedenbach, P. (2022, March 17). Benchmark: MariaDB vs MySQL on commodity cloud hardware. MariaDB. Retrieved April 4, 2024, from https://mariadb.com/resources/blog/benchmark-mariadb-vs-mysql-on-commodity-cloud-hardware/

Internet Information Services - MoodleDocs. (n.d.). Retrieved April 4, 2024, from https://docs.moodle.org/25/en/Internet_Information_Services

Ksiazek, K. (2022, May 4). Building a highly available database for Moodle using MariaDB (Replication & MariaDB Cluster). SeveralNines. Retrieved April 4, 2024, from https://severalnines.com/blog/building-highly-available-database-moodle-using-mariadb-replication-mariadb-cluster/

Leanserver. (2023, July 19). Интеграция ASP.NET со службами IIS 7. Microsoft Learn. Retrieved April 4, 2024, from https://learn.microsoft.com/ru-ru/iis/application-frameworks/building-and-running-aspnet-applications/aspnet-integration-with-iis

Marcondes, A. H. da S., Miers, C. C., Pillon, M. A., & Koslovski, G. P. (2018). SDN4Moodle: An SDN-based toolset to enhance QoS of Moodle platform. In 2018 IEEE Symposium on Computers and Communications (ISCC) (pp. 00627–00632). IEEE. https://doi.org/10.1109/ISCC.2018.8538523 DOI: https://doi.org/10.1109/ISCC.2018.8538523

MariaDB - MoodleDocs. (n.d.). Retrieved April 4, 2024, from https://docs.moodle.org/403/en/MariaDB

Moodle in English: IIS vs Apache for Moodle. (2015, July 24). Moodle.org. Retrieved April 4, 2024, from https://moodle.org/mod/forum/discuss.php?d=317278

MySQL: MySQL 8.4 Reference Manual: Alternative Storage Engines. (n.d.). Retrieved April 4, 2024, from https://dev.mysql.com/doc/refman/8.4/en/storage-engines.html

Prakasa, J., Hanani, A., Hariri, F., & Utama, S. (2024). Improving Moodle performance using HAProxy and MariaDB Galera Cluster. Applied Information System and Management (AISM), 7, 29–36. https://doi.org/10.15408/aism.v7i1.34871 DOI: https://doi.org/10.15408/aism.v7i1.34871

Raetsky, D., Ulyanin, S. A., & Ermakova, L. A. (2016). Development of the Portolo SibGU platform for system learning management "Moodle." Cybernetics and Programming, 2(2), 52–61. https://doi.org/10.7256/2306-4196.2016.2.18016 DOI: https://doi.org/10.7256/2306-4196.2016.2.18016

Slavko, G., & Serhiienko, S. (2021). Optimisation 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) (pp. 1–5). IEEE. https://doi.org/10.1109/MEES52427.2021.9598719 DOI: https://doi.org/10.1109/MEES52427.2021.9598719

Storage engines. (n.d.). MariaDB KnowledgeBase. Retrieved April 4, 2024, from https://mariadb.com/kb/en/storage-engines/

Triangga, H., Faisal, I., & Lubis, I. (2019). Analisis perbandingan algoritma static round-robin dengan least-connection terhadap efisiensi load balancing pada load balancer haproxy. InfoTekJar (Jurnal Nasional Informatika dan Teknologi Jaringan), 4(1). https://doi.org/10.30743/infotekjar.v4i1.1688 DOI: https://doi.org/10.30743/infotekjar.v4i1.1688

Wikipedia contributors. (2024, July 29). Apache HTTP Server. Wikipedia. Retrieved April 4, 2024, from https://en.wikipedia.org/wiki/Apache_HTTP_Server

XMLDB defining an XML structure - MoodleDocs. (n.d.). Retrieved April 4, 2024, from https://docs.moodle.org/dev/XMLDB_defining_an_XML_structure#The_XMLDB_editor

Yusuf, R., & Kusniyati, H. (2020). 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, 94–101. https://doi.org/10.32628/CSEIT206473 DOI: https://doi.org/10.32628/CSEIT206473

Zdravev, Z., Velinov, A., & Spasov, S. (2021). 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 (pp. 99–106).