Search Postgresql Archives

Adivice on master - master replication.

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

 



Hi
I'm new to Posgresql.
I have been requested to setup application level HA. The picture is, I
will have 2 web servers behind 2 new work load balancers, so should
one fail the NLB's will redirect traffic to the remaining server. I
need a similar scenario for the Pgsql servers.

>From my reading I need a synchronise master - master. so both servers
need to be hot. Such that the web servers are unaware of which server
the are communicating with, so should one  pgsql server go down there
would be no interruption to the web servers.

The processes need to be handled automagicly , well at least the fail
over where the one server takes over the failed servers work load.

Everything I have looked at has a single point of failure, generally
the management application that looks after the replication.

How do I achieve this .. I'm looking for a comprehensive howto .

Thanks
G

-- 
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