CentOS mariadb5.5 Upgrade to 10.0

The suggested upgrade procedure Is:shutdown and uninstall MARIADB 5.5 a backup (this is the Take time to perfect a B Ackup of your databases) Install MARIADB 10.0 [1] Run Mysql_upgrade Ubuntu and Debian packages do this automatically when They are installed; Red Hat, CentOS, and Fedora packages do not Mysql_upgrade does two things:upgrades the ' permission tables in the MySQL dat Abase with some new fields does a very quick check the all tables and marks them as compatible with MARIADB 10.0 in most CA Ses this should is a fast operation (depending of course on the number of tables) ADD new options to My.cnf to enable feat Ures

If you are my.cnf then you are need to restart Mysqld

MARIADB is a drop-in replacement for MySQL installed by default on CentOS 7, and offers many speed and performance IM Provements. MARIADB offers more storage engines than MySQL, including Cassandra (NoSQL), XTRADB (drop-in replacement for InnoDB), and Oqgraph. 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

The ' ll follow a simple best practice:ensuring the list of available packages are up to date before installing ing NEW:

Yum-y Update

Now find which repo your should with the MARIADB repository generator. We ' re going to add the CentOS 7 (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/centos7-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 is sure to backup MARIADB and/or your entire server before proceeding W ith the following instructions! Removing mariadb would remove services that depend on mariadb!

Stop mariadb:

Systemctl Stop MARIADB

Remove the existing MARIADB packages:

Yum Remove Mariadb-server mariadb mariadb-libs

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

Yum Clean all step #3: Install mariadb 10.0

At this point, installing MARIADB 10.0 are 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 are 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)]> be sociable, share!