Received: from calliope1.fm.intel.com (fmfdns01.fm.intel.com [132.233.247.10]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAQK8Gm27283 for ; Mon, 26 Nov 2001 15:08:17 -0500 (EST) (envelope-from michael.g.millsap@intel.com) Received: from fmsmsxvs041.fm.intel.com (fmsmsxvs041.fm.intel.com [132.233.42.126]) by calliope1.fm.intel.com (8.9.1a+p1/8.9.1/d: relay.m4, v 1.46 2001/10/25 21:02:55 root Exp $) with SMTP id UAA02138 for ; Mon, 26 Nov 2001 20:08:17 GMT Received: from FMSMSX018.fm.intel.com ([132.233.42.197]) by fmsmsxvs041.fm.intel.com (NAVGW 2.5.1.6) with SMTP id M2001112612092728667 ; Mon, 26 Nov 2001 12:09:27 -0800 Received: by fmsmsx018.fm.intel.com with Internet Mail Service (5.5.2653.19) id ; Mon, 26 Nov 2001 12:08:13 -0800 Message-ID: From: "Millsap, Michael G" To: "PostgresQL PHP list (E-mail)" Subject: PostgreSQL pseudo cluster Date: Mon, 26 Nov 2001 12:08:02 -0800 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200111/131 X-Sequence-Number: 772 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