The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

rollback to 5.5 with WHM

Hi all,

I installed MariaDB 10 on my new server and saw different performance to what I expected, higher CPU usage and slower query times than mysql 5.1. I had mariaDB 5.5 running before I reprovisioned this server on my first iteration of this server move for UAT.

However I need to now keep this data intact and move back to 5.5. I have managed to rollback to mySQL 5.5 however when I go back through the steps of installing mariadb at http://blog.cpanel.net/mysql-mariadb/ Even though I chose the 5.5. repo, the system still looks to install v10 and its dependencies. II am on CentOS and not sure how I go about getting 5.5 installed as would be my current preference.

Any advice?

Cheers Dan

Answer Answered by Daniel Black in this comment.

do a mysqldump from 10.0 and use this to restore into 5.5.

You may need to do yum downgrade to get the right version after updating your /etc/yum.repos.d/MariaDB.repo

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.