This tutorial shows the step-by-step guide on upgrading and converting from MySQL version 5.1 firstly to MariaDB version 5.5, and then subsequently to MariaDB 10.0, in CentOS 6.6 system. The procedure should works on most Red Hat Enterprise Linux (RHEL), CentOS, Fedora, Scientific Linux and similar distributions version 5, 6 and 7.
MariaDB 10 is the version which MariaDB deviated from MySQL 5.6 to indicate that not all features of MySQL 5.6 is implemented in MariaDB 10, while MariaDB includes even more features that are not available on MySQL, such as ExtraDB, Aria, Cassandra, CONNECT storage engine. MariaDB 10 also important in such a way that it includes several much wanted features, including full-text indexes search support.
If you haven’t upgraded to MariaDB 5.5, visit the tutorial Part 1 – Install and Upgrade MySQL to MariaDB 5.5.
Part 2 – Upgrade MariaDB/MySQL 5.5 to MariaDB 10.0
Note: Since MariaDB is drop-in replacement for MySQL for version <= 5.5, if you're on MySQL 5.5, you can follow the steps outlined below to upgrade to MariaDB 10 directly, without having to switch to MariaDB 5.5 beforehand.
- If you continue to upgrade process from MySQL 5.1 to MariaDB 5.5 to MariaDB 10.0, skip this step. Else, backup your databases.
- Ensure that all software packages are up-to-date before upgrading:
- Stop the MariaDB or MySQLservice:
service mysql stop
- Uninstall and remove MariaDB 5.5 or MySQL 5.5:
yum remove mysql mysql-server
- Visit MariaDB repository configuration generator to setup a MariaDB 10 repo by selecting your distro and release.
Edit the file named MariaDB.repo (or any name that you chose) in /etc/yum.repos.d directory, and replace the content inside it with the custom MariaDB YUM repository entry for CentOS generated.
For CentOS 6.6, the content of /etc/yum.repos.d/MariaDB.repo is:
# MariaDB 10.0 CentOS repository list - created 2015-01-25 17:31 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
- Clean the repository cache information:
yum clean all
- Install MariaDB 10.0:
yum install MariaDB-server MariaDB-client
- When installation is completed, start the MariaDB database service:
service mysql start
- Run the MariaDB upgrade script:
- Verify that the MariaDB 10.0 is running by logging into the database system using command-line client:
The output should indicates MariaDB:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 12
Server version: 10.0.15-MariaDB MariaDB Server
Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
The installation and upgrading to MariaDB 10.0 has completed. By default, MariaDB no longer uses /etc/my.cnf as the single configuration file for the rDBMS. Instead, the configuration file has been split into several files located inside "/etc/my.cnf.d" directory, namely mysql-clients.cnf, server.cnf and tokudb.cnf.
To complete the migration to MariaDB 10.0, relocate the MySQL configuration settings from the backed up my.cnf to appropriate section in appropriate new .cnf file for MariaDB 10. Also take note of variables which have changed between versions. If you does not like the new MariaDB .cnf structure, you can continue to use a single my.cnf file, replacing the MariaDB 10 default version.