Jump to content

Community

PedroNL

Move from MySQL to MariaDB

Recommended Posts

@Rhett: What are the advantages of MariaDB over MySQL? I've read that its generally faster than MySQL so I'm curious if its worth considering switching to MariaDB 10 over 5.6 of MySQL.

Also what is the process of upgrading to it?

Share this post


Link to post
Share on other sites
1 minute ago, Joey_M said:

@Rhett: What are the advantages of MariaDB over MySQL? I've read that its generally faster than MySQL so I'm curious if its worth considering switching to MariaDB 10 over 5.6 of MySQL.

Also what is the process of upgrading to it?

It would depend on your situation, there may be no advantage at all, however it is recommended by most over mysql, in short it's an optimized version of mysql with both performance and other enhancements by the Mariadb team. The process would also depend on your setup, I would consult with your hosting provider and they would be able to assist you in the proper method though. 

Share this post


Link to post
Share on other sites
12 hours ago, RObiN-HoOD said:

I moved from MySQL to mariadb 5.5 and everything works fine.

Is it ok to upgrade to mariadb 10.x regarding IPB?

Ipb will work fine (I use it) but I would take a backup just to be safe 

Share this post


Link to post
Share on other sites

I am running my VPS and have realised that WHM/cPanel has a built in upgrade menu from MySQL 5.6.35 to MariaDB 10.0. and started thinking of the upgrade exactly for the same reason @PedroNL stated

I know I should first backup before doing any change of this kind but I am wondering if I have to make any changes if everything goes fine.

Do I need to change DB setting in conf_global.php ? Do I have to change any other thing within the IPS software ?

MazdaClubTRSnip29.thumb.JPG.6e894b6873643468e78f3bcf4ef4b0ce.JPG

Edited by ABGenc

Share this post


Link to post
Share on other sites
4 minutes ago, jcdesign said:

I did this upgrade with WHM panel for a long time ago MariaDb 10.1, and there was no issue at all.

 

Untitled-1.jpg

So I understand that you had to change nothing post upgrade , right ?

Did you need to fine tune the configuration settings for MariaDB or you kept them as they are ?

Last question, how long does it take ( I know it depends on DB size )

Share this post


Link to post
Share on other sites
1 minute ago, jcdesign said:

I changed nothing.

My Db was on about 660 mb  and the upgrade took about 5-10 minutes I think.

Looks very similar ;) Thanks

Share this post


Link to post
Share on other sites
14 hours ago, jcdesign said:

I changed nothing.

My Db was on about 660 mb  and the upgrade took about 5-10 minutes I think.

One last question, did you realise any significant performance boost after the upgrade ?

Share this post


Link to post
Share on other sites
3 hours ago, jcdesign said:

Hard to say! I was converting to MartiaDb because @ASTRAPI and couple of other member recommend MariaDb.

Since your comments have encouraged me I have just upgraded to MariaDB 10.0.30 . It was much more easier and faster than I have expected. Not more than a reboot time. My users even did not realise it I can say.

We will see if it will benefit or not ;)  Thanks

Share this post


Link to post
Share on other sites

In the last two years I have read about the percona, mariadb and mysql differences and I didn't upgrade yet either. As you guys I am also running WHM/Cpanel and I love it for reasons like that. Upgrading / Changing the database system is nothing but a click. 

Share this post


Link to post
Share on other sites
17 minutes ago, inkredible said:

In the last two years I have read about the percona, mariadb and mysql differences and I didn't upgrade yet either. As you guys I am also running WHM/Cpanel and I love it for reasons like that. Upgrading / Changing the database system is nothing but a click. 

I was just thinking MariaDB was a whole different thing. After reading, I have realised it was basically same but the difference between them was getting bigger in time and it might be harder to upgrade in the next releases so I decided to have a go.

To tell the truth I did not feel so much difference from MySQL 5.6.35 to 10.0.30 but at least I now know I will not get any copmlaints from @ASTRAPI or other experts cause my DB is not MariaDB :D 

Share this post


Link to post
Share on other sites

Sorry if this is a n00b question, but: for those of us who run PHP/mySQL apps on our VPS apart from the IPB suite, is it possible to have both mySQL and mariaDB on a server?  I have a couple of apps that use mySQL and have no idea if they would run post-conversion or not.

Share this post


Link to post
Share on other sites
5 minutes ago, liquidfractal said:

Sorry if this is a n00b question, but: for those of us who run PHP/mySQL apps on our VPS apart from the IPB suite, is it possible to have both mySQL and mariaDB on a server?  I have a couple of apps that use mySQL and have no idea if they would run post-conversion or not.

Not sure what your applications are but I can give you one example.

I was using SMF 2.0.8 before my conversion to IPS and kept the script on the server for archiving purposes, I have seen that I did not need to change anything at all for it to keep running. I think ( not very sure though ) the front-end of the database server is the same but backend service is changing after conversion to MariaDB which lets you keep using it without any change.

Share this post


Link to post
Share on other sites
7 minutes ago, liquidfractal said:

Sorry if this is a n00b question, but: for those of us who run PHP/mySQL apps on our VPS apart from the IPB suite, is it possible to have both mySQL and mariaDB on a server?  I have a couple of apps that use mySQL and have no idea if they would run post-conversion or not.

I am pretty sure they will run on mariadb, too. Even replicating from MariaDB to MySQL works (depending on both versions). You can read more about the incompabilities here: https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/

Share this post


Link to post
Share on other sites
1 minute ago, inkredible said:

I am pretty sure they will run on mariadb, too. Even replicating from MariaDB to MySQL works (depending on both versions). You can read more about the incompabilities here: https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/

Awesome...will check it out.  Thanks to you and @ABGenc!

Share this post


Link to post
Share on other sites

MariaDB is a drop in replacement and all your apps should work with it.

IT has some advantages compared to Mysql and that's why exists as if it was exact the same with Mysql then there is no reason to have two same things :-)

One nice feature is the query optimizer and a few other things that you may need to manualy adjust to see a better result.

You can use Google to find more related info.

As i always say just installing a softwaee can't offer much better performance using default settings....

 

Share this post


Link to post
Share on other sites
28 minutes ago, ASTRAPI said:

One nice feature is the query optimizer and a few other things that you may need to manualy adjust to see a better result.

You can use Google to find more related info.

Astrapi, isnt query optimization related to the code/query itself ? Is there anything we can do about it as users ? Does it have any bits to do on MariaDB side ?

Share this post


Link to post
Share on other sites
5 minutes ago, ABGenc said:

Astrapi, isnt query optimization related to the code/query itself ? Is there anything we can do about it as users ? Does it have any bits to do on MariaDB side ?

MySQL and MariaDB and other database systems have automatic query optimizer which can optimize "simple" query optimizations. Obviously they can't optimize all queries, that would be coders' task. MariaDB claims to have a better query optimizer than MySQL has as far as I know.

Share this post


Link to post
Share on other sites
6 hours ago, ABGenc said:

I was just thinking MariaDB was a whole different thing. After reading, I have realised it was basically same but the difference between them was getting bigger in time and it might be harder to upgrade in the next releases so I decided to have a go.

To tell the truth I did not feel so much difference from MySQL 5.6.35 to 10.0.30 but at least I now know I will not get any copmlaints from @ASTRAPI or other experts cause my DB is not MariaDB :D 

Now upgrade to MariaDB 10.1 :p

Share this post


Link to post
Share on other sites

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...