Re: postgresql clustering

Jonah,

I stumbled on this discussion in one of my recurring searches for an
open-source database app capable of true clustering (failover, load
balancing, etc) that I can pair with my PHP application. A search
that, sadly, most often ends in disappointment -- there's tons and tons
of database marketing BS out there.

Part of my frustration is do to my lack of a real understanding of the
models you mentioned in your comment. I've been searching for
meaningful text and comparisons of the different clustering models, but
have yet to find anything that truely breaks it down well (and deep).

Could you perhaps point me -- and anyone else that happens upon this
post with the same frustrations -- in the right direction?

I've looked at PostgreSQL and EnterpriseDB, but I can't find anything
definitive as far as clustering capabilities. What kinds of projects
are there for clustering PgSQL, and are any of them mature enough for
commercial apps?

Best,
Dan

"Jonah H. Harris" wrote:
> In the past couple years I've worked on several personal/business projects
> to cluster PostgreSQL and InnoDB (without MySQL). I've tested
> shared-nothing, shared-memory, and shared-disk models. IMHO, shared-disk is
> the only viable option for performance and/or large production business
> environments. Using shared-memory or shared-nothing architectures in a
> database are fine for high-availability, but are expensive from a
> business-case for added performance. I'd be happy to share any of my
> clustering knowledge with ya offline. Have fun!
>
>
>
> On 9/21/05, Rafik Salama <rafikamir(at)gmail(dot)com> wrote:
> >
> > No I do not have a case study, I just read so, but what I am suggesting to
> > start doing is that if there is no cluster implementation to give high
> > availability of the database, I will start doing this project through the
> > message passing technique and I already have in the university a cluster
> > of
> > 19 machine intel xeon, you can see it in this URL
> > http://www.cs.aucegypt.edu/~cluster
> >
> > But any way I was just asking so as not to reinvent the Wheel, in case
> > there
> > is something like that, but since there is not, I will give it a try, at
> > the
> > end of the day it is open source and I can do anything and if it happens
> > to
> > work, who knows!!!!
> >
> > Thanks
> >
> > Rafik Salama
> > Systems Architect
> >
> > CIT Global
> > CIT Building, Free Zone
> > Nasr City,
> > P.O.Box 11816, Cairo, Egypt
> > Tel : +202 271 8794 (ext. 115)
> > Fax : +202 2748335
> > Cell: +2010 5410035
> > http://www.citglobal.com
> >
> > -----Original Message-----
> > From: David Fetter [mailto:david(at)fetter(dot)org]
> > Sent: Wednesday, September 21, 2005 8:12 PM
> > To: Rafik Salama
> > Cc: pgsql-hackers(at)postgresql(dot)org
> > Subject: Re: [HACKERS] postgresql clustering
> >
> > On Wed, Sep 21, 2005 at 08:01:08PM +0300, Rafik Salama wrote:
> > > Dear Sirs
> > >
> > > I know that that postgresql can be configured for high availability
> > > over a clustered environment using pgcluster,
> >
> > Do you have a case study showing this?
> >
> > > I am currently studying in my masters the clustering using MPI and
> > > OpenMP, PVM and others packages and I have to do a project, so I was
> > > thinking to use this opportunity to start implementing the
> > > clustering over postgresql using any of the above packages.
> > >
> > > What do you think?
> >
> > Let a thousand schools of thought content. Let a hundred flowers
> > bloom.
> >
> > Cheers,
> > D
> > --
> > David Fetter david(at)fetter(dot)org http://fetter.org/
> > phone: +1 510 893 6100 mobile: +1 415 235 3778
> >
> > Remember to vote!
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: don't forget to increase your free space map settings
> >
>
>
>
> --
> Respectfully,
>
> Jonah H. Harris, Database Internals Architect
> EnterpriseDB Corporation
> http://www.enterprisedb.com/