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!



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 по дате отправления:

Предыдущее
От: Chris Browne
Дата:
Сообщение: Re: R: feature proposal ...
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Table Partitioning is in 8.1