Re: [Postgres-xc-general] What is the minimum server requirement for pgxc

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

Hi Koichi,

As of now what i am trying to do is, i want to setup pgxc for one state.
but in future this number of state will be increased upto five.

I want to take the advantage multi-master functionality as well as data
synchronization between all the states.with my application there will be
1000 of concurrent connections.

For HA i am setting GTM master and slave if required i can setup slave for
datanodes as well. from my application side i am thinking to use HearBeat
for failover.

i will only have one table in our application which will have billion of
records.

I am looking for such solution which satisfies multi-master and
high-availability
feature. this is th two feature is the main reason i want to use pgxc.

Please suggest.

Regards
Juned Khan



On Thu, Mar 27, 2014 at 8:49 AM, Koichi Suzuki <koi...@gm...>wrote:

> Juned;
>
> I'd like to know what kind of cluster you need to configure.  Also
> would like to know if your application is OLTP, batch or analytic, as
> well as what XC feature you'd like.   If it is OLTP, how much
> transactions your are handling and if each transaction is as simple as
> DBT-1/DBT-2 or bit more complicated as DBT-5.
>
> You're trying to add datanodes so I imaged you're trying to start
> small and then expand the cluster.   I'd like to know how your
> application is growing in size and transaction.
>
> Also, I'd like to know how much HA feature you need and what kind of
> automatic failover tool you are planning to use.
>
> They are always very important points when you choose most suitable
> database for your application.
>
> They are very important to think in advance and if you can share these
> (not what is your application, but the above characteristics), we may
> be able to provide more suitable information to you.
>
> Best Regards
> ---
> Koichi Suzuki
>
>
> 2014-03-26 22:00 GMT+09:00 Mason Sharp <ms...@tr...>:
> >
> >
> >
> > On Wed, Mar 26, 2014 at 8:49 AM, Juned Khan <jkh...@gm...> wrote:
> >>
> >> Hi Mason
> >>
> >> That is correct mailing list helped me a lot, and i am very thankful to
> >> everyone.
> >>
> >> Yeah earlier i have asked about this requirement and received good
> >> response and advices
> >> but the point which you have mentioned that is noticeable, i can not
> >> ignore that
> >>
> >> i should think about this many points before moving ahead.
> >>
> >
> > BTW, I did not mean to discouarge you... I just did not want you to try
> to
> > use XC for a solution where it is not a good fit (or, not a good fit
> without
> > some custom development work) and end up saying that Postgres-XC is not
> good
> > in general.
> >
> > --
> > Mason Sharp
> >
> > TransLattice - http://www.translattice.com
> > Distributed and Clustered Database Solutions
> >
> >
> >
> >
> ------------------------------------------------------------------------------
> > Learn Graph Databases - Download FREE O'Reilly Book
> > "Graph Databases" is the definitive new guide to graph databases and
> their
> > applications. Written by three acclaimed leaders in the field,
> > this first edition is now available. Download your free book today!
> > http://p.sf.net/sfu/13534_NeoTech
> > _______________________________________________
> > 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