MariaDB

Install MariaDB on CentOS 6

This topic contains 1 reply, has 2 voices, and was last updated by wangari wangari 1 year, 9 months ago.

  • Author
    Posts
  • #580
     augustine krapf 
    Participant

    How do i Install MariaDB on CentOS 6?

  • #581
    wangari wangari 
    Participant

    MariaDB is a drop-in replacement for MySQL. It is easy to install, offers many speed and performance improvements, and is easy to integrate into most MySQL deployments.

    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 installing MariaDB on a single CentOS 6 node.

    I’ll be working from a TD Web Services Core Managed CentOS 6.5 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 6 (64 bit) MariaDB 5.5 repository.

    vim /etc/yum.repos.d/mariadb.repo

    # MariaDB 5.5 CentOS repository list – created 2014-10-03 15:57 UTC
    # http://mariadb.org/mariadb/repositories/
    [mariadb]
    name = MariaDB
    baseurl = http://yum.mariadb.org/5.5/centos6-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 MySQL Installation

    In some cases a manual uninstall of mysql is necessary. Be sure to backup MySQL before proceeding.

    Stop MySQL:

    service mysqld stop

    Remove the existing MySQL packages:

    yum remove mysql-server mysql

    Step #3: Install MariaDB

    At this point, installing MariaDB is as simple as running just one command:

    yum -y install MariaDB-server MariaDB-client

    And then start MySQL, now MariaDB, again:

    service mysql start

    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 2
    Server version: 5.5.39-MariaDB MariaDB Server

    Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

    Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

You must be logged in to reply to this topic.

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending
TD Web Services

 COPYRIGHT OF TD WEB SERVICES © 2017. ALL RIGHTS RESERVED.

or

Log in with your credentials

or    

Forgot your details?

or

Create Account