Обсуждение: High Availability - Performace Scalability - Dyanamic Load Balancing

Поиск
Список
Период
Сортировка

High Availability - Performace Scalability - Dyanamic Load Balancing

От
JM
Дата:
Hi All,

    I just came off an exibit and I was wondering if there ways to do clustering
in postgres.
    I envy mySQL because there's a application for clustering it...

    EMIC networks has this marketing tagline:
        High Availability - Performace Scalability - Dyanamic Load Balancing
    they are the one who provide this app... ( but its not open source )


Thanks,


Re: High Availability - Performace Scalability -

От
Dave Cramer
Дата:
Jerome,

I'm curious what you expect out of clustering. High Availability, and
Load Balancing seem possible, but Performance ? I would think there is a
cost associated with clustering, that degrades performance.

Anyways, to answer your question, there are a few tools that allow High
Availability, and Load Balancing.

pgpool ftp://ftp.sra.co.jp/pub/cmd/postgres/pgpool/pgpool-2.0.8.tar.gz

and if you prefer java C-JDBC
http://c-jdbc.objectweb.org/

Dave
On Wed, 2004-08-18 at 06:10, JM wrote:
> Hi All,
>
>     I just came off an exibit and I was wondering if there ways to do clustering
> in postgres.
>     I envy mySQL because there's a application for clustering it...
>
>     EMIC networks has this marketing tagline:
>         High Availability - Performace Scalability - Dyanamic Load Balancing
>     they are the one who provide this app... ( but its not open source )
>
>
> Thanks,
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
--
Dave Cramer
519 939 0336
ICQ # 14675561


Re: [ADMIN] High Availability - Performace Scalability

От
Mitch Pirtle
Дата:
Dave Cramer wrote:

>Jerome,
>
>I'm curious what you expect out of clustering. High Availability, and
>Load Balancing seem possible, but Performance ? I would think there is a
>cost associated with clustering, that degrades performance.
>
>Anyways, to answer your question, there are a few tools that allow High
>Availability, and Load Balancing.
>
>pgpool ftp://ftp.sra.co.jp/pub/cmd/postgres/pgpool/pgpool-2.0.8.tar.gz
>
>and if you prefer java C-JDBC
>http://c-jdbc.objectweb.org/
>

Another interesting tool is SQLRelay:

    http://sqlrelay.sf.net/

-- Mitch