mysql互为主从Replication.pdfVIP

mysql互为主从Replication 一、环境 系统：CentOS x64 Mysql ：Version 5.1.47 主机：A ：01 root： B ：02 root： 二、步骤 两台 MySQL均如要开启 binlog日志功能，开启方法：加入 log-bin=mysql-bin 1、主机A配置文件如下： # vi /etc/f [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-error=/var/lib/mysql/mysql.err log = /var/lib/mysql/query_log.log log-slow-queries = /var/lib/mysql/slow_query_log.log user=mysql default-character-set=utf8 init_connect=SET NAMES utf8 # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 log-bin=mysql-bin server-id=1 binlog-do-db=iccstm1 #是要记录日志的数据库 binlog-ignore-db=mysql #是不要记录日志的数据库名，多个数据库中间用逗号(,)隔开 replicate-do-db=iccstm1 replicate-ignore-db=mysql log-slave-updates #表示 如果一个MASTER 挂掉的话，另外一个马上接管；一定要加上， 否则不会把更新的记录写到二进制文件里 slave-skip-errors=all #是跳过错误，继续执行复制操作 sync_binlog=1 auto_increment_increment=2 auto_increment_offset=1 #这样 A 的auto_increment 字段产生的数值是：1, 3, 5, 7, …等 奇数 ID [client] default-character-set=utf8 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid 2、主机B配置文件如下： [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-error=/var/lib/mysql/mysql.err log = /var/lib/mysql/query_log.log log-slow-queries = /var/lib/mysql/slow_query_log.log user=mysql default-character-set=utf8 init_connect=SET NAMES utf8 # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 log-bin=mysql-bin server-id=2 binlog-do-db=iccstm1 binlog-ignore-db=mysql replicate-do-db=iccstm1 replica