15 to 8.0.x. Authority required 1. Enable binlog MySQL 5.7 my.cnf configuration sample: [mysqld] server-id=1 log-bin=mysql-bin binlog-format=row binlog-row-image=full max_connections=600 Run the following command and check whether binlog is enabled. show variables like '%log_bin%'; show variables like '%binlog%'; If the following information is displayed, binlog is enabled. +----------------- ---------------------+---------------------------------------+ | log_bin | ON | | binlog_format | ROW | | binlog_row_image | FULL | +-----------------------------------------+---------------------------------------+

8.0.x. Authority required 1. Enable binlog in source MySQL 5.7 my.cnf configuration sample: [mysqld] server-id=1 log-bin=mysql-bin binlog-format=row binlog-row-image=full max_connections=600 Run following command and check whether binlog is enabled. show variables like '%log_bin%'; show variables like '%binlog%'; If the following information is displayed, binlog is enabled. +----------------- 9.2. ShardingSphere-Proxy 375 Apache ShardingSphere document | log_bin | ON | | binlog_format | ROW | | binlog_row_image | FULL | +-----------------------------------------+---------------------------------------+

document 权限要求 1. 源端开启 binlog MySQL 5.7 my.cnf 示例配置： [mysqld] server-id=1 log-bin=mysql-bin binlog-format=row binlog-row-image=full max_connections=600 执行以下命令，确认是否有开启 binlog： show variables like like '%log_bin%'; show variables like '%binlog%'; 如以下显示，则说明 binlog 已开启 +-----------------------------------------+---------------------------------------+ | Variable_name | Value | +---------------- ---------------------+---------------------------------------+ | log_bin | ON | | binlog_format | ROW | | binlog_row_image | FULL | +-----------------------------------------+---------------------------------------+

8.0.x。 权限要求 1. 源端开启 binlog MySQL 5.7 my.cnf 示例配置： [mysqld] server-id=1 log-bin=mysql-bin binlog-format=row binlog-row-image=full max_connections=600 执行以下命令，确认是否有开启 binlog： show variables like like '%log_bin%'; show variables like '%binlog%'; 如以下显示，则说明 binlog 已开启 +-----------------------------------------+---------------------------------------+ | Variable_name | Value | +---------------- ---------------------+---------------------------------------+ | log_bin | ON | | binlog_format | ROW | | binlog_row_image | FULL | +-----------------------------------------+---------------------------------------+

manually. Privileges MySQL 1. Enable binlog Configuration Example of MySQL 5.7 my.cnf: [mysqld] server-id=1 log-bin=mysql-bin binlog-format=row binlog-row-image=full max_connections=600 Execute the following SQL to confirm whether binlog is turned on or not: show variables like '%log_bin%'; show variables like '%binlog%'; As shown below, it means binlog has been turned on: +-------------- ---------------------+---------------------------------------+ | log_bin | ON | | binlog_format | ROW | | binlog_row_image | FULL | +-----------------------------------------+---------------------------------------+

15 to 5.7.x. Authority required 1. Enable binlog MySQL 5.7 my.cnf configuration sample: [mysqld] server-id=1 log-bin=mysql-bin binlog-format=row binlog-row-image=full max_connections=600 Run the following command and check whether binlog is enabled. show variables like '%log_bin%'; show variables like '%binlog%'; If the following information is displayed, binlog is enabled. +----------------- ---------------------+---------------------------------------+ | log_bin | ON | | binlog_format | ROW | | binlog_row_image | FULL | +-----------------------------------------+---------------------------------------+

document Authority required 1. Enable binlog in source MySQL 5.7 my.cnf configuration sample: [mysqld] server-id=1 log-bin=mysql-bin binlog-format=row binlog-row-image=full max_connections=600 Run following command and check whether binlog is enabled. show variables like '%log_bin%'; show variables like '%binlog%'; If the following information is displayed, binlog is enabled. +----------------- ---------------------+---------------------------------------+ | log_bin | ON | | binlog_format | ROW | | binlog_row_image | FULL | +-----------------------------------------+---------------------------------------+

manually. Privileges MySQL 1. Enable binlog Configuration Example of MySQL 5.7 my.cnf: [mysqld] server-id=1 log-bin=mysql-bin binlog-format=row binlog-row-image=full max_connections=600 Execute the following SQL to confirm whether binlog is turned on or not: show variables like '%log_bin%'; show variables like '%binlog%'; As shown below, it means binlog has been turned on: +-------------- ---------------------+---------------------------------------+ | log_bin | ON | | binlog_format | ROW | | binlog_row_image | FULL | +-----------------------------------------+---------------------------------------+

8.0.x。 权限要求 1. 源端开启 binlog MySQL 5.7 my.cnf 示例配置： [mysqld] server-id=1 log-bin=mysql-bin binlog-format=row binlog-row-image=full max_connections=600 执行以下命令，确认是否有开启 binlog： show variables like like '%log_bin%'; show variables like '%binlog%'; 如以下显示，则说明 binlog 已开启 +-----------------------------------------+---------------------------------------+ | Variable_name | Value | +---------------- ---------------------+---------------------------------------+ | log_bin | ON | | binlog_format | ROW | | binlog_row_image | FULL | +-----------------------------------------+---------------------------------------+

1 权限要求 MySQL 1. 开启 binlog MySQL 5.7 my.cnf 示例配置： [mysqld] server-id=1 log-bin=mysql-bin binlog-format=row binlog-row-image=full max_connections=600 执行以下命令，确认是否有开启 binlog： show variables like like '%log_bin%'; show variables like '%binlog%'; 如以下显示，则说明 binlog 已开启 +-----------------------------------------+---------------------------------------+ | Variable_name | Value | +---------------- ---------------------+---------------------------------------+ | log_bin | ON | | binlog_format | ROW | | binlog_row_image | FULL | +-----------------------------------------+---------------------------------------+