How to Deploy the Chamilo MySQL Database for High Availability
Chamilo is, just like Open edX or Moodle, a platform that allows educational institutions to transfer their educational activities to the internet. Given that the majority of the educational activity has moved online in the...
How to Automatically Manage Failover of the MySQL Database for Moodle
In our previous blogs, we made justification for why you need a database failover and have explained how a failover mechanism works. I’m sharing this in case you have questions on why you should set...
How to Benchmark Performance of Moodle
Moodle, the world's most popular learning management system (LMS), is commonly being deployed in a rapidly growing and large scale environment. Fortunately, Moodle is built with availability and scalability in mind, with lots of tools,...
How to Setup Automatic Failover for the Moodle MySQL Database
In a previous blog, we had discussed how to migrate a standalone Moodle setup to scalable setup based on a clustered database. The next step you will need to think about is the failover mechanism...
How to Backup Your Moodle MySQL Database
Data is an essential part of running a Moodle environment. Should the IT operations team lose data accidentally, then it could lead to a huge loss. So, to protect valuable information, sysadmins need to back...
Working With MyISAM in MySQL
MyISAM is one of the most popular storage engines in MySQL. MyISAM frequently is the second choice after InnoDB - in this blog post we will try to find out how best to work with...
Tips for Monitoring MySQL for Moodle
Database monitoring is a critical part of any application’s maintenance. Finding database issues on time can help the application remain healthy and accessible. Without monitoring in place, database outages can be prolonged, resulting in increased...
Hot, Warm and Cold Backups in MySQL
When dealing with backups in MySQL, you have probably heard the terms “hot backup”, “warm backup” and “cold backup”. In this blog post we will try to figure out the similarities and differences between them....
How to Deploy the Open edX MySQL Database for High Availability
Open edX is a platform for online educational activities. Given the situation the world is in, all such platforms are encountering higher loads and their importance has significantly increased. Those are not just the “helper”...
How to Migrate Standalone Moodle to a Clustered Database Scalable Setup
Online Learning nowadays is quickly gaining traction since the COVID-19 pandemic happened. Most of the educational institutions are having to set up platforms for online learning, and pretty much all students are having to access...
Testing Your MySQL Database Backups
Backup testing should be a part of any backup strategy. The testing of your backups allows you to see how long it takes to get the data derived from database backups up and running again....
Which Moodle Database Should You Use?
The open source, eLearning LMS Moodle has recently been getting a lot of attention due to the COVID-19 Pandemic. The strain on the resources as educators move their students to eLearning platforms has caused many...