PedroNL Posted November 17, 2016 Share Posted November 17, 2016 Dear All, It would be good to think about this for IPS future for the DB back end. https://seravo.fi/2015/10-reasons-to-migrate-to-mariadb-if-still-using-mysql Link to comment Share on other sites More sharing options...
Rhett Posted November 17, 2016 Share Posted November 17, 2016 MariahDB Has been the default DB for Centos7, it's a drop in replacement for mysql, recommended, and works great. What questions do you have? Link to comment Share on other sites More sharing options...
Joey_M Posted December 16, 2016 Share Posted December 16, 2016 @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? Link to comment Share on other sites More sharing options...
Rhett Posted December 16, 2016 Share Posted December 16, 2016 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. Link to comment Share on other sites More sharing options...
RObiN-HoOD Posted December 16, 2016 Share Posted December 16, 2016 I moved from MySQL to mariadb 5.5 and everything works fine. Is it ok to upgrade to mariadb 10.x regarding IPB? Link to comment Share on other sites More sharing options...
pxg.me nick Posted December 16, 2016 Share Posted December 16, 2016 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 Link to comment Share on other sites More sharing options...
ABGenc Posted March 18, 2017 Share Posted March 18, 2017 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 ? Link to comment Share on other sites More sharing options...
jcdesign Posted March 18, 2017 Share Posted March 18, 2017 I did this upgrade with WHM panel for a long time ago MariaDb 10.1, and there was no issue at all. Link to comment Share on other sites More sharing options...
ABGenc Posted March 18, 2017 Share Posted March 18, 2017 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. 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 ) Link to comment Share on other sites More sharing options...
jcdesign Posted March 18, 2017 Share Posted March 18, 2017 I changed nothing. My Db was on about 660 mb and the upgrade took about 5-10 minutes I think. Link to comment Share on other sites More sharing options...
ABGenc Posted March 18, 2017 Share Posted March 18, 2017 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 Link to comment Share on other sites More sharing options...
ABGenc Posted March 19, 2017 Share Posted March 19, 2017 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 ? Link to comment Share on other sites More sharing options...
jcdesign Posted March 19, 2017 Share Posted March 19, 2017 Hard to say! I was converting to MartiaDb because @ASTRAPI and couple of other member recommend MariaDb. Link to comment Share on other sites More sharing options...
ABGenc Posted March 19, 2017 Share Posted March 19, 2017 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 Link to comment Share on other sites More sharing options...
inkredible Posted March 20, 2017 Share Posted March 20, 2017 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. Link to comment Share on other sites More sharing options...
ABGenc Posted March 20, 2017 Share Posted March 20, 2017 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 Link to comment Share on other sites More sharing options...
LiquidFractal Posted March 20, 2017 Share Posted March 20, 2017 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. Link to comment Share on other sites More sharing options...
ABGenc Posted March 20, 2017 Share Posted March 20, 2017 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. Link to comment Share on other sites More sharing options...
inkredible Posted March 20, 2017 Share Posted March 20, 2017 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/ Link to comment Share on other sites More sharing options...
LiquidFractal Posted March 20, 2017 Share Posted March 20, 2017 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! Link to comment Share on other sites More sharing options...
ASTRAPI Posted March 20, 2017 Share Posted March 20, 2017 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.... Link to comment Share on other sites More sharing options...
ABGenc Posted March 20, 2017 Share Posted March 20, 2017 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 ? Link to comment Share on other sites More sharing options...
inkredible Posted March 20, 2017 Share Posted March 20, 2017 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. Link to comment Share on other sites More sharing options...
RevengeFNF Posted March 20, 2017 Share Posted March 20, 2017 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 Now upgrade to MariaDB 10.1 Link to comment Share on other sites More sharing options...
ABGenc Posted March 20, 2017 Share Posted March 20, 2017 22 minutes ago, RevengeFNF said: Now upgrade to MariaDB 10.1 Really needed ? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.