server-id=1

log-bin=master-bin

binlog-format=ROW

# 以下两个为可选选项，如果要保证数据不丢失最好在清理binlog之前把要清理的日志备份，日志文件的大小根据磁盘的性能做适当的调整

expire_logs_days = 7 // binlog过期清理时间

max_binlog_size = 1G // binlog每个日志文件大小

 

max_connections = 1000

character-set-server = utf8mb4 // 配置字符集

collation-server = utf8mb4_unicode_ci // 配置字符集

// 配置不同步的库

binlog-ignore-db = mysql

binlog-ignore-db = sys

binlog-ignore-db = information_schema

binlog-ignore-db = performance_schema

systemctl restart mysqld

[mysqld]

max_connections = 1000

log_bin = slave-bin

server_id = 2

relay_log = slave-relay-bin

log_slave_updates = 1

read_only = 1

#以下两个为可选选项，如果要保证数据不丢失最好在清理binlog之前把要清理的日志备份，日志文件的大小根据磁盘的性能做适当的调整

expire_logs_days = 7 //binlog过期清理时间

max_binlog_size = 100m //binlog每个日志文件大小

 

replicate_ignore_db=information_schema

replicate_ignore_db=performance_schema

replicate_ignore_db=mysql

replicate_ignore_db=sys

mysql> show master status;

+-------------------+----------+--------------+------------------+-------------------+

| File              | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |

+-------------------+----------+--------------+------------------+-------------------+

| master-bin.000001 |      154 |              |                  |                   |

+-------------------+----------+--------------+------------------+-------------------+

1 row in set (0.00 sec)