MySQL 8 vs MariaDB - Important!!!

[RadioDAVE.US]

Add my name to the people who switched from MySQL to MariaDB. MariaDB is much faster in my environment. I'm running Windows 10 Professional, 16GB RAM, i5 (six cores), on SSD. Note that the same machine is also hosting StereoTool audio processing, which eats a ton of CPU time. The music library includes 5,226 entries.

I have written a custom playlist generator (Clocklist) that runs every 30 minutes to build a clock-pattern playlist for the following half-hour. Clocklist is written in C# and the performance is highly dependent upon the database querys' performance.

After switching from MySQL to MariaDB, the Clocklist playlist generation time dropped from 650ms to 150ms. 150ms includes the I/O for file creation and program execution. Individual database queries often take 7ms to 12ms.

While the previous execution of 650ms is an acceptable time for playlist generation, the drop to 150ms is a good metric for examining the performance of the infrastructure. The only change was the database engine for this dramatic change in system performance.

I continue to use MySQL Workbench to analyze the data.

[bobhill]

I'll tell you what, my searches were getting excruciatingly slow with 7000 database entries plus. (beautiful music format) Today the database wouldn't load anything  new and I went and changed the my.ini file in  programdata\mysql\mysql server8.0   to put max_allowed_packet up a bunch to 40M  and suddenly not only did my backup database load instead of error out with max_allowed_packet error, but my searches also became breezy as the wind.   

Just throwing that out there!  I mean instantaneous......Not kidding.

[jeffm]

Hi all, so how DOES one switch from MySQL to MariaDB?  Jhonny's tutorial on page 1 seems to be gone now and everything I've looked at online seems to contradict each other (uninstall MySQL vs doing some "mysqldump" which I have no clue about.

Thanks in advance.

[Jhonny]

https://www.radiodj.info/howto/migratie.php   

[jeffm]

https://www.radiodj.info/howto/migratie.php   

Thanks!!!!  Will give it a go!

[Derek]

Updated link (2022) for Jhonny's info. Thanks to Jhonny and the new info site host :-)

https://radiodj.site/howto/migratie.php

*** Please note this post from Marius regarding Beta 2.0.3.4 (not sure if later versions still need this) ***

https://www.radiodj.ro/community/index.php?topic=15858.0

[jbakel]

i have a question and i already ask it in the dutch forum.
we are swtiched to maria DB with a new computers, now i have the problem that i cannot connect to the host computer with studio 2, hou can i make it work,

[marclr17]

Hi,

In 2023, is still MariaDB a better choice than MySQL for Radio DJ ?
Thank you,

Marc - France

[RadioDJ2022]

DJ Garybaldy is telling people not to use Mysql server 8 as its buggy If it works for you then thats great just there are users struggling with radiodj and mysql

[marclr17]

thank you Dave 

[starlite]

Hi there..

Wanting to change to MariaDB for RDJv2 0.45

Not sure why I went back to mySQL after all these years of MDB with latest RDJv2 install. doh !!
 
Win 10 Home 22H2
15/2/23 
19045.4561 
Win Feature Pack 1000.19060.1000.0

Is this still the way?
https://radiodj.site/howto/migratie.php

EDIT:

Did this and it works fine with Mariadb 10.11 but fails with newer 11.42   Have reported the 'bug' if that is what it is !

[Chuck.Christie]

This is very interesting to me. I have Windows 10 (strike one), MySQL ver 9 (strike two), and RadioDJ v2.0.4.5

Here is what has happened recently: AutoDJ loads the first batch slowly, the track start times begin to disappear, then they lag the clock by a few minutes, and the playlist stops. I can clear the playlist, and it will reload, sometimes with the start times and sometimes without. When I shut down RadioDJ and restarted it, everything worked, and the process slowly repeated.

Is this an MYSQL issue that may be resolved with a MariaDB conversion? If so, which version?

Thanks for your insights and help!

Chuck