1,mariadb简介 mariadb由mysql的创始人michael widenius(英语:michael widenius)主导开发,他早前曾以10亿美元的价格,将自己创建的公司mysql ab卖给了sun,此后,随着sun被甲骨文收购,mysql的所有权也落入oracle的手中。mariadb名称来自michael wideniu
1,mariadb简介
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源
# cat /etc/yum.repos.d/mariadb.repo[mariadb]name = mariadbbaseurl = http://yum.mariadb.org/10.0/centos6-amd64gpgkey=https://yum.mariadb.org/rpm-gpg-key-mariadbgpgcheck=1
(2)安装单机版mariadb
# yum -y install mariadb-server
安装集群版mariad【本文来自鸿网互联 (http://www.68idc.cn)】b集群
# 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 5server version: 10.0.17-mariadb mariadb servercopyright (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)