Re: Replication: Connecting Slave and Master
Posted by:
Ryan Allen
Date: January 18, 2013 12:22PM
So I ran those and netstat as well to see what's going on.
On the slave I ran:
nmap -PN <master_local_ip> -p 3306
and that detected:
PORT STATE SERVICE VERSION
3306/tcp filtered mysql
So it found MySQL listening on 3306, but I read filtered state is a bit like an "inconclusive" result with nmap, so I did the other tests too. I ran the telnet test with:
telnet <master_local_ip> 3306
and that just spun endlessly and timed out. Then I tried:
netstat -tulpn
and that found:
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 <master_ip>:3306 0.0.0.0:* LISTEN
Now I'm confused again, because if I understand these correctly, netstat and nmap are saying the port is open and being used by mysql, right? What could have happened with telnet and back at the mysql prompt?
Subject
Views
Written By
Posted
12797
January 18, 2013 09:55AM
2646
January 18, 2013 10:53AM
1998
January 18, 2013 11:15AM
1968
January 18, 2013 11:20AM
Re: Replication: Connecting Slave and Master
1967
January 18, 2013 12:22PM
1842
January 18, 2013 12:32PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.