Re: [Postgres-xc-general] Info about permormance and high availability of postgres-xc

[鈴木 幸市 <ko...@in...>]

I might have been wrong.   My colleague tried to do it with Heartbeat and couldn’t find how to do it.   Corosync may be better to handle it.

Thanks.
---
Koichi Suzuki

2014/10/20 19:58、Nikhil Sontakke <ni...@tr...<mailto:ni...@tr...>> のメール：

Hi Suzuki-san,

Yes, we have written custom resource Corosync/Pacemaker agents for failover of GTM to GTM-standby and also for failover of datanodes in Postgres-XL.

As Mason mentioned, the setup is a little complicated, but doable and yes we need to be a little careful about too eager failover.

Regards,
Nikhils

On Mon, Oct 20, 2014 at 3:27 PM, Koichi Suzuki <koi...@gm...<mailto:koi...@gm...>> wrote:
Does your configuration offer all the failover, including GTM,
datanode and coordinator?
---
Koichi Suzuki


2014-10-20 18:33 GMT+09:00 Mason Sharp <ms...@tr...<mailto:ms...@tr...>>:
>
>
> On Mon, Oct 20, 2014 at 11:19 AM, 鈴木 幸市 <ko...@in...<mailto:ko...@in...>> wrote:
>>
>> In HA, I don’t think Corosync/Pacemaker can deal with XC configuration,
>> where many components are interrelated and they are HA-aware.    At present,
>> Corosync/Pacemaker works well for HA-unaware components with master/slave
>> pair model.   XC configuration is more complicated than what they can deal
>> with.
>>
>
> We have configured with Corosync/Pacemaker. It is complex, however.
>
>
>
> --
> Mason Sharp
>
> TransLattice - http://www.translattice.com<http://www.translattice.com/>
> Clustered and Distributed Database Solutions
>
>
>
> ------------------------------------------------------------------------------
> Comprehensive Server Monitoring with Site24x7.
> Monitor 10 servers for $9/Month.
> Get alerted through email, SMS, voice calls or mobile push notifications.
> Take corrective actions from your mobile device.
> http://p.sf.net/sfu/Zoho
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...<mailto:Pos...@li...>
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Postgres-xc-general mailing list
Pos...@li...<mailto:Pos...@li...>
https://lists.sourceforge.net/lists/listinfo/postgres-xc-general



--
TransLattice - http://www.translattice.com<http://www.translattice.com/>
Distributed and Clustered Database Solutions
Postgres-XL Support

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho_______________________________________________
Postgres-xc-general mailing list
Pos...@li...
https://lists.sourceforge.net/lists/listinfo/postgres-xc-general