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

[坂田 哲夫 <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.