pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: libra dba <libra.dba@gmail.com>
To: pgsql-general@postgresql.org
Subject: using warm standby with drbd???
Date: Tue, 4 Mar 2008 17:07:50 -0500
Message-ID: <9abe84da0803041407u3abd92a6oc4ab099f5c3b2d1b@mail.gmail.com> (raw)

Hi All!

I have configured the warm standby using WAL FILES and DRBD. The wal files
are generated as server A. I am using DRBD to replicate these wal files
between server A and server B. The DRBD service is running as Primary on
Server A and secondary on Server B. The wal_files are written to the server
B, but there is a drawback for DRBD. The filesystme needs to be unmounted on
the server B (where DRBD is running secondary role).

So recovery is not countinuous.(file systme is unmounted). To start the
recovery, i need to change the DRBD role to primary on server B. After that
i have to mount the filesystem. Once i mount the filesystem, the recovery
process starts.

Is there any way in which i need not switch secondary/primary role for DRBD
on server B?
Is there any way in which i can have the file system mounted on server B,
running DRBD secondary role?

How else can i replicate the wal_files? ( i don't want to user common file
system ,,, NFS,,, etc.)?

Another thing which i want to ask is that if we are generating archives
every 1 minute. then what happens to the data which was written to the
server A after 35 seconds after the last wal file generation.(server A
crashes).

Since this data has not been archived (it was supposed to archive after 1
minute), do i think that this is the loss of data in a server A crash as
this 35 second data has not been written to the archived logs and neither
has been transported to server B?

A quick reply is highly appreciated!

Thanks!

view thread (3+ messages)  latest in thread

Message-ID: <9abe84da0803041407u3abd92a6oc4ab099f5c3b2d1b@mail.gmail.com>
Permalink:  ../9abe84da0803041407u3abd92a6oc4ab099f5c3b2d1b@mail.gmail.com/
Also on:    postgresql.org/message-id/9abe84da0803041407u3abd92a6oc4ab099f5c3b2d1b@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: libra.dba@gmail.com, pgsql-general@postgresql.org
  Subject: Re: using warm standby with drbd???
  In-Reply-To: <9abe84da0803041407u3abd92a6oc4ab099f5c3b2d1b@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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