pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Mirroring PostgreSQL database
5+ messages / 5 participants
[nested] [flat]
* Mirroring PostgreSQL database
@ 2005-07-25 18:01 Shashi Kanth Boddula <sboddula@novell.com>
2005-07-25 13:04 ` Re: Mirroring PostgreSQL database Richard Huxton <dev@archonet.com>
2005-07-25 15:20 ` Re: Mirroring PostgreSQL database Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2005-07-25 16:03 ` Re: Mirroring PostgreSQL database Joshua D. Drake <jd@commandprompt.com>
2005-07-27 21:21 ` Re: Mirroring PostgreSQL database Sebastian Hennebrueder <usenet@laliluna.de>
0 siblings, 4 replies; 5+ messages in thread
From: Shashi Kanth Boddula @ 2005-07-25 18:01 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Mirroring PostgreSQL database
2005-07-25 18:01 Mirroring PostgreSQL database Shashi Kanth Boddula <sboddula@novell.com>
@ 2005-07-25 13:04 ` Richard Huxton <dev@archonet.com>
3 siblings, 0 replies; 5+ messages in thread
From: Richard Huxton @ 2005-07-25 13:04 UTC (permalink / raw)
To: Shashi Kanth Boddula <sboddula@novell.com>; +Cc: pgsql-performance
Shashi Kanth Boddula wrote:
>
> 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.
You don't say what the nature of the problem with dbmirror is. Are they
saturating their bandwidth? Are one or both servers unable to keep pace
with the updates?
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Mirroring PostgreSQL database
2005-07-25 18:01 Mirroring PostgreSQL database Shashi Kanth Boddula <sboddula@novell.com>
@ 2005-07-25 15:20 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
3 siblings, 0 replies; 5+ messages in thread
From: Christopher Kings-Lynne @ 2005-07-25 15:20 UTC (permalink / raw)
To: Shashi Kanth Boddula <sboddula@novell.com>; +Cc: pgsql-performance
Try Slony: www.slony.info
Shashi Kanth Boddula wrote:
>
> 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
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Mirroring PostgreSQL database
2005-07-25 18:01 Mirroring PostgreSQL database Shashi Kanth Boddula <sboddula@novell.com>
@ 2005-07-25 16:03 ` Joshua D. Drake <jd@commandprompt.com>
3 siblings, 0 replies; 5+ messages in thread
From: Joshua D. Drake @ 2005-07-25 16:03 UTC (permalink / raw)
To: Shashi Kanth Boddula <sboddula@novell.com>; +Cc: pgsql-performance
> 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 ?
You want to take a look at Slony-I or Mammoth Replicator.
http://www.slony.info/
http://www.commandprompt.com/
>
> Thank you . Waiting for your reply.
>
>
> Thanks & Regards,
> Shashi Kanth
> Consultant - Linux
> RHCE , LPIC-2
> Onward Novell - Bangalore
> 9886455567
>
>
--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Mirroring PostgreSQL database
2005-07-25 18:01 Mirroring PostgreSQL database Shashi Kanth Boddula <sboddula@novell.com>
@ 2005-07-27 21:21 ` Sebastian Hennebrueder <usenet@laliluna.de>
3 siblings, 0 replies; 5+ messages in thread
From: Sebastian Hennebrueder @ 2005-07-27 21:21 UTC (permalink / raw)
To: pgsql-performance
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2005-07-27 21:21 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-07-25 18:01 Mirroring PostgreSQL database Shashi Kanth Boddula <sboddula@novell.com>
2005-07-25 13:04 ` Richard Huxton <dev@archonet.com>
2005-07-25 15:20 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2005-07-25 16:03 ` Joshua D. Drake <jd@commandprompt.com>
2005-07-27 21:21 ` Sebastian Hennebrueder <usenet@laliluna.de>
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