Re: [Postgres-xc-developers] Developing HA for PG XC ( was Re: Pacemaker RA for datanode/coordinator)

[Koichi S. <koi...@gm...>]

I think it's a good idea to disclose what assumption is the HA feature
assumes, especially configuration, master slave connection for
coordinator/datanode, use of VIP, interface to applications, etc.
This will help people to be prepared.

I'm also interested if it runs together with Pacemaker/Corosync.

Thanks.
----------
Koichi Suzuki

# I'm now writing a book on PostgreSQL HA.  Do you think I can include
this topic to the book?


2012/8/9 坂田　哲夫 <sak...@la...>:
> Hi folks,
>
> We are now developing HA facility for XC with another team rather than XC
> core development. Say them XC HA team. The facility will be released as open
> source software by the end of this year.
>
> The HA facility will be developed through two phases as follow.
>
> 1. furnish fundamental function giving redundancy to XC core like as
> streaming replication to make transactional data in data nodes durable, GTM
> protecting XIDs with GTM stand-by against failures. These functions are
> mainly developed by PostgreSQL and PG XC core development teams
> respectively.
>
> 2. integrate PG XC and Linux-HA. When a component occurs failure, we would
> like to fail over automatically. To realize this, XC HA team is going to
> develop RAs (resource agents) for data node and coordinator for Linux-HA
> (pacemaker) at first, then RA for GTM and GTM standby.
> This integration (in other words, developing RAs) is done by XC HA team.
>
> So far, XC HA team does not provide its products including source codes,
> documentation as open source. And its activities are not opened either
> except some requirement to XC core which might have influence on XC design,
> performance, operations and so on. XC HA team's activities will be opened
> after we release our first HA facility as I mentioned.
>
> best regards,
> Tetsuo Sakata.
>
>
>
> (2012/07/27 9:20), Koichi Suzuki wrote:
>>
>> I've heard another group is working together with Linux HA Japan to
>> provide XC RA's.
>>
>> Sakata-san, could you provide related info if available?
>>
>> Regards;
>> ----------
>> Koichi Suzuki
>>
>>
>> 2012/7/24 Nikhil Sontakke <ni...@st...>:
>>>
>>> Hi,
>>>
>>> So what's the latest status of these HA activities for PGXC?
>>>
>>> Like the coordinator/datanode agents being discussed here, do we have
>>> agents for GTM for example? Also is this happening in some open source
>>> group where we can participate and see the latest and greatest source
>>> changes?
>>>
>>> Regards,
>>> Nikhils
>
>
> --
> sakata.tetsuo _at_ lab.ntt.co.jp
> SAKATA, Tetsuo. Shinagawa Tokyo JAPAN.