Re: Bigtime scaling of Postgresql (cluster and stuff I suppose) - Mailing list pgsql-general

From Vivek Khera
Subject Re: Bigtime scaling of Postgresql (cluster and stuff I suppose)
Date
Msg-id F964FD5C-7906-4FB2-8E03-1B0C24D89E39@khera.org
Whole thread Raw
In response to Bigtime scaling of Postgresql (cluster and stuff I suppose)  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
List pgsql-general
On Aug 25, 2007, at 8:12 AM, Phoenix Kiula wrote:

> The sentence that caught my attention is "Nokia, Alcatel and Nortel
> are all building real-time network nodes on top of MySQL Cluster."
>
> My experiences with MySQL so far have been less than exhilerating
> (only tried it for our web stuff, which is not much so far but
> increasingly rapidly) but I have seen a lot of talk about MySQL
> clusters.
>
> Is there something similar in the PG world? PG Clusters?

MySQL Cluster is a specific product.  It is not just mysql databases
lumped together to make a big mysql DB.  It is a memory-based
database that requires at least 2 machines to run, and is not
usefully redundant and distributed until you have many machines.  The
telco's use it for their logging and switching infrastructure where
you need 100% uptime and wicked fast response (thus memory based.)
And you'll note it was developed by Ericsson...

There is no equivalent in Postgres.

There are several replication choices for Postgres. Google will find
them for you, or just look on the postgres.org pages for the list.
We use slony1 and it works very well for our need.


pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: LDAP service lookup
Next
From: Tom Lane
Date:
Subject: Re: Restore v. Running COPY/INDEX seperatly