Re: Peer to peer replication of Postgresql databases

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: Peer to peer replication of Postgresql databases
Дата
Msg-id 87bs61kli3.fsf@mailbox.samurai.com
обсуждение исходный текст
Ответ на Peer to peer replication of Postgresql databases  (Anuradha Ratnaweera <anuradha@lklug.pdn.ac.lk>)
Ответы Re: Peer to peer replication of Postgresql databases  (Anuradha Ratnaweera <anuradha@lklug.pdn.ac.lk>)
Список pgsql-hackers
[ pgsql-patches removed from Cc: list ]

Anuradha Ratnaweera <anuradha@lklug.pdn.ac.lk> writes:
> I am trying to add some replication features to postgres (yes, I have
> already looked at ongoing work), in a peer to peer manner.

Did you look at the research behind Postgres-R, and the pgreplication
stuff?

> - When a frontend process sends a read query, each backend process
>   does that from its own data area.

Surely that's not correct -- a SELECT can be handled by *any one*
node, not each and every one, right?

> - There are two types of write queries.  Postmasters use seperate
>   communication channels for each.  One is the sequencial channel which
>   carries writes whose order is important, and the non-sequencial
>   channel carries write queries whose order is not important.

How do you distinguish between these?

Cheers,

Neil

-- 
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC



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

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: MySQL vs PostgreSQL.
Следующее
От: Dave Cramer
Дата:
Сообщение: move 0 behaviour