Re: Hardware recommendations to scale to silly load

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: Hardware recommendations to scale to silly load
Дата
Msg-id x7d6ejb2c0.fsf@yertle.int.kciLink.com
обсуждение исходный текст
Ответ на Re: Hardware recommendations to scale to silly load  ("Matt Clark" <matt@ymogen.net>)
Ответы Re: Hardware recommendations to scale to silly load  (Greg Stark <gsstark@mit.edu>)
Список pgsql-performance
>>>>> "MC" == Matt Clark <matt@ymogen.net> writes:

MC> And concurrency is very high, because it's a web app, and each
MC> httpd has one connection to PG, and there can be hundreds of
MC> active httpd processes.  Some kind of connection pooling scheme
MC> might be in order when there are that many active clients.  Any

One thing you really should do (don't know if you already do it...) is
have your web split into a front-end proxy and a back-end application
server.  There are lots of docs on how to do this for mod_perl, but it
can apply to just about any backend technology that is pooling the
connections.

With a setup like this, my front-end web server typically has about
100 to 150 connections, and the backend doing the dynamic work (and
accessing the database) has peaked at 60 or so.  Usually the backend
numbers at about 25.

The front-end small processes get to deal with your dialup customers
trickling down the data since it buffers your backend for you.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

В списке pgsql-performance по дате отправления:

Предыдущее
От: Vivek Khera
Дата:
Сообщение: Re: Hardware recommendations to scale to silly load
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: opinion on RAID choice