Обсуждение: postgresql HA solution for different network domain

Поиск
Список
Период
Сортировка

postgresql HA solution for different network domain

От
Amine Tengilimoglu
Дата:

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

Re: postgresql HA solution for different network domain

От
Nicolas Karolak
Дата:
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...