FAQ: How do I synchronise more than one copy of RadioDJ to the same database?
Its not particularly hard to do.
The way we do it for our different machines running RadioDJ is we now have a centralised database on the local network on a Linux box (MariaDB) and allow the machines to connect to that.
“A Windows install will work just as well, Once you’ve configured the firewall to allow connections on port 3306”
We don’t recommend doing this using a “root” account on your MySQL server though.
You can find out how to create a new SQL user Here
We connect to the MySQL server using the database setup tool and point to the machine running MariaDB (e.g: 192.168.0.10)
You can find the local IP of the machine by logging into your router admin.
Then we make sure the songs have the same paths on every machine running RadioDJ (e.g: C:\Music)
We took a database back up from one machine and restored that backup on all machines so the songs/categories/events were synced etc…
You can have as many copies of RadioDJ synced to same database that you want, although our advice would be DON’T go playing songs on any other instances while you’re already running one copy of RadioDJ using that DB.
If you require more than 1 copy of RadioDJ to be online at one time create a separate database for those instances.
I hope people find this post easy to understand, It is as easy as it looks to network different copies of RadioDJ to one database.
P.S: Please don’t try this with a remote SQL server, if the connection drops it will crash RadioDJ so its best to keep it on the local network.