|
主机规划: 192.168.0.221 os6—221 192.168.0.222 os6—222 192.168.0.223 os6—223 192.168.0.224 os6—224 haproxy 192.168.0.225 os6—225 haproxy 安装脚本: #!/bin/bash sed -i "s/SELINUX=enforcing/SELINUX=disabled/g" /etc/selinux/config setenforce 0 service iptables start iptables -F iptables -A INPUT -p tcp -i eth0 --dport 3306 -m state --state NEW,ESTABLISHED -j ACCEPT iptables -A INPUT -p tcp -i eth0 --dport 4444 -m state --state NEW,ESTABLISHED -j ACCEPT iptables -A INPUT -p tcp -i eth0 --dport 4567 -m state --state NEW,ESTABLISHED -j ACCEPT iptables -A INPUT -p tcp -i eth0 --dport 4568 -m state --state NEW,ESTABLISHED -j ACCEPT yum install ntp -y ntpdate cn.pool.ntp.org echo "*/1 * * * * root ntpdate cn.pool.ntp.org" >> /etc/crontab 安装percona之前,必须删除mysql-libs,这个包和percona冲突. yum remove mysql-libs -y rpm -ivh http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm yum install socat -y yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch -y yum install Percona-XtraDB-Cluster-56 -y 配置文件:/etc/my.cnf 引导服务器配置,即os6---221 [mysqld] #wsrep wsrep_provider=/usr/lib64/libgalera_smm.so wsrep_cluster_address=gcomm://os6---221,os6-222,os6---223 binlog_format=ROW default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 wsrep_node_address=os6---221 wsrep_sst_method=xtrabackup-v2 wsrep_cluster_name=singulax wsrep_sst_auth=“wsrep:wsrep” 启动os6—221数据库 /etc/init.d/myslq bootstrap-pxc 创建replication用户(此步骤只需要在init服务器上执行,启动其他服务器时会自动复制.请参考PXC复制原理) GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO wsrep@'localhost' IDENTIFIED BY ‘wsrep'; FLUSH PRIVILEGES; os6---221服务器 [mysqld] #wsrep wsrep_provider=/usr/lib64/libgalera_smm.so wsrep_cluster_address=gcomm://os6---221,os6-222,os6---223 binlog_format=ROW default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 wsrep_node_address=os6---222 wsrep_sst_method=xtrabackup-v2 wsrep_cluster_name=singulax wsrep_sst_auth=“wsrep:wsrep” 启动os6—222数据库 /etc/init.d/mysql start || service mysql start os6---223服务器 [mysqld] #wsrep wsrep_provider=/usr/lib64/libgalera_smm.so wsrep_cluster_address=gcomm://os6---221,os6-222,os6---223 binlog_format=ROW default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 wsrep_node_address=os6---223 wsrep_sst_method=xtrabackup-v2 wsrep_cluster_name=singulax wsrep_sst_auth=“wsrep:wsrep” 启动os6—223数据库 /etc/init.d/mysql start || service mysql start pxc安装完毕后,会自动clustercheck命令和9200端口检测mysql服务的正常. 用法: /usr/bin/clustercheck <user> <pass> <available_when_donor=0|1> <log_file> <available_when_readonly=0|1> <defaults_extra_file> 添加检测用户: grant process on *.* to clustercheckuser@'localhost' identified by ‘clustercheckuser'; 检测返回结果:200 或者 503.例如 clustercheck clustercheckuser clustercheckuser HTTP/1.1 200 OK Content-Type: text/plain Connection: close Content-Length: 40 Percona XtraDB Cluster Node is synced. 9200端口:先安装xinetd,利用xinetd生成9200端口. yum install xinetd -y xinetd安装完毕后,后生成mysqlchk文件,并配置 # default: on # description: mysqlchk service mysqlchk { # this is a config for xinetd, place it in /etc/xinetd.d/ disable = no flags = REUSE socket_type = stream type = UNLISTED port = 9200 wait = no user = nobody server = /usr/bin/clustercheck log_on_failure += USERID only_from = 0.0.0.0/0 # # Passing arguments to clustercheck # <user> <pass> <available_when_donor=0|1> <log_file> <available_when_readonly=0|1> <defaults_extra_file>" # Recommended: server_args = user pass 1 /var/log/log-file 0 /etc/my.cnf.local" # Compatibility: server_args = user pass 1 /var/log/log-file 1 /etc/my.cnf.local" # 55-to-56 upgrade: server_args = user pass 1 /var/log/log-file 0 /etc/my.cnf.extra" server_args = clustercheckuser clustercheckuser # recommended to put the IPs that need # to connect exclusively (security purposes) per_source = UNLIMITED } 然后,在/etc/services为9200端口添加新服务 mysqlchk 9200/tcp # mysqlchk 启动xinetd service xinetd start chkconfig xinetd on Haproxy负载均衡和检测 安装haproxy yum install haproxy -y #centos6官方自带安装包,直接yum安装即可 配置防火墙 iptables -A INPUT -p tcp --dport 8080 -m state --state NEW,ESTABLISHED -j ACCEPT iptables -A INPUT -p tcp --dport 3306 -m state --state NEW,ESTABLISHED -j ACCEPT iptables -A INPUT -p tcp --dport 3307 -m state --state NEW,ESTABLISHED -j ACCEPT 配置文件: frontend stats-front bind *:8080 mode http default_backend stats-back frontend pxc-front bind *:3307 mode tcp default_backend pxc-back frontend pxc-onenode-front bind *:3308 mode tcp default_backend pxc-onenode-back backend stats-back mode http balance roundrobin stats uri /haproxy/stats stats auth haproxy:haproxy backend pxc-back mode tcp balance leastconn option httpchk server c1 192.168.115.221:3306 check port 9200 inter 12000 rise 3 fall 3 server c2 192.168.115.222:3306 check port 9200 inter 12000 rise 3 fall 3 server c3 192.168.115.223:3306 check port 9200 inter 12000 rise 3 fall 3 backend pxc-onenode-back mode tcp balance leastconn option httpchk server c1 192.168.115.221:3306 check port 9200 inter 12000 rise 3 fall 3 server c2 192.168.115.222:3306 check port 9200 inter 12000 rise 3 fall 3 backup server c3 192.168.115.223:3306 check port 9200 inter 12000 rise 3 fall 3 backup 启动 service haproxy start service haproxy stop 访问: http://192.168.115.224:8080/haproxy/stats (责任编辑：IT) |