Thread: [Postgres-xc-general] Postgres-XC - GTM HA

postgres-xc-general

[Postgres-xc-general] Postgres-XC - GTM HA

From: Bruno C. O. <bru...@ho...> - 2014-06-16 18:52:24

Hi!

I'm using this tutorial to simulate a HA environment with Postgres-xc.
http://postgresxc.wikia.com/wiki/GTM_Standby_Configuration

I did the gtm down and gtm-standby going up.
The problem is that is a manual process, i had to run a command in all
gtm-proxy and gtm standby.
How i can make this process automatic?

Thank you!

-- 
Att,
Bruno Cezar de Oliveira.
bru...@ho...
-------------------------------------------------------
Uberlândia - MG.

Re: [Postgres-xc-general] Postgres-XC - GTM HA

From: 鈴木幸市 <ko...@in...> - 2014-06-17 00:47:34

pgxc_ctl provides automated process for this. You have to configure XC cluster with pgxc_ctl though. In this case, although, you need to promote GTM standby and reconnect gtm_proxy with separate pgxc_ctl command.

pgxc_ctl source material is under contrib directory. Reference and tutorial are available at
http://postgres-xc.sourceforge.net/docs/1_2_1/pgxc-ctl.html and
https://sourceforge.net/projects/postgres-xc/files/Pgxc_ctl_primer/ respectively.

Regards;
---
Koichi Suzuki

2014/06/17 3:52、Bruno Cezar Oliveira <bru...@ho...<mailto:bru...@ho...>> のメール：

Hi!

I'm using this tutorial to simulate a HA environment with Postgres-xc.
http://postgresxc.wikia.com/wiki/GTM_Standby_Configuration

I did the gtm down and gtm-standby going up.
The problem is that is a manual process, i had to run a command in all gtm-proxy and gtm standby.
How i can make this process automatic?

Thank you!

--
Att,
Bruno Cezar de Oliveira.
bru...@ho...<mailto:bru...@ho...>
-------------------------------------------------------
Uberlândia - MG.
------------------------------------------------------------------------------
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing & Easy Data Exploration
http://p.sf.net/sfu/hpccsystems_______________________________________________
Postgres-xc-general mailing list
Pos...@li...
https://lists.sourceforge.net/lists/listinfo/postgres-xc-general

Re: [Postgres-xc-general] Postgres-XC - GTM HA

From: Bruno C. O. <bru...@ho...> - 2014-06-17 13:25:26

Hi Koichi Suzuki,

i'm using the pgxc_ctl but how the gtm-proxy can commute to gtm standby
automatic, without a manual intervention?
Whem the gtm-proxy have a timeout more then 5 seconds, for exemple, the
gtm-proxy commute automatically to the gtm standby.

The gtm-proxy can do this? Or i need to create a script to do this?


Thanks for the answer!


2014-06-16 21:47 GMT-03:00 鈴木 幸市 <ko...@in...>:

>  pgxc_ctl provides automated process for this.   You have to configure XC
> cluster with pgxc_ctl though.   In this case, although, you need to promote
> GTM standby and reconnect gtm_proxy with separate pgxc_ctl command.
>
>  pgxc_ctl source material is under contrib directory.    Reference and
> tutorial are available at
> http://postgres-xc.sourceforge.net/docs/1_2_1/pgxc-ctl.html and
> https://sourceforge.net/projects/postgres-xc/files/Pgxc_ctl_primer/
> respectively.
>
>  Regards;
> ---
> Koichi Suzuki
>
>  2014/06/17 3:52、Bruno Cezar Oliveira <bru...@ho...> のメール：
>
>  Hi!
>
> I'm using this tutorial to simulate a HA environment with Postgres-xc.
> http://postgresxc.wikia.com/wiki/GTM_Standby_Configuration
>
> I did the gtm down and gtm-standby going up.
> The problem is that is a manual process, i had to run a command in all
> gtm-proxy and gtm standby.
> How i can make this process automatic?
>
> Thank you!
>
> --
> Att,
> Bruno Cezar de Oliveira.
> bru...@ho...
> -------------------------------------------------------
> Uberlândia - MG.
>
> ------------------------------------------------------------------------------
> HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
> Find What Matters Most in Your Big Data with HPCC Systems
> Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
> Leverages Graph Analysis for Fast Processing & Easy Data Exploration
>
> http://p.sf.net/sfu/hpccsystems_______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>
>
>


-- 
Att,
Bruno Cezar de Oliveira.
bru...@ho...
-------------------------------------------------------
Uberlândia - MG.

Re: [Postgres-xc-general] Postgres-XC - GTM HA

From: 鈴木幸市 <ko...@in...> - 2014-06-18 00:42:55

Could you try “reconnect gtm_proxy”?
---
Koichi Suzuki

2014/06/17 22:25、Bruno Cezar Oliveira <bru...@ho...<mailto:bru...@ho...>> のメール：

Hi Koichi Suzuki,

i'm using the pgxc_ctl but how the gtm-proxy can commute to gtm standby automatic, without a manual intervention?
Whem the gtm-proxy have a timeout more then 5 seconds, for exemple, the gtm-proxy commute automatically to the gtm standby.

The gtm-proxy can do this? Or i need to create a script to do this?

Thanks for the answer!

2014-06-16 21:47 GMT-03:00 鈴木 幸市 <ko...@in...<mailto:ko...@in...>>:
pgxc_ctl provides automated process for this. You have to configure XC cluster with pgxc_ctl though. In this case, although, you need to promote GTM standby and reconnect gtm_proxy with separate pgxc_ctl command.

Regards;
---
Koichi Suzuki

2014/06/17 3:52、Bruno Cezar Oliveira <bru...@ho...<mailto:bru...@ho...>> のメール：

Hi!

I'm using this tutorial to simulate a HA environment with Postgres-xc.
http://postgresxc.wikia.com/wiki/GTM_Standby_Configuration

I did the gtm down and gtm-standby going up.
The problem is that is a manual process, i had to run a command in all gtm-proxy and gtm standby.
How i can make this process automatic?

Thank you!

--
Att,
Bruno Cezar de Oliveira.
bru...@ho...<mailto:bru...@ho...>
-------------------------------------------------------
Uberlândia - MG.
------------------------------------------------------------------------------
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing & Easy Data Exploration
http://p.sf.net/sfu/hpccsystems_______________________________________________
Postgres-xc-general mailing list
Pos...@li...<mailto:Pos...@li...>
https://lists.sourceforge.net/lists/listinfo/postgres-xc-general

--
Att,
Bruno Cezar de Oliveira.
bru...@ho...<mailto:bru...@ho...>
-------------------------------------------------------
Uberlândia - MG.