MySQL主主复制+Keepalived高可用(备注).docx

MySQL双主机群部署环境描述OS:CentOS 6.5 x86_64MySQL: MySQL-server-5.5.28-1.linux2.6.x86_64.rpm、MySQL-client-5.5.28-1.linux2.6.x86_64.rpmMaster:192.168.83.132Backup:192.168.83.134Virtual IP:192.168.83.125安装MySQL（两台主机需要进行相同的安装操作）1）安装rpm包安装之前需要先检查系统是否存在预装的mysql版本[root@node3 ~]# rpm -qa|grep -i mysql如果检查到系统预装的mysql则执行如下命令卸载[root@node3 ~]# yum –y remove mysql-libs-5.1.71*执行如下命令安装[root@node3 ~]# rpm –ivh MySQL-server-5.5.28-1.linux2.6.x86_64.rpm[root@node3 ~]# rpm –ivh MySQL-client-5.5.28-1.linux2.6.x86_64.rpm2）启动mysql[root@node3 ~]# service mysql start第一次运行mysql时需要对root用户设置密码：[root@node3 ~]# mysql –urootmysql update?mysql.user?set?password=PASSWORD(root@123)?where?User=root;mysql flush?privileges;3）编辑my.cnf文件（没有则创建）[root@node3 ~]# vim /etc/my.cnf[mysqld]server-id = 1 #Backup机器设置为2log-bin = mysql-binbinlog-ignore-db = mysql,information_schema #忽略写入binlog日志的库auto-increment-increment = 2 #字段变化增量值auto-increment-offset = 1 #初始字段id设置为1，Backup设置为2slave-skip-errors = all #忽略所有复制产生的错误追加以上内容，编辑完之后保存，重启mysql服务[root@node3 ~]# service mysql restart设置主主复制查看下log-bin日志和position的位置mysql show master status;创建replication用户，并给root用户赋权mysql create user replication@% identified by replication;mysql grant all on *.* to replication@%;mysql grant all privileges on *.* to root@% identified by root@123;mysql grant all privileges on *.* to root@localhost identified by root@123;mysql grant all privileges on *.* to root@127.0.0.1 identified by root@123;mysql flush privileges;配置Master和BackupMaster的配置如下：mysql grant replication slave on *.* to replication@192.168.83.% identified by replication;mysql flush privileges;mysql change master to master_host = 192.168.83.134, master_user=replication, master_password=replication, master_log_file=mysql-bin.000002, master_log_pos=107;mysql start slave; #启动同步master_host：Backup机器IPmaster_user：上面创建的replication用户master_password：replication用户的密码master_log_file：第一步查询出来的File的名称master_log_pos：第一步查询出来的Postion的值Backup的配置如