So you’ve successfully installed and configured the RadioDJ database.
Now you have it installed its a good idea if once in a while you do some basic maintenance to ensure optimum operation.
I asked my partner to find out when we actually installed MariaDB on our PC that we run RadioDJ from.
Turns out we’ve had MariaDB installed since June 2014.
Yesterday we upgraded it to the latest version. Which went smoothly after we’d remembered to shut mysqld.exe down as a service.
In the last 15 months that we’ve been using MariaDB we’ve only had 1 maybe 2 issues with a database table becoming corrupted after a sudden shutdown of the computer.
That was easily fixed using Heidisql to repair the tables.
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 something major happens on the PC running it.
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
@MariaDB is the database program EVERYONE should be using.
You can now automatically backup your RadioDJ database at a specified hour of the day with the database setup tool.
It’s pretty straight forward to set up.
It should automatically backup your database at the hour you set it to backup.