Slave connection to master hanging
Posted: Fri May 08, 2009 2:07 pm
I've configured a slave server to connect to a master server, but it's not working.
I'm able to connect to the master server from the slave server via the command line, so I have ruled out a firewall issue.
Here's the output of show processlist;
Now, if I restart the slave server, I'm able to view the following in the syslog:
http://www.howtoforge.com/mysql_database_replication
I'm able to connect to the master server from the slave server via the command line, so I have ruled out a firewall issue.
Here's the output of show processlist;
Code: Select all
*************************** 2. row ***************************
Id: 6067123
User: system user
Host:
db: NULL
Command: Connect
Time: 163141
State: Connecting to master
Info: NULL
*************************** 3. row ***************************
Id: 6067124
User: system user
Host:
db: NULL
Command: Connect
Time: 25414
State: Has read all relay log; waiting for the slave I/O thread to update it
Info: NULL
*************************** 4. row ***************************
So I'm not sure what the problem is. I followed the instructions for setting it up here:May 8 15:01:41 adserver mysqld[4926]: 090508 15:01:41 [Note] Slave I/O thread killed while connecting to master
May 8 15:01:41 adserver mysqld[4926]: 090508 15:01:41 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000005', position 30173784
May 8 15:01:41 adserver mysqld[4926]: 090508 15:01:41 [Note] Error reading relay log event: slave SQL thread was killed
May 8 15:01:49 adserver mysqld[4926]: 090508 15:01:49 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000005' at position 30173784, relay log './adserver-relay-bin.000003' position: 98
May 8 15:04:58 adserver mysqld[4926]: 090508 15:04:58 [ERROR] Slave I/O thread: error connecting to master 'pages_slave@xxx.xxx.xxx.xxx:3306': Error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 110' errno: 2013 retry-time: 60 retries: 86400
http://www.howtoforge.com/mysql_database_replication