MySQL高可用性之Keepalived+MySQL

环境描述：
OS：CentOS6.5_X64
MASTER：192.168.0.202
BACKUP：192.168.0.203
VIP：192.168.0.204
1、配置两台Mysql主主同步
[root@master ~]# yum install mysql-server mysql -y
[root@master ~]# service mysqld start
[root@master ~]# mysqladmin -u root password 123.com
[root@master ~]# vi /etc/my.cnf #开启二进制日志，设置id
[mysqld]
log-bin=mysql-bin
server-id=1 #backup这台设置2
[root@master ~]# service mysqld restart#先查看下log bin日志和pos值位置master配置如下：[root@ master ~]# mysql -u root -p123.com
mysql> GRANT REPLICATION SLAVE ON *.* TO "replication"@"192.168.0.%" IDENTIFIED BY "replication";
mysql> flush privileges;
mysql> change master to
-> master_host="192.168.0.203",
-> master_user="replication",
-> master_password="replication",
-> master_log_file="mysql-bin.000002",
-> master_log_pos=106; #对端状态显示的值
mysql> start slave; #启动同步backup配置如下：[root@backup ~]# mysql -u root -p123.com
mysql> GRANT REPLICATION SLAVE ON *.* TO "replication"@"192.168.0.%" IDENTIFIED BY "replication";
mysql> flush privileges;
mysql> change master to
-> master_host="192.168.0.202",
-> master_user="replication",
-> master_password="replication",
-> master_log_file="mysql-bin.000002",
-> master_log_pos=106;
mysql> start slave;#主主同步配置完毕，查看同步状态Slave_IO和Slave_SQL是YES说明主主同步成功。在master插入数据测试下：在backup查看是否同步成功：可以看到已经成功同步过去，同样在backup插入到user表数据，一样同步过去，双主就做成功了。Keepalived 的详细介绍：请点这里
Keepalived 的下载地址：请点这里推荐阅读：CentOS 6.3下Haproxy+Keepalived+Apache配置笔记 http://www.linuxidc.com/Linux/2013-06/85598.htmHaproxy + KeepAlived 实现WEB群集 on CentOS 6 http://www.linuxidc.com/Linux/2012-03/55672.htmKeepalived+Haproxy配置高可用负载均衡 http://www.linuxidc.com/Linux/2012-03/56748.htmHaproxy+Keepalived构建高可用负载均衡 http://www.linuxidc.com/Linux/2012-03/55880.htm

Oracle10.2.0.4-RAC两节点集群环境搭建MySQL 5.6更人性化修改redo log事务日志文件大小相关资讯 keepalived MySQL高可用性

高可用集群技术之Keepalived实现（今 10:42）
轻量级Keepalived实现Nginx与LVS高（06月10日）
LVS+Keepalived使用总结（03月15日）

LVS + Keepalived 介绍及安装（08月31日）
Keepalived实现Nginx的高可用（05月19日）
Linux服务器 Keepalived双机热备实（03月11日）

本文评论查看全部评论（0）