Обсуждение: postgresql HA solution for different network domain
Hi all;
I have question about postgresql HA solituons. I want to make a replication on two different network domains. The master is one side(10.100.34.21 etc.) the replica the other side(192.145.78.32 etc.). So these machines have different network. The application servers should not affect during failover so we should not change any thing on application servers..like ip.. we saw vip solution but that won't help on different ip blocks... Do u have any advice or idea about on it?
Thanks in advance...
You can put a HAProxy between your application and database, with something like that: https://severalnines.com/blog/postgresql-load-balancing-using-haproxy-keepalived Regards, Nicolas KAROLAK | SysAdmin 6-8, rue André Voguet - 94200 Ivry-sur-Seine +33 1 77 56 77 96 | www.ubicast.eu | www.ubicast.tv Le sam. 15 sept. 2018 à 08:11, Amine Tengilimoglu <aminetengilimoglu@gmail.com> a écrit : > > Hi all; > > > I have question about postgresql HA solituons. I want to make a replication on two different network domains. The masteris one side(10.100.34.21 etc.) the replica the other side(192.145.78.32 etc.). So these machines have different network.The application servers should not affect during failover so we should not change any thing on application servers..likeip.. we saw vip solution but that won't help on different ip blocks... Do u have any advice or idea about onit? > > > > Thanks in advance...