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