Garela cluster
All firewalls and selinux need to be turned off
Time must be synchronized and time server can be prepared.
# vim / etc/ntp.conf
Server 127.127.1.0
Fudge 127.127.1.0 stratum 10
# systemctl restart ntpd
Client synchronization time:
$ntpdate galera1
Download and install Galera (install each one)
Note: Galera has a separate patch pack, as well as a complete package with patches based on mysql
We need to download the version with the wsrep extension patch, such as:
MySQL 5.7.20 extended with wsrep patch version 25.13
Do a good local resolution: ip corresponds to galera1,garela2,garela3
Configure yum Feed
# cat galera.repo
[galera]
Name=galera
Baseurl= http://releases.galeracluster.com/mysql-wsrep-5.7/centos/7/x86_64/
Enabled=1
Gpgcheck=0
View the installation package
Yum list | grep 'galera'
Galera.x86_64 25.3.12-2.el7 epel
Mysql-wsrep-5.7.x86_64 5.7.20-25.13.el7 galera
Mysql-wsrep-client-5.7.x86_64 5.7.20-25.13.el7 galera
Mysql-wsrep-common-5.7.x86_64 5.7.20-25.13.el7 galera
Mysql-wsrep-devel-5.7.x86_64 5.7.20-25.13.el7 galera
Mysql-wsrep-libs-5.7.x86_64 5.7.20-25.13.el7 galera
Mysql-wsrep-libs-compat-5.7.x86_64 5.7.20-25.13.el7 galera
Mysql-wsrep-server-5.7.x86_64 5.7.20-25.13.el7 galera
Mysql-wsrep-test-5.7.x86_64 5.7.20-25.13.el7 galera
Installation:
# yum install mysql-wsrep-5.7.x86_64 galera rsync-y
Modify the mysql configuration file to change all mysql passwords to 123
Each machine creates a user for data synchronization:
Mysql > grant all on *. * to 'syncuser'@'%' identified by' 123'
Mysql > flush privileges
Mysql > grant all on *. * to 'syncuser'@'%' identified by' Qianfeng123 thanks'
Mysql > flush privileges
Configure Galera Replication:
Galera1 configuration: the main configuration file my.cnf is appended as follows. The boldface part is different from other nodes.
Server-id=1
Binlog_format=row
Innodb_file_per_table=1
Innodb_autoinc_lock_mode=2
Wsrep_on=ON
Wsrep_provider=/usr/lib64/galera/libgalera_smm.so
Wsrep_cluster_name='galera'
Wsrep_cluster_address='gcomm://'
Wsrep_node_name='galera1'
Wsrep_node_address='192.168.245.133'
Wsrep_sst_auth=syncuser:'123'
Wsrep_sst_method=rsync
Gelera2 configuration: the main configuration file my.cnf is appended as follows:
Server-id=2
Binlog_format=row
Innodb_file_per_table=1
Innodb_autoinc_lock_mode=2
Wsrep_on=ON
Wsrep_provider=/usr/lib64/galera/libgalera_smm.so
Wsrep_cluster_name='galera'
Wsrep_cluster_address='gcomm://galera1,galera3' / / you don't have to write the first one here, but you have to write it later, and you can't write your own ip or locally resolved names.
Wsrep_node_name='galera2'
Wsrep_node_address='192.168.245.136'
Wsrepairsstatically authentic syncuserdisplacement Qianfeng123 bicycle'
Wsrep_sst_method=rsync
Restart the mysql of each machine
View port: galera port: 4567 dint MySQL port: 3306
Test:
Mysql > show status like 'wsrep%'
