Re: Application structure for NLB

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Chris Hohmann (nospam_at_thankyou.com)
Date: 04/27/04 

Date: Tue, 27 Apr 2004 13:55:26 -0700

"J. Baute" <QQNVICFBGPKG@spammotel.com> wrote in message
news:1c1676e6.0404262302.56decca0@posting.google.com...
> "J. Baute" <WUPYRDEDAWJD@spammotel.com> wrote in message
news:<4088d097$0$10978$a0ced6e1@news.skynet.be>...
> > Hi,
> >
> > we're looking into addapting an intranet site to make it possible to
load
> > balance it.
> > Currently is consist out of 3 major parts which are
> > 1) the code
> > 2) the database with system data & user content
> > 3) html & picture files uploaded and maintainde by users (site
content)
> >
> > Currently the application is split up into to parts, where we have a
backend
> > DB server, and code & content are on the webserver.
> >
> > N° 3 is where we have a "problem". Since this content is variable,
this
> > needs to be available on all NLB'd webservers.
> > Basically it would come down to moving the content, which is now
hosted on
> > the webserver itself, to the backend DB server (or another server),
so that
> > all NLB'd server are always accessing and updating the same shared
data.
> >
> > The thing is that by doing this we are actually putting more load on
the
> > backend server, which will now also be in charge of hosting the
files,
> > indexing them, together with the serving the DB, and the NLB'd
webserver
> > will only be running the code.
> > So in fact, the part that will be load balanced, will be the least
intense
> > part. The bottleneck will be the backend server... so maybe it's
not worth
> > the trouble of LB'ing the whole thing?
> >
> > Thoughts, comments?
>
> anyone?

This is interesting. I was having a discussion recently about this very
topic. An associate of mine was arguing that we should store images,
reports and other object within the database to provide "location
agnostic" access to the files for a web farm scenario. I argued that
it's seldom appropriate to store object in the database and would rather
see references to those files stored in the database or simple use a
virtual directory mapping to provide mirrored access to the same file
share to each web node. So you can either:

1. Store the files in the database. Boo!

OR

2. Use virtual directories to provide mirrored access. Good but not
great

OR

3. Use virtual directories in combination with file references stored in
the database. Great! The best of both worlds.

HTH
-Chris Hohmann

Relevant Pages

  • Re: Calculated value dilemma
    ... I am designing a database for my charity (we are a local special needs ... and I should therefore simply calculate the balance ... Take advantage of 300 years of modern accounting practices and design ...
    (comp.databases.theory)
  • Re: Generating one table with a terabyte of data
    ... I didn't know we could split a database file group over multiple HDs. ... > Run perfmon counters to a log and analyze them after a bulk load. ... Another thing is to split the updates across file sets. ... >> loading of daily data in the fastest time. ...
    (microsoft.public.sqlserver.dts)
  • Re: Slow form, again
    ... subforms if you think the problem might lie there. ... Is the below query what the Parent form is based on? ... Removing all subforms gets the form to load in about 15 seconds. ... If it's not my database I'm not sure what to tell my co-workers and boss ...
    (microsoft.public.access.tablesdbdesign)
  • Re: ARC VT100 repair and test.
    ... perfect balance and everything was within tolerance. ... There was virtually no 2H in the distortion spectra once I de-bugged the amp, ... It isn't UL, strictly, because some of the load is distributed to ... An R69S BMW would have been a far better bike than a bloomin squaffer. ...
    (rec.audio.tubes)
  • Re: ARC VT100 repair and test.
    ... perfect balance and everything was within tolerance. ... There was no great matching of the 6DJ8 used in the amp during the tests I ... It isn't UL, strictly, because some of the load is distributed to ... The use of 8ohms connected across the 4 ohm outlets improves the load match ...
    (rec.audio.tubes)