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)

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。