MySQL and Moodle
What is MySQL?
What is MySQL?
MySQL is an open-source relational database management system (RDBMS). Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter, and “SQL”, the abbreviation for Structured Query Language.
How good is MySQL? Well, it powers Facebook, Google, Twitter, Uber, PayPal, Netflix, and YouTube to name just a few – so it’s definitely up to the job of powering Moodle 😉
History
MySQL is free and open-source software under the terms of the GNU General Public License, and is also available under a variety of proprietary licenses (mainly for large enterprises).
MySQL was owned and sponsored by the Swedish company MySQL AB, which was bought by Sun Microsystems (now Oracle Corporation).
In 2010, when Oracle acquired Sun, Michael Widenius forked the open-source MySQL project to create MariaDB.
This was because of concerns that Oracle (a big database company already) might restrict the development of MySQL, at least at the larger scale, or even the open source community version, as it could compete with the existing Oracle product line.
We haven’t really seen this, but many people are now looking to MariaDB as the preferred option for Moodle.
That said, the new version of MySQL, MySQL 8.0, is up to twice as fast as the previous version – which is a huge performance increase.
- H5P periodic table – 8th September 2023
- Moodle 4.0 – 15th May 2022
- Moodle 4.0 other highlights – 14th May 2022