Re: postgresql clustering
От | Jonah H. Harris |
---|---|
Тема | Re: postgresql clustering |
Дата | |
Msg-id | 36e6829205092111222afd266f@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: postgresql clustering ("Rafik Salama" <rafikamir@gmail.com>) |
Ответы |
Re: postgresql clustering
("Daniel Duvall" <the.liberal.media@gmail.com>)
|
Список | pgsql-hackers |
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!
--
Respectfully,
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
http://www.enterprisedb.com/
On 9/21/05, Rafik Salama <rafikamir@gmail.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@fetter.org]
Sent: Wednesday, September 21, 2005 8:12 PM
To: Rafik Salama
Cc: pgsql-hackers@postgresql.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@fetter.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/
В списке pgsql-hackers по дате отправления: