ubuntumysql互为主从配置

《ubuntumysql互为主从配置》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Mysql主主复制一、环境描述服务器A  192.168.1.108      服务器B  192.168.1.110      Mysql版本：5.1.26      SystemOS：CentOSrelease5.4 二、主主配置过程 1、创建同步用户：  服务器A：        grantreplicationslave,fileon*.*to'replication'@'192.168.1.110'identifiedby'123456';flushprivileges;服务器B：grantreplicationslave,fi

2、leon*.*to'replication'@'192.168.1.108'identifiedby'123456';flushprivileges;2、修改mysql配置文件  A：server-id=1log_bin=/var/log/mysql/mysql-bin.logexpire_logs_days=10max_binlog_size=100Mbinlog_do_db=testbinlog_ignore_db=mysqlreplicate-do-db=testreplicate-ignore-db=mysqllog_slave_

3、updatessync_binlog=1auto_increment_increment=2uto_increment_offset=1  B：server-id=2log_bin=/var/log/mysql/mysql-bin.logexpire_logs_days=10max_binlog_size=100Mbinlog_do_db=testbinlog_ignore_db=mysqlreplicate-do-db=testreplicate-ignore-db=mysqllog_slave_updatessync_binlog=1

4、auto_increment_increment=2uto_increment_offset=2 参数选项说明：log-slave-updates  将执行的复制sql记录到二进制日志sync_binlog 当有二进制日志写入binlog文件的时候，mysql服务器将它同步到磁盘上auto_increment_increment，auto_increment_offset主要用于主主复制中，用来控制AUTO_INCREMENT列的操作      3、重启mysql服务后，进入mysql命令行，执行操作如下：  A:   mysql>flu

5、shtableswithreadlock;   mysql>showmasterstatusG***************************1.row***************************           File:mysql-bin.000028           Position:866                 Binlog_Do_DB:testBinlog_Ignore_DB:mysql1rowinset(0.00sec)       mysql>unlocktables;          

6、   mysql>stopslave;mysql>changemastertomaster_host='192.168.1.110',master_user='replication',master_password='123456',master_log_file='mysql-bin.000014',master_log_pos=704;             mysql>startslave;              B：   mysql>flushtableswithreadlock;   mysql>showmasterst

7、atusG***************************1.row***************************           File:mysql-bin.000014           Position:704                 Binlog_Do_DB:testBinlog_Ignore_DB:mysql1rowinset(0.00sec)       mysql>unlocktables;             mysql>stopslave;mysql>changemastertomas

8、ter_host='192.168.1.108',master_user='replication',master_password='123456',master_log_file='mys