On Tue, Mar 14, 2000 at 08:49:52PM -0500, Joseph Mack wrote:
> On Tue, 14 Mar 2000, jake buchholz wrote:
> > What I need to be able to do is 'hop' ports across the real servers,
> > i.e. forward the mysql connection port from the web servers over to the
> > mysql servers.
>
> I don't understand what you're doing here. Can you explain this again.
kernels: 2.2.14 + lvs 0.9.7
lvs-director:
- eth0 = public lvs-director ip
- eth0: aliases = virtual ip's
- eth1 = private net lvs-director ip
- connections to virtual ip ports are round-robin load-balanced via
direct routing to real-servers, based on port. That is, for each
virtual ip...
. mysql (3309) goes to one mysql real-server
. http (80) goes to multiple web real-servers
. telnet (23) and ssh (22) go to one shell real-server
. ftp (20/21) go to one ftp real-server
real-server:
- eth0 = public real-server ip
- lo: aliases = virtual ip's
- eth1 = private real-server ip
The problem: When a CGI (or PHP) on the web real-server wants to make a
mysql connection (or a user on the shell server wants to connect via the
'mysql' client program), the virtual ip for that connection exists on the
local machine, where no mysqld is running to connect to.
I need to find some way to forward/tunnel/? virtual-ip:3309 off the web
and shell real-servers over to the appropriate mysql real-server where
it can be properly serviced...
--
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
|