### 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 | | | +--------------------+----------+--------------+------------------+ ```