From: | "libra dba" <libra(dot)dba(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | using warm standby with drbd??? |
Date: | 2008-03-04 22:07:50 |
Message-ID: | 9abe84da0803041407u3abd92a6oc4ab099f5c3b2d1b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
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!
From | Date | Subject | |
---|---|---|---|
Next Message | Mary Anderson | 2008-03-04 22:13:02 | Re: Documenting a DB schema |
Previous Message | Steve Crawford | 2008-03-04 21:27:15 | Re: [SQL] Documenting a DB schema |
From | Date | Subject | |
---|---|---|---|
Next Message | Mary Anderson | 2008-03-04 22:13:02 | Re: Documenting a DB schema |
Previous Message | Steve Crawford | 2008-03-04 21:27:15 | Re: [SQL] Documenting a DB schema |