MySQL双主配置

原创

151wqooo 2013-08-01 12:13:45 博主文章分类：MySQL ©著作权

文章标签 MySQL 双主 文章分类 MySQL 数据库

©著作权归作者所有：来自51CTO博客作者151wqooo的原创作品，请联系作者获取转载授权，否则将追究法律责任

一、ip划分

server1_mysql：192.168.10.63

server2_mysql: 192.168.10.64

二、MySQL安装

yuminstall mysql

yuminstall mysql-server

yum install mysql-devel

关闭防火墙

/etc/init.d/iptables stop

关闭SElinux

/usr/sbin/setenforce 0

echo "/usr/sbin/setenforce 0" >> /etc/rc.local

或者：

vim /etc/selinux/config

SELINUX=disabled

三、创建用户并授权

server1:

mysql> GRANT REPLICATION SLAVE ON *.* TO'aixue'@'192.168.10.64' IDENTIFIED BY '123456';

server2：

mysql> GRANT REPLICATION SLAVE ON *.* TO'aixue'@'192.168.10.63' IDENTIFIED BY '123456';

四、修改my.cnf配置文件

Server1：

[mysqld]
server-id= 10
log-bin =mysql-bin
binlog-do-db=aixue
binlog-ignore-db=mysql
binlog-ignore-db=information_schema
auto-increment-increment= 2
auto-increment-offset = 1

# service mysqld restart

Server2：

[mysqld]
server-id = 20
log-bin = mysql-bin
binlog-do-db=aixue
binlog-ignore-db=mysql
binlog-ignore-db= information_schema
auto-increment-increment = 2
auto-increment-offset = 2

# service mysqld restart

五、两数据库数据同步

Server1:

mysqldump -A -x > /tmp/full.sql

#scp /tmp/full.sql root@192.168.10.64:/tmp/

Server2:

#mysql –u root –p < /tmp/full.sql

六、启用复制功能

Server1：

>CHANGE MASTER TO MASTER_HOST='192.168.10.64',MASTER_USER='aixue',MASTER_PASSWORD='123456';

>start slave;

Server2：