pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL pseudo cluster
2+ messages / 2 participants
[nested] [flat]
* PostgreSQL pseudo cluster
@ 2001-11-26 20:08 Millsap, Michael G <michael.g.millsap@intel.com>
0 siblings, 1 reply; 2+ messages in thread
From: Millsap, Michael G @ 2001-11-26 20:08 UTC (permalink / raw)
To: pgsql-php
I am trying to build a semi-scaleable (up to three SMP servers),
highly-available database without forking over $300k to Oracle. I expect the
app to be about 90% reads and 10%writes. The architecture will be the
Internet into a Cisco Local Director load balancer that will forward
requests to one of three web servers running Apache/PHP. The web servers
will have redundant Gb Ethernet cards running into redundant switches, which
then run into the three database servers. Each web server will have it's own
dedicated database server for reads. For writes, I was planning on having
wrapper functions that would modify all three databases for each modifying
transaction, thus keeping my data synchronized between database servers.
Each database will have it's own storage, as most of the data for the
application will be graphics files that I will keep on a NAS, reference by
the database instead of storing in the database. Does anyone have experience
with such an architecture? Does it sound prudent?
Thanks,
Mike Millsap
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: PostgreSQL pseudo cluster
@ 2001-12-02 16:58 Jean-Michel POURE <jm.poure@freesurf.fr>
parent: Millsap, Michael G <michael.g.millsap@intel.com>
0 siblings, 0 replies; 2+ messages in thread
From: Jean-Michel POURE @ 2001-12-02 16:58 UTC (permalink / raw)
To: pgsql-php
Le Lundi 26 Novembre 2001 21:08, vous avez écrit :
> I am trying to build a semi-scaleable (up to three SMP servers),
> highly-available database without forking over $300k to Oracle. I expect
> the app to be about 90% reads and 10%writes.
Hello Mike,
It is impossible to query/update several PostgreSQL servers using server-side
languages (PLpgSQL, PERLpgSQL, etc...). Schema support (planned for 7.3)
might bring these features.
For the moment, there are three replication packages available:
- http://www.erserver.com/
- http://pgreplicator.sourceforge.net/
- http://gborg.postgresql.org/project/pgreplication/projdisplay.php
I never used replication before and do not know whether these projects are
mature or not. Maybe you should register ADMIN and GENERAL mailing lists and
ask for advice there.
Best regards,
Jean-Michel POURE
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-12-02 16:58 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-11-26 20:08 PostgreSQL pseudo cluster Millsap, Michael G <michael.g.millsap@intel.com>
2001-12-02 16:58 ` Jean-Michel POURE <jm.poure@freesurf.fr>
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