p; = 8M
[mysqlhotcopy]
interactive_timeout
#将配置文件传到其它服务器上,并修改里面对应的wsrep_node_address
scp -r /export/mysql/mysql3307 192.168.252.228:/export/mysql
scp -r /export/mysql/mysql3307 192.168.252.229:/export/mysql
#在node1上面初始化并启动pxc的第一个节点,并对配置文件中的用户授权
cd /usr/local/mysql
./bin/mysqld--defaults-file=/export/mysql/mysql3307/my3307.cnf --initialize-insecure
./bin/mysqld--defaults-file=/export/mysql/mysql3307/my3307.cnf --wsrep-new-cluster &
mysql>GRANT PROCESS, RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'thunder'@'localhost'IDENTIFIED BY 'thunder';FLUSH PRIVILEGES;
#在node2,node3上面启动pxc的其它节点,观察是否启动成功,并在node1上面进行写入,观察node2,node3上面是否有进行同步
./bin/mysqld--defaults-file=/export/mysql/mysql3307/my3307.cnf &
到此,cluster1就安装完毕了
3. 安装cluster2
除配置文件外,其它与cluster1安装一样,cluster的端口为5567
###PXC ###
default_storage_engine=Innodb
innodb_locks_unsafe_for_binlog = 1
innodb_autoinc_lock_mode = 2
wsrep_cluster_name = cluster2
wsrep_cluster_address =gcomm://192.168.252.227:5567,192.168.252.228:5567,192.168.252.229:5567wsrep_node_address = 192.168.252.228:5567
wsrep_provider_options = "base_port=5567"
wsrep_provider =/usr/local/mysql/lib/libgalera_smm.so
wsrep_sst_method = xtrabackup-v2
wsrep_sst_auth = thunder:thunder
4. 安装cluster3
除配置文件外,其它与cluster1安装一样,
###PXC ###
default_storage_engine=Innodb
innodb_locks_unsafe_for_binlog = 1
innodb_autoinc_lock_mode = 2
wsrep_cluster_name = cluster3
wsrep_cluster_address = gcomm://192.168.252.227:6567,192.168.252.228:6567,192.168.252.229:6567
wsrep_node_address = 192.168.252.228:6567
wsrep_provider_options = "base_port=6567"
wsrep_provider =/usr/local/mysql/lib/libgalera_smm.so
wsrep_sst_method = xtrabackup-v2
wsrep_sst_auth = thunder:thunder
5. 说明:
1.PXC不支持myisam引擎,在node1上创建myisam表后,其它节点不会进行复制。
2.建议的最小集群节点数为3,虽然两个节点也能运行,但是无法保证数据的稳定,当两节点时,任何一个节点出故障,将导致集群无法访问。最大值<=8。
3.3台机器损失一台机器性能。
4.关于wsrep_sst_method,有3种可选:mysqldump,rsync,xtrabackup
mysqldump最慢
rsync最快,但是在同步期间会锁表
xtrabackup可以在线传输,只有在copy表结构文件时会锁表,和其备份原理一样
5.启动顺序,如果为单机单实例,则
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
第一个实例启动命令为:
/etc/init.d/mysql bootstarp-pxc
如果为多实例,则通过mysqld_safe的方式来启动:
./bin/mysqld --defaults-file=/export/mysql/mysql3307/my3307.cnf --wsrep-new-cluster &
6. 可在启动时指定从哪台机器进行同步
./bin/mysqld --defaults-file=/export/mysql/mysql3307/my3307.cnf --wsrep-sst-donor=’192.168.252.228’ &