Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have problem connecting my slave to master. In past it was working fine and since I restart my master then slave cannot connect.

I checked the slave user on master all good. Everything on slave is the way it suppose to be. but everytime I start the slave my ID Thread is not connecting to master.

Any idea?

share|improve this question
    
Why would you edit his post like that? –  Kyle Buser Sep 14 '10 at 18:16
    
I corrected tags and made minor grammatical corrections. What do you take exception to, @KyleBuser? –  Warner Sep 14 '10 at 18:20
    
Deleted his Thanks and added typo in the title. I understand the tags, but the other stuff, just wondering why even bother ;o –  Kyle Buser Sep 14 '10 at 18:43
    
My edit was primarily for the tags. mysql tags are well organized and I would like to keep it that way. –  Warner Sep 14 '10 at 19:02
add comment

2 Answers

up vote 1 down vote accepted

You probably have the Slave_IO_Running but not the Slave_SQL_Running. In other words, binlogs are updating but queries aren't running. You can verify this with SHOW SLAVE STATUS\G.

Execute stop slave; and then start slave; on the slave to restart both IO and SQL.

Otherwise, produce any errors in the SHOW SLAVE STATUS and the error log, and I will be able to provide further recommendation.

share|improve this answer
    
the issue was the firewall. I could get connected to my master because the firewall was blocking me. Thanks for your comment. –  IDS-master Sep 14 '10 at 21:06
add comment

Can you give the print out from both SHOW MASTER STATUS\G and SHOW SLAVE STATUS\G on the respective servers.

Have you checked the logs yet? Specifically: /var/lib/mysql/[servername].err

I had the same thing happen to me after a restart, what I ended up having to do was reset the replication so that it used a new bin log file.

share|improve this answer
    
the issue was the firewall. I could get connected to my master because the firewall was blocking me. Thanks for your comment. –  IDS-master Sep 14 '10 at 21:06
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.