Server MySQL to MariaDB Upgrade

[un4saken]

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.

 

[rockforlife]

will wordpress run on this fork?

 

[strokerace]

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.

 

[un4saken]

All MySQL connectors (PHP, Perl, Python, Java, .NET, MyODBC, Ruby, MySQL C connector etc) work unchanged with MariaDB.

See more at: https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/

 

[strokerace]

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]

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

because in my site i use mysql functions.

eg.

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

 

[un4saken]

Rave, did u read my last post?

 

[Genesis]

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.

 

[rave]

All MySQL connectors (PHP, Perl, Python, Java, .NET, MyODBC, Ruby, MySQL C connector etc) work unchanged with MariaDB.

See more at: https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/

yes i read this post.i never used maria db before so i asked. but hoping that everything will be ok after upgrading to maria db.....

thanks un4saken :smile:

 

[un4saken]

In progressCompleted
The scheduled maintenance has been completed.

 

[Genesis]

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?

 

[un4saken]

Yes Genesis, It's supposed to be like that. Check phpinfo http://status.gi9.co/phpinfo.php

 

[Genesis]

OK got it thanks un4! Great job .... felt completely effortless on the user end of things.

 

[Genesis]

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!

 

[un4saken]

You can check CPU Load and Memory Usage live in here http://www.status.gi9.co/

It's almost half of the old setup. More secure, more fast server.

 

[admin]

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

Great Work..

 

[un4saken]

Little update on this.

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