How to upgrade Mysql 5.1 to MariaDB 10.0.X under CentOS 6.5 without using mysqldump

Jephe Wu - http://linuxtechres.blogspot.com

Environment:  CentOs 6.5 64bit with default mysql 5.1 server and innodb engine for database.
Objective:  Upgrade database to MariaDB 10 without dumping table contents.

Concept:  Tried to upgrade directly from Mysql 5.1 to MariaDB 10 but it doesn't work, we got errors in mysql log file. However, upgrade to Percona server 5.5 first then upgrade to MariaDB 10 works.


Steps

upgrade to Percona 5.5 server first
run the following commands to upgrade mysql 5.1 to Percona 5.5,

refer to http://www.percona.com/doc/percona-server/5.5/installation/yum_repo.html 

yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm

/etc/init.d/mysql stop
rpm -e mysql mysql-server
yum install Percona-Server-client-55 Percona-Server-server-55

/etc/init.d/mysql start

mysql_upgrade -uroot -ppassword

upgrade Percona 5.5 to MariaDB 10.0.X

Refer to https://downloads.mariadb.org/mariadb/repositories/#mirror=aarnet_pty_ltd&distro=CentOS&distro_release=centos6-amd64&version=10.0 

vi /etc/yum.repos.d/MariaDb.repo and put into following

# MariaDB 10.0 CentOS repository list - created 2014-12-10 08:39 UTC # http://mariadb.org/mariadb/repositories/ [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.0/centos6-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1

 /etc/init.d/mysql stop
sudo yum install MariaDB-server MariaDB-client
/etc/init.d/mysql start

mysql_upgrade -uroot -ppassword