postgres-xc-general

[Postgres-xc-general] Problem wtih GTM Stand By configuration

[Juned K. <jkh...@gm...>]

Hi All,

I want to use postgre-xc for multi master uses. I want to setup two server
with GTM,cordinator and datanodes.

And in future i want to add another servers as well with same
configuration, and in future i will add more.

To test this, i have setup two server with GTM,Coordinator and datanode on
same server. i have follow below link for configuration.

http://postgresxc.wikia.com/wiki/Laptop_configuration

Now How do i configuration this two system as master master configuration,
will add more masters in future.

I found link of GTM standby configuration,then i have setup GTM standby on
one separate system using below link.

http://postgresxc.wikia.com/wiki/GTM_Standby_Configuration

then i started GTM, datanodes and ordinators on both server, then i tried
to run below command on Stand By  server.

gtm_ctl promote -Z gtm -D /home/postgresxc/pgxc/gtm/ -o "-s gtm -t 20001"

But got this error:
gtm_ctl: could not send promote signal (PID: 11937): No such process

So my question is am i going to right way to achieve my goal ? how do i
avoid this error ?


-- 
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com

Re: [Postgres-xc-general] Problem wtih GTM Stand By configuration

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

If you mean master-master just replication, you should specify each
table as DISTRIBUTE BY REPLICATION.

Adding servers could be complicated steps.   I advice to use pgxc_ctl
to configure and maintain your cluster.    You will find the document
at http://postgres-xc.sourceforge.net/docs/1_1/pgxc-ctl.html

When you add new server, you can add new
datanode/coordinator/gtm_proxy with pgxc_ctl commands.    Also, you
can redistribute your table (in this case, add a node to replicate the
data), you can use ALTER TABLE.   Document will be at
http://postgres-xc.sourceforge.net/docs/1_1/sql-altertable.html

XC is not intended to use as multimaster replication.    It assumes
that you have a few big tables updated very frequently (transaction
tables) which should be distributed, not replicated and other tables
which are relatively stable and are joined frequently with transaction
tables (master tables).

Regards;
---
Koichi Suzuki


2014-02-17 15:51 GMT+09:00 Juned Khan <jkh...@gm...>:
> Hi All,
>
> I want to use postgre-xc for multi master uses. I want to setup two server
> with GTM,cordinator and datanodes.
>
> And in future i want to add another servers as well with same configuration,
> and in future i will add more.
>
> To test this, i have setup two server with GTM,Coordinator and datanode on
> same server. i have follow below link for configuration.
>
> http://postgresxc.wikia.com/wiki/Laptop_configuration
>
> Now How do i configuration this two system as master master configuration,
> will add more masters in future.
>
> I found link of GTM standby configuration,then i have setup GTM standby on
> one separate system using below link.
>
> http://postgresxc.wikia.com/wiki/GTM_Standby_Configuration
>
> then i started GTM, datanodes and ordinators on both server, then i tried to
> run below command on Stand By  server.
>
> gtm_ctl promote -Z gtm -D /home/postgresxc/pgxc/gtm/ -o "-s gtm -t 20001"
>
> But got this error:
> gtm_ctl: could not send promote signal (PID: 11937): No such process
>
> So my question is am i going to right way to achieve my goal ? how do i
> avoid this error ?
>
>
> --
> Thanks,
> Juned Khan
> iNextrix Technologies Pvt Ltd.
> www.inextrix.com
>
> ------------------------------------------------------------------------------
> Android apps run on BlackBerry 10
> Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
> Now with support for Jelly Bean, Bluetooth, Mapview and more.
> Get your Android app in front of a whole new audience.  Start now.
> http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>

Re: [Postgres-xc-general] Problem wtih GTM Stand By configuration

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

You cannot configure more than one GTM master in a cluster.   You need to configure only one GTM, which will takes care of all the nodes in the cluster.

You need to create tables with “DISTRIBUTE BY REPLICATION” clause.   Documentation will be found at http://postgres-xc.sourceforge.net/docs/1_1/sql-createtable.html

Regards;
---
Koichi Suzuki

2014/02/22 17:20、Juned Khan <jkh...@gm...<mailto:jkh...@gm...>> のメール：

Hi Koichi,

PFA
Thanks for your response.

Let me explain you my exact requirement. I have attached one image for that.

As per that image i have multiple states which has GTM, datanodes and coordinators.
In future i will add more states. so how data will be replicated with the datanodes of different stat.

can i configure central GTM server which can handle all this stuff., or how do i configure each
GTM to communicate with other GTMs so all DBs can be replicated



On Mon, Feb 17, 2014 at 1:08 PM, Koichi Suzuki <koi...@gm...<mailto:koi...@gm...>> wrote:
If you mean master-master just replication, you should specify each
table as DISTRIBUTE BY REPLICATION.

Adding servers could be complicated steps.   I advice to use pgxc_ctl
to configure and maintain your cluster.    You will find the document
at http://postgres-xc.sourceforge.net/docs/1_1/pgxc-ctl.html

When you add new server, you can add new
datanode/coordinator/gtm_proxy with pgxc_ctl commands.    Also, you
can redistribute your table (in this case, add a node to replicate the
data), you can use ALTER TABLE.   Document will be at
http://postgres-xc.sourceforge.net/docs/1_1/sql-altertable.html

XC is not intended to use as multimaster replication.    It assumes
that you have a few big tables updated very frequently (transaction
tables) which should be distributed, not replicated and other tables
which are relatively stable and are joined frequently with transaction
tables (master tables).

Regards;
---
Koichi Suzuki


2014-02-17 15:51 GMT+09:00 Juned Khan <jkh...@gm...<mailto:jkh...@gm...>>:
> Hi All,
>
> I want to use postgre-xc for multi master uses. I want to setup two server
> with GTM,cordinator and datanodes.
>
> And in future i want to add another servers as well with same configuration,
> and in future i will add more.
>
> To test this, i have setup two server with GTM,Coordinator and datanode on
> same server. i have follow below link for configuration.
>
> http://postgresxc.wikia.com/wiki/Laptop_configuration
>
> Now How do i configuration this two system as master master configuration,
> will add more masters in future.
>
> I found link of GTM standby configuration,then i have setup GTM standby on
> one separate system using below link.
>
> http://postgresxc.wikia.com/wiki/GTM_Standby_Configuration
>
> then i started GTM, datanodes and ordinators on both server, then i tried to
> run below command on Stand By  server.
>
> gtm_ctl promote -Z gtm -D /home/postgresxc/pgxc/gtm/ -o "-s gtm -t 20001"
>
> But got this error:
> gtm_ctl: could not send promote signal (PID: 11937): No such process
>
> So my question is am i going to right way to achieve my goal ? how do i
> avoid this error ?
>
>
> --
> Thanks,
> Juned Khan
> iNextrix Technologies Pvt Ltd.
> www.inextrix.com<http://www.inextrix.com/>
>
> ------------------------------------------------------------------------------
> Android apps run on BlackBerry 10
> Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
> Now with support for Jelly Bean, Bluetooth, Mapview and more.
> Get your Android app in front of a whole new audience.  Start now.
> http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...<mailto:Pos...@li...>
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>



--
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com<http://www.inextrix.com/>
<diagram_new.png>------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk_______________________________________________
Postgres-xc-general mailing list
Pos...@li...
https://lists.sourceforge.net/lists/listinfo/postgres-xc-general

Re: [Postgres-xc-general] Problem wtih GTM Stand By configuration

[Juned K. <jkh...@gm...>]

Hi Koichi,

i think i should try this with my local system first.

Thanks you very much for help.


On Mon, Feb 24, 2014 at 11:20 AM, 鈴木 幸市 <ko...@in...> wrote:

>  You cannot configure more than one GTM master in a cluster.   You need to
> configure only one GTM, which will takes care of all the nodes in the
> cluster.
>
>  You need to create tables with “DISTRIBUTE BY REPLICATION” clause.
> Documentation will be found at
> http://postgres-xc.sourceforge.net/docs/1_1/sql-createtable.html
>
>  Regards;
> ---
> Koichi Suzuki
>
>  2014/02/22 17:20、Juned Khan <jkh...@gm...> のメール：
>
>    Hi Koichi,
>
>  PFA
>  Thanks for your response.
>
>  Let me explain you my exact requirement. I have attached one image for
> that.
>
>  As per that image i have multiple states which has GTM, datanodes and
> coordinators.
> In future i will add more states. so how data will be replicated with the
> datanodes of different stat.
>
>  can i configure central GTM server which can handle all this stuff., or
> how do i configure each
> GTM to communicate with other GTMs so all DBs can be replicated
>
>
>
> On Mon, Feb 17, 2014 at 1:08 PM, Koichi Suzuki <koi...@gm...>wrote:
>
>> If you mean master-master just replication, you should specify each
>> table as DISTRIBUTE BY REPLICATION.
>>
>> Adding servers could be complicated steps.   I advice to use pgxc_ctl
>> to configure and maintain your cluster.    You will find the document
>> at http://postgres-xc.sourceforge.net/docs/1_1/pgxc-ctl.html
>>
>> When you add new server, you can add new
>> datanode/coordinator/gtm_proxy with pgxc_ctl commands.    Also, you
>> can redistribute your table (in this case, add a node to replicate the
>> data), you can use ALTER TABLE.   Document will be at
>> http://postgres-xc.sourceforge.net/docs/1_1/sql-altertable.html
>>
>> XC is not intended to use as multimaster replication.    It assumes
>> that you have a few big tables updated very frequently (transaction
>> tables) which should be distributed, not replicated and other tables
>> which are relatively stable and are joined frequently with transaction
>> tables (master tables).
>>
>> Regards;
>> ---
>> Koichi Suzuki
>>
>>
>> 2014-02-17 15:51 GMT+09:00 Juned Khan <jkh...@gm...>:
>>  > Hi All,
>> >
>> > I want to use postgre-xc for multi master uses. I want to setup two
>> server
>> > with GTM,cordinator and datanodes.
>> >
>> > And in future i want to add another servers as well with same
>> configuration,
>> > and in future i will add more.
>> >
>> > To test this, i have setup two server with GTM,Coordinator and datanode
>> on
>> > same server. i have follow below link for configuration.
>> >
>> > http://postgresxc.wikia.com/wiki/Laptop_configuration
>> >
>> > Now How do i configuration this two system as master master
>> configuration,
>> > will add more masters in future.
>> >
>> > I found link of GTM standby configuration,then i have setup GTM standby
>> on
>> > one separate system using below link.
>> >
>> > http://postgresxc.wikia.com/wiki/GTM_Standby_Configuration
>> >
>> > then i started GTM, datanodes and ordinators on both server, then i
>> tried to
>> > run below command on Stand By  server.
>> >
>> > gtm_ctl promote -Z gtm -D /home/postgresxc/pgxc/gtm/ -o "-s gtm -t
>> 20001"
>> >
>> > But got this error:
>> > gtm_ctl: could not send promote signal (PID: 11937): No such process
>> >
>> > So my question is am i going to right way to achieve my goal ? how do i
>> > avoid this error ?
>> >
>> >
>> > --
>> > Thanks,
>> > Juned Khan
>> > iNextrix Technologies Pvt Ltd.
>> > www.inextrix.com
>> >
>>  >
>> ------------------------------------------------------------------------------
>> > Android apps run on BlackBerry 10
>> > Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
>> > Now with support for Jelly Bean, Bluetooth, Mapview and more.
>> > Get your Android app in front of a whole new audience.  Start now.
>> >
>> http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
>> > _______________________________________________
>> > Postgres-xc-general mailing list
>> > Pos...@li...
>> > https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>> >
>>
>
>
>
> --
> Thanks,
> Juned Khan
> iNextrix Technologies Pvt Ltd.
> www.inextrix.com
>  <diagram_new.png>
> ------------------------------------------------------------------------------
> Managing the Performance of Cloud-Based Applications
> Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
> Read the Whitepaper.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk_______________________________________________
>
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>
>
>


-- 
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com