### my.cnf ``` 主数据库修改这两项配置 server-id = 100 log_bin = /var/log/mysql/mariadb-bin 从数据库只需要修改server-id就可以 ``` ### 2.授权给从服务器 ``` GRANT REPLICATION SLAVE ON *.* to 'root'@'172.17.0.%' identified by '39c1c2217ecd8f866a5501ed35fbebe4'; ``` ### 3.查询主数据库状态 ``` show master status; MariaDB [(none)]> show master status; +--------------------+----------+--------------+------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +--------------------+----------+--------------+------------------+ | mariadb-bin.000001 | 527 | | | +--------------------+----------+--------------+------------------+ ```