|
On Wed, Mar 15, 2000 at 11:38:23AM -0800, Brad Cox wrote:
> > > > 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...
> > > got it. Have't thought clearly about this (and haven't tested it)
> > > but I expect you'll have to have another copy of mysql
> > > listening on the IP of the realserver (RIP)
> > > This is not particularly subtle I'll admit
> >
> > Not really a viable option for me, unfortunately... webs are served from
> > 2 or more web real-servers, but need to reference just one mysql real-
> > server (the same mysql data can't be hosted from more than one mysql
> > server). different webs on the same web real-server may need to access
> > different mysql real-servers...
>
> If your mysql data can only be on one real server, why are you trying to
> get to it via lvs at all?
we're developing a web farm and want to be able to distribute customer
databases across a set of mysql real-servers. If we remove a mysql
real-server for some reason, it's just a matter of redirecting those
mysql databases among the remaining machines. Likewise, if we add a
new mysql real-server, we can re-balance the redirects across all
available machines instead of having N-1 being busy and 1 more-or-less
unused...
--
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
|
