如何配置mysql双主_Mysql双主配置

最近 网站和其他的应用服务器共用数据库 耦合上出了点问题   问题找了几天都没找出来 在迫于无赖的情况下 准备做双主  在正准备跑线上的时候 问题解决了  双主方案没用到 这里贴出来 记录一下

双主和主从配置差不多，但里面还是很多参数没搞清楚。

----------------------------------------------

授权用户

mysql> grant replication slave,reload,super on *.* to sea@192.168.1.204 identified by 'sea';

mysql> flush privileges;

B：

mysql> grant replication slave,reload,super on *.* to sea@192.168.1.204 identified by 'sea';

mysql> flush privileges;

A:my.cnf

log-bin=/var/log/mysql/mysql-bin.log

server-id = 1

binlog-ignore-db=mysql

binlog-ignore-db=information_schema

binlog-do-db=www

replicate-ignore-db=informattion

replicate-ignore-db=mysql

replicate-do-db=www

log-slave-updates

slave-skip-errors=all

sync_binlog=1

auto_increment_increment=2

auto_increment_offset=1

B:my.cnf

log-bin=/var/log/mysql/mysql-bin.log

server-id = 2

binlog-ignore-db=mysql

binlog-ignore-db=information_schema

binlog-do-db=www

replicate-ignore-db=informattion

replicate-ignore-db=mysql

replicate-do-db=www

log-slave-updates

slave-skip-errors=all

sync_binlog=1

auto_increment_increment=2

auto_increment_offset=2

------- 查看偏移点 ----------------

slave stop;

CHANGE MASTER TO MASTER_HOST='192.168.1.204', MASTER_USER='sea', MASTER_PASSWORD='sea',MASTER_LOG_FILE='mysql-bin.000001',MASTER_LOG_POS=106;

slave start ;

slave stop;

CHANGE MASTER TO MASTER_HOST='192.168.1.206', MASTER_USER='sea', MASTER_PASSWORD='sea',MASTER_LOG_FILE='mysql-bin.000001',MASTER_LOG_POS=983;

slave start ;

---------------------

mysqldump -uroot -p mydb > /root/db.sql

scp -P 22 db.sql root@192.168.1.204:/root/

use mydb;

source /root/db.sql;

-------------------------------------------------

最后 测试~A删除添加 B同步了

B更新 删除 添加 A也同步

只是没拿到线上跑  不知道会不会出什么问题