Hi,
Il 09/02/11 01:34, Rangi, Jai ha scritto:
Hello,
I am looking for a replication solution for
PG 9.x. Idea is to have one master replication server and
multiple (around 20) slave servers read only. I see PG 9 has
inbuilt Streaming replication. Is this the best replication
solution. How about slony? Which option will keep the slave
nodes in closest sync to master and which is more stable.
With PostgreSQL 9.0 in terms of builtin replication you can take
advantage of Hot Standby based on either WAL shipping or on
Streaming Replication. I would personally stick with builtin
solutions if you plan to have full replicas of your databases,
even in terms of maintenance and upgrades later on (in the long
term). Some tools, including replication manager (repmgr) are
coming out in order to manage HA clusters (for more info:
http://blog.2ndquadrant.com/en/2011/01/easier-postgresql-90-clusters.html).
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartolini@xxxxxxxxxxxxxx | www.2ndQuadrant.it
|
