[development] Advanced DB features

[Ken Rickard]

Earnie-

I did not say that we store data on the web server -- in fact, we always
keep the two separate.  I simply said that we place the datadase server on
the same network switch (in reality, on the same rack) as the web server, to
avoid latency issues.

We actually use a load-balanced web server connected to replicated MySQL.

- Ken


On Fri, May 2, 2008 at 9:13 AM, Earnie Boyd <earnie at users.sourceforge.net>
wrote:

> Quoting Ken Rickard <agentrickard at gmail.com>:
>
>  Earnie-
> >
> > (I work for one of those corporations.)
> >
> > But that 100 ms latency would only affect non-Drupal data being pulled
> > into
> > the application -- say an inventory database housed in Connecticut with
> > a
> > web app server in Georgia (actual example).
> >
> >
> I would give away too much to explain in detail but we store 100K rows of
> usage data in any given minute.  The account holders can review those rows
> real time including months of history.  The set of data is too large and too
> sensitive to store on the web server.  Just one example.  Lots of data
> everywhere.  I can't think that any of our data is actually sitting on the
> web servers except for internal use sites.
>
>
> Earnie -- http://for-my-kids.com/
> -- http://give-me-an-offer.com/
>
>


-- 
Ken Rickard
agentrickard at gmail.com
http://ken.therickards.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20080502/1c7cb913/attachment.htm