5.6的主主复制(针对单个具体的数据库)

192.168.3.9 192.168.3.6
mysql的下载网站 repo.mysql.com/yum 找到centos6的5.6 release 版本
yum 安装后 配置文件vim /etc/my.cnf

主主复制	主从复制	原始代码
[mysqld]	[mysqld]	[mysqld]
datadir=/home/mysql	datadir=/home/mysql	datadir=/home/mysql
socket=/var/lib/mysql/mysql.sock	socket=/var/lib/mysql/mysql.sock	socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log	log-error=/var/log/mysqld.log	log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid	pid-file=/var/run/mysqld/mysqld.pid	pid-file=/var/run/mysqld/mysqld.pid
server-id = 1	server-id = 1
auto-increment-increment = 2	集群内的服务器数量
auto-increment-offset = 1	数据库自动增长的起点	应各不相同避免
explicit_defaults_for_timestamp = 1
character_set_server=utf8
interactive_timeout = 57600
log-bin = mysql-bin	log-bin = mysql-bin
expire-logs-days = 100
replicate-do-db = wang #需要同步的数据库
binlog-ignore-db = mysql
binlog-ignore-db = information_schema
slave-skip-errors=all
log-slave-updates
symbolic-links=0
skip-name-resolve	skip-name-resolve	关闭域名功能，优化快速访问

主机间互相授权互相添加master 关闭相应防火墙

---

全库同步简单配置
#新增主主复制开始
binlog_format=ROW
relay_log=/var/lib/mysql/relay-log
auto-increment-increment=2
auto-increment-offset=1
sync_binlog=1
sync_master_info=1
sync_relay_log=1
sync_relay_log_info=1
#新增主主复制结束