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.

During my master to master replication, I got a problem on telnet. After fixing it also my replication on both side doesn't work. Master 2 replicates all the database of Master 1 but Master 1 is unable to replicate it. When I see "netstat" command on Master 2, it shows Time_wait.

C:\Users\xxxx>netstat

Active Connections

  Proto  Local Address          Foreign Address        State
  TCP    Master 2:3306        Master 1:55907      TIME_WAIT
  TCP    Master 2:3306        Master 1:55908      TIME_WAIT
  TCP    Master 2:3306        Master 1:55909      TIME_WAIT
  TCP    Master 2:3389        xxxxx:50189         ESTABLISHED
  TCP    Master 2:38690       Master 1:3306       ESTABLISHED"

What could be the possible solution. I am working on replication from past 2 weeks, and I am in serious trouble. Please hel pme

share|improve this question
    
Is anything displaying in the MySQL logs? Please post. –  bmurtagh Oct 26 '12 at 13:59
    
If you don't mind, then you tell me where could I find MYSQL logs. In my UI of MYSQL , it says like this : your current log destination is set to file. for logs to be viewed within workbench they mus tbe configured to be sent to table. this option is only available in mysql version 5.1 and newer. –  Mainio Oct 26 '12 at 14:11
    
You'd have to login to the server and view the my.cnf for to know the absolute path to the logs. Typically on a Linux server it is in /var/log/mysql/ –  bmurtagh Oct 26 '12 at 14:24

1 Answer 1

up vote 0 down vote accepted

I resolved my problem. Actually my password of replication was different and during configuration I put the same password on both end. Later on checking my master.config I found the problem and it is working fine now :). Thank you for your support.

share|improve this answer

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.