pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDRDB?
7+ messages / 5 participants
[nested] [flat]
* DRDB?
@ 2005-06-27 07:22 Martin Fandel <martin.fandel@alphyra-evs.de>
0 siblings, 2 replies; 7+ messages in thread
From: Martin Fandel @ 2005-06-27 07:22 UTC (permalink / raw)
To: pgsql-admin
Hi all,
is DRDB (http://www.drbd.org/) a recommended replication-solution for
PostgreSQL? I asked some PostgreSQL-People and DRDB-People on the
Linux-Tag in germany. But I'm not very assured about this solution.
Which is the best solution? (Slony, DRDB, WAL or something else?)
Best regards,
Martin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: DRDB?
@ 2005-06-27 09:45 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Martin Fandel <martin.fandel@alphyra-evs.de>
1 sibling, 1 reply; 7+ messages in thread
From: Bruce Momjian @ 2005-06-27 09:45 UTC (permalink / raw)
To: Martin Fandel <martin.fandel@alphyra-evs.de>; +Cc: pgsql-admin
Martin Fandel wrote:
> Hi all,
>
> is DRDB (http://www.drbd.org/) a recommended replication-solution for
> PostgreSQL? I asked some PostgreSQL-People and DRDB-People on the
> Linux-Tag in germany. But I'm not very assured about this solution.
Uh, we really don't _recommend_ replication solutions. However, I will
say I have heard of Slony, but never of DRDB. It seems DRDB replicates
the file system blocks to another machine. While this could work just
fine, it is different than something like Slony that allows you to
replicate only certain tables and allows for you to switch master and
slave roles among servers.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (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] 7+ messages in thread
* Re: DRDB?
@ 2005-06-27 14:19 Tom Lane <tgl@sss.pgh.pa.us>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 7+ messages in thread
From: Tom Lane @ 2005-06-27 14:19 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Martin Fandel <martin.fandel@alphyra-evs.de>; pgsql-admin
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Martin Fandel wrote:
>> is DRDB (http://www.drbd.org/) a recommended replication-solution for
>> PostgreSQL? I asked some PostgreSQL-People and DRDB-People on the
>> Linux-Tag in germany. But I'm not very assured about this solution.
> Uh, we really don't _recommend_ replication solutions. However, I will
> say I have heard of Slony, but never of DRDB. It seems DRDB replicates
> the file system blocks to another machine.
I have not probed further than the site's top page, but unless DRBD
offers some pretty strong guarantees about physical write order on the
master being duplicated on the slave, it won't work reliably for
Postgres.
regards, tom lane
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: DRDB?
@ 2005-06-27 14:39 Magnus Hagander <mha@sollentuna.net>
0 siblings, 2 replies; 7+ messages in thread
From: Magnus Hagander @ 2005-06-27 14:39 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Martin Fandel <martin.fandel@alphyra-evs.de>; pgsql-admin
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Martin Fandel wrote:
> >> is DRDB (http://www.drbd.org/) a recommended
> replication-solution for
> >> PostgreSQL? I asked some PostgreSQL-People and DRDB-People on the
> >> Linux-Tag in germany. But I'm not very assured about this solution.
>
> > Uh, we really don't _recommend_ replication solutions. However, I
> > will say I have heard of Slony, but never of DRDB. It seems DRDB
> > replicates the file system blocks to another machine.
(Um, Bruce, we talked to Alan Robertson about this in Copenhagen a
couple of months back. So you've certainly *heard* of it :P)
> I have not probed further than the site's top page, but
> unless DRBD offers some pretty strong guarantees about
> physical write order on the master being duplicated on the
> slave, it won't work reliably for Postgres.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: DRDB?
@ 2005-06-27 14:51 Tom Lane <tgl@sss.pgh.pa.us>
parent: Magnus Hagander <mha@sollentuna.net>
1 sibling, 0 replies; 7+ messages in thread
From: Tom Lane @ 2005-06-27 14:51 UTC (permalink / raw)
To: Magnus Hagander <mha@sollentuna.net>; +Cc: Bruce Momjian <pgman@candle.pha.pa.us>; Martin Fandel <martin.fandel@alphyra-evs.de>; pgsql-admin
"Magnus Hagander" <mha@sollentuna.net> writes:
>> I have not probed further than the site's top page, but
>> unless DRBD offers some pretty strong guarantees about
>> physical write order on the master being duplicated on the
>> slave, it won't work reliably for Postgres.
> From what I've heard, it does guarantee this. I think it requires you to
> put all your stuff on the same DRBD device (no special device for WAL).
That would seem pretty likely --- I don't see how a block-level driver
could synchronize operations occuring on different devices.
regards, tom lane
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: DRDB?
@ 2005-06-27 23:52 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Magnus Hagander <mha@sollentuna.net>
1 sibling, 0 replies; 7+ messages in thread
From: Bruce Momjian @ 2005-06-27 23:52 UTC (permalink / raw)
To: Magnus Hagander <mha@sollentuna.net>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; Martin Fandel <martin.fandel@alphyra-evs.de>; pgsql-admin
Magnus Hagander wrote:
> > Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > > Martin Fandel wrote:
> > >> is DRDB (http://www.drbd.org/) a recommended
> > replication-solution for
> > >> PostgreSQL? I asked some PostgreSQL-People and DRDB-People on the
> > >> Linux-Tag in germany. But I'm not very assured about this solution.
> >
> > > Uh, we really don't _recommend_ replication solutions. However, I
> > > will say I have heard of Slony, but never of DRDB. It seems DRDB
> > > replicates the file system blocks to another machine.
>
> (Um, Bruce, we talked to Alan Robertson about this in Copenhagen a
> couple of months back. So you've certainly *heard* of it :P)
Oh, that was it. Yea, I remember now!
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (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] 7+ messages in thread
* Re: DRDB?
@ 2005-06-28 00:47 Peter Eisentraut <peter_e@gmx.net>
parent: Martin Fandel <martin.fandel@alphyra-evs.de>
1 sibling, 0 replies; 7+ messages in thread
From: Peter Eisentraut @ 2005-06-28 00:47 UTC (permalink / raw)
To: Martin Fandel <martin.fandel@alphyra-evs.de>; +Cc: pgsql-admin
Martin Fandel wrote:
> Which is the best solution? (Slony, DRDB, WAL or something else?)
Slony is a master/slave replication system that can improve overall read
performance. DRBD gives you a hot stand-by system. Both of these are
completely different goals, which can be implemented complementarily.
A WAL-based replication gives you about the same effect as a DRBD
replication, but with DRBD you pass on all the responsibility to the
operating system. One guy at LinuxTag told be he manages his DRBD
pairs using Linux virtual servers, which would mean that on some level
you don't even notice that you have two machines running instead of
one. If have yet to figure that out, but it sounds quite nice.
Btw., it was probably me who told you about DRBD, but I didn't make that
up myself. A lot of people are currently using it.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2005-06-28 00:47 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-06-27 07:22 DRDB? Martin Fandel <martin.fandel@alphyra-evs.de>
2005-06-27 09:45 ` Bruce Momjian <pgman@candle.pha.pa.us>
2005-06-27 14:19 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-06-28 00:47 ` Peter Eisentraut <peter_e@gmx.net>
2005-06-27 14:39 Re: DRDB? Magnus Hagander <mha@sollentuna.net>
2005-06-27 14:51 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-06-27 23:52 ` Bruce Momjian <pgman@candle.pha.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox