MariaDB is a drop-in replacement for MySQL installed by default on CentOS 7, and offers many speed and performance improvements. MariaDB offers more storage engines than MySQL, including Cassandra (NoSQL), XtraDB (drop-in replacement for InnoDB), and OQGRAPH.
Pre-Flight Check
Step #1: 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:
Now find which repo you should use with the
For a refresher on editing files with vim see:
# MariaDB 10.0 CentOS repository list – created 2014-10-13 13:04 UTC
#
[mariadb]
name = MariaDB
baseurl =
gpgkey=
gpgcheck=1
Then exit and save the file with the command :wq .
Step #2: Remove the Existing MariaDB Installation
Be sure to
Removing MariaDB will remove services that depend on MariaDB!
Stop MariaDB:
Clean-up the repository cache information with the following command:
Step #3: Install MariaDB 10.0
At this point, installing MariaDB 10.0 is as simple as running just one command:
And then start MariaDB again:
Be sure that MariaDB is set to start at boot:
Verify MySQL is now MariaDB by using the command client:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 4
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)]>
Be Sociable, Share!
Pre-Flight Check
- These instructions are intended for upgrading from MariaDB 5.5 to MariaDB 10.0 on CentOS 7.
- I’ll be working from a Liquid Web Core Managed CentOS 7 server, and I’ll be logged in as root.
Step #1: 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:
Code:
yum -y update
Now find which repo you should use with the
You must be registered for see links
. We’re going to add the CentOS 7 (64 bit) MariaDB 10.0 repository.For a refresher on editing files with vim see:
You must be registered for see links
Code:
vim /etc/yum.repos.d/MariaDB10.repo
# MariaDB 10.0 CentOS repository list – created 2014-10-13 13:04 UTC
#
You must be registered for see links
[mariadb]
name = MariaDB
baseurl =
You must be registered for see links
gpgkey=
You must be registered for see links
gpgcheck=1
Then exit and save the file with the command :wq .
Step #2: Remove the Existing MariaDB Installation
Be sure to
You must be registered for see links
before proceeding with the following instructions!Removing MariaDB will remove services that depend on MariaDB!
Stop MariaDB:
Code:
systemctl stop mariadb
Clean-up the repository cache information with the following command:
Code:
yum clean all
Step #3: Install MariaDB 10.0
At this point, installing MariaDB 10.0 is as simple as running just one command:
Code:
yum -y install MariaDB-server MariaDB-client
And then start MariaDB again:
Code:
systemctl start mysql
Be sure that MariaDB is set to start at boot:
Code:
systemctl enable mysql
Code:
Run mysql_upgrade:
Code:
mysql_upgrade
Verify MySQL is now MariaDB by using the command client:
Code:
mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 4
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)]>
Be Sociable, Share!