79.MariaDB Installation

MARIADB Introduction

MARIADB database management System is a branch of MySQL, mainly by the open source community in the maintenance, the use of GPL licensing MARIADB is fully compatible with MySQL, including the API and command line, so that it can easily become a substitute for MySQL. For the storage engine, use XtraDB (English: XtraDB) instead of the MySQL InnoDB. MARIADB, led by MySQL's founder Michael Widenius (English: Michael Widenius), sold his company, MySQL AB, to Sun for $1 billion earlier, and since Sun was acquired by Oracle, MySQL's ownership also falls into Oracle's hands. Mariadb name comes from Michael Widenius's daughter Maria's name.
Reference connection: Https://baike.baidu.com/item/mariaDB/6466119?fr=aladdin

Version information

Get connections

wget https://downloads.mariadb.com/MariaDB/mariadb-10.2.6/bintar-linux-glibc_214-x86_64/ Mariadb-10.2.6-linux-glibc_214-x86_64.tar.gz

1. Download the binary installation package

[Email protected]/]# cd/usr/local/src/
[Email protected]/]# wget https://downloads.mariadb.com/MariaDB/mariadb-10.2.6/bintar-linux-glibc_214-x86_64/ Mariadb-10.2.6-linux-glibc_214-x86_64.tar

2. Unpack the binary installation package and move to/usr/local

[Email protected]/]# tar zxvf mariadb-10.2.6-linux-glibc_214-x86_64.tar.gz
[Email protected]/]# MV MARIADB-10.2.6-LINUX-GLIBC_214-X86_64/USR/LOCAL/MARIADB

3. Initialize, specify Basedir and DataDir

[Email protected]/]# CD. /mariadb/
[Email protected]/]#/scripts/mysql_install_db--user=mysql--basedir=/usr/local/mariadb--datadir=/data/mariadb

4. Copy the configuration file and edit it

[email protected]/]# CP support-files/my-small.cnf/usr/local/mariadb/my.cnf
[[Email protected]/]# VI my.cnf//designation Basedir and DataDir

5. Copy the startup script to the/etc/init.d/directory and modify the contents.

[email protected]/]# CP support-files/mysql.server/etc/init.d/mariadb
[[email protected]/]# vim/etc/init.d/mariadb//define BASEDIR,DATADIR,CONF and startup parameters

and add the--defaults-file option in the following startup item to load the specified configuration file

Once modified, save and exit.

6. Start MARIADB

[[email protected]/]#/etc/init.d/mariadb start
Starting mariadb (via Systemctl): [OK]
[Email protected]/]# NETSTAT-LNTP

79.MariaDB Installation