MySQL Master Slave Replication Error 1062 (14/08/09更新)
- Category: 電腦相關
- Last Updated: Sunday, 10 August 2014 17:22
- Published: Wednesday, 23 July 2014 22:27
- Written by sam
安裝、設定都不難
難在除錯…
剛好閒著來看一下Replication運行的如何
想不到一看就看到GG了…
[root@ip-172-31-12-172 html]# mysql -e 'show slave status\G'
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host:
Master_User:
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mylogbin.000001
Read_Master_Log_Pos: 2193370
Relay_Log_File: mysqld-relay-bin.000002
Relay_Log_Pos: 99060
Relay_Master_Log_File: mylogbin.000001
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB: joomla
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1062