目前情况:
1.系统版本都是centos mysql版本相同
2.主服务器正在运行,不能停止。
3.主服务器IP为:192.168.18.112
从服务器IP为:192.168.18.118
从服务器IP为:192.168.18.101
4.从服务器MSYQL slave 为停止状态
配置步骤:
2.在 Master 上建立一个复制用户,slave 通过这个用户来访问 Master。
mysql> grant replication slave,file on *.* to'back'@'192.168.18.118' identified by '123456';
mysql> flush privileges;
3. 设置 Master
server-id = 1
binlog-do-db = cms
binlog-ignore-db= mysql
binlog-ignore-db= test
binlog-ignore-db= dede
binlog-ignore-db= information_schema
log-slave-updates
slave-skip-errors=all
4.备份 Master 数据。
首先锁住数据,然后通过 copy 文件,生成快照完毕后,再解锁:
flush tables with read lock;
-- copy data files ...
unlock tables;
5. 在 slave 上应用先前备份的数据,并设置 salve
server-id = 2
master-host=192.168.18.112
master-user=back
master-password=123456
master-port=3306
binlog-do-db = cms
binlog-ignore-db= dede
binlog-ignore-db= doce
binlog-ignore-db= mysql
binlog-ignore-db= test
binlog-ignore-db= information_schema
log-slave-updates
slave-skip-errors=all
master-connect-retry=60
expire_logs_days=365
server-id = 1
binlog-ignore-db=mysql
replicate-same-server-id=0
auto-increment-increment = 2
auto-increment-offset = 1
server-id = 2
binlog-ignore-db=mysql
#replicate-same-server-id=0
auto-increment-increment=2
auto-increment-offset=1
master-host=222.73.248.111
master-user=replication
master-password=slave
master-port=3306
replicate-do-db = chebbs
replicate-do-db = chehome
replicate-do-db = cheuc
#replicate-do-db = cms
replicate-do-db = modoer
master-connect-retry=60 这个参数是网络断了之后重联的时间
expire_logs_days=365 设置自动清理MySQL binlog日志