List:General Discussion« Previous MessageNext Message »
From:Jesse Date:January 31 2007 4:55pm
Subject:Re: Replication not working?
View as plain text  
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?
>> Thanks,
>> Jesse

Replication not working?Jesse31 Jan
  • Re: Replication not working?Michael DePhillips31 Jan
  • Re: Replication not working?Jesse31 Jan
  • Re: Replication not working?Jesse31 Jan
  • Re: Replication not working?Jesse31 Jan
    • Re: Replication not working?Dan Nelson31 Jan