本文主要是介绍mysql主主复制配置，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
1、原理：两个主服务建立二进制日志和relay-log，主服务器建立复制账号供另一个主服务器来连接监听用，另一个主服务器也建立复制账号提供主服务器连接监听2.建立mysql在两个主节点master(192.168.1.110)和slave1(192.168.1.111)复制
1)配置master(192.168.1.110)和slave1(192.168.1.111)的my.cnf的配置信息（需要配置主机名、二进制文件、二进制文件格式和relay-log）
master(192.168.1.110)：/etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#skip-grant-tables
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
#server-id
server-id=110
#binary log
log-bin=mysql-bin
#statement row mixed
binlog-format=mixed
#relay log
relay-log=mysql-relay
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
slave1(192.168.1.111):/etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
#server-id
server-id=111
log-bin=mysql-bin
binlog-format=mixed
#relay log
relay-log=mysql-relay
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
**重启master(192.168.1.110)和slave1(192.168.1.111)的mysql，目的重启加载配置信息
[root@master ~]# service mysqld restart
[root@slave1 mysql]# service mysqld restart
2)master(192.168.1.110) 和slave1(192.168.1.111)建立授权账号：
master(192.168.1.110):mysql> grant replication client, replication slave on *.* to 'root'@'%' identified by '123456';
master(192.168.1.110):mysql> flush privileges;
slave1(192.168.1.111)：mysql> grant replication client, replication slave on *.* to 'root'@'%' identified by '123456';
slave1(192.168.1.111)：mysql> flush privileges;
3)master(192.168.1.110)建立slave1(192.168.1.111)复制信息；slave1(192.168.1.111)建立master(192.168.1.110)复制信息
a.master(192.168.1.110)要需要建立slave1(192.168.1.111)复制信息,即在master(192.168.1.110)中建立slave信息，启动slave（mysql>start slave）就可以从slave1(192.168.1.111)监听复制变化的二进制文件信息：
//查看slave1(192.168.1.111)的master信息：
slave1(192.168.1.111):mysql> show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000003 | 268 | | |
+------------------+----------+--------------+------------------+
master(192.168.1.110)需要在slave配置复制slave1(192.168.1.111)的信息为：
master_host='192.168.1.111'
master_user='root'
master_password='123456'
master_log_file='mysql-bin.000003'
master_log_pos=268
master(192.168.1.110):mysql>change master to master_host='192.168.1.111', master_user='root', master_password='123456',master_log_file='mysql-bin.000003',master_log_pos=268;
master(192.168.1.110):mysql>start slave;
b.同理slave1(192.168.1.111)建立master(192.168.1.110)复制信息
master(192.168.1.110)：mysql> show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000005 | 268 | | |
+------------------+----------+--------------+------------------+
slave1(192.168.1.111):mysql>change master to master_host='192.168.1.110', master_user='root', master_password='123456',master_log_file='mysql-bin.000005',master_log_pos=268;
c.启动各自配置好的slave进行互相复制监听
master(192.168.1.110):mysql> start slave
slave1(192.168.1.111):mysql> start slave
这篇关于mysql主主复制配置的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
