public inbox for [email protected]
help / color / mirror / Atom feedpgsql: Remove replicaiton FAQ item.
15+ messages / 8 participants
[nested] [flat]
* pgsql: Remove replicaiton FAQ item.
@ 2004-11-14 21:33 Bruce Momjian <[email protected]>
0 siblings, 1 reply; 15+ messages in thread
From: Bruce Momjian @ 2004-11-14 21:33 UTC (permalink / raw)
To: [email protected]
Log Message:
-----------
Remove replicaiton FAQ item.
Modified Files:
--------------
pgsql/doc:
FAQ (r1.269 -> r1.270)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ.diff?r1=1.269&r2=1.270)
pgsql/doc/src/FAQ:
FAQ.html (r1.227 -> r1.228)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/FAQ.html.diff?r1=1.227&r2=1.228)
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: pgsql: Remove replicaiton FAQ item.
@ 2004-11-16 05:32 Robert Treat <[email protected]>
parent: Bruce Momjian <[email protected]>
0 siblings, 1 reply; 15+ messages in thread
From: Robert Treat @ 2004-11-16 05:32 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; +Cc: [email protected]
On Sunday 14 November 2004 16:33, Bruce Momjian wrote:
> Log Message:
> -----------
> Remove replicaiton FAQ item.
>
> Modified Files:
> --------------
> pgsql/doc:
> FAQ (r1.269 -> r1.270)
>
> (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ.diff?r1=1.269&r2=
>1.270) pgsql/doc/src/FAQ:
> FAQ.html (r1.227 -> r1.228)
>
> (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/FAQ.html.diff
>?r1=1.227&r2=1.228)
While the answer may have been a little dated, this still seems to be an FAQ.
Was there a discussion on removing this? If so I'll go read that, but ISTM
this question should remain.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: pgsql: Remove replicaiton FAQ item.
@ 2004-11-17 03:31 Marc G. Fournier <[email protected]>
parent: Robert Treat <[email protected]>
0 siblings, 2 replies; 15+ messages in thread
From: Marc G. Fournier @ 2004-11-17 03:31 UTC (permalink / raw)
To: Robert Treat <[email protected]>; +Cc: Bruce Momjian <[email protected]>; [email protected]
On Tue, 16 Nov 2004, Robert Treat wrote:
> On Sunday 14 November 2004 16:33, Bruce Momjian wrote:
>> Log Message:
>> -----------
>> Remove replicaiton FAQ item.
>>
>> Modified Files:
>> --------------
>> pgsql/doc:
>> FAQ (r1.269 -> r1.270)
>>
>> (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ.diff?r1=1.269&r2=
>> 1.270) pgsql/doc/src/FAQ:
>> FAQ.html (r1.227 -> r1.228)
>>
>> (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/FAQ.html.diff
>> ?r1=1.227&r2=1.228)
>
> While the answer may have been a little dated, this still seems to be an FAQ.
> Was there a discussion on removing this? If so I'll go read that, but ISTM
> this question should remain.
agreed, this definitly does fall under a "Very FAQ" kinda thing ...
pointers to the various methods that are currently in use, at a minimum,
would be good ...
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [email protected] Yahoo!: yscrappy ICQ: 7615664
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: pgsql: Remove replicaiton FAQ item.
@ 2004-12-01 22:26 Bruce Momjian <[email protected]>
parent: Marc G. Fournier <[email protected]>
1 sibling, 1 reply; 15+ messages in thread
From: Bruce Momjian @ 2004-12-01 22:26 UTC (permalink / raw)
To: Marc G. Fournier <[email protected]>; +Cc: Robert Treat <[email protected]>; Bruce Momjian <[email protected]>; [email protected]
I am thinking of adding a replication section to the main docs rather
than have it in the FAQ. It would be part of the external
tools/interfaces section I want to add to 8.0 (during our RC period).
---------------------------------------------------------------------------
Marc G. Fournier wrote:
> On Tue, 16 Nov 2004, Robert Treat wrote:
>
> > On Sunday 14 November 2004 16:33, Bruce Momjian wrote:
> >> Log Message:
> >> -----------
> >> Remove replicaiton FAQ item.
> >>
> >> Modified Files:
> >> --------------
> >> pgsql/doc:
> >> FAQ (r1.269 -> r1.270)
> >>
> >> (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ.diff?r1=1.269&r2=
> >> 1.270) pgsql/doc/src/FAQ:
> >> FAQ.html (r1.227 -> r1.228)
> >>
> >> (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/FAQ.html.diff
> >> ?r1=1.227&r2=1.228)
> >
> > While the answer may have been a little dated, this still seems to be an FAQ.
> > Was there a discussion on removing this? If so I'll go read that, but ISTM
> > this question should remain.
>
> agreed, this definitly does fall under a "Very FAQ" kinda thing ...
> pointers to the various methods that are currently in use, at a minimum,
> would be good ...
>
> ----
> Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
> Email: [email protected] Yahoo!: yscrappy ICQ: 7615664
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: pgsql: Remove replicaiton FAQ item.
@ 2004-12-01 23:44 Marc G. Fournier <[email protected]>
parent: Bruce Momjian <[email protected]>
0 siblings, 1 reply; 15+ messages in thread
From: Marc G. Fournier @ 2004-12-01 23:44 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; +Cc: Marc G. Fournier <[email protected]>; Robert Treat <[email protected]>; Bruce Momjian <[email protected]>; [email protected]
On Wed, 1 Dec 2004, Bruce Momjian wrote:
>
> I am thinking of adding a replication section to the main docs rather
> than have it in the FAQ. It would be part of the external
> tools/interfaces section I want to add to 8.0 (during our RC period).
Even then, a FAQ entry should be added to point to that section ... IMHO
...
>
> ---------------------------------------------------------------------------
>
> Marc G. Fournier wrote:
>> On Tue, 16 Nov 2004, Robert Treat wrote:
>>
>>> On Sunday 14 November 2004 16:33, Bruce Momjian wrote:
>>>> Log Message:
>>>> -----------
>>>> Remove replicaiton FAQ item.
>>>>
>>>> Modified Files:
>>>> --------------
>>>> pgsql/doc:
>>>> FAQ (r1.269 -> r1.270)
>>>>
>>>> (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ.diff?r1=1.269&r2=
>>>> 1.270) pgsql/doc/src/FAQ:
>>>> FAQ.html (r1.227 -> r1.228)
>>>>
>>>> (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/FAQ.html.diff
>>>> ?r1=1.227&r2=1.228)
>>>
>>> While the answer may have been a little dated, this still seems to be an FAQ.
>>> Was there a discussion on removing this? If so I'll go read that, but ISTM
>>> this question should remain.
>>
>> agreed, this definitly does fall under a "Very FAQ" kinda thing ...
>> pointers to the various methods that are currently in use, at a minimum,
>> would be good ...
>>
>> ----
>> Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
>> Email: [email protected] Yahoo!: yscrappy ICQ: 7615664
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 8: explain analyze is your friend
>>
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> [email protected] | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square, Pennsylvania 19073
>
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [email protected] Yahoo!: yscrappy ICQ: 7615664
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: pgsql: Remove replicaiton FAQ item.
@ 2004-12-02 02:19 Bruce Momjian <[email protected]>
parent: Marc G. Fournier <[email protected]>
0 siblings, 0 replies; 15+ messages in thread
From: Bruce Momjian @ 2004-12-02 02:19 UTC (permalink / raw)
To: Marc G. Fournier <[email protected]>; +Cc: Robert Treat <[email protected]>; Bruce Momjian <[email protected]>; [email protected]
Marc G. Fournier wrote:
> On Wed, 1 Dec 2004, Bruce Momjian wrote:
>
> >
> > I am thinking of adding a replication section to the main docs rather
> > than have it in the FAQ. It would be part of the external
> > tools/interfaces section I want to add to 8.0 (during our RC period).
>
> Even then, a FAQ entry should be added to point to that section ... IMHO
> ...
Yes, once the section is done we can point to it.
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [COMMITTERS] pgsql: Remove replicaiton FAQ item.
@ 2005-04-24 12:01 Bruce Momjian <[email protected]>
parent: Marc G. Fournier <[email protected]>
1 sibling, 2 replies; 15+ messages in thread
From: Bruce Momjian @ 2005-04-24 12:01 UTC (permalink / raw)
To: Marc G. Fournier <[email protected]>; +Cc: Robert Treat <[email protected]>; pgsql-docs
Marc G. Fournier wrote:
> On Tue, 16 Nov 2004, Robert Treat wrote:
>
> > On Sunday 14 November 2004 16:33, Bruce Momjian wrote:
> >> Log Message:
> >> -----------
> >> Remove replicaiton FAQ item.
> >>
> >> Modified Files:
> >> --------------
> >> pgsql/doc:
> >> FAQ (r1.269 -> r1.270)
> >>
> >> (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ.diff?r1=1.269&r2=
> >> 1.270) pgsql/doc/src/FAQ:
> >> FAQ.html (r1.227 -> r1.228)
> >>
> >> (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/FAQ.html.diff
> >> ?r1=1.227&r2=1.228)
> >
> > While the answer may have been a little dated, this still seems to be an FAQ.
> > Was there a discussion on removing this? If so I'll go read that, but ISTM
> > this question should remain.
>
> agreed, this definitly does fall under a "Very FAQ" kinda thing ...
> pointers to the various methods that are currently in use, at a minimum,
> would be good ...
Yep, big mistake my removing the replication FAQ item. I have re-added a
new one:
4.21) What replication solutions are available?
Though "replication" is a single term, there are two major replication
technologies. Multi-master replication allows read/write queries to be
sent to multiple replicated computers. Using this capability has a
serious performance impact. Pgcluster is the most popular such solution
available for PostgreSQL. Master-slave replication allows a single
master to receive read/write queries, with slaves able to accept only
read/SELECT queries. The most popular master-slave PostgreSQL
replication solution is Slony. There are also commercial and
hardware-based replication solutions available.
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [COMMITTERS] pgsql: Remove replicaiton FAQ item.
@ 2005-04-24 16:11 Christopher Browne <[email protected]>
parent: Bruce Momjian <[email protected]>
1 sibling, 1 reply; 15+ messages in thread
From: Christopher Browne @ 2005-04-24 16:11 UTC (permalink / raw)
To: pgsql-docs
Martha Stewart called it a Good Thing when [email protected] (Bruce Momjian) wrote:
> Yep, big mistake my removing the replication FAQ item. I have re-added a
> new one:
>
> 4.21) What replication solutions are available?
>
> Though "replication" is a single term, there are two major replication
> technologies. Multi-master replication allows read/write queries to be
> sent to multiple replicated computers. Using this capability has a
> serious performance impact. Pgcluster is the most popular such solution
> available for PostgreSQL. Master-slave replication allows a single
> master to receive read/write queries, with slaves able to accept only
> read/SELECT queries. The most popular master-slave PostgreSQL
> replication solution is Slony. There are also commercial and
> hardware-based replication solutions available.
A suggestion for rewording:
Though "replication" is a single term, there are a number of
approaches and technologies to handle it, and thus, for different
purposes, a number of replication systems are available.
Master/slave replication allows a single master to receive read/write
queries, where slaves can only accept read/SELECT queries. The most
popular freely available master-slave PostgreSQL replication solution
is Slony-I.
Multi-master replication allows read/write queries to be sent to
multiple replicated computers. Using this capability generaly has a
fairly severe impact on performance due to the need to synchronize
changes between servers. Pgcluster is the most popular such solution
freely available for PostgreSQL.
There are also commercial and hardware-based replication solutions
available supporting a variety of replication models.
--
(format nil "~S@~S" "cbbrowne" "acm.org")
http://linuxdatabases.info/info/slony.html
"It can be shown that for any nutty theory, beyond-the-fringe
political view or strange religion there exists a proponent on the
Net. The proof is left as an exercise for your kill-file."
-- Bertil Jonell
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [COMMITTERS] pgsql: Remove replicaiton FAQ item.
@ 2005-04-24 18:04 Jeff Davis <[email protected]>
parent: Bruce Momjian <[email protected]>
1 sibling, 1 reply; 15+ messages in thread
From: Jeff Davis @ 2005-04-24 18:04 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; +Cc: Marc G. Fournier <[email protected]>; Robert Treat <[email protected]>; pgsql-docs
Should the text include a mention of synchronous vs. asynchronous? Or
does master-master imply synchronous?
Regards,
Jeff Davis
On Sun, 2005-04-24 at 08:01 -0400, Bruce Momjian wrote:
> Marc G. Fournier wrote:
> > On Tue, 16 Nov 2004, Robert Treat wrote:
> >
> > > On Sunday 14 November 2004 16:33, Bruce Momjian wrote:
> > >> Log Message:
> > >> -----------
> > >> Remove replicaiton FAQ item.
> > >>
> > >> Modified Files:
> > >> --------------
> > >> pgsql/doc:
> > >> FAQ (r1.269 -> r1.270)
> > >>
> > >> (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ.diff?r1=1.269&r2=
> > >> 1.270) pgsql/doc/src/FAQ:
> > >> FAQ.html (r1.227 -> r1.228)
> > >>
> > >> (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/FAQ.html.diff
> > >> ?r1=1.227&r2=1.228)
> > >
> > > While the answer may have been a little dated, this still seems to be an FAQ.
> > > Was there a discussion on removing this? If so I'll go read that, but ISTM
> > > this question should remain.
> >
> > agreed, this definitly does fall under a "Very FAQ" kinda thing ...
> > pointers to the various methods that are currently in use, at a minimum,
> > would be good ...
>
> Yep, big mistake my removing the replication FAQ item. I have re-added a
> new one:
>
> 4.21) What replication solutions are available?
>
> Though "replication" is a single term, there are two major replication
> technologies. Multi-master replication allows read/write queries to be
> sent to multiple replicated computers. Using this capability has a
> serious performance impact. Pgcluster is the most popular such solution
> available for PostgreSQL. Master-slave replication allows a single
> master to receive read/write queries, with slaves able to accept only
> read/SELECT queries. The most popular master-slave PostgreSQL
> replication solution is Slony. There are also commercial and
> hardware-based replication solutions available.
>
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [COMMITTERS] pgsql: Remove replicaiton FAQ item.
@ 2005-04-24 18:40 Joshua D. Drake <[email protected]>
parent: Jeff Davis <[email protected]>
0 siblings, 1 reply; 15+ messages in thread
From: Joshua D. Drake @ 2005-04-24 18:40 UTC (permalink / raw)
To: Jeff Davis <[email protected]>; +Cc: Bruce Momjian <[email protected]>; Marc G. Fournier <[email protected]>; Robert Treat <[email protected]>; pgsql-docs
Jeff Davis wrote:
> Should the text include a mention of synchronous vs. asynchronous? Or
> does master-master imply synchronous?
It shouldn't. It is possible to have synchronous replication without it
being master<->master.
Sincerely,
Joshua D. Drake
>
> Regards,
> Jeff Davis
>
> On Sun, 2005-04-24 at 08:01 -0400, Bruce Momjian wrote:
>
>>Marc G. Fournier wrote:
>>
>>>On Tue, 16 Nov 2004, Robert Treat wrote:
>>>
>>>
>>>>On Sunday 14 November 2004 16:33, Bruce Momjian wrote:
>>>>
>>>>>Log Message:
>>>>>-----------
>>>>>Remove replicaiton FAQ item.
>>>>>
>>>>>Modified Files:
>>>>>--------------
>>>>> pgsql/doc:
>>>>> FAQ (r1.269 -> r1.270)
>>>>>
>>>>>(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ.diff?r1=1.269&r2=
>>>>>1.270) pgsql/doc/src/FAQ:
>>>>> FAQ.html (r1.227 -> r1.228)
>>>>>
>>>>>(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/FAQ.html.diff
>>>>>?r1=1.227&r2=1.228)
>>>>
>>>>While the answer may have been a little dated, this still seems to be an FAQ.
>>>>Was there a discussion on removing this? If so I'll go read that, but ISTM
>>>>this question should remain.
>>>
>>>agreed, this definitly does fall under a "Very FAQ" kinda thing ...
>>>pointers to the various methods that are currently in use, at a minimum,
>>>would be good ...
>>
>>Yep, big mistake my removing the replication FAQ item. I have re-added a
>>new one:
>>
>> 4.21) What replication solutions are available?
>>
>> Though "replication" is a single term, there are two major replication
>> technologies. Multi-master replication allows read/write queries to be
>> sent to multiple replicated computers. Using this capability has a
>> serious performance impact. Pgcluster is the most popular such solution
>> available for PostgreSQL. Master-slave replication allows a single
>> master to receive read/write queries, with slaves able to accept only
>> read/SELECT queries. The most popular master-slave PostgreSQL
>> replication solution is Slony. There are also commercial and
>> hardware-based replication solutions available.
>>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [COMMITTERS] pgsql: Remove replicaiton FAQ item.
@ 2005-04-24 22:54 Bruce Momjian <[email protected]>
parent: Joshua D. Drake <[email protected]>
0 siblings, 1 reply; 15+ messages in thread
From: Bruce Momjian @ 2005-04-24 22:54 UTC (permalink / raw)
To: Joshua D. Drake <[email protected]>; +Cc: Jeff Davis <[email protected]>; Marc G. Fournier <[email protected]>; Robert Treat <[email protected]>; pgsql-docs
Joshua D. Drake wrote:
> Jeff Davis wrote:
> > Should the text include a mention of synchronous vs. asynchronous? Or
> > does master-master imply synchronous?
>
> It shouldn't. It is possible to have synchronous replication without it
> being master<->master.
We could mention async vs sync but at the FAQ stage I think the
multi-master/master-slave disinction is enough. Let's see what questions
we get.
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [COMMITTERS] pgsql: Remove replicaiton FAQ item.
@ 2005-04-24 23:15 Mischa Sandberg <[email protected]>
parent: Bruce Momjian <[email protected]>
0 siblings, 1 reply; 15+ messages in thread
From: Mischa Sandberg @ 2005-04-24 23:15 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; +Cc: Joshua D. Drake <[email protected]>; Jeff Davis <[email protected]>; Marc G. Fournier <[email protected]>; Robert Treat <[email protected]>; pgsql-docs
Quoting Bruce Momjian <[email protected]>:
> Joshua D. Drake wrote:
> > Jeff Davis wrote:
> > > Should the text include a mention of synchronous vs.
> asynchronous? Or
> > > does master-master imply synchronous?
> >
> > It shouldn't. It is possible to have synchronous replication
> without it
> > being master<->master.
>
> We could mention async vs sync but at the FAQ stage I think the
> multi-master/master-slave disinction is enough. Let's see what
> questions
> we get.
About all you can say is, it is not possible to implement synchronous
master-master replication, because of conflict resolution of
simultaneous transactions.
--
"Dreams come true, not free." -- S.Sondheim, ITW
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [COMMITTERS] pgsql: Remove replicaiton FAQ item.
@ 2005-04-24 23:24 Bruce Momjian <[email protected]>
parent: Mischa Sandberg <[email protected]>
0 siblings, 1 reply; 15+ messages in thread
From: Bruce Momjian @ 2005-04-24 23:24 UTC (permalink / raw)
To: Mischa Sandberg <[email protected]>; +Cc: Joshua D. Drake <[email protected]>; Jeff Davis <[email protected]>; Marc G. Fournier <[email protected]>; Robert Treat <[email protected]>; pgsql-docs
Mischa Sandberg wrote:
> Quoting Bruce Momjian <[email protected]>:
>
> > Joshua D. Drake wrote:
> > > Jeff Davis wrote:
> > > > Should the text include a mention of synchronous vs.
> > asynchronous? Or
> > > > does master-master imply synchronous?
> > >
> > > It shouldn't. It is possible to have synchronous replication
> > without it
> > > being master<->master.
> >
> > We could mention async vs sync but at the FAQ stage I think the
> > multi-master/master-slave disinction is enough. Let's see what
> > questions
> > we get.
>
> About all you can say is, it is not possible to implement synchronous
> master-master replication, because of conflict resolution of
> simultaneous transactions.
You mean asynchronous master-master? There are some implementations
(Sybase?, pgreplicator) that do this and have conflict resolution.
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [COMMITTERS] pgsql: Remove replicaiton FAQ item.
@ 2005-04-25 00:04 Mischa Sandberg <[email protected]>
parent: Bruce Momjian <[email protected]>
0 siblings, 0 replies; 15+ messages in thread
From: Mischa Sandberg @ 2005-04-25 00:04 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; +Cc: Joshua D. Drake <[email protected]>; Jeff Davis <[email protected]>; Marc G. Fournier <[email protected]>; Robert Treat <[email protected]>; pgsql-docs
Quoting Bruce Momjian <[email protected]>:
> Mischa Sandberg wrote:
> > About all you can say is, it is not possible to implement
> synchronous
> > master-master replication, because of conflict resolution of
> > simultaneous transactions.
>
> You mean asynchronous master-master? There are some implementations
> (Sybase?, pgreplicator) that do this and have conflict resolution.
Forgive my kibitz, then; perhaps my head has been stuck in sand a
while. You're right, I forgot about the nicer bits of Sybase
RepServer. Synchronous replication was scratched early in the project,
because two-phase commit took too long across a dozen db servers.
Pgreplicator advertises itself as a "store-and-forward asynch replica
(sic) engine." (quoth http://pgreplicator.sourceforge.net/ )
--
"Dreams come true, not free." -- S.Sondheim, ITW
^ permalink raw reply [nested|flat] 15+ messages in thread
* Re: [COMMITTERS] pgsql: Remove replicaiton FAQ item.
@ 2005-04-30 03:52 Bruce Momjian <[email protected]>
parent: Christopher Browne <[email protected]>
0 siblings, 0 replies; 15+ messages in thread
From: Bruce Momjian @ 2005-04-30 03:52 UTC (permalink / raw)
To: Christopher Browne <[email protected]>; +Cc: pgsql-docs
OK, updated:
<P>Though "replication" is a single term, there are several technologies
for doing replication, with advantages and disadvantages for each.</P>
<P>Master/slave replication allows a single master to receive read/write
queries, while slaves can only accept read/<SMALL>SELECT</SMALL> queries.
The most popular freely available master-slave PostgreSQL replication
solution is <A href="http://gborg.postgresql.org/project/slony1/projdisplay$
Slony-I</A>.</P>
<P>Multi-master replication allows read/write queries to be sent to
multiple replicated computers. This capability also has a severe
impact on performance due to the need to synchronize changes between
servers. <A href="http://pgfoundry.org/projects/pgcluster/">Pgcluster</a;
is the most popular such solution freely available for PostgreSQL.</P>
<P>There are also commercial and hardware-based replication solutions
available supporting a variety of replication models.</P>
---------------------------------------------------------------------------
Christopher Browne wrote:
> Martha Stewart called it a Good Thing when [email protected] (Bruce Momjian) wrote:
> > Yep, big mistake my removing the replication FAQ item. I have re-added a
> > new one:
> >
> > 4.21) What replication solutions are available?
> >
> > Though "replication" is a single term, there are two major replication
> > technologies. Multi-master replication allows read/write queries to be
> > sent to multiple replicated computers. Using this capability has a
> > serious performance impact. Pgcluster is the most popular such solution
> > available for PostgreSQL. Master-slave replication allows a single
> > master to receive read/write queries, with slaves able to accept only
> > read/SELECT queries. The most popular master-slave PostgreSQL
> > replication solution is Slony. There are also commercial and
> > hardware-based replication solutions available.
>
> A suggestion for rewording:
>
> Though "replication" is a single term, there are a number of
> approaches and technologies to handle it, and thus, for different
> purposes, a number of replication systems are available.
>
> Master/slave replication allows a single master to receive read/write
> queries, where slaves can only accept read/SELECT queries. The most
> popular freely available master-slave PostgreSQL replication solution
> is Slony-I.
>
> Multi-master replication allows read/write queries to be sent to
> multiple replicated computers. Using this capability generaly has a
> fairly severe impact on performance due to the need to synchronize
> changes between servers. Pgcluster is the most popular such solution
> freely available for PostgreSQL.
>
> There are also commercial and hardware-based replication solutions
> available supporting a variety of replication models.
> --
> (format nil "~S@~S" "cbbrowne" "acm.org")
> http://linuxdatabases.info/info/slony.html
> "It can be shown that for any nutty theory, beyond-the-fringe
> political view or strange religion there exists a proponent on the
> Net. The proof is left as an exercise for your kill-file."
> -- Bertil Jonell
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 15+ messages in thread
end of thread, other threads:[~2005-04-30 03:52 UTC | newest]
Thread overview: 15+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-11-14 21:33 pgsql: Remove replicaiton FAQ item. Bruce Momjian <[email protected]>
2004-11-16 05:32 ` Robert Treat <[email protected]>
2004-11-17 03:31 ` Marc G. Fournier <[email protected]>
2004-12-01 22:26 ` Bruce Momjian <[email protected]>
2004-12-01 23:44 ` Marc G. Fournier <[email protected]>
2004-12-02 02:19 ` Bruce Momjian <[email protected]>
2005-04-24 12:01 ` Bruce Momjian <[email protected]>
2005-04-24 16:11 ` Christopher Browne <[email protected]>
2005-04-30 03:52 ` Bruce Momjian <[email protected]>
2005-04-24 18:04 ` Jeff Davis <[email protected]>
2005-04-24 18:40 ` Joshua D. Drake <[email protected]>
2005-04-24 22:54 ` Bruce Momjian <[email protected]>
2005-04-24 23:15 ` Mischa Sandberg <[email protected]>
2005-04-24 23:24 ` Bruce Momjian <[email protected]>
2005-04-25 00:04 ` Mischa Sandberg <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox