Running A Database Needn’t Be Scary!

I’ve just joined a “radio station automation” group on Facebook, Don’t normally bother with groups on FB but this one was recommended to me.

I saw this post on there last week:

“I’m Looking for a simple piece of software that has a live assist feature without the hassle of SQL and databases”

 
What are you scared of? Running a database/MySQL server need not be scary…

Read the full article

RadioDJ Database Maintenance

So you’ve successfully installed and configured the RadioDJ database.

Click to enlarge

Now you have it installed its a good idea if once in a while you do some basic maintenance to ensure optimum operation.

Read the full article

Last updated on: July 19th, 2017
at 17:23 PM Europe/London

MariaDB 3 Years And Counting

Just been looking back on various posts on my Facebook page from around this time 3 years ago.

I realised it was around June 2014 when we were first made aware of MariaDB an alternative to Oracle MySQL

Since that first install 3 years ago things have ran smoothly. We’ve not had to rebuild the RadioDJ database from scratch once.

Read the full article

Last updated on: July 31st, 2017
at 21:32 PM Europe/London

Creating A New SQL User

In case you haven’t already noticed, SQL tends to allow some pretty insecure permissions by default, allowing root access from any computer.

This is a big problem, especially if you have port forwarding configured on your router to your SQL instance.

However, you can easily create new users using any management interface, so we’ll do it with HeidiSQL

Read the full article

Last updated on: May 17th, 2017
at 13:21 PM Europe/London

What Database Issues?

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.

In the last 36 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.

Read the full article

Last updated on: July 31st, 2017
at 15:35 PM Europe/London

Translate ยป