MySQL Forums
Forum List  »  Replication

Error connecting to master
Posted by: Andreas Otto
Date: February 13, 2008 10:21AM

Hi,

I have just started to use replication and try to get a master - slave replication to work.

I thought I have followed the manual but I can't get it to work.

The error log says:
080213 17:08:47 [ERROR] Slave I/O thread: error connecting to master 'replication@xxx.xxx.xxx.xxx:3306': Error: 'Lost connection to MySQL server during query' errno: 2013 retry-time: 60 retries: 86400

mysql> SHOW SLAVE STATUS\G;
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: xxx.xxx.xxx.xxx
Master_User: replication
Master_Port: 3306
Connect_Retry: 60
Master_Log_File:
Read_Master_Log_Pos: 4
Relay_Log_File: mysql-relay.000001
Relay_Log_Pos: 98
Relay_Master_Log_File:
Slave_IO_Running: No
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: 0
Relay_Log_Space: 98
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: NULL


mysql> SHOW MASTER STATUS\G;
*************************** 1. row ***************************
File: mysql-bin.000001
Position: 30401
Binlog_Do_DB:
Binlog_Ignore_DB:


Any ideas what might be wrong?


Cheers,
Andreas

Options: ReplyQuote


Subject
Views
Written By
Posted
Error connecting to master
11393
February 13, 2008 10:21AM
3560
February 14, 2008 06:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.