Mariadb introduction, mariadb

Mariadb introduction, mariadb

1. Introduction to mariadb

Official Website: https://mariadb.org
MariaDB was developed by Michael Widenius, MySQL founder. He sold his own company MySQL AB to SUN for $1 billion, as SUN was acquired by Oracle, the ownership of MySQL also fell into the hands of Oracle. MariaDB is named by Michael Widenius's daughter Maria.

2. Differences from Mysql

After MySQL5.6 is released, Oracle uses the Community edition and the Enterprise Edition, and does not release the 5.6 patch;

3. Install mariadb

(1) Enable MariaDB Source
Reference: https://mariadb.com/kb/en/mariadb/yum/
# Cat/etc/yum. repos. d/mariadb. repo
[Mariadb]
Name = MariaDB
Base url = http://yum.mariadb.org/10.0/centos6-amd64
Gpgkey = https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
Gpgcheck = 1
(2) install the standalone version of MariaDB
# Yum-y install MariaDB-server
Install cluster version MariaDB Cluster
# Yum-y install MariaDB-server

# Yum-y install MariaDB-Galera-server

4. Start and test mariadb
(1) Start mariadb
#/Etc/init. d/mysql start
(2) test mariadb

[Root @ node1 ~] # Mysql-u root-p [
Welcome to the MariaDB monitor. Commands end with; or \ g.
Your MariaDB connection id is 5
Server version: 10.0.17-MariaDB Server

Copyright (c) 2000,201 5, Oracle, MariaDB Corporation AB and others.

Type 'help; 'or' \ H' for help. type' \ C' to clear the current input statement.

MariaDB [(none)]> show databases;
+ -------------------- +
| Database |
+ -------------------- +
| Information_schema |
| Mysql |
| Performance_schema |
| Test |
+ -------------------- +
4 rows in set (0.00 sec)