Show Slave Status returns a bunch of stuff that I can't view in the command
line utility. When I use a visual tool, it shows me a bunch of different
fields, but I didn't see anything that looked like an error.
Slave_IO_State = "Connecting to master". Last_Errno is 0. So, from that
perspective, everything looks OK.
The last entry in the log was as follows:
070130 17:34:43 [ERROR] Slave I/O thread: error connecting to master
'Replication@Anchorman:3306': Error: 'Can't connect to MySQL server on
'Anchorman' (10061)' errno: 2003 retry-time: 60 retries: 86400
I think that is the problem. When setting up a replication user account, it
asks for "host", so I put my local server's name in there. Actually, that is
"host you will be making the connection from". So, I changed it to that
machine's name, and I've been abel to connect using that user name and
password now. I don't know if this has now stopped replication. If so, how
do I restart it?
----- Original Message -----
From: "Michael DePhillips" <dephilli@stripped>
To: "Jesse" <jlc@stripped>
Cc: "MySQL List" <mysql@stripped>
Sent: Tuesday, January 30, 2007 7:57 PM
Subject: Re: Replication not working?
> Should be almost instantaneous. Do a show slave status on the
> slave....also check the error log.
> Jesse wrote:
>> I'm playing with setting up replication on two MySQL Servers that I have
>> set up here. I set it up according to the instructions found on the
>> MySQL web site, then I went in on the master and added a new record to
>> one of the tables, then checked the slave about 30 minutes later, and the
>> record has not appeared. How often does the slave check for new records
>> on the master? Also, is there some location that I can check for errors?