I asked my partner to find out when we actually installed MariaDB on our PC that we run RadioDJ from.
We’ve had MariaDB installed on all of our machines since June 2014. Including any website servers its rare we have to do any maintenance.
Since we started using MariadB we’ve only had 1 maybe 2 issues with a database table becoming corrupted after a sudden/improper shutdown of the computer.
Which was easily fixed using HeidiSQL to repair the tables
MariaDB should install this for you on Windows
RadioDJ running alongside MariaDB hardly uses CPU or Memory.
We take a regular daily backups of our database with the RadioDJ database setup tool.
The database in RadioDJ is far more robust and tends not to go wrong unless there’s a split second power failure, a split second powercut once corrupted one of our databases bit it was easily fixed using HeidiSQL.
On the whole @MariaDB seems to work like a star.
We’d like to thank the development team at MariaDB for making such a wonderfully stable SQL server program.
What Database Issues? I wouldn’t have a stable reliable music stream without it!
RadioDJ of course has to take some of the credit.
So next time you’re looking to install a database for use with a radio automation program such as RadioDJ
Things are going rather well with MariaDB, I can’t remember the last time I had to do any maintenance on the MySQL tables. 5 years in and we wouldn’t use any other database software now we’ve discovered how amazingly reliable MariaDB is.
August 2019: We’ve now moved the RadioDJ database onto the new Raspberry PI4 and so far so good. Maria DB is running away nicely on Raspbian and we connect to that database from 1 of 2 PC’s running RadioDJ.
Why wasn’t it this simple 20 years ago when I first got the bug for Internet radio? I spent a lot of time fighting with Oracle MySQL server.
MariaDB is the MySQL database solution EVERYONE should be using!
Last updated on: 13th August 2019
at 14:12 PM Europe/London