PedroNL Posted November 17, 2016 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
Rhett Posted November 17, 2016 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?
Joey_M Posted December 16, 2016 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?
Rhett Posted December 16, 2016 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.
RObiN-HoOD Posted December 16, 2016 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?
pxg.me nick Posted December 16, 2016 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
ABGenc Posted March 18, 2017 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 ?
jcdesign Posted March 18, 2017 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.
ABGenc Posted March 18, 2017 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 )
jcdesign Posted March 18, 2017 Posted March 18, 2017 I changed nothing. My Db was on about 660 mb and the upgrade took about 5-10 minutes I think.
ABGenc Posted March 18, 2017 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
ABGenc Posted March 19, 2017 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 ?
jcdesign Posted March 19, 2017 Posted March 19, 2017 Hard to say! I was converting to MartiaDb because @ASTRAPI and couple of other member recommend MariaDb.
ABGenc Posted March 19, 2017 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
inkredible Posted March 20, 2017 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.
ABGenc Posted March 20, 2017 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
LiquidFractal Posted March 20, 2017 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.
ABGenc Posted March 20, 2017 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.
inkredible Posted March 20, 2017 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/
LiquidFractal Posted March 20, 2017 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!
ASTRAPI Posted March 20, 2017 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....
ABGenc Posted March 20, 2017 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 ?
inkredible Posted March 20, 2017 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.
RevengeFNF Posted March 20, 2017 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
ABGenc Posted March 20, 2017 Posted March 20, 2017 22 minutes ago, RevengeFNF said: Now upgrade to MariaDB 10.1 Really needed ?
Recommended Posts
Archived
This topic is now archived and is closed to further replies.