ElearningWorld.org

For the online learning world

Technical

MariaDB stats and Moodle

Can the MariaDB stats provide anything useful for Moodle admins?

We can find some useful background information for Moodle Administrators considering switching from MySQL to MariaDB.

These stats are all taken from https://mariadb.org, which get the statistics from user feedback.

Operating System

Well, the first thing to note is that MariaDB is much more popular on Windows than Linux. These figures have to be thought about though … there are probably a lot more small Windows server than Linux servers.

OSUploads
Darwin28
FreeBSD24
Linux6,766
OpenVMS8
Windows101,150

Linux distro

The table below shows that the distributors using MariaDB are heavily slanted towards Mageia and CentOS. This is because MariaDB is the default database engine on these. It’s not so popular with Ubuntu and Debian environments, where MySQL is well established, and this is the most common Moodle environment.

DistroUploads
lsb: Mageia 52,344
lsb: Mageia 61,767
centos: CentOS Linux release 7.5.1804 (Core) 175
os: NAME=”Red Hat Enterprise Linux Server”128
centos: CentOS Linux release 7.4.1708 (Core) 108
centos: CentOS Linux release 7.6.1810 (Core) 100
os: PRETTY_NAME=”Debian GNU/Linux 9 (stretch)”98
lsb: Ubuntu 16.04.4 LTS78
SuSE: SUSE Linux Enterprise Server 12 (x86_64)77
os: PRETTY_NAME=”Debian GNU/Linux 8 (jessie)”73
centos: CentOS Linux release 7.3.1611 (Core) 70
centos: CentOS Linux release 7.2.1511 (Core) 64
lsb: Ubuntu 16.04.5 LTS58
lsb: blackPanther OS v16.2SE (Silent Killer)58
lsb: Ubuntu 16.04.3 LTS56

Country

What about country adoption patters? Interesting that the only European country in the top 10 is German. This might relate back to the CentOS statistics above.

It’s also interesting that Russia and the USA round out the top 3, which are far in excess of other countries. Maybe Mageia is popular in Russia?

1Unknown102,669
2Russian Federation81,038
3Germany67,044
4United States of America62,222
5China4,671
6Korea1,452
7Indonesia1,012
8Mexico919
9India670
10Brazil584

So, there is nothing here that screams “Moodle Administrators, wherever you are, consider moving to MariaDB.”

Even so, there may be good reasons, and we will start to investigate those next month.

Stuart Mealor
Latest posts by Stuart Mealor (see all)

Stuart Mealor

Stuart is interested in all things e-learning, with specific interests in Moodle, e-learning strategy, and business development. His experience in education over 30 years, MBA in International Business, and knowledge of e-learning systems implementation, together with graphic design background, give him a unique skill set for e-learning projects.

Add a reply or comment...