|
On Sat, Apr 01, 2000 at 01:43:19PM -0500, Joseph Mack wrote:
> On Sat, 1 Apr 2000, jake buchholz wrote:
> > > a previous posting sounded like someone had got http and mysql realservers
> > That was me. In theory, that appeared to be the solution, but I didn't
> > have the opportunity to thoroughly test it at that point.
>
> good to know. I'd put it into the next version of the HOWTO as working.
> I'll hold off for a while :-)
>
> > on the mysql real server...
> > tcpdump dst host <VIP>
>
> I assume (since you're using VIP on the realserver) you're running VS-DR?
yep.
> > if, from an outside box, I want to connect via 'mysql -h<VIP>', the connect
> > fails, and I'm not seeing any tcpdump output on the mysql real server.
>
> can you change to VS-NAT at least for a test? you should start seeing
> packets from VIP->DIP
you know, I was _just_ about to do that, when I noticed that ipvsadm -L was
reporting the port as :3309, but tcpdump was calling it .mysql... I grepped
/etc/services, and discovered what the problem is.
mysql's port is 3306, not 3309! Damn, my discalculate eyes! I switched to
use that port, and wouldn't ya know... it actually _works_. (slaps
forehead)
Should note that mysql has entries in /etc/services on 3306 for both tcp
and udp -- not quite sure if traffic is expected via both, or if it'll
try one if the other isn't available for some reason.
> sounds like it isn't a simple 1 port service :-( and it's time to look at
> the docs. I've got a mysqld running on this machine (that I haven't
> used for 6months) and it has a unix socket (in /tmp and you can see it
> with netstat -an). Got any idea what this is doing? Is it only for the
> local client?
yep. the local mysql client will connect to the unix socket.
--
Jake Buchholz, Senior Systems Administrator : /~\
ExecPC (a Voyager.net company, NASDAQ: VOYN) : ASCII \ / Against
Voyager.net Hosting Solutions Lead R&D Engineer : Ribbon X HTML
GnuPG (PGP5/6) and PGP 2.6.2 pub keys available : Campaign / \ Mail
|
