数风流人物

一、安装percona环境 二、下载PXC 三、编辑PXC的节点配置：

月月

一、环境准备 主机IP 主机名 操作系统版本 PXC 192.168.244.146 node1 CentOS7.1 Percona-XtraDB-Cluster-56-5.6.30 192.168.244.147 node2 CentOS7.1 Percona-XtraDB-Cluster-56-5.6.30 192.168.244.148 node3 CentOS7.1 Percona-XtraDB-Cluster-56-5.6.30 关闭防火墙或者允许3306, 4444, 4567和4568四个端口的连接 关闭SElinux 二、下载PXC 安装PXC yum源 # yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm 这样会在/etc/yum.repos.d下生成percona-release.repo文件 安装PXC # yum install Percona-XtraDB-Cluster-56 最终下载下来的版本是Percona-XtraDB-Cluster-56-5.6.30 注意：三个节点上均要安装。 三、配置节点 配置节点一 修改node1的/etc/my.cnf 复制代码 [mysqld] datadir=/var/lib/mysql user=mysql # Path to Galera library wsrep_provider=/usr/lib64/galera3/libgalera_smm.so # Cluster connection URL contains the IPs of node#1, node#2 and node#3 wsrep_cluster_address=gcomm://192.168.244.146,192.168.244.147,192.168.244.148 # In order for Galera to work correctly binlog format should be ROW binlog_format=ROW # MyISAM storage engine has only experimental support default_storage_engine=InnoDB # This changes how InnoDB autoincrement locks are managed and is a requirement for Galera innodb_autoinc_lock_mode=2 # Node #1 address wsrep_node_address=192.168.244.146 # SST method wsrep_sst_method=xtrabackup-v2 # Cluster name wsrep_cluster_name=my_centos_cluster # Authentication for SST method wsrep_sst_auth="sstuser:s3cret" 复制代码 启动node1 # systemctl start mysql@bootstrap.service 注意：这个是CentOS 7下的启动方式，如果是CentOS 6，则启动方式为 # /etc/init.d/mysql bootstrap-pxc 之所以采用bootstrap启动，其实是告诉数据库，这是第一个节点，不用进行数据的同步。 利用这种方式启动，相当于wsrep_cluster_address方式设置为gcomm://。 此时，可登录客户端查看数据库的状态 mysql> show status like 'wsrep%'; 主要关注以下参数的状态 复制代码 +------------------------------+--------------------------------------+ | Variable_name | Value | +------------------------------+--------------------------------------+ | wsrep_local_state_uuid | 1fbb69e3-32a3-11e6-a571-aeaa962bae0c | ... | wsrep_local_state | 4 | wsrep_local_state_comment | Synced | ... | wsrep_cluster_size | 1 ... | wsrep_cluster_status | Primary | | wsrep_connected | ON | ... | wsrep_ready | ON | 复制代码 在上面的配置文件中，有个wsrep_sst_auth参数。该参数是用于其它节点加入到该集群中，利用XtraBackup执行State Snapshot Transfer（类似于全量同步）的。 所以，接下来是授权 mysql> CREATE USER 'sstuser'@'localhost' IDENTIFIED BY 's3cret'; mysql> GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'sstuser'@'localhost'; mysql> FLUSH PRIVILEGES; 配置节点二 修改node2的/etc/my.cnf 复制代码 [mysqld] datadir=/var/lib/mysql user=mysql # Path to Galera library wsrep_provider=/usr/lib64/galera3/libgalera_smm.so # Cluster connection URL contains the IPs of node#1, node#2 and node#3 wsrep_cluster_address=gcomm://192.168.244.146,192.168.244.147,192.168.244.148 # In order for Galera to work correctly binlog format should be ROW binlog_format=ROW # MyISAM storage engine has only experimental support default_storage_engine=InnoDB # This changes how InnoDB autoincrement locks are managed and is a requirement for Galera innodb_autoinc_lock_mode=2 # Node #2 address wsrep_node_address=192.168.244.147 # SST method wsrep_sst_method=xtrabackup-v2 # Cluster name wsrep_cluster_name=my_centos_cluster # Authentication for SST method wsrep_sst_auth="sstuser:s3cret"