以主備都在一臺機器上為例,平臺為windows,主備庫都在D盤,分別名為mysql和mysql-slave 主庫上創建復制賬號 ~~~ GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'repl'@'127.0.0.1' IDENTIFIED BY 'password'; ~~~ 修改主庫和備庫配置文件 master的my.ini(linux為my.cnf) ~~~ log-bin=D:/mysql/mysql-bin server_id=488 #server_id不要和slave重復即可 sync_binlog=1 #MySQL提交事務前會將二進制日志同步到磁盤上 ~~~ slave的my.ini ~~~ log-bin=D:/mysql-slave/mysql-bin server_id=489 relay_log=D:/mysql-slave/mysql-relay-bin #中繼日志位置 read_only=1 log_slave_updates=1 ~~~ 啟動復制 ~~~ CHANGE MASTER TO MASTER_HOST='192.168.1.152', MASTER_USER='repl', MASTER_PASSWORD='password', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=8; ~~~ MASTER_LOG_FILE和MASTER_LOG_POS可以通過show master status查看 開始復制 ~~~ START SLAVE ~~~ 查看復制狀態 ~~~ SHOW SLAVE STATUS\G ~~~ 可以看到(舉例) ~~~ *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 127.0.0.1 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000001 Read_Master_Log_Pos: 8s //#同步讀取二進制日志的位置，大于等于Exec_Master_Log_Pos Relay_Log_File: mysql-relay-bin.000001 Relay_Log_Pos: 251 Relay_Master_Log_File: mysql-bin.000001 Slave_IO_Running: Yes Slave_SQL_Running: Yes 當Slave_IO_Running和Slave_SQL_Running都是Yes時,表示復制正在運行 ~~~