Belgian University Uses ClusterControl to Keep Moodle Databases Running Smoothly

Deployment, Management & Scaling for the Moodle LMS Database
Industry
Education
Location
Belgium
Data Center
3
AP Hogeschool Antwerpen (AP University of Applied Sciences and Arts Antwerp) is a non-profit public higher-education institution located in the urban setting of the large city of Antwerp.
Challenge
Digital learning has long been part of the ethos of AP Hogeschool Antwerpen, but when it started hosting its electronic learning platform (Moodle) on its own servers after being part of the Blackboard-network of the University of Antwerp for years, the need for more professional tools grew.
Solution
ClusterControl allowed the team to quickly and easily deploy pre-configured, highly available MariaDB databases; removing the need for manual scripts and specialized database knowledge. This improved performance and increased productivity.

Why Severalnines

The team also took advantage of the deployment and database monitoring functions, especially the query monitoring which provided insight that the team had not had before. The Moodle database has about 200 tables, but Moodle plugins come with their own schemas and not all of them are properly indexed or optimized - as the IT team would find out. Thanks to the query monitor, the developers could identify the slow queries and get tips on how to get them to run faster - for instance, adding a missing index to a table.
“At some point, a mistake was made by us, making the database corrupt, but thanks to ClusterControl, fixing it was a lot easier than what it would have been without it.”
Systems Operator, AP Hogeschool Antwerpen