1
2
3
4
5
6
7
8
9
10
|
server-
id
= 1
log-bin=mysql-bin
# 打开二进制日志功能,作为主库时必须设置
log-slave-updates
# 做为从库时,数据库的修改也会写到bin-log里
binlog-ignore-db = mysql
binlog-ignore-db = information_schema
binlog-ignore-db = performance_schema
replicate-wild-ignore-table = mysql.%
replicate-wild-ignore-table = information_schema.%
replicate-wild-ignore-table = performance_schema.%
expire_logs_days=5
# 表示自动删除5天以前的binlog,可选
|
1
2
3
4
5
6
7
8
9
10
|
server-
id
= 2
log-bin=mysql-bin
log-slave-updates
binlog-ignore-db = mysql
binlog-ignore-db = information_schema
binlog-ignore-db = performance_schema
replicate-wild-ignore-table = mysql.%
replicate-wild-ignore-table = information_schema.%
replicate-wild-ignore-table = performance_schema.%
expire_logs_days=5
|
1
2
|
>
GRANT
REPLICATION SLAVE
ON
*.*
TO
'repl_user'
@
'172.16.4.%'
IDENTIFIED
BY
'MNVq_YOg9'
;
> FLUSH
PRIVILEGES
;
|
1
2
3
|
> reset master;(清空master的binlog,平时慎用,可选)
> flush tables
with
read
lock;
> show master status;
|
1
2
3
4
|
> stop slave;
> CHANGE MASTER
TO
MASTER_HOST=
'172.16.4.235'
, MASTER_USER=
'repl_user'
, MASTER_PASSWORD=
'MNVq_YOg9'
, MASTER_LOG_FILE=
'mysql-bin.000001'
, MASTER_LOG_POS=120;
> start slave;
> show slave status\G
|
1
2
3
|
> reset master;(清空master的binlog,平时慎用,可选)
> flush tables
with
read
lock;
> show master status;
|
1
2
3
4
5
|
> unlock tables;
> stop slave;
> CHANGE MASTER
TO
MASTER_HOST=
'172.16.4.236'
, MASTER_USER=
'repl_user'
, MASTER_PASSWORD=
'MNVq_YOg9'
, MASTER_LOG_FILE=
'mysql-bin.000001'
, MASTER_LOG_POS=120;
> start slave;
> show slave status\G
|
1
|
> unlock tables;
|
1
2
3
|
> INSTALL PLUGIN rpl_semi_sync_master SONAME
'semisync_master.so'
;
> INSTALL PLUGIN rpl_semi_sync_slave SONAME
'semisync_slave.so'
;
> show variables
like
'%semi%'
;
|
1
2
|
>
SET
GLOBAL
rpl_semi_sync_master_enabled = 1;
>
SET
GLOBAL
rpl_semi_sync_slave_enabled = 1;
|
1
2
|
rpl_semi_sync_master_enabled = 1
rpl_semi_sync_slave_enabled = 1
|
1
2
|
> stop slave;start slave;
> show status
like
'%semi%'
;
|