Search Postgresql Archives

Re: Postgresql Replication Comparison Required

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello,

in general my advice would be to stick with native features, therefore use either Streaming Replication (or alternatively log shipping replication). You might need some tools to help you manage the cluster, clients routing and balancing but I suggest you look into this later.

On Thu, 29 Dec 2011 16:55:00 +0530, saurabh gupta <saurabh.b85@xxxxxxxxx> wrote:
If I would require replication for backup purpose only 

For disaster recovery, you need physical base backups with continous archiving (http://www.postgresql.org/docs/9.1/interactive/continuous-archiving.html)

 If I would require to scale the reads 

You need Hot Standby here (and you might need to route read only applications to one of the slaves somehow - but you can worry about this later).

 If I would require High Avaliability and Consistency 

Streaming replication. With 9.1 you also have Synchronous Streaming Replication which means you have zero data loss of committed transactions within your PostgreSQL cluster. Another useful tool you might want to look into is repmgr (www.repmgr.org).

 Also It will be very helpful if you can share the perfomance or
experience with postgresql replication solutions. 

I wish I could help you more here, but most of our professional work is performed under strict NDAs.

An interesting and useful documentation section is this also: http://www.postgresql.org/docs/9.1/interactive/high-availability.html

I hope this helps.

Cheers,
Gabriele
--
 Gabriele Bartolini - 2ndQuadrant Italia
 PostgreSQL Training, Services and Support
 Gabriele.Bartolini@xxxxxxxxxxxxxx - www.2ndQuadrant.it

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux