MySQL Galera 集群的安装过程
MySQL Galera集群版的mysql是经过codeship打了wsrep补丁的,不是普通的mysql版本.可以从github下载。
环境:redhat 7
mysql:5.5.37
galera: 25.3.5
解压,新增mysql用户,然后初始化mysql
[root@os1 ~]# ls -l mysql-5.5.37_wsrep_25.10-linux-x86_64.tar.gz
-rw-r--r--. 1 root root 62014481 Nov 23 17:17 mysql-5.5.37_wsrep_25.10-linux-x86_64.tar.gz
[root@os1 mysql]# ./scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data
安装 galera的plugin
[root@os1 ~]# rpm -ivh --force galera-25.3.5-1.rhel6.x86_64.rpm
Preparing... ################################# [100%]
Updating / installing...
1:galera-25.3.5-1.rhel6 ################################# [100%]
拷贝libgalera的plugin到mysql/lib目录下
[root@os1 local]# cp /usr/lib64/galera/libgalera_smm.so /usr/local/mysql/lib/plugin
[root@os1 ~]# chown -R mysql:mysql /usr/local/mysql
编写/etc/my.cnf文件
[mysqld]
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are