MySql 分布式集群原理（4）relaylog相关

1.查看binlog是否开启

在MySQL5.7版本，binlog默认是不开启的。

mysql> show variables like "%relay_log%";
+---------------------------+--------------------------------+
| Variable_name             | Value                          |
+---------------------------+--------------------------------+
| max_relay_log_size        | 0                              |
| relay_log                 | /var/lib/mysql/relay-bin       |
| relay_log_basename        | /var/lib/mysql/relay-bin       |
| relay_log_index           | /var/lib/mysql/relay-bin.index |
| relay_log_info_file       | relay-log.info                 |
| relay_log_info_repository | FILE                           |
| relay_log_purge           | ON                             |
| relay_log_recovery        | OFF                            |
| relay_log_space_limit     | 0                              |
| sync_relay_log            | 10000                          |
| sync_relay_log_info       | 10000                          |
+---------------------------+--------------------------------+

2.开启relatlog

在服务器的/etc/my.cnf文件下修改，添加以下内容

server-id=2
relay-log=/var/lib/mysql/relay-bin

然后重启数据库service mysqld restart