pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSlony1 or DRBD for replication ?
6+ messages / 5 participants
[nested] [flat]
* Slony1 or DRBD for replication ?
@ 2006-04-14 12:56 Pierre LEBRECH <pierre.lebrech@laposte.net>
0 siblings, 2 replies; 6+ messages in thread
From: Pierre LEBRECH @ 2006-04-14 12:56 UTC (permalink / raw)
To: pgsql-admin
Hello,
I want to replicate my PostgreSQL database at an other location. The
distance between the two locations should be around 10 miles. The link
should be a fast ethernet dedicated link.
What would you suggest me to do? DRBD or slony1 for PostgreSQL replication?
Thank you.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Slony1 or DRBD for replication ?
@ 2006-04-14 13:21 Shoaib Mir <shoaibmir@gmail.com>
parent: Pierre LEBRECH <pierre.lebrech@laposte.net>
1 sibling, 0 replies; 6+ messages in thread
From: Shoaib Mir @ 2006-04-14 13:21 UTC (permalink / raw)
To: pgsql-admin
SLONY should be the choice :)
On 4/14/06, Pierre LEBRECH <pierre.lebrech@laposte.net> wrote:
>
> Hello,
>
> I want to replicate my PostgreSQL database at an other location. The
> distance between the two locations should be around 10 miles. The link
> should be a fast ethernet dedicated link.
>
> What would you suggest me to do? DRBD or slony1 for PostgreSQL
> replication?
>
> Thank you.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Slony1 or DRBD for replication ?
@ 2006-04-14 15:25 Joshua D. Drake <jd@commandprompt.com>
parent: Pierre LEBRECH <pierre.lebrech@laposte.net>
1 sibling, 1 reply; 6+ messages in thread
From: Joshua D. Drake @ 2006-04-14 15:25 UTC (permalink / raw)
To: Pierre LEBRECH <pierre.lebrech@laposte.net>; +Cc: pgsql-admin
On Fri, 2006-04-14 at 14:56 +0200, Pierre LEBRECH wrote:
> Hello,
>
> I want to replicate my PostgreSQL database at an other location. The
> distance between the two locations should be around 10 miles. The link
> should be a fast ethernet dedicated link.
>
> What would you suggest me to do? DRBD or slony1 for PostgreSQL replication?
It depends on your needs.
If you want to be able to use the slave postgresql instance (reporting,
non replicated name spaces, materialized views etc...) Slony or Mammoth
Replicator.
If you want to also replicate users/groups, grant and revoke, Mammoth
Replicator.
If you just want a hot backup... DRBD.
Joshua D. Drake
>
> Thank you.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Slony1 or DRBD for replication ?
@ 2006-04-14 17:42 Pierre LEBRECH <pierre.lebrech@laposte.net>
parent: Joshua D. Drake <jd@commandprompt.com>
0 siblings, 2 replies; 6+ messages in thread
From: Pierre LEBRECH @ 2006-04-14 17:42 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: pgsql-admin
Joshua D. Drake wrote:
> On Fri, 2006-04-14 at 14:56 +0200, Pierre LEBRECH wrote:
>
>>Hello,
>>
>>I want to replicate my PostgreSQL database at an other location. The
>>distance between the two locations should be around 10 miles. The link
>>should be a fast ethernet dedicated link.
>>
>>What would you suggest me to do? DRBD or slony1 for PostgreSQL replication?
>
>
> It depends on your needs.
>
> If you want to be able to use the slave postgresql instance (reporting,
> non replicated name spaces, materialized views etc...) Slony or Mammoth
> Replicator.
>
> If you want to also replicate users/groups, grant and revoke, Mammoth
> Replicator.
>
> If you just want a hot backup... DRBD.
>
> Joshua D. Drake
>
The second location should be used in case of emergency. So, if my first
machine/system becomes unreachable for whatever reason, I want to be
able to switch very quickly to the other machine. Of course, the goal is
to have no loss of data. That is the context.
Furthermore, I have experience with DRBD (not on databases) and I do not
know if DRBD would be the best way to solve this replication problem.
Thanks for any suggestions and explanations.
PS : my database is actualy in production in a critical environment
>
>
>>Thank you.
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 9: In versions below 8.0, the planner will ignore your desire to
>> choose an index scan if your joining column's datatypes do not
>> match
>>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Slony1 or DRBD for replication ?
@ 2006-04-14 18:14 Christopher Browne <cbbrowne@acm.org>
parent: Pierre LEBRECH <pierre.lebrech@laposte.net>
1 sibling, 0 replies; 6+ messages in thread
From: Christopher Browne @ 2006-04-14 18:14 UTC (permalink / raw)
To: pgsql-admin
In the last exciting episode, pierre.lebrech@laposte.net (Pierre LEBRECH) wrote:
> Thanks for any suggestions and explanations.
A third possibility would be PITR, new in version 8, if the point is
to have recovery from big failure. You'd periodically copy the whole
DB, and continually copy WAL files across the wire...
See the PG docs; there's a whole chapter on it...
--
output = ("cbbrowne" "@" "gmail.com")
http://linuxdatabases.info/info/spreadsheets.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] 6+ messages in thread
* Re: Slony1 or DRBD for replication ?
@ 2006-04-21 01:42 Jim C. Nasby <jnasby@pervasive.com>
parent: Pierre LEBRECH <pierre.lebrech@laposte.net>
1 sibling, 0 replies; 6+ messages in thread
From: Jim C. Nasby @ 2006-04-21 01:42 UTC (permalink / raw)
To: Pierre LEBRECH <pierre.lebrech@laposte.net>; +Cc: Joshua D. Drake <jd@commandprompt.com>; pgsql-admin
On Fri, Apr 14, 2006 at 07:42:29PM +0200, Pierre LEBRECH wrote:
> The second location should be used in case of emergency. So, if my first
> machine/system becomes unreachable for whatever reason, I want to be
> able to switch very quickly to the other machine. Of course, the goal is
> to have no loss of data. That is the context.
>
> Furthermore, I have experience with DRBD (not on databases) and I do not
> know if DRBD would be the best way to solve this replication problem.
>
> Thanks for any suggestions and explanations.
>
> PS : my database is actualy in production in a critical environment
I believe that Continuent currently has the only no-loss (ie:
syncronous) replication solution. DRBD might allow for this as well, if
it can be setup to not return from fsync until the data's been
replicated.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2006-04-21 01:42 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-04-14 12:56 Slony1 or DRBD for replication ? Pierre LEBRECH <pierre.lebrech@laposte.net>
2006-04-14 13:21 ` Shoaib Mir <shoaibmir@gmail.com>
2006-04-14 15:25 ` Joshua D. Drake <jd@commandprompt.com>
2006-04-14 17:42 ` Pierre LEBRECH <pierre.lebrech@laposte.net>
2006-04-14 18:14 ` Christopher Browne <cbbrowne@acm.org>
2006-04-21 01:42 ` Jim C. Nasby <jnasby@pervasive.com>
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