RadioDJ - Free Radio Automation Software Forum

Maria DB

Offline DJ Garybaldy

  • *****
  • 4281
  • Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Maria DB
« on: June 26, 2014, 10:12:27 AM »
I'm just about to  try Maria DB for testing with. 

Question for those of you who use it. What should I look out for as a first time user? & Is it difficult to setup?

I'm always up for trying new things just need to know of any pitfalls before I try. :bash:
Retired DJ & Proud USER of RadioDJ since 2010

https://djgarybaldy.blogspot.com/
https://djgarybaldy.blogspot.com/2020/08/radiodj-frequently-asked-questions-faq.html

Database repair: https://tinyurl.com/dbrepairradiodj

https://djgarybaldy.blogspot.com/p/about-me.html

Offline DJ Garybaldy

  • *****
  • 4281
  • Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Re: Maria DB
« Reply #1 on: June 26, 2014, 11:31:55 AM »
Wow that was painless and a lot less hassle than setting up MySQL

May be an idea for users who aren't up to speed with the whole rigmarole of setting MySQL up!

https://downloads.mariadb.org/mariadb

I had it running within minutes.
« Last Edit: September 10, 2016, 06:48:35 PM by DJ Garybaldy »
Retired DJ & Proud USER of RadioDJ since 2010

https://djgarybaldy.blogspot.com/
https://djgarybaldy.blogspot.com/2020/08/radiodj-frequently-asked-questions-faq.html

Database repair: https://tinyurl.com/dbrepairradiodj

https://djgarybaldy.blogspot.com/p/about-me.html

Offline DJ Garybaldy

  • *****
  • 4281
  • Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Re: Maria DB
« Reply #2 on: June 26, 2014, 12:58:14 PM »
Just done a Tutorial on setting up Maria DB here are some basic instructions.

It should be fairly easy even if your not used to a SQL server.

N.B: If you have previously had MySQL installed you will need to see this article about removing it as a service.

http://superuser.com/questions/452262/how-to-remove-mysql-service-from-windows

If you haven't had MySQL installed before just follow these steps.

1) Download the Maria DB MSI installer for your version of Windows

2) Click Install and run when Windows prompts.

3) On the licence agreement screen check the accept box. Click next.

4) On the next screen will be the components you need to install don’t change anything here just click next.

5) You should now have a screen that says “Modify password for database user root”. Enter your desired password.

Tip: Write this password down you will need it later in RadioDJ.

5a) Only check the “Enable access from remote machines” box if you need it later for stuff like website requests and now playing info. Click next.

6) On the next screen keep the default settings apart from the buffer size change that to something like 255MB. Click next.

7) You should then see a tick box “Enable feedback plugin” I didn’t bother enabling it. Just click next if you don’t want to send feedback.

You should now have a a screen that says Install. Click install.

If all goes to plan the Maria DB SQL server should be installed. Once you have verified that MySQL is running as a service then you can install the RadioDJ Database.

Hope this helps someone.
« Last Edit: July 27, 2020, 04:10:21 PM by DJ Garybaldy »
Retired DJ & Proud USER of RadioDJ since 2010

https://djgarybaldy.blogspot.com/
https://djgarybaldy.blogspot.com/2020/08/radiodj-frequently-asked-questions-faq.html

Database repair: https://tinyurl.com/dbrepairradiodj

https://djgarybaldy.blogspot.com/p/about-me.html

starlite

Re: Maria DB
« Reply #3 on: June 26, 2014, 03:15:21 PM »
If I cannot resolve my mySQL problem is this an option? 
Does it use the same 3306 ports etc. and does one use the RDJ Database program?

If so, I may try it even temporarily to see if it works with the Demo Script.

Offline SnowHow

  • *****
  • 911
  • A-1 Radio - The Variety Channel
    • A-1 Radio - The Variety Channel
Re: Maria DB
« Reply #4 on: June 26, 2014, 03:22:23 PM »
I'm trying it out also. I installed it on my testing computer and all my websites and RDJ work perfectly fine. Setup was a breeze. I especially like that HeidiSQL is bundled with it. :)


J-


Offline DJ Garybaldy

  • *****
  • 4281
  • Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Re: Maria DB
« Reply #5 on: June 26, 2014, 03:28:49 PM »
I'm trying it out also. I installed it on my testing computer and all my websites and RDJ work perfectly fine. Setup was a breeze. I especially like that HeidiSQL is bundled with it. :)


J-

I've yet to delve into HeidiSQL that being said I wonder if my current DB editing tool will connect to it...... :bash: Oh well here goes....

If I cannot resolve my mySQL problem is this an option? 
Does it use the same 3306 ports etc. and does one use the RDJ Database program?

If so, I may try it even temporarily to see if it works with the Demo Script.


It's certainly worth a try. Just make sure MySQL is uninstalled first (that's after making a backup of your current RDJ database) so you can just update the new database from the backup.

Retired DJ & Proud USER of RadioDJ since 2010

https://djgarybaldy.blogspot.com/
https://djgarybaldy.blogspot.com/2020/08/radiodj-frequently-asked-questions-faq.html

Database repair: https://tinyurl.com/dbrepairradiodj

https://djgarybaldy.blogspot.com/p/about-me.html

Offline SnowHow

  • *****
  • 911
  • A-1 Radio - The Variety Channel
    • A-1 Radio - The Variety Channel
Re: Maria DB
« Reply #6 on: June 26, 2014, 03:35:44 PM »
I've yet to delve into HeidiSQL that being said I wonder if my current DB editing tool will connect to it...... :bash: Oh well here goes....


Mine did. Dreamcoder 5.3 and MySQL Administrator both work. I could backup/restore with M.A. and edit with Dreamcoder. Your tools should work also.

J-


Re: Maria DB
« Reply #7 on: June 26, 2014, 06:06:57 PM »
So cool to hear!  I've grown weary of MySQL since it fell into the shackles of Oracle.

Offline DJ Garybaldy

  • *****
  • 4281
  • Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Re: Maria DB
« Reply #8 on: June 26, 2014, 06:11:53 PM »
So far so good It's been up for over 6 hours today without spluttering once.

Plus my favourite SQL editor does work with it..... I'm sort of sold!

It's the simplicity part when it comes to installing it  I like it's almost idiot proof! (I said Almost  :bash:)

Got to try and see what happens on 64bit box with it yet.
Retired DJ & Proud USER of RadioDJ since 2010

https://djgarybaldy.blogspot.com/
https://djgarybaldy.blogspot.com/2020/08/radiodj-frequently-asked-questions-faq.html

Database repair: https://tinyurl.com/dbrepairradiodj

https://djgarybaldy.blogspot.com/p/about-me.html

Offline SnowHow

  • *****
  • 911
  • A-1 Radio - The Variety Channel
    • A-1 Radio - The Variety Channel
Re: Maria DB
« Reply #9 on: June 26, 2014, 07:52:06 PM »
I haven't seen any way to adjust the concurrent connections yet. I wonder if that has to be done directly in the my.ini file?


It's working great for me too. It's barely using any resources. I think we may have a winner here, but I'm not "jumping the gun" just yet. I want to watch it work for a couple days to see how it holds up.


J-


starlite

Re: Maria DB
« Reply #10 on: June 27, 2014, 08:05:48 AM »
How is it going, still up and running?

Trying mine tonight on another XP box.

When I'm finished we'll know whether it is Idiot proof  or not !  :-)

oz

Offline DJ Garybaldy

  • *****
  • 4281
  • Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Re: Maria DB
« Reply #11 on: June 27, 2014, 10:28:38 AM »
How is it going, still up and running?

Trying mine tonight on another XP box.

When I'm finished we'll know whether it is Idiot proof  or not !  :-)

oz

Oh dear your still using XP!! I'd be careful as Microsoft aren't supporting that OS anymore there won't be any security patches and your machine could be vulnerable to hackers.  :bash:

I haven't seen any way to adjust the concurrent connections yet. I wonder if that has to be done directly in the my.ini file?


It's working great for me too. It's barely using any resources. I think we may have a winner here, but I'm not "jumping the gun" just yet. I want to watch it work for a couple days to see how it holds up.


J-



I haven't looked inside the my.ini file yet I thought the "Buffer Size" setting would handle concurrent connections? Or am i wrong. need to do some more reading on this I guess.

After yesterdays success with testing. I'm now running 2 copies of RadioDJ with 2 separate databases.  So far so good......


Retired DJ & Proud USER of RadioDJ since 2010

https://djgarybaldy.blogspot.com/
https://djgarybaldy.blogspot.com/2020/08/radiodj-frequently-asked-questions-faq.html

Database repair: https://tinyurl.com/dbrepairradiodj

https://djgarybaldy.blogspot.com/p/about-me.html

Re: Maria DB
« Reply #12 on: June 27, 2014, 11:12:14 AM »
Hi Gary !

Did you see my post here ?

http://www.radiodj.ro/community/index.php?topic=5331.0

It's a fantastic tiny portable MySQL server lighter than MariaDB, and it works well with RDJ !
www.nemoradio.fr

Offline DJ Garybaldy

  • *****
  • 4281
  • Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Re: Maria DB
« Reply #13 on: June 27, 2014, 11:16:15 AM »
Hi Gary !

Did you see my post here ?

http://www.radiodj.ro/community/index.php?topic=5331.0

It's a fantastic tiny portable MySQL server lighter than MariaDB, and it works well with RDJ !

Yes I saw it not been able to test it. I'll fire the old laptop up later to test this theory as I don't have USB support enabled on virtual box.

I only setup this thread because I thought Maria DB is easier to setup than a standard MySQL server.

Anything that makes life easier for other users has got to be good.

Retired DJ & Proud USER of RadioDJ since 2010

https://djgarybaldy.blogspot.com/
https://djgarybaldy.blogspot.com/2020/08/radiodj-frequently-asked-questions-faq.html

Database repair: https://tinyurl.com/dbrepairradiodj

https://djgarybaldy.blogspot.com/p/about-me.html

Online Marius

  • *****
  • 5664
    • Radio DJ
Re: Maria DB
« Reply #14 on: June 27, 2014, 11:21:24 AM »
Switched one of my testing instances to MariaDB 10.
As they write in the documentation, the memory usage is higher than MySQL (about 100MB) on my system, which is really not a problem on today systems if it brings some performance on other fronts.

However, the good things seem to happen to the processor usage (Data collected from Resource Monitor with only the mysqld.exe service selected):

- On track change: 0.02
- On track search: 0.01

One after another, easy to install, perfect compatible from the RadioDJ point of view, performance seem to be higher at a first sight.
I will also test it more and share my thoughts.
DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.