1. 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版本rootnode3 # rpm -qa|grep -i mysql如果检查到系统预装的 mysql 则执行如下命令卸载rootnode3 # yum -y remove mysql-libs-5.1.71 *执行如下命令安装rootnode3 # rpm -ivh MySQL-server-5.5.28-1.linux2.6.x86_64.rpmrootnode3 # rpm -ivh MySQL-client-5.5.28-1.linux2.6.x86_64.rpm2）启动 mysqlrootnode3 # service mysql start第一次运行mysql时需要对root用户设置密码：rootnode3 # mysql -urootmysqlupdate mysql.user set password=PASSWORD（root123） where User=root ;mysqlflush privileges;3 ）编辑my.cnf文件（没有则创rootnode3 # vim /etc/my.cnfmysqldserver-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服务rootnode3 # service mysql restart设置主主复制1）查看下 log-bin日志和position的位置mysql show master status;mysqL show master status;1lrFlrlrI File| Position | Binlog Do DE |BiiXoglgrioreDB|1lrFlrlr| mysql-bin,0000&5 |107h+|mysqlTinform ation_schema |4-+41 row in set (G.&0 sec2 ）创建replication用户，并给root用户赋权mysql create user replication% identified by replication;mysql grant all on *.* to replication%;mysqlgrant all privileges on *.* to root% identified by root123; mysqlgrant all privileges on *.* to rootlocalhost identified by root123; mysqlgrant all privileges on *.* to root127.0.0.1 identified by root123; mysqlflush privileges;3) 配置 Master 和 BackupMaster 的配置如下：mysql grant replication slave on *.* to replication192.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 的配置如下：mysql grant replication slave on *.* to replication192.168.83.% identifiedby replication;mysql flush privileges;mysql change master to master_host = 192.168.83.132, master_user=replication, master_password=replication, master_log_file=mysql-bin.000002, master_log_pos=107;mysql start slave;#启动同步至此主主同步配置完成，查看同步状态 Slave_IO_Running 和Slave_SQL_Running如果为YES则说明主主同步成功。mysql show slave statusG;mysql show slave statusG；床蛍事事事鬣*卑*璟床蛍輿事*辈章卑*床床蛍輿事鬣辈卑 1b厂owSlave_IO_State：Waiting if or master to send eventMaster_Host:192.168.83.132Mater_Llser!replicationMaEter_Po rt:330&Connect_Ret ry：:60Master_Lag_File：mysql.-bin.00QO05Read Master Log Pos；107Relay_Lag_File:;node3- reTLay-bin. 9S0012Rslmy_L0g_Pos:;253Relay Master Log File:mysql -ban .999095Slave_IO_Runriing :岳Slave sqL Runriing:品KaplieaTeojJE!Replic ate_Igrio r&_DE:Replicate_Da_Table：Rjeplicat&_Igniore_Ta ble：Repl icat e_Wil dl_DtD_T able：Repl icat e_Wil ?_Ignio re_T able：Last_Errno;0Last_Eo:Skip_Counter；0Exec Master Lag Pos:1G7Rjalay_Lag_Space：409Untn_Coridition:I NoneUntizL_Lag_FiLe!UnliT_Lag_Pos :! 04) 测试同步在 master 插入数据测试下：mysql use test; Database changed mysql show tables;Empy set 0.&0 sec) mysql create table user (number INT(10)jnante VARCHAR(255)- Query OK, 0 rows affected (&.05 sec) mysql insert into user valuas(01j rzhangsanr; Query OK, 1 raw affected (0.90 sec) mysql show tabiesj+E-| 7blss_in_test |+buser+E-1 row in set (0-00 5巳匚mysql在 backup 查看是否同步成功：mysql use es.tDatabase changedrnysql show tables;-i1-| Table5_in_te5t |41-use r_+1 row in set (0-00 sec)mysql select number, name front user1；H+number|name4+41|zhangsan4+1rowinse (0-90sec)mysql可以看到已经成功同步过去，同样在 backup 插入到 user 表数据，一样同步过去， 双主就做成功了。2.安装Keepalived （两台都需要安装），完成主主HA1）下载 keepalived-1.2.7.tar.gz将下载的tar文件放在/opt/mysql目录（该目录自己指定，也可以为其他目录）2）安装 keepalivedrootnode3 # yum install -y pcre-devel openssl-devel popt-devel gcc 以上依赖包，如果不存在则安装，存在则忽略在没有网络的环境下，安装过程中可能会存在openssl-devel安装不成功的情况， 此时按照如下顺序安装 rpm：1安装 keyutils-libs-l.4-5.el6.x86_64.rpm，首先卸载掉系统自带的 keyutils#rpm -e -nodeps keyutils-libs-1.4-4.el6.x86_64安装已下载的#rpm -ivh keyutils-libs-1.4-5.el6.x86_64.rpm2安装 keyutils-libs-devel-1.4-5.el6.x86_64.rpm#rpm -ivh keyutils-libs-devel-1.4-5.el6.x86_64.rpm3安装 krb5-libs-1.10.3-57.el6.x86_64.rpm，首先卸载 krb5-libs-1.10.3-10.el6_4.6.x86_64#rpm -e -nodeps