RadioDJ - Free Radio Automation Software Forum

More or Less Radio Talk => Software and Utilities => Topic started by: DJ Garybaldy on June 26, 2014, 10:12:27 AM

Title: Maria DB
Post by: DJ Garybaldy 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:
Title: Re: Maria DB
Post by: DJ Garybaldy 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 (https://downloads.mariadb.org/mariadb)

I had it running within minutes.
Title: Re: Maria DB
Post by: DJ Garybaldy 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 (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  (https://downloads.mariadb.org/) 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.
Title: Re: Maria DB
Post by: starlite 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.
Title: Re: Maria DB
Post by: SnowHow 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-

Title: Re: Maria DB
Post by: DJ Garybaldy 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.

Title: Re: Maria DB
Post by: SnowHow 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-

Title: Re: Maria DB
Post by: packzap 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.
Title: Re: Maria DB
Post by: DJ Garybaldy 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.
Title: Re: Maria DB
Post by: SnowHow 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-

Title: Re: Maria DB
Post by: starlite 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
Title: Re: Maria DB
Post by: DJ Garybaldy 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......


Title: Re: Maria DB
Post by: nemoradio 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 (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 !
Title: Re: Maria DB
Post by: DJ Garybaldy 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 (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.

Title: Re: Maria DB
Post by: Marius 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.
Title: Re: Maria DB
Post by: Marius on June 27, 2014, 11:23:57 AM
Hi Gary !

Did you see my post here ?

http://www.radiodj.ro/community/index.php?topic=5331.0 (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 !

If the size is not a problem, MariaDB can also run as a portable application: https://mariadb.com/kb/en/portable-mariadb/
Title: Re: Maria DB
Post by: DJ Garybaldy on June 27, 2014, 11:43:31 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.

I've certainly noticed a difference in how RadioDJ runs with this DB system. It's a lot snappier and loads rotations faster.

I've got 2GB of ram to play with and all processes are only using about 700mb of that. I can cope with that i think.  :bash:
Title: Re: Maria DB
Post by: DJ Garybaldy on June 29, 2014, 10:41:55 AM
The few days of testing Maria DB have left me with only one conclusion....

I won't be switching back to Oracle MySQL anytime soon. Maria DB doesn't seem as bloated as MySQL and it seems to be holding it's own .

Events Rotations & Jingles all loading fine RadioDJ is performing like a star no splutters no freezes .....

If only setting up Shoucast v2 was this stress free!  :bash:
Title: Re: Maria DB
Post by: HMC on June 29, 2014, 01:44:45 PM
Glad to hear that it's working great. When I mentioned mariaDB the other day I didn't know there weren't many using it yet. I just started using RDJ and I used mariaDB from the start. So I only know how RDJ works using mariaDB . It works great and is fast. It hardly uses any resources in terms of ram. My server is dedicated to RDJ so nothing else runs on it. I have 16GB ram and haven't seen it use more than 1.5GB total so far for the whole system. I will have two instances of RDJ playing.

It is very easy to install using the wizard and takes just a couple of minutes. Everything you know about MySQL pretty much works the same so there isn't much new for someone to learn. Same port, my.ini, root login etc. Anyone using it will be happy they did.

I definitely will not be using Oracle MySQL either as I've moved a way from it since that is basically what the tech community is doing as well. It works great and is enhanced more than MySQL is. I can tell you know I haven't seen any issues with it yet. I come from a tech/engineer background and my sites will be using mariaDB as well going forward on new setups.  Id love to see mariaDB be the official RDJ DB at some point.
Title: Re: Maria DB
Post by: DJ Garybaldy on June 29, 2014, 02:12:01 PM
Glad to hear that it's working great. When I mentioned mariaDB the other day I didn't know there weren't many using it yet. I just started using RDJ and I used mariaDB from the start. So I only know how RDJ works using mariaDB . It works great and is fast. It hardly uses any resources in terms of ram. My server is dedicated to RDJ so nothing else runs on it. I have 16GB ram and haven't seen it use more than 1.5GB total so far for the whole system. I will have two instances of RDJ playing.

It is very easy to install using the wizard and takes just a couple of minutes. Everything you know about MySQL pretty much works the same so there isn't much new for someone to learn. Same port, my.ini, root login etc. Anyone using it will be happy they did.

I definitely will not be using Oracle MySQL either as I've moved a way from it since that is basically what the tech community is doing as well. It works great and is enhanced more than MySQL is. I can tell you know I haven't seen any issues with it yet. I come from a tech/engineer background and my sites will be using mariaDB as well going forward on new setups.  Id love to see mariaDB be the official RDJ DB at some point.

I'm running mine  on system with just 2GB of RAM and did have 2 instances running the other day quite happily playing together.

Got 5 streams running as well and everything is just sitting back relaxed and happy.

I hadn't heard of MariaDB until you mentioned it. I'm always curious when it comes to learning new stuff.... Hence why I did the tutorial on setting it up.

I find it funny how with RadioDJ I've never had a database crash and I've been using it well over 3/4 years. Yet with a certain other automation program i was re-building the database ever 2/3 weeks.... :bash:

Maria DB looks like it could be good for people using RDJ.

I'd be interested to hear how it performs with a database that has over 30,000+ songs in it.

Title: Re: Maria DB
Post by: joshuatree44 on June 29, 2014, 05:18:51 PM
I am using it as well. My PC running it and RDJ is seeming a bit more stable and faster. Thanks for this idea. It comes with cool features like HeidiSQL which is a great tool to use. I am liking this stuff that helps. Marius with the backup and updates features is making this program the best out there. But Maria took me about 2 mins to setup from install to finish. Thanks for this. Well done. Does it auto update or how does it get latest updates?
Title: Re: Maria DB
Post by: SnowHow on June 29, 2014, 05:40:56 PM
I was reading the documentation on it last night and I didn't see anything about an auto update feature. I would imagine the method is the same as MySQL.

One cool feature I found was that the concurrent connections are in a dynamic thread pool, not static. So if the needs of the server increases, it dynamically increases the allowable connections to the server to prevent bog downs. It does install with a max of 500 which can be increased in the my.ini file if needed.


J-

Title: Re: Maria DB
Post by: Jhonny on June 29, 2014, 06:49:23 PM
Well, I'm became the proud owner of a laptop
my daughter has another, and gave me this with vista and a 60GB disk.
I'm setting him so I can run rdj and mariabd.

so it will bi my laptop dancer  :hihi:   

The MariaDB MSI is working properly whit rdj, but we/I have to test it a bit more.

insofar it can be a winner and become easier to install as the mysql server and just have the HeidiSQL installed to.

And as HMC says.
Quote
Id love to see mariaDB be the official RDJ DB at some point.

There's a possibility, and the explanations become more easily from start to finish to use rdj because everyone knows what he is talking about.

But think it has to bi more tested.

I can't setup the smaller version of mariadb (mini server 11) on the laptop got errors.

Grtz. All
Title: Re: Maria DB
Post by: joshuatree44 on June 29, 2014, 07:58:37 PM
Since I installed MariaDB last night it has been running flawlessly. It is less of a resources hog. It is really nice to be seeing my machine rocking easier. I just noticed the service of MySQL56 is still in my services. I disabled it but how do I get it to go away? answer in CMD Prompt as Admin
Code: [Select]
sc delete MySQL56 and all is well again. I am sure that there still is prob some orphan files still around. I hope not.
Title: Re: Maria DB
Post by: starlite on June 30, 2014, 05:50:53 AM
Did you guys setup MariaDB OVER your MySQL or start afresh?

Title: Re: Maria DB
Post by: joshuatree44 on June 30, 2014, 06:08:03 AM
Just do what Snow says to do. they are two different programs. I used the backup feature in radiodj to backup my dbase. Then I went to services.msc in windows stopped MySQL. Then I installed Maaria and copied in the dbase and then uninstalled mysql. Bingo off to the races and faster.

Did you guys setup MariaDB OVER your MySQL or start afresh?
Title: Re: Maria DB
Post by: starlite on June 30, 2014, 06:11:04 AM
Sounds good..  Doing it now..
Title: Re: Maria DB
Post by: starlite on June 30, 2014, 08:14:18 AM
Well no blood or pain.. Very simple install for a new instance so it starts all clean.

Noticed it came with buffer at 255 which Gary suggested and that it installed in in C:\Programs on XP.
I now also have Heidi in C:\Programs and but RadioDJ17 in C:\.

Must say after taking the RadioDJ db over to the data folder in Maria, it was flawless.
Just started Radiodj and there it was !

Now have mini_server11 on Win7 machine as well. Both ez pz :-)
Title: Re: Maria DB
Post by: Vanlen on June 30, 2014, 02:26:15 PM
Well, I bit the bullet and installed the latest version of MariaDB 64 bit.   You were right DJ Gary, painless :cool:

Cheers

Title: Re: Maria DB
Post by: DJ Garybaldy on June 30, 2014, 02:32:42 PM
Well, I bit the bullet and installed the latest version of MariaDB 64 bit.   You were right DJ Gary, painless :cool:

Cheers

Welcome to the something something dark side Vanlen  :D

I'm running the 32 bit one and it's been up solidly now for over 2 days.....

Title: Re: Maria DB
Post by: joshuatree44 on June 30, 2014, 05:06:02 PM
It is just that simple to do. It is so less on my system. I looked at my task manager and it is way way down now. It is amazing that there is something that does the same work but with half the footprint.

Welcome to the something something dark side Vanlen  :D

I'm running the 32 bit one and it's been up solidly now for over 2 days.....
Title: Re: Maria DB
Post by: suffolk on June 30, 2014, 08:12:06 PM
How Strange  Maria DB fails to make new session on my pc  as did mysql  but userver did work but  to slow

ive just built a new i7 high spec i will try install on that and report back

john
Title: Re: Maria DB
Post by: joshuatree44 on June 30, 2014, 09:14:35 PM
Makes a new session? What do you mean by session? When you install it, it will start right up. Just make sure you have mysql disabled in services. It is not that hard to setup. Disabled it in services.msc and then went and installed MariahDB. It walked me through everything and setup root and everything. Then I went over to the DB manager that comes with radiodj and just imported my backup DB in. And off i went with the uninstall of MySQL. simple and easy as that. I restarted after everything and made sure everything was happy. Working like a champ now and stable as crap.


How Strange  Maria DB fails to make new session on my pc  as did mysql  but userver did work but  to slow

ive just built a new i7 high spec i will try install on that and report back

john
Title: Re: Maria DB
Post by: DJ Garybaldy on June 30, 2014, 09:26:31 PM
Quote
How Strange  Maria DB fails to make new session on my pc  as did mysql  but userver did work but  to slow

You've missed something somewhere. If you read the tutorial  it does say to remove MySQL as a service before you try and install MariaDB. Otherwise it will cause you headaches.... :bash:

http://djgarybaldy.co.uk/maria-db-radiodj/ (http://djgarybaldy.co.uk/maria-db-radiodj/)

Title: Re: Maria DB
Post by: suffolk on June 30, 2014, 09:30:52 PM
i did stop mysql  but  will take out and do it over again  thanks

john

Title: Re: Maria DB
Post by: suffolk on June 30, 2014, 09:52:58 PM
Ok i uninstalled all mysql  and userver   installed mairadb as per ins and set info  as set out 

unablke to connect to any mysql hosts

john
Title: Re: Maria DB
Post by: joshuatree44 on June 30, 2014, 10:13:45 PM
what is unable to connect. I think your still missing something some place. Gary has a good link there and setup is pretty easy. I think Your missing something somewhere. I was able to connect right away.
Title: Re: Maria DB
Post by: suffolk on June 30, 2014, 10:34:04 PM
yes i agree  so easy to do 
im trying on  a brand new server 64bit  it dont like mysql grr lol

the fun goes on

john
Title: Re: Maria DB
Post by: FL Coast on June 30, 2014, 10:45:09 PM
Ok i uninstalled all mysql  and userver   installed mairadb as per ins and set info  as set out 

unablke to connect to any mysql hosts

john

Ok John, when I installed Maria DB on my 32bit Windows 7 machine I completely uninstalled MySQL before attempting to install Maria.  When I got to the part to name the database, I opted to name it RadioDj170, and the setup accepted the change fine.  Setup completed without a hitch.  When I went to Database setup in Radio DJ, I made sure all of the information was correct including the database name was RadioDj170.  I clicked on VALIDATE and it gave me the same message. Unable to connect.  After about 15 minutes of scratching my head I thought What the Heck.  I changed the Database name from RadioDj170 to MySQL and clicked Validate and everything fired up.  Running now with no problems.  I don't know why MariaDB didn't accept the name change.

I hope this will help.   :)

Wayne

[attachment deleted by admin]
Title: Re: Maria DB
Post by: suffolk on June 30, 2014, 10:50:39 PM
Yer i understand  that  i did just try it  failed again

32bit win 7


win 7 64bit no luck on there either
Title: Re: Maria DB
Post by: joshuatree44 on June 30, 2014, 10:55:04 PM
Your name change is odd. It took mine no problem. I could help you guys with teamviewer or something. I think your missing a step some place. This is not that hard. Suffolk PM me your contact information, like Skype and the like. I can help you with what I can.
Title: Re: Maria DB
Post by: suffolk on June 30, 2014, 11:00:36 PM
Im begining to think the same but i have done this 3 times already  with no problems 
im happy for you to  have a look teamview

sorry if im off topic   on this now


as i use  external  web site for  requests i really need mysql in 

john
Title: Re: Maria DB
Post by: suffolk on June 30, 2014, 11:09:11 PM
joshuatree44 have pmd
Title: Re: Maria DB
Post by: joshuatree44 on June 30, 2014, 11:10:04 PM
do you need mysql or do you need Maria? I am willing to take a look or watch what you do in skype. Either way if you want Maria we can get you up and running. This program is very quick and painless. I would suggest if people are having issues with this and cant get it to work with the steps we have outlined here then stick with what works. Maria is not for everyone if it can not get it to work.

http://superuser.com/questions/452262/how-to-remove-mysql-service-from-windows (http://superuser.com/questions/452262/how-to-remove-mysql-service-from-windows) I think this should be listed for help as well since most times it will not delete the service. This is how you can make it go bye bye. Also I learned with helping here that if you are using a different port than 3306 make sure you note it in the database setup utility for rdj to 127.0.0.1:3309 or what ever the port number is. It is all pretty easy once you do it. I am using the alpha setup since it seems a bit faster than the 10.0 version. But to each their own. If you need help PM and I will see what I can do.
Title: Re: Maria DB
Post by: suffolk on June 30, 2014, 11:39:27 PM
Cool thanks  for help  all sorted  thankyou joshuatree44

regards john
Title: Re: Maria DB
Post by: DJ Garybaldy on July 13, 2014, 03:00:04 PM
After a few weeks of constant testing I’ve come to the conclusion that Maria DB and RadioDJ work rather well together not so much as hiccup! Everything is running flawlessly....

There is no way i'm going back to Oracle MySQL now ..... It's nice when things work! it's Less stressful!  :hihi:
Title: Re: Maria DB
Post by: starlite on July 13, 2014, 03:31:41 PM
Code: [Select]
It's nice when things work! it's Less stressful!  :hihi:
Wow isn't that the truth !!

I too have found MariaDB to be rocking along beautifully...
Title: Re: Maria DB
Post by: joshuatree44 on July 13, 2014, 04:43:36 PM
AMEN! Been running it here and no issues. Much less of a power hog. seems to respond much faster even if I am using the beta.


Code: [Select]
It's nice when things work! it's Less stressful!  :hihi:
Wow isn't that the truth !!

I too have found MariaDB to be rocking along beautifully...
Title: Re: Maria DB
Post by: SnowHow on July 13, 2014, 05:09:19 PM
Well, I haven't found anything wrong with it either. I like how it dynamically changes the concurrent connections based on demand.

I think I'll take the plunge and try it on the main server today....


J-

Title: Re: Maria DB
Post by: HMC on July 14, 2014, 01:32:23 AM
Well, I haven't found anything wrong with it either. I like how it dynamically changes the concurrent connections based on demand.

I think I'll take the plunge and try it on the main server today....


J-

Good luck. I don't foresee any issues with it. I've been running as my main DB since I first installed RDJ. I agree with DJ Gary, I won't be using Oracle MySQL again for anything. It hardy uses any resources and ram although I have plenty, its just nice to know it works well.
Title: Re: Maria DB
Post by: joshuatree44 on July 14, 2014, 03:49:28 AM
yep my streaming machine runs way better on a 3.2 Pent D (2 CPUS) 4 GB of RAM machine. It is barely above 50% at a peak.


Good luck. I don't foresee any issues with it. I've been running as my main DB since I first installed RDJ. I agree with DJ Gary, I won't be using Oracle MySQL again for anything. It hardy uses any resources and ram although I have plenty, its just nice to know it works well.
Title: Re: Maria DB
Post by: SnowHow on July 14, 2014, 04:05:54 AM
yep my streaming machine runs way better on a 3.2 Pent D (2 CPUS) 4 GB of RAM machine. It is barely above 50% at a peak.

Running at 19% down from ~30%.

Dell Optiplex 745
Core 2 Duo 2 CPU 6400@ 2.13 GHz ea.
Server 2008 SP1 64-bit
4 Gig RAM

Noticeable improvement in speed and overall performance.  :ok:

J-




Title: Re: Maria DB
Post by: Marius on July 14, 2014, 11:56:31 AM
One thing that never worked for me on Windows 7 was the service auto start on Oracle's MySQL. It's true that it didn't count too much and i never tried to fix it, but never had this problem on MariaDB.
It's a minor thing, but i also saw this thing happening when i helped users remotely and is a huge drawback because many users aren't familiar with MySQL or services.
All they know is they installed MySQL but still the program cannot connect to the database...  :bash:
Title: Re: Maria DB
Post by: DJ Garybaldy on July 14, 2014, 12:13:27 PM
One thing that never worked for me on Windows 7 was the service auto start on Oracle's MySQL. It's true that it didn't count too much and i never tried to fix it, but never had this problem on MariaDB.
It's a minor thing, but i also saw this thing happening when i helped users remotely and is a huge drawback because many users aren't familiar with MySQL or services.
All they know is they installed MySQL but still the program cannot connect to the database...  :bash:

I had exactly the same issue years ago with MySQL 3.2 on XP could never get the service to auto start. Only had one other version of Oracle MySQL do that to me and that was 4.0.24 all the 5.x.xx series of MySQL installed as a service with no issues. Although sometimes removing MySQL as a service could be rather painful.

I think Maria DB is pretty fool proof and should be the one recommended for new users.
Title: Re: Maria DB
Post by: SnowHow on July 14, 2014, 04:36:35 PM

I think Maria DB is pretty fool proof and should be the one recommended for new users.

I am inclined to agree, but I think it prudent to point out that AndyDeGroo (http://www.radiodj.ro/community/index.php?topic=5395.msg31630#msg31630) found this bug (https://mariadb.com/kb/en/mariadb/mariadb-documentation/getting-started/getting-installing-and-upgrading-mariadb/troubleshooting-installation-issues/installation-issues-with-php5/) with PHP scripts. MariaDB is slightly different than MySQL and there could be other differences we haven't found yet. I advise caution before going full sail...

J-

Title: Re: Maria DB
Post by: DJ Garybaldy on July 14, 2014, 04:41:13 PM
All the web scripts I'm using are working fine with my install of Maria DB.

I switched from the wordpress plugin to the demo script last week and Now playing and requests are working just fine.

I haven't seen any evidence of anything wrong on our servers.
Title: Re: Maria DB
Post by: SnowHow on July 14, 2014, 05:14:09 PM
All the web scripts I'm using are working fine with my install of Maria DB.

I switched from the wordpress plugin to the demo script last week and Now playing and requests are working just fine.

I haven't seen any evidence of anything wrong on our servers.

Yeah, your right. I'm just being paranoid, I suppose. It's a failing...  :hihi:

Oh what the heck, let's just go for it!  :ok:

J-

Title: Re: Maria DB
Post by: HMC on July 14, 2014, 08:33:28 PM
Yeah, your right. I'm just being paranoid, I suppose. It's a failing...  :hihi:

Oh what the heck, let's just go for it!  :ok:

J-

I also connect to mariaDB from a different web server that is Linux based running php 5.4 and haven't had any issues. I think that is a remote issue that apparently most people do not have as there aren't many comments on that issue. Also it was made 3 years ago. mariaDB is on now version 10.
Title: Re: Maria DB
Post by: AndyDeGroo on July 14, 2014, 09:54:59 PM
I am inclined to agree, but I think it prudent to point out that AndyDeGroo (http://www.radiodj.ro/community/index.php?topic=5395.msg31630#msg31630) found this bug (https://mariadb.com/kb/en/mariadb/mariadb-documentation/getting-started/getting-installing-and-upgrading-mariadb/troubleshooting-installation-issues/installation-issues-with-php5/) with PHP scripts. MariaDB is slightly different than MySQL and there could be other differences we haven't found yet. I advise caution before going full sail...

That error would appear only if PHP used mysql client library from MariaDB. That is usually not the case on Windows systems as PHP comes with it's own mysql client .dll file and doesn't use global libraries (as opposed to nix systems). As suggested by the answer (https://mariadb.com/kb/en/mariadb/mariadb-documentation/getting-started/getting-installing-and-upgrading-mariadb/troubleshooting-installation-issues/installation-issues-with-php5/), you can still "Use your original MySQL client library with the MariaDB".

I'm following this thread but still haven't tried MariaDB. I'd have to migrate a big chunk of data on my development machine. I have few databases over 1GB in size and holding 5M+ records.
Title: Re: Maria DB
Post by: FL Coast on July 19, 2014, 09:55:15 PM
I have been using Maria DB on my test machine for about 3 weeks now.  Everything has been clicking along very well.  It does seem to change tracks and make transitions faster and smother.  I have been keeping the test machine sync’d with the production machine.  I will copy the Database Backup from the production machine to the test unit and import it into the Maria DB.  This has been going well in keeping newly imported jingles, commercials and songs playable on the test unit.  I was just before biting the bullet and making Maria DB part of the production unit.

As I was about to make it so… then decided I would export the Maria Database and the try to reimport it.  The import got about ¾ of the way and stopped.   I canceled the operation and started all over again with the same results.  So I exported the current database again and tried to reimport it.  Once again, the same results.  I exported a new backup of the production machines database (MySQL), moved it to the test unit, and imported it without any issues.  Everything operated properly.  I then exported the test units database again and tried to import it back (where it came from) into the Maria DB with it importing to about the ¾ mark and stopping.   :angry:

Has anyone else tried to import a backup database that was generated by Maria?  I am running RadioDJ 1.7.0 (and yes both databases have been updated) on both machines.  Production machine is Windows 7 – 64, the test unit is Windows 7 – 32.  Am I the only one having this issue?   :bash:
Title: Re: Maria DB
Post by: HMC on July 19, 2014, 11:51:21 PM
Has anyone else tried to import a backup database that was generated by Maria?  I am running RadioDJ 1.7.0 (and yes both databases have been updated) on both machines.  Production machine is Windows 7 – 64, the test unit is Windows 7 – 32.  Am I the only one having this issue?   :bash:

I have and didn't have any problems. I made a backup and then screwed up one of my tables by deleting the procedure. Oops.. Anyway, I Truncated the DB and reimported the backup no issues.
Title: Re: Maria DB
Post by: Vanlen on July 20, 2014, 12:53:58 AM
Quote
Has anyone else tried to import a backup database that was generated by Maria?
I just did to see how it went and yikes!  I had the same problem :huh:
It gets part way to restore then stalls and errors with

Quote
Restore process was interrupted by an exception.
Import ErrorMySq.Data.MySqlClient.MysqlException:
Unknow column "0x" in 'Field List" at MySql.Data.MySqlClient.MySqlBackup.ImportS

Couldn't get the rest of the info off the screen.  I exited the backup and everything is running but not restoring could be a BIG problem here.

I'm on Win 7 - 64

Cheers
Title: Re: Maria DB
Post by: FL Coast on July 20, 2014, 01:17:26 AM
Yes Vanlen, my exact problem.  Since it is my test machine, I will rebuild with a fresh start of Maria DB to see if I can figure out where the problem is.  Beyond that, looks like I will be sticking with MySQL on the production machine.  The strange thing is it would restore the backup database from my production machine that is still MySQL.   ???
Title: Re: Maria DB
Post by: HMC on July 20, 2014, 05:10:13 AM
Did you check any logs to see what is causing it to hang or if it's a an error in the file? I can't imagine this being a big issue in a since that makes mariaDB unstable. mariaDB is pretty huge. It's already the default database on Linux Redhat EL 7 and CentOS 7. If you know anything about Linux you know that's a big thing for businesses.

http://www.zdnet.com/red-hat-enterprise-linux-7-beta-arrives-with-mariadb-as-its-default-database-7000024194/ (http://www.zdnet.com/red-hat-enterprise-linux-7-beta-arrives-with-mariadb-as-its-default-database-7000024194/)

So I'm not really trying to make excuses here but there is something weird here. I'm going to test it again on my pc but my main prod machine didn't have that problem when I restored. I backed up to a sql file actually using HeidiSQL and restored it. I didn't use RDJ's backup utility. I'll try it with that and see if I get the same problem.

I've been running mariaDB since the first day I installed RDJ because I knew mariaDB is a replacement for MySQL so i automatically downloaded that first. I haven't seen an issue yet and it also runs 24/7.  I'll do some exports and test.
Title: Re: Maria DB
Post by: DJ Garybaldy on July 20, 2014, 09:11:47 AM
Quote
Has anyone else tried to import a backup database that was generated by Maria?

Yes - I just did a manual backup and restored it with no issues. Is Maria DB running with all the correct permissions?

Title: Re: Maria DB
Post by: Marius on July 20, 2014, 12:11:55 PM
Just tested to backup and then restore and no problems found at this end.
Title: Re: Maria DB
Post by: AndyDeGroo on July 20, 2014, 05:07:09 PM
I too have finally migrated my data to MariaDB and the best part was that mysql_upgrade_wizard.exe did everything for me apart from one issue with one skip-federated switch in my.ini which made upgrade service terminate on startup.

I also tested backup using Database Setup and resulting file didn't contain any strange column names. I could not reproduce this behaviour.

@Vanlen You can open the backup file in text editor and find the culprit by searching for "0x". It should be easy to correct using search and replace if the errors are not all over the file. Actually, I'd like to take a look at the file and Marius could also see if it is an issue in Database Setup.exe. Could someone having this issue place the backup online and post the link here?
Title: Re: Maria DB
Post by: nchuijg on July 20, 2014, 05:37:54 PM
I run MariaDB for a week, the change was not a problem, everthing goes wel, but there were frequinly heart audio effects not coused by loss of CPU power, now i am back to MySQL no problems at all.
RadioDJ 1.6.5.7 run on Del Optiplex 760 with Pentium Dual Core E5200 2.5 GHz with 2 GB memory Win 7 32 bit

Greetings Nico.
Title: Re: Maria DB
Post by: Vanlen on July 20, 2014, 07:24:15 PM
Thanks Andy for your offer.  But it turns out I'm a complete Idiot. :bash: I was loading up a backup from a 32 bit instance of my other system which was MySQL based and the proper backup from my MariaDB Test box (WIn 7 64) bit version version of MariaDB worked as it should and restored as it should.  So to clarify.  MariaDB is back to working like a charm.  Now I'll just run and stick my head in the sand for the rest of the day. :hihi:

Cheers
Title: Re: Maria DB
Post by: AndyDeGroo on July 20, 2014, 08:17:12 PM
I was loading up a backup from a 32 bit instance of my other system which was MySQL based and the proper backup from my MariaDB Test box (WIn 7 64) bit version version of MariaDB worked as it should and restored as it should.
There shouldn't be any difference between .sql files generated on 32 or 64bit systems. That could happen only if you were restoring MySQL data directory from 64 to 32 bit system and not the other way.
Are we talking about the same method of backup? I meant backup using .sql file generated by Database Setup.exe or mysqldump. I'd still like to take a look at the file if it is possible.
Title: Re: Maria DB
Post by: FL Coast on July 20, 2014, 11:07:18 PM
I think my problem may go back to when I first installed MariaDB.  (See my previous post)  «Reply #38 on: June 30, 2014, 04:45:09 PM
 
After playing around with MariaDB for a while trying to discover why it would not import a database it generated, just for my personal curiosity, I deleted MariDB and made a new install with the latest version.  This time it accepted my naming of the database and I was able to access it in RadioDJ.  I imported the database from my 64 bit machine and everything was off and running.  I did a backup of that machines database and re-imported it on the same machine and it worked.  I moved the db backup to my 64 bit machine and imported it with no problems.

So I will continue to test MariaDB a few more weeks before I decide to take the plunge and install it on my production machine.

Thanks for everyone’s commits.
Title: Re: Maria DB
Post by: Vanlen on July 21, 2014, 12:20:58 AM
@AndyDeGroo

Okay, here is a drop box link with the dump incase Marius wants a boo at it too.  I used the Backup/Restore from DBSetup up  1.7.1 Release

https://www.dropbox.com/s/07fivdyzgwcm6wu/20140719%20194530.sql (https://www.dropbox.com/s/07fivdyzgwcm6wu/20140719%20194530.sql)
Title: Re: Maria DB
Post by: AndyDeGroo on July 21, 2014, 01:08:41 AM
You have backup of not only RadioDJ database, but MySQL internal schema tables. I don't know how you got them.
You would have unneeded tables in your RDJ database after restoring thins file as the file contains table create statements without database name.

Oh, I see now. You are using internal mysql schema for storing RDJ data. You should have created new database before running Database Setup. Otherwise you are in for rough ride when restoring RDJ data. Not only that, but also the backup file is much larger than it should be because it contains MySQL users, table structures, help reference and a lot more than you need.

I'll clean up the mess and try to restore on a test database to see if it stops somewhere.

Update: Removed all mysql tables and data from the file and restore went well. Your problem was caused by trying to restore to mysql database, which changes with each MySQL version and certainly in MariaDB. Please create new database and then I could assist you with the backup file.
Here is the clean file: 20140719 194530-RDJ-only.sql (https://dl.dropboxusercontent.com/u/9294655/20140719%20194530-RDJ-only.sql). Note that it is at least half the size of the original.

Note to Marius: Add Database Setup option to create new table for RDJ.
Title: Re: Maria DB
Post by: Vanlen on July 21, 2014, 02:38:16 PM
Wow, thanks for your help Andy and sleuth work.   I restored with the fixed backup and bam instant restore!.  But I'll follow your directions and do a fresh MariaDB database and take it from there. When everyone was raving about MariaDB I did a MySQL Backup then uninstalled MySQL and thought I had created a new Database and did a restore which worked but then after a while tried the restore and no go with the backup I posted which now I see why it would hang with all the extra baggage in it you found. LOL.   Since MariaDB is used only on a test box I'll start with it from scratch and try again.

Cheers and thanks

Title: Re: Maria DB
Post by: Vanlen on July 23, 2014, 01:13:04 AM
Okay, I created a new DB from scratch with MariaDB and the backup file that Andy created loaded without any issues.   Runnning solid.   I don't know how the MySQL extra tables and data was in there but was from a back up of MySQL BEFORE deleting MYSQL from my system and installed MariaDB 64 bit from scratchand loaded the RESTORE file that was fixed by Andy DeGroo and all is well.   I'm wondering if backing up with MySQL is a good idea and for those starting out with MariaDB should start from scratch.   Seems to me the way to go.


Cheers

Title: Re: Maria DB
Post by: AndyDeGroo on July 23, 2014, 01:42:37 AM
I'm wondering if backing up with MySQL is a good idea and for those starting out with MariaDB should start from scratch.   Seems to me the way to go.
You had internal mysql tables in backup file because you had "mysql" in "MySQL Database" field on Database Setup Utilty. That database should not be messed with.
I'm surprised that you didn't have issues before. It might have appeared after moving to MariaDB because internal tables are different in MariaDB.
Title: Re: Maria DB
Post by: Vanlen on July 23, 2014, 02:42:48 PM
Thanks for the explanation.

Cheers

Title: Re: Maria DB
Post by: 704djs on September 02, 2014, 04:27:29 AM
Just done a Tutorial on setting up Maria DB http://djgarybaldy.co.uk/maria-db-radiodj/ (http://djgarybaldy.co.uk/maria-db-radiodj/)

Should be fairly easy if your not used to a SQL server......

Hope this helps someone.



link not work Gary
Title: Re: Maria DB
Post by: FL Coast on September 02, 2014, 05:17:28 AM

The link works for me.


link not work Gary
Title: Re: Maria DB
Post by: DJ Garybaldy on September 02, 2014, 08:09:19 AM
Quote
link not work Gary

Our  VPS fell over it should be up and running again now.

I've updated the original post about the tutorial to include a basic how to setup should my blog not be available.

http://www.radiodj.ro/community/index.php?topic=5339.msg31097#msg31097 (http://www.radiodj.ro/community/index.php?topic=5339.msg31097#msg31097)
Title: Re: Maria DB
Post by: elsilva0 on January 02, 2015, 06:41:14 AM
Quote
I will also test it more and share my thoughts.

@Marius #Mairus Have u tested mariadb anymore? Does it really get more memory usage than mysql?
Title: Re: Maria DB
Post by: DJ Garybaldy on January 15, 2015, 05:44:39 PM
Just to confirm to anyone reading this topic.

So far since July 2014 my database hasn't crashed once, hasn't spluttered it's just worked as it should.

So yes the answer to the question: MariaDB is really stable and works like a trooper.

Quote
Have u tested mariadb anymore? Does it really get more memory usage than mysql?

You tell the program how much memory to use when you set MariaDB up I have mine set at 300mb and as you can tell everything works.
Title: Re: Maria DB
Post by: Hansen on January 15, 2015, 07:04:32 PM
there is hope for mankind......

by that, i mean that even i, could install this....

works perfectly even flawless ;)
Title: Re: Maria DB
Post by: Marius on January 15, 2015, 07:23:51 PM
 :D
Title: Re: Maria DB
Post by: Jhonny on January 15, 2015, 10:39:58 PM
Today had a funeral of my uncle, was a bit sad, but after reading the latest comments, I really had to  :D :D :D

Quote
@Marius #Mairus Have u tested mariadb anymore? Does it really get more memory usage than mysql?
No just less.
Hasta la vista elsilvaO, you have make my day. 
great boys... Thanks

JH.
Title: Re: Maria DB
Post by: DJ Garybaldy on September 03, 2015, 03:11:08 PM
I've just upgraded my copy of MariaDB to the latest build https://downloads.mariadb.org/mariadb/10.0.21/ (https://downloads.mariadb.org/mariadb/10.0.21/)

Top Tip: As I've just found out before you attempt to upgrade MariaDB you need to:

A) Backup your RDJ database
B) Shut RadioDJ down including the database backup tool.
B) Stop mysqld.exe as a service.

Then you can begin the install of 10.0.21 if all goes to plan, the installer should automatically restart mysqld.exe as a service then you should just be able to restart RadioDJ

5 minute job if that.
Title: Re: Maria DB
Post by: ricky on September 03, 2015, 10:22:37 PM
Have been using it now for over two months and as of yet no problems it just works and as you say it is not as hard to setup  on win 7 pc  :) :cool:
Title: Re: Maria DB
Post by: DJ Garybaldy on September 04, 2015, 01:21:39 PM
I've been using MariaDB now since June 2014. I've never had a an SQL program that was this stable and easy to use.

Something would regularly go wrong with MySQL esp the 4 series but I don't seem to have that problem with MariaDB.

Only had to repair the database once to my memory and that was after a power cut. Other than that it's running absolutely flawless.

It's just nice when stuff works..... **Looks at Windows 10**  >:D

Title: Re: Maria DB
Post by: DJ Garybaldy on June 01, 2016, 11:16:53 AM
Wow has it really been 2 years this month since I first tried MariaDB .... ???

I don't know about anyone else but everything here is running as smooth as a nut...

It's been rare to have an issue. I haven't had to reinstall the database from scratch once. If I have had any issues they've been quickly sorted with HeidiSQL, The only time the DB has crashed was due to a power failure.

I love it when I can just leave software to do its own thing without having to constantly rebuild the database  :bash:

MariaDB & RadioDJ a partnership made in heaven? I think so.

Title: Re: Maria DB
Post by: packzap on June 02, 2016, 05:29:29 AM
Yes!  I concur.
Title: Re: Maria DB
Post by: dj_simplicity on October 19, 2016, 12:59:56 PM
hi
  installed MariaDb and uninstalled MySQL so I'm trying to restore save database but it only loads half way did a repair through HeidiSQL still the same hmmmmm?   any ideas  well off to work thank you for the help
Title: Re: Maria DB
Post by: DJ Garybaldy on October 19, 2016, 03:11:57 PM
We're you running the database setup tool as "Administrator"?
Title: Re: Maria DB
Post by: DJ Garybaldy on June 02, 2017, 04:26:29 PM
Hard to believe its 3 years this month since I took the plunge and installed MariaDB rather than MySQL from Oracle.

It has to be the most stable piece of database software I've ever used... Only had to repair it once in 3 years (after a power cut)

RadioDJ just chugs along day after day lining up some amazing tunes that I would never have thought to put together back to back.

MariaDB you rock!

I just love it when software works it cuts out all the stress.