Re: postgresql clustering

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/