《Mysql Master-Slave Replication 主从复制》由会员分享，可在线阅读，更多相关《Mysql Master-Slave Replication 主从复制（3页珍藏版）》请在装配图网上搜索。
1、MySQL Master-Slave(s) Replication 主从复制配置的步骤：Master服务器上操作：修改master的f 或者 my.ini:*注意server-id必须是唯一的1. mysqld2. log-bin=mysql-bin3. server-id=1Slave(s)服务器上操作：修改slave(s)的f 或者 my.ini:*注意server-id也必须是唯一的mysqldserver-id=2Master服务器上操作：建一个复制用的用户：mysql CREATE USER repl% IDENTIFIED BY slavepass;mysql GRANT REPL
2、ICATION SLAVE ON *.* TO repl%;这里建的用户就是repl 密码是slavepass 主机是%*下面介绍的步骤的前提是数据库是新的，而且没有正在进行的其他操作，这样就不用进行加锁和导入导出的操作了。Master服务器上操作：使用SHOW MASTER STATUS命令 查看Master 服务器的log文件状态，文件名和位置会在配置slave(s)的时候使用：mysql SHOW MASTER STATUS;+-+-+-+-+| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |+-+-+-+-+| mysql-bin
3、.000003 | 73 | test | manual,mysql |+-+-+-+-+Slave(s)服务器上操作：把Slave指向对应的mastermysql CHANGE MASTER TO - MASTER_HOST=master_host_name, - MASTER_USER=replication_user_name, - MASTER_PASSWORD=replication_password, - MASTER_LOG_FILE=recorded_log_file_name, - MASTER_LOG_POS=recorded_log_position;MASTER_HOS
4、T 就是MASTER服务器的IP或者主机名MASTER_USER和MASTER_PASSWORD 就是上面配置的用于复制的用户名和密码MASTER_LOG_FILE 和MASTER_LOG_POS 就是在Master服务器用SHOW MASTER STATUS命令查询到的File 和 Position最后启动slave就可以了：mysql start slave;可以用SHOW SLAVE STATUSG 或者 SHOW PROCESSLIST G 命令查看状态mysql SHOW SLAVE STATUSG* 1. row * Slave_IO_State: Waiting for mast
5、er to send event Master_Host: master1 Master_User: root Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 931 Relay_Log_File: slave1-relay-bin.000056 Relay_Log_Pos: 950 Relay_Master_Log_File: mysql-bin.000004 Slave_IO_Running: Yes Slave_SQL_Running: Yes Repli
6、cate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 931 Relay_Log_Space: 1365 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Ma
7、ster_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: 0mysql SHOW PROCESSLIST G;* 4. row * Id: 10 User: root Host: slave1:58371 db: NULLCommand: Binlog Dump Time: 777 State: Has sent all binlog to slave; waiting for binlog to be updated Info: NULL
Mysql Master-Slave Replication 主从复制
