Mysql galera cluster 集群笔记

约定不等于承诺〃 2022-05-10 05:46 223阅读 0赞

系统 Ubuntu 14.04.5 LTS (GNU/Linux 4.4.0-31-generic x86\_64)

**1.安装需要的源**

sudo apt-get install software-properties-common  
sudo apt-key adv --keyserver keyserver.ubuntu.com --recv BC19DDBA

**2.更新源加入**  
sudo vim /etc/apt/sources.list.d/galera.list

deb http://releases.galeracluster.com/ubuntu trusty main  
deb http://releases.galeracluster.com/mysql-wsrep-5.6/ubuntu trusty main  
deb http://releases.galeracluster.com/galera-3/ubuntu trusty main

**3.更新源 **  
sudo apt-get update

**4.安装**  
sudo apt-get install galera-3 galera-arbitrator-3 mysql-wsrep-5.6

**5.安装完后测试mysql是否正常启动 **  
sudo service mysql start

**5.1 .如果不能正常启动，注意是否有/var/run/mysqld/目录，及权限  **  
sudo mkdir /var/run/mysqld/    
sudo chmod 777 /var/run/mysqld/

**6.创建远程联接用户**  
grant all on \*.\* to MyCluster@'%' identified by '\*\*\*\*\*\*\*\*' with grant option;   
flush privileges;

**7.测试远程访问数据库**  
mysql -h 192.168.0.145 -uMyCluster -p  
mysql -h 192.168.0.144 -uMyCluster -p  
mysql -h 192.168.0.146 -uMyCluster -p

**8.主节点配置**  
vim /etc/mysql/my.cnf

\[mysqld\]  
bind-address = 0.0.0.0  
binlog\_format=ROW  
default-storage-engine=innodb  
innodb\_autoinc\_lock\_mode=2  
innodb\_flush\_log\_at\_trx\_commit=0  
innodb\_buffer\_pool\_size=122M

wsrep\_provider=/usr/lib/libgalera\_smm.so  
wsrep\_provider\_options="gcache.size=300M; gcache.page\_size=1G"  
wsrep\_cluster\_name="galeracluster"  
wsrep\_cluster\_address="gcomm://"  
wsrep\_sst\_method=rsync  
wsrep\_sst\_auth=MyCluster:\*\*\*\*\*\*\*\*  
   
!includedir /etc/mysql/conf.d/  
!includedir /etc/mysql/mysql.conf.d/

**9.从节点1的配置**  
vim /etc/mysql/my.cnf

\[mysqld\]  
bind-address = 0.0.0.0  
binlog\_format=ROW  
default-storage-engine=innodb  
innodb\_autoinc\_lock\_mode=2  
innodb\_flush\_log\_at\_trx\_commit=0  
innodb\_buffer\_pool\_size=122M

wsrep\_provider=/usr/lib/libgalera\_smm.so  
wsrep\_provider\_options="gcache.size=300M; gcache.page\_size=1G"  
wsrep\_cluster\_name="galeracluster"  
wsrep\_cluster\_address="gcomm://192.168.0.144"  
wsrep\_sst\_method=rsync  
wsrep\_sst\_auth=MyCluster:\*\*\*\*\*\*\*\*  
   
!includedir /etc/mysql/conf.d/  
!includedir /etc/mysql/mysql.conf.d/

**10.从节点2的配置**  
vim /etc/mysql/my.cnf

\[mysqld\]  
bind-address = 0.0.0.0  
binlog\_format=ROW  
default-storage-engine=innodb  
innodb\_autoinc\_lock\_mode=2  
innodb\_flush\_log\_at\_trx\_commit=0  
innodb\_buffer\_pool\_size=122M

wsrep\_provider=/usr/lib/libgalera\_smm.so  
wsrep\_provider\_options="gcache.size=300M; gcache.page\_size=1G"  
wsrep\_cluster\_name="galeracluster"  
wsrep\_cluster\_address="gcomm://192.168.0.144"  
wsrep\_sst\_method=rsync  
wsrep\_sst\_auth=MyCluster:\*\*\*\*\*\*\*\*  
   
!includedir /etc/mysql/conf.d/  
!includedir /etc/mysql/mysql.conf.d/

**11.先停止，再启动集群其他节点**  
sudo service mysql stop  
sudo service mysql start --wsrep-new-cluster  
mysql -uroot -p  
SHOW GLOBAL STATUS WHERE Variable\_name IN('wsrep\_ready','wsrep\_cluster\_size','wsrep\_cluster\_status','wsrep\_connected');

**   
11.查看集群启动情况**  
mysql -uroot -p  
SHOW GLOBAL STATUS WHERE Variable\_name IN('wsrep\_ready','wsrep\_cluster\_size','wsrep\_cluster\_status','wsrep\_connected');