Mendigaum Posted January 18, 2012 Report Share Posted January 18, 2012 Gostaria de obter alguma ajuda a respeito de replicaçãoConfigurei um servidor master e um servidor slave, porém o servidor slave não está recebendo as atualizações do master.Eu exportei os 4 bancos do meu interesse com mysqldump, importei no slave e reiniciei ambos os servidores120118 9:50:20 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000004' at position 106, relay log './mysqld-relay-bin.000020' po$ 120118 9:50:20 [Note] Slave I/O thread: connected to master 'slave_user@189.123.163.51:3306', replication started in log 'mysql-bin.000004' at position 106 120118 14:34:52 [Note] Slave I/O thread killed while reading event 120118 14:34:52 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000004', position 106 120118 14:34:52 [Note] Error reading relay log event: slave SQL thread was killed mysql> SHOW SLAVE STATUS\G; *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 189.123.163.51 Master_User: slave_user Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000004 Read_Master_Log_Pos: 106 Relay_Log_File: mysqld-relay-bin.000026 Relay_Log_Pos: 243 Relay_Master_Log_File: mysql-bin.000004 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_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: 106 Relay_Log_Space: 243 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 1 row in set (0.00 sec) ERROR: No query specified Quote Link to comment Share on other sites More sharing options...
Question
Mendigaum
Gostaria de obter alguma ajuda a respeito de replicação
Configurei um servidor master e um servidor slave, porém o servidor slave não está recebendo as atualizações do master.
Eu exportei os 4 bancos do meu interesse com mysqldump, importei no slave e reiniciei ambos os servidores
Link to comment
Share on other sites
0 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.