mariadb簡介,mariadb
1,mariadb簡介
官網連結:https://mariadb.org
MariaDB由MySQL的創始人Michael Widenius(英語:Michael Widenius)主導開發,他早前曾以10億美元的價格,將自己建立的公司MySQL AB賣給了SUN,此後,隨著SUN被甲骨文收購,MySQL的所有權也落入Oracle的手中。MariaDB名稱來自Michael Widenius的女兒Maria的名字。
2.與Mysql區別
Oracle在發布MySQL5.6後,採用了社區版與企業版區分,同時沒有推出5.6的相關修複補丁;
3.安裝mariadb
(1)啟用MariaDB源
參考連結:https://mariadb.com/kb/en/mariadb/yum/
# cat /etc/yum.repos.d/mariadb.repo
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0/centos6-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
(2)安裝單機版MariaDB
# yum -y install MariaDB-server
安裝叢集版MariaDB叢集
# yum -y install MariaDB-server
# yum -y install MariaDB-Galera-server
4.啟動並測試mariadb
(1)啟動mariadb
# /etc/init.d/mysql start
(2)測試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 MariaDB Server
Copyright (c) 2000, 2015, 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)