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
'[EMAIL PROTECTED]: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?
Thanks,
Jesse
----- Original Message -----
From: "Michael DePhillips" <[EMAIL PROTECTED]>
To: "Jesse" <[EMAIL PROTECTED]>
Cc: "MySQL List" <mysql@lists.mysql.com>
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
