Re: Clustering

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Clustering
Дата
Msg-id 1114715623.13303.1357.camel@state.g2switchworks.com
обсуждение исходный текст
Ответ на Clustering  (Patrick Haugen <pathaugen@gmail.com>)
Список pgsql-general
On Thu, 2005-04-28 at 13:59, Patrick Haugen wrote:
> I haven't found any information on clustering with PostgreSQL.
>
> One idea we've been tossing around is through PostgreSQL you can
> create a function that does something when something else happens.
>
> Pseudo code:
> When databse xyz table companyname is updated update the same table
> and rows in database abc;
>
> So each time an update is made, the server performs the function.  So
> every update is essentially 1xN updates (N is the number of servers),
> but is all done at the server level so should be fast.
>
> Now the problem with that solution is if a server db/table gets
> updated and when it is sending that same update over the net to the
> offsite cluster, the server crashes. That update technically went
> through, however the record of it is lost.
>
> What is a good clustering technique for PostgreSQL?


Something that pretty much does that with the help of a couple of
external daemons is the slony project.

http://slony.info

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

Предыдущее
От: Patrick Haugen
Дата:
Сообщение: Clustering
Следующее
От: Scott Frankel
Дата:
Сообщение: Re: on insert rule & primary key