How to Upgrade MySQL 5.1 to MariaDB 10.0 on CentOS 6

Step #1: Upgrade from MySQL 5.1 to MariaDB 5.5

The proper upgrade path from MySQL 5.1 to MariaDB 10.0 is as follows:

1. MySQL 5.1

2. MariaDB 5.5

3. MariaDB 10.0

Step #2: Add the MariaDB Repository


First, you’ll follow a simple best practice: ensuring the list of available packages is up to date before installing anything new:

yum -y update


Then disable the MariaDB 5.5 repo:

mv /etc/yum.repos.d/MariaDB55.repo /etc/yum.repos.d/MariaDB55.repo.disabled


Now find which repo you should use with the MariaDB repository generator. We’re going to add the CentOS 6 (64 bit) MariaDB 10.0 repository.

vim /etc/yum.repos.d/MariaDB10.repo

# MariaDB 10.0 CentOS repository list – created 2014-10-10 17:33 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


Then exit and save the file with the command :wq .


Step #3: Add the EPEL Repository


MariaDB may have dependencies such as socat that are apart of Extra Packages for Enterprise Linux (EPEL), which is a community repository of non-standard packages for the RHEL distribution. To install the EPEL repository:

rpm -iUvh http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm

Step #4: Remove the Existing MariaDB Installation

Be sure to backup MySQL before proceeding with the following instructions!


Stop MariaDB:

service mysql stop


Remove the existing MariaDB packages:

yum -y remove mysql-server mysql-client


Clean-up the repository cache information with the following command:

yum clean all


Step #5: Install MariaDB 10.0


At this point, installing MariaDB 10.0 is as simple as running just one command:

yum -y install MariaDB-server MariaDB-client


And then start MariaDB again:

service mysql start


Be sure that MariaDB is set to start at boot:

chkconfig mysql on


Run mysql_upgrade:

mysql_upgrade


Verify MySQL is now MariaDB by using the command client:

mysql

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 13
Server version: 10.0.14-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.

MariaDB [(none)]>

  • 64 Users Found This Useful
Was this answer helpful?

Related Articles

How To List and Attach to Docker Containers

List Containers First we’ll list which containers we have running: docker ps Your result...

How to Install the MongoDB PHP Driver (Extension) on CentOS 6

Step 1: Setup Environment, Install PHP Extension & Application Repository (PEAR) As a matter...

How to Install WP-CLI

WP-CLI is a command line tool for interacting with and managing WordPress sites. WP-CLI is very...

How to List Which Apache Modules are Enabled on Ubuntu

The Apache web server is one of the most popular and powerful web servers in the world due to its...

How to Add a User and Grant Root Privileges on Fedora 20

Step 1: Add the User It’s just one simple command to add a user. In this case, we’re adding a...

Powered by WHMCompleteSolution