centos mariadb5.5升级到10.0,centosmariadb5.5
The suggested upgrade procedure is:
- Shutdown and uninstall MariaDB 5.5
- Take a backup (this is the perfect time to take a backup 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
database with some new fields - Does a very quick check of all tables and marks them as compatible with MariaDB 10.0
- Upgrades the permission tables in the
- In most cases this should be a fast operation (depending of course on the number of tables)
- Add new options to my.cnf to enable features
- If you change
my.cnf
then you need to restartmysqld
- If you change
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- 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.
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/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 InstallationBe sure to backup MariaDB and/or your entire server before proceeding with the following instructions!Removing MariaDB will 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
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)]>
原文链接:
https://blog.csdn.net/iastro/article/details/52047227