How to Upgrade MariaDB 5.5 to MariaDB 10.0 on Fedora 20
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.
Requirements
- These instructions are intended for upgrading from MariaDB 5.5 to MariaDB 10.0 on Fedora 20.
- I’ll be working from a Liquid Web Self Managed Fedora 20 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.
yum -y update
Now find which repo you should use with the MariaDB repository generator. We’re going to add the CentOS 7 (64 bit) MariaDB 10.0 repository.
For a refresher on editing files with vim see: New User Tutorial: Overview of the Vim Text Editor.
vim /etc/yum.repos.d/MariaDB10.repo
# MariaDB 10.0 CentOS repository list – created 2014-10-13 13:04 UTC
# http://mariadb.org/mariadb/repositories/
[mariadb] name = MariaDB
baseurl = http://yum.mariadb.org/10.0/fedora20-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
Then exit and save the file with the command :wq.
Step #2: Remove the Existing MariaDB Installation
Be sure to backup MariaDB before proceeding with the following instructions!
Stop MariaDB.
systemctl stop mariadb
Remove the existing MariaDB packages.
yum -y remove mariadb-server mariadb mariadb-libs
Step #3: 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.
systemctl start mysql
Be sure that MariaDB is set to start at boot.
systemctl enable mysql
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 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)]>
Related Articles:
- How to Force HTTPS For Your Domain
- 2 Methods of Checking Apache Version
- How to Install Adminer MySQL Database Management Tool on AlmaLinux
- How to Edit the PHP Memory for Your WordPress Site via WP Toolkit
- 4 Methods for How to Install Yarn on Windows Server
- How to Install Bpytop Resource Monitoring Tool on AlmaLinux
About the Author: J. Mays
As a previous contributor, JMays shares his insight with our Knowledge Base center. In our Knowledge Base, you'll be able to find how-to articles on Ubuntu, CentOS, Fedora and much more!
Our Sales and Support teams are available 24 hours by phone or e-mail to assist.
Latest Articles
How to Force HTTPS For Your Domain
Read ArticleWhat is CGI-Bin and What Does it Do?
Read ArticleTop 10 Password Security Standards
Read ArticleTop 10 Password Security Standards
Read ArticleHow to Use the WP Toolkit to Secure and Update WordPress
Read Article