Server Guide How to Upgrade MariaDB 5.5 to MariaDB 10.0 on CentOS 7

  • Downloading from our site will require you to have a paid membership. Upgrade to a Premium Membership today!

    Dont forget read our Rules! Also anyone caught Sharing this content will be banned. By using this site you are agreeing to our rules so read them. Saying I did not know is simply not an excuse! You have been warned.

Radio

    ven0m

    Administrator
    Staff member
    Administrator
    Moderator
    Platinum
    xenForo 2.x.x
    xenForo 1.x.x
    Contributor
    vBulletin All Access Pass
    The Chest
    Verified
    Ultra Platinum VIP
    Platinum VIP
    Gold VIP
    Silver VIP
    Premium
    Member
    Jul 17, 2005
    20,466
    7,708
    321
    localhost
    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:

    Code:
    yum -y update

    Now find which repo you should use with the . We’re going to add the CentOS 7 (64 bit) MariaDB 10.0 repository.

    For a refresher on editing files with vim see:

    Code:
    vim /etc/yum.repos.d/MariaDB10.repo

    # 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 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!