Re: Distributed Database

From: Neil Horman (nhorman_at_rNeOdShPaMt.com)
Date: 12/16/03 

Date: Tue, 16 Dec 2003 08:14:28 -0500

Alan Connor wrote:
> Let's say that I have a database distributed among 20 boxes, all at different
> locations with different IPs.
>
> The full database takes only 5 of these boxes, so there are 3 mirrors.
>
> Can someone tell me the best way to set things up so that a client can
> just enter a URL and access whichever group of 5 boxes currently isn't
> being used to capacity? How to connect those 5 boxes together so that
> they are effectively ONE box?
>
DNS is a cheap solution. Several name server packages provide features
(or at least have patches available) to allow you to specify some level
of load balancing policy, be it a simple round robin approach, or
something a little more complex. It takes a little work to set up, and
it can get a little askew, as once a DNS lookup is cached by a client
there is no rebalancing available to the system

Alternatively there are professional hardware/software solutions to do
this. IBM offers websphere (I think) which enables this sort of
transparent load balancing feature, and it appears as one IP address to
the outside world, so multiple accesses from the same client can be
reblanaced as needed. Expect to pay corporate prices for this though.

HTH
Neil 

-- 
  Neil Horman
  Red Hat, Inc., http://people.redhat.com/nhorman
  gpg keyid: 1024D / 0x92A74FA1, http://www.keyserver.net

Relevant Pages

  • XP Pro Client wont accept incoming RDP Connection
    ... Posted the following in our local NG yesterday - despite helpful advice, ... Money-conscious SB Client buys 2 XP Pro clones from local PC shop, ... We reset the local security settings. ... These boxes do run Autocad with a fancy graphics card feeding 28" LCD ...
    (microsoft.public.windows.server.sbs)
  • Re: Security log chaos -
    ... I did not know about the AD client for the 9x boxes. ... do not have it setup on the server at all. ... >win9x machines not getting the correct wins server addresses from the dhcp ...
    (microsoft.public.backoffice.smallbiz)
  • Re: Distributed Database
    ... >> Let's say that I have a database distributed among 20 boxes, ... >> Can someone tell me the best way to set things up so that a client can ... > transparent load balancing feature, and it appears as one IP address to ... Thanks Neil. ...
    (comp.os.linux.networking)
  • Check box checking & application loads slow
    ... Two problems I'd appreciate any suggestions with [VFP8, XP(dev and client)]: ... At some point when using the check boxes on a pageframe they don't check ... Default data session of the initial formset - dataload method ...
    (microsoft.public.fox.programmer.exchange)
  • Re: RTM_LOSING: Kernel Suspects Partitioning
    ... The DS10 is connected two times to a layer3 switch (autonegotiation ... turned off) - the problem is the same when I connect the client to the ... the fx-uplink on the switch or connect only the two boxes with a hub. ... inet xx.xx.xx.5 netmask ffffff00 broadcast xx.xx.xx.255 ipmtu ...
    (comp.unix.tru64)