From: Sebastian Hennebrueder <usenet@laliluna.de>
To: pgsql-performance@postgresql.org
Subject: Re: Mirroring PostgreSQL database
Date: Wed, 27 Jul 2005 23:21:39 +0200
Message-ID: <42E7FAE3.7070604@laliluna.de> (raw)
In-Reply-To: <s2e4888c.065@lucius.provo.novell.com>
References: <s2e4888c.065@lucius.provo.novell.com>
Shashi Kanth Boddula schrieb:
> Hi,
> I have one customer who is using PostgreSQL 7.4.8 on Linux . He has
> some problems with database mirroring . The details are follows.
> The customer is using Linux on which PostgreSQL 7.4.8 along with Jboss
> 3.2.3 is running . He has 2 servers , one is acting as a live server
> (primary) and another is acting as a fail-over (secondary) server
> . Secondary server is placed in remote location . These servers are
> acting as a Attendence server for daily activities . Nearly 50,000
> employees depend on the live server .
>
> The customer is using DBmirror tool to mirror the database records of
> primary to secondary . The customer is complaining that there is one
> day (24 hours) delay between primary and secondray for database
> synchronization . They have dedicated line and bandwidth , but still
> the problems exists.
>
> I just want to know , for immediate data mirroring , what is the best
> way for PostgreSQL . PostgreSQL is offering many mirror tools , but
> which one is the best ?. Is there any other way to accomplish the task ?
>
> Thank you . Waiting for your reply.
>
>
> Thanks & Regards,
> Shashi Kanth
> Consultant - Linux
> RHCE , LPIC-2
> Onward Novell - Bangalore
> 9886455567
>
>
For java based solution you could also have a look at x-jdbc or xjdbc.
But before you should find out what the reason for the delay is
actually. When the backup server is to slow, it may be not important which
mirroring tool you use.
--
Best Regards / Viele Grüße
Sebastian Hennebrueder
----
http://www.laliluna.de
Tutorials for JSP, JavaServer Faces, Struts, Hibernate and EJB
Get support, education and consulting for these technologies - uncomplicated and cheap.
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-performance@postgresql.org
Cc: usenet@laliluna.de
Subject: Re: Mirroring PostgreSQL database
In-Reply-To: <42E7FAE3.7070604@laliluna.de>
* 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