On 30/04/2013, at 9:58 PM, Richard Comblen <[email protected]> wrote:

> Hi all,
> 
> I have a two node setup with replicated PostgreSQL DB (master/slave
> setup). Focus is on keeping the system up and running, not on
> capacity.
> All good, that works fine.
> 
> Now, a new requirement shows up: the two nodes should be connected
> using two physically separated networks, and should survive failure of
> one of the two networks.

Do you mean split-site? Or just two different networks?
Bonding might be a good option if the latter. 

> 
> The two nodes communicate together for PostgreSQL replication.
> 
> Initially, the slave will communicate with the master on network 1,
> and if network 1 fails, it should switch to network 2.
> 
> Obviously, I cannot use a virtual-ip over two different networks. What
> would be the closest solution in term of features ?
> 
> I was thinking about having a resource agent managing a port forward
> rule on slave node, something like localhost:5433 =>
> master_ip_on_network1:5432, that would switch to localhost:5433 =>
> master_ip_on_network2:5432, so that it would be transparent for the
> replication tool.
> 
> Do you know if such a resource agent is already implemented somewhere ?
> 
> Do you have remarks, comments about such a setup ?
> 
> Do you have suggestion on a better way to achieve these requirements ?
> 
> Thanks,
> 
> Richard
> _______________________________________________
> Linux-HA mailing list
> [email protected]
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems

_______________________________________________
Linux-HA mailing list
[email protected]
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems

Reply via email to