centos mariadb5.5升級到10.0

來源:互聯網
上載者:User

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 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 restart mysqld

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.

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/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 Be 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 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)]> Be Sociable, Share!

相關文章

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.