Re: vacuum, performance, and MVCC

Поиск
Список
Период
Сортировка
От Rick Gigger
Тема Re: vacuum, performance, and MVCC
Дата
Msg-id E7EC710D-4D7E-4E6B-9164-004D0E7B1006@alpinenetworking.com
обсуждение исходный текст
Ответ на Re: vacuum, performance, and MVCC  ("Mark Woodward" <pgsql@mohawksoft.com>)
Список pgsql-hackers
On Jun 22, 2006, at 2:36 PM, Mark Woodward wrote:

>>
>>> What you seem not to grasp at this point is a large web-farm,  
>>> about 10
>>> or
>>> more servers running PHP, Java, ASP, or even perl. The database is
>>> usually
>>> the most convenient and, aside from the particular issue we are  
>>> talking
>>> about, best suited.
>>
>>     The answer is sticky sessions : each user is assigned to one and  
>> only one
>> webserver in the cluster and his session is maintained locally, in  
>> RAM. No
>> locks, no need to manage distributed session...
>>
>>> I actually have a good number of years of experience in this  
>>> topic, and
>>> memcached or file system files are NOT the best solutions for a  
>>> server
>>> farm.
>>
>>     If sessions are distributed, certainly, but if sessions are  
>> sticky to
>> their own server ?
>
> And what if a particulr server goes down? or gets too high a  
> percentage of
> the load?

Yes, I don't think that sticky sessions are the answer.  But phps  
session handling behavior could be greatly improved on.


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

Предыдущее
От: Rick Gigger
Дата:
Сообщение: Re: vacuum, performance, and MVCC
Следующее
От: mark@mark.mielke.cc
Дата:
Сообщение: Re: vacuum, performance, and MVCC