Server MySQL to MariaDB Upgrade

un4saken

Administrator
All server will go under maintenance to upgrade MySQL to MariaDB. Please backup your account to prevent any inconveniences situation that may arise from the upgrade.

Date: Saturday, 26th March 2016
Start Time: 7.00 PM (GMT)
End Time: 8.00 PM (GMT)
Duration: 60 minutes

How will this impact my services?
During the maintenance window of 60 minutes the web services and cpanel services may be offline.

How can I monitor progress of the maintenance to ensure my services have been fully restored?
Throughout the progress of this maintenance, we will update this topic.


In progress

Completed
The scheduled maintenance has been completed.
 
Seeing you are switching to this fork. Will all my resources that have Mysql links, will they still work? I don't want to rewrite over 500 files. Its bad enough that I had to update it to work on php 5.6 and above.
 
Ok Thanks. I just had a quick glace at the wiki before I posted. It didn't really say to much and was a bit scared. But I just looked at my code quickly and say that I really need to do some house cleaning on it. So, if this change does cause me errors, it will motivate me into cleaning it up.
 

rave

New member
will it affect my site if maria db takes place instead of mysql?

because in my site i use mysql functions.

eg.
PHP:
$pl = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM mainpage WHERE rave>'0'"));
 

Genesis

Administrator
Staff member
strokerace said:
Seeing you are switching to this fork. Will all my resources that have Mysql links, will they still work? I don't want to rewrite over 500 files. Its bad enough that I had to update it to work on php 5.6 and above.
Same here, I used this as an opportunity to clean up my hosting accounts. Last night I spent some time to first do thorough backups of everything and then clean up my accounts. Didn't realize I had as many WordPress sites with databases. I also cleaned up some of my dot.tk domain names.

I'm good to go. :p
 

Genesis

Administrator
Staff member
Everything is working perfectly as before. Only question is I don't see the name MariaDB in cPanel. It is still mySQL. Is that how it is supposed to be?
 

Genesis

Administrator
Staff member
OK got it thanks un4! Great job .... felt completely effortless on the user end of things. :cool:
 

Genesis

Administrator
Staff member
I've given both phpmyadmin and creating and importing databases a very big workout in cpanel, and everything is working OK. I imported an old mySQL database and WordPress figured out how to update it.

This was effortless. Thanks un4!
 

admin

Administrator
Staff member
I can feel the queries loading faster, especially on my Wordpress sites.

Great Work..
 

un4saken

Administrator
Little update on this.

MySQL CPU usage is down to %1 with MariaDB update. It was around %10-15 before