PXC（Percona XtraDB Cluster）集群安装

• 安装PXC，分别在11，12，13上安装

参考 https://www.percona.com/doc/percona-xtradb-cluster/5.6/installation/yum_repo.html

yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm
yum install Percona-XtraDB-Cluster-56

• 启动mysql服务，添加sst用户，节点间同步需要改账户

service mysql restart

DELETE FROM mysql.user WHERE user='';  
GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'sstuser'@'localhost' IDENTIFIED BY 'sstuser';;  
FLUSH PRIVILEGES;  

• 依次修改my.cnf配置文件

# Template my.cnf for PXC
# Edit to your requirements.

[mysqld]

server_id                      = 1
log_bin
binlog_format                  = ROW
innodb_buffer_pool_size        = 100M
innodb_flush_log_at_trx_commit = 0
innodb_flush_method            = O_DIRECT
innodb_log_files_in_group      = 2
innodb_log_file_size           = 20M
innodb_file_per_table          = 1
datadir                        = /var/lib/mysql

wsrep_cluster_address          = gcomm://192.168.1.11,192.168.1.12,192.168.1.13
#wsrep_cluster_address          = gcomm://
wsrep_provider                 = /usr/lib64/galera3/libgalera_smm.so

wsrep_slave_threads            = 8
wsrep_cluster_name             = Cluster
wsrep_node_name                = Node1
wsrep_sst_auth                 = sstuser:sstuser

#wsrep_sst_method               = xtrabackup

innodb_locks_unsafe_for_binlog = 1
innodb_autoinc_lock_mode       = 2

default_storage_engine=InnoDB



[mysqld_safe]
pid-file = /run/mysqld/mysql.pid
syslog


!includedir /etc/my.cnf.d

 

11上执行 systemctl start mysql@bootstrap.service 

12 ， 13 上执行 service mysql start

 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '' WITH GRANT OPTION;
改密
mysqladmin -u root password "password";
授权
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;

show global status like 'wsrep_cluster_size';

 

转载于:https://my.oschina.net/u/938837/blog/707070