mariadbgaleracluster数据库集群一键安装脚本-创新互联

mariadb galare cluster是一套高可用全主mysql集群方案，优势高度数据一致性。

脚本：

#!/bin/bash

# Author:    laocao

# Date:     2016/05/03

# Revision:   1.0

if [ ! -f "/etc/yum.repos.d/mariadb.repo" ];then

  echo "[mariadb]" >>/etc/yum.repos.d/mariadb.repo

  echo "name = MariaDB" >>/etc/yum.repos.d/mariadb.repo

  echo "baseurl = http://yum.mariadb.org/10.0/centos6-amd64" >>/etc/yum.repos.d/mariadb.repo

  echo "enabled = 1" >>/etc/yum.repos.d/mariadb.repo

  echo "gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB" >>/etc/yum.repos.d/mariadb.repo

  echo "gpgcheck=1" >>/etc/yum.repos.d/mariadb.repo

  echo -e "\033[32m add mariadb yum repo successflly \033[0m"

  yum makecache

else

  echo -e "\033[31m mariadb.repo has exist! noting to do \033[0m"

fi

echo ""

echo "#######install MariaDB-Galera-server galera MariaDB-client#######"

yum -y install MariaDB-Galera-server galera MariaDB-client

echo -e "\033[32m install MariaDB success \033[0m"

echo ""

if [ ! -d /data/DBdata ];then

  mkdir /data/DBdata

  mkdir /data/binlog

  chown -R mysql.mysql /data/DBdata

  chown -R mysql.mysql /data/binlog

  echo -e "\033[32m create DBdata and binlog directories successflly! \033[0m"

else

  echo -e "\033[31m /data/DBdata has exist! noting to do \033[0m"

fi

echo ""

echo "#####mysql_install_db####"

mysql_install_db --user=mysql --datadir=/data/DBdata

echo -e "\033[32m mysql_install_db has completed \033[0m"

echo ""

echo -e "\033[31m you need copy wsref.cnf to /etc/my.cnf.d/ \033[0m"

echo -e "\033[31m you can start database manually \033[0m"

另外有需要云服务器可以了解下创新互联cdcxhl.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。