Re: hardware performance and some more

Список
Период
Сортировка
От Ron Johnson
Тема Re: hardware performance and some more
Дата
Msg-id 1059153176.26037.130.camel@haggis
обсуждение исходный текст
Ответ на Re: hardware performance and some more  (Josh Berkus)
Список pgsql-performance
Дерево обсуждения
hardware performance and some more  (Kasim Oztoprak, )
 Re: hardware performance and some more  ("Shridhar Daithankar", )
 Re: hardware performance and some more  (Kasim Oztoprak, )
  Re: hardware performance and some more  (Ron Johnson, )
 Re: hardware performance and some more  ("Roman Fail", )
 Re: hardware performance and some more  (Kasim Oztoprak, )
 Re: hardware performance and some more  (William Yu, )
  Re: hardware performance and some more  ("Shridhar Daithankar", )
 Re: hardware performance and some more  (Kasim Oztoprak, )
  Re: hardware performance and some more  ("Shridhar Daithankar", )
  Re: hardware performance and some more  (Ron Johnson, )
   Re: hardware performance and some more  (Josh Berkus, )
    Re: hardware performance and some more  (Ron Johnson, )
 Re: hardware performance and some more  (Kasim Oztoprak, )
  Re: hardware performance and some more  ("Shridhar Daithankar", )
On Fri, 2003-07-25 at 11:13, Josh Berkus wrote:
> Folks,
>
> > Since PG doesn't have active-active clustering, that's out, but since
> > the database will be very static, why not have, say 8 machines, each
> > with it's own copy of the database?  (Since there are so few updates,
> > you feed the updates to a litle Perl app that then makes the changes
> > on each machine.)  (A round-robin load balancer would do the trick
> > in utilizing them all.)
>
> Another approach I've seen work is to have several servers connect to one SAN
> or NAS where the data lives.  Only one server is enabled to handle "write"
> requests; all the rest are read-only.  This does mean having dispacting
> middleware that parcels out requests among the servers, but works very well
> for the java-based company that's using it.

Wouldn't the cache on the read-only databases get out of sync with
the true on-disk data?

--
+-----------------------------------------------------------------+
| Ron Johnson, Jr.        Home:              |
| Jefferson, LA  USA                                              |
|                                                                 |
| "I'm not a vegetarian because I love animals, I'm a vegetarian  |
|  because I hate vegetables!"                                    |
|    unknown                                                      |
+-----------------------------------------------------------------+



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

Предыдущее
От: Franco Bruno Borghesi
Дата:
Сообщение: Re: index questions
Следующее
От: "Mendola Gaetano"
Дата:
Сообщение: Wrong rows number expected