1. vim /etc/my.cnf
    2. #添加如下配置
    3. server-id=1 #服务器id (主从必须不一样)，爱写啥写啥，别太离谱就行
    4. log-bin=mysql-bin  #打开日志(主机需要打开)，这个mysql-bin也可以自定义，这里也可以加上路径
    5. #作为主机的配置
    6. binlog-do-db=master  #要给从机同步的库
    7. binlog-ignore-db=mysql  #不给从机同步的库(多个写多行)
    8. binlog-ignore-db=information_schema
    9. binlog-ignore-db=performance_schema
    10. binlog-ignore-db=sys
    11. expire_logs_days=7  #自动清理 7 天前的log文件,可根据需要修改
    1. cd /usr/local/mysql/bin
    2. service mysqld restart
    1. create user 'backup'@'localhost' identified by 'Bonc@20211220';
    2. grant replication slave on *.* to 'backup'@'%';
    3. flush privileges;
    4. ##在主服务器上查看当前二进制文件（从库配置时需要使用）
    5. show master status\G #
    1. vim /etc/my.cnf 
    2. #添加下面几行
    3. server_id=2
    4. master_info_repository=TABLE
    5. relay_log_info_repository=TABLE
    1. mysql> stop slave;
    2. Query OK, 0 rows affected, 1 warning (0.00 sec)
    3. mysql> change master to
    4.     -> master_host='10.8.18.73',
    5.     ->  master_user='backup',
    6.     -> master_password='123456',
    7.     ->  master_log_file='mysql-bin.000001',
    8.     -> master_log_pos=610;
    9. Query OK, 0 rows affected, 2 warnings (0.03 sec)

    mysql> start slave;
    Query OK, 0 rows affected (0.00 sec)