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...
Understanding Character Sets and Collations in MySQL
If you have ever worked with MySQL, you inevitably came across character sets and collations. In this blog post, we will try to give you a more in-depth look at what those two are and...
Boosting Performance by Using Read Write Splitting of Database Traffic with Moodle 3.9
Moodle is a very well known Learning Management System which is intended to help educational organizations organize their online learning activities. As you can imagine, given the online shift in 2020 caused by the COVID-19,...