pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
High Availability - Performace Scalability - Dyanamic Load Balancing
4+ messages / 4 participants
[nested] [flat]

* High Availability - Performace Scalability - Dyanamic Load Balancing
@ 2004-08-18 10:10 JM <jerome@gmanmi.tv>
  2004-08-18 13:10 ` Re: [GENERAL] High Availability - Performace Scalability - Dave Cramer <pg@fastcrypt.com>
  0 siblings, 1 reply; 4+ messages in thread

From: JM @ 2004-08-18 10:10 UTC (permalink / raw)
  To: pgsql-admin; +Cc: pgsql-general@postgresql.org

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,




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [GENERAL] High Availability - Performace Scalability -
  2004-08-18 10:10 High Availability - Performace Scalability - Dyanamic Load Balancing JM <jerome@gmanmi.tv>
@ 2004-08-18 13:10 ` Dave Cramer <pg@fastcrypt.com>
  2004-08-18 14:05   ` Re: [GENERAL] High Availability - Performace Scalability Mitch Pirtle <mitchy@spacemonkeylabs.com>
  2004-09-30 15:36   ` Re: [GENERAL] High Availability - Performace Scalability - JEDIDIAH <jedi@nomad.mishnet>
  0 siblings, 2 replies; 4+ messages in thread

From: Dave Cramer @ 2004-08-18 13:10 UTC (permalink / raw)
  To: jerome@gmanmi.tv; +Cc: pgsql-admin@postgresql.org, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [GENERAL] High Availability - Performace Scalability
  2004-08-18 10:10 High Availability - Performace Scalability - Dyanamic Load Balancing JM <jerome@gmanmi.tv>
  2004-08-18 13:10 ` Re: [GENERAL] High Availability - Performace Scalability - Dave Cramer <pg@fastcrypt.com>
@ 2004-08-18 14:05   ` Mitch Pirtle <mitchy@spacemonkeylabs.com>
  1 sibling, 0 replies; 4+ messages in thread

From: Mitch Pirtle @ 2004-08-18 14:05 UTC (permalink / raw)
  To: pg@fastcrypt.com; +Cc: jerome@gmanmi.tv, pgsql-admin@postgresql.org, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [GENERAL] High Availability - Performace Scalability -
  2004-08-18 10:10 High Availability - Performace Scalability - Dyanamic Load Balancing JM <jerome@gmanmi.tv>
  2004-08-18 13:10 ` Re: [GENERAL] High Availability - Performace Scalability - Dave Cramer <pg@fastcrypt.com>
@ 2004-09-30 15:36   ` JEDIDIAH <jedi@nomad.mishnet>
  1 sibling, 0 replies; 4+ messages in thread

From: JEDIDIAH @ 2004-09-30 15:36 UTC (permalink / raw)
  To: pgsql-admin

On 2004-08-18, Dave Cramer <pg@fastcrypt.com> 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.

	Data in an RDBMS application should be localised enough that you
should be able to evenly split the workload over a number of cluster
nodes and not have them step on each other's toes too much. It's a difficult
problem but not insurmountable.

[deletia]

-- 
        Negligence will never equal intent, no matter how you 
attempt to distort reality to do so. This is what separates         ||| 
the real butchers from average Joes (or Fritzes) caught up in      / | \
events not in their control.


                                                     



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2004-09-30 15:36 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-18 10:10 High Availability - Performace Scalability - Dyanamic Load Balancing JM <jerome@gmanmi.tv>
2004-08-18 13:10 ` Re: [GENERAL] High Availability - Performace Scalability - Dave Cramer <pg@fastcrypt.com>
2004-08-18 14:05   ` Re: [GENERAL] High Availability - Performace Scalability Mitch Pirtle <mitchy@spacemonkeylabs.com>
2004-09-30 15:36   ` Re: [GENERAL] High Availability - Performace Scalability - JEDIDIAH <jedi@nomad.mishnet>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox