| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
| Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, "Shulgin, Oleksandr" <oleksandr(dot)shulgin(at)zalando(dot)de>, Andres Freund <andres(at)anarazel(dot)de>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, Victor Wagner <vitus(at)wagner(dot)pp(dot)ru>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Proposal: Implement failover on libpq connect level. |
| Date: | 2015-09-11 12:38:58 |
| Message-ID: | CA+Tgmob64+A1pmLeFjvB6=TA9KZZ2gSysu3TxcC2xUvtfVzkRg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-jdbc |
On Wed, Sep 9, 2015 at 4:30 PM, Kevin Grittner <kgrittn(at)ymail(dot)com> wrote:
> Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>
>> I think the problem we should be trying to solve is: Given a set
>> of server IPs, connect to one that is up.
>>
>> I believe this comes up in several different scenarios.
>>
>> Example #1: [single server; changing IP address gracefully]
>>
>> Example #2: [xDB/BDR client uses local master if up; else a remote]
>>
>> Example #3: [SR/HS with changing primary]
>
> For all of those it is clear that we do not need (or want!)
> heartbeat, STONITH, fencing, etc. to be handled by the connector.
> If the above are the sorts of problems we are trying to solve, a
> very simple solution is the best. I know you outlined several; I'm
> not sure it would matter all that much which one we used -- any
> would work and someone should Just Do It.
>
>> I'm sure there are more.
>
> Ay, there's the rub. Some people seemed to be suggesting that this
> should be far more than what you describe above. That would, IMO,
> be a mistake.
It sounds like we are pretty much on the same page. :-)
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anastasia Lubennikova | 2015-09-11 12:45:04 | [PROPOSAL] Covering + unique indexes. |
| Previous Message | Robert Haas | 2015-09-11 12:36:04 | Re: Moving SS_finalize_plan processing to the end of planning |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2015-09-17 21:28:52 | JDBC 1203 released |
| Previous Message | Kevin Grittner | 2015-09-09 20:30:49 | Re: Proposal: Implement failover on libpq connect level. |