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

[Ashutosh B. <ash...@en...>]

That's a really big mile stone for Postgres-XC. Many people have expressed
concerns about high possibilitiy of SPOF in XC. This solution would prove
beneficial.

On Fri, Aug 10, 2012 at 3:02 PM, 坂田 哲夫 <sak...@la...> wrote:

> Dear folks,
>
> I'm involved in HA facility implementation for Postgres-XC.  This work
> began lecenty by a separate team from Postgres-XC core, say, XC HA team.
>    We're planning to release this facility as an open source software by
> the end of this calendar year.
>
> The Postgres-XC HA facility will be developed in two phases:
>
> Phase1: Furnish fundamental functionality to give 1) redundancy to XC
> core component based on streaming replication which makes transactional
> data in datanode durable, and 2) backup GTM with GTM stand-by to handle
> GTM failure.    Basic   feature of 1) will be taken from PostgreSQL work
> and 2) will be taken from Postgres-XC core feature respectively.
>
> Phase2: Integrate Postgres-XC and Linux-HA.   When one of the
> Postgres-XC components fails, it will be failed over automatically to
> continue Postgres-XC operation.   For this purpose, XC HA team is
> developing RAs (Resource Agents).    RA for coordinator and datanode
> will be implemented first, and then for GTM.   XC HA team will be
> involved in them too.
>
> So far, XC HA team has not released any of the code, documentation or
> other materials.   Please understand that (mainly because of
> administrative reasons) we're not planning to open XC HA team activities
> to public except for requirements to Postgres-XC core, which might have
> some influence to Postgres-XC design, performance and operations etc.
>
> The XC HA team is planning to make its activities open to public when
> the first Postgres-XC HA facility is released.
>
> 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.
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>



-- 
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Enterprise Postgres Company