|
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?
tcpdump is a little tricky since the packets from the director to the
realserver go via the linklayer and you wont see them with tcpdump
(unless there's something about tcpdump I don't know). The only mysql
packets you'll see on the realserver will have src=VIP,dst=CIP
> 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
> on the redirector...
>
> tcpdump host <RIP> or host <VIP>
>
> from an outside box trying to connect via 'mysql -h<VIP>', I'm seeing two
> lines:
>
> 12:52:52.654440 eth0 < <OIP>.62710 > <VIP>.mysql: S 2856299978:2856299978(0)
> win 32120 <mss 1460,sackOK,timestamp 264231195 0,nop,wscale 0> (DF)
> 12:52:52.654481 eth0 > <VIP>.mysql > <OIP>.62710: R 0:0(0) ack 2856299979 win > 0
so the director is listening to port=mysql
> here's the ipvsadm -L info:
>
> TCP <VIP>:3309 rr
> -> <RIP>:3309 Route 1 0 0
OK
> > > the LVS -> real server for databases are 1:1.
> > I'm sorry I don't know what this means
>
> One mysql <VIP> -> one mysql <RIP>
you've got a one realserver mysqld LVS.
> > so need a monitor for mysqld?
>
> Not really.
it should be easy enough to write one when we need it.
> > I would expect that multiple mysqlds will have to access the same
> > file system (eg by nfs, other people are talking about gfs, but I
> > don't know if anyone has got it to work with LVS yet)
>
> Haven't heard about gfs, but yes, the databases are served to the mysql real
> servers via nfs.
be prepared in case of data corruption
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?
Joe
--
Joseph Mack mack@xxxxxxxxxxx
|
