Thread: Mirroring PostgreSQL database

Mirroring PostgreSQL database

From
"Shashi Kanth Boddula"
Date:
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


Re: Mirroring PostgreSQL database

From
Richard Huxton
Date:
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

Re: Mirroring PostgreSQL database

From
Christopher Kings-Lynne
Date:
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
>
>

Re: Mirroring PostgreSQL database

From
"Joshua D. Drake"
Date:
> 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/

Re: Mirroring PostgreSQL database

From
Sebastian Hennebrueder
Date:
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.