Sorry, I hit send before I was actually done. So.... Given the error I am
070131 11:53:55 [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
There are a couple of issues hwere. Primary is that it's trying to connect
on port 3306. I'm actually using 3307, but can't seem to find where I
change this setting. Have any suggestions?
----- 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?