Bi-Directional replication client awareness

From: Martin Gudmundsson <martingudmundsson(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Bi-Directional replication client awareness
Date: 2014-07-11 18:42:35
Message-ID: 84184AEF-887D-49DF-8F47-6377B1D6EE9F@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all!
I was wondering if there are any specific load balancing/failover functionality planned for client drivers connection to a BDR group. In my case the jdbc driver, but could be relevant for other drivers as well.

Or is the long term plan that we need we need to rely on middleware like pgpool or other third party frameworks for this?

The reason I’m asking is because I was reading up on BDR and started thinking about who important the client interfaces also are to be able to take full advantage of these features.

Having client awareness of the nodes ip, port numbers, status and current load, could probably bring powerful features to this as a whole. That is some how other database vendors take care of client failover and load balancing and has in my experience proved to work very well.

And not only for BDR, but also streaming replication setups, could use this to do automatic client failovers, in the case there is a server side failover.

Anyone who knows if there is anything in progress regarding this?

Kind regards, Martin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message François Beausoleil 2014-07-11 19:48:37 Re: index contains unexpected zero page at block error
Previous Message Igor Neyman 2014-07-11 17:33:48 Re: Windows Installation User account - Correct database for us