X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D9C4FD1B34D for ; Mon, 24 May 2004 14:13:37 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 26826-01 for ; Mon, 24 May 2004 14:13:17 -0300 (ADT) Received: from pop.e-it.com (pop.e-it.com [216.187.113.81]) by svr1.postgresql.org (Postfix) with ESMTP id 0F1EAD1B19F for ; Mon, 24 May 2004 14:13:15 -0300 (ADT) Received: (qmail 20568 invoked by uid 500); 24 May 2004 17:13:08 -0000 Received: from ool-18b9d65f.dyn.optonline.net (HELO did-it.com) (eric@did-it.com@24.185.214.95) by pop.e-it.com with SMTP; 24 May 2004 17:13:08 -0000 Message-ID: <40B22D28.7010307@did-it.com> Date: Mon, 24 May 2004 13:13:12 -0400 From: Ericson Smith User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Greg Spiegelberg Cc: pgsql-admin@postgresql.org, "pgsql-general@postgresql.org" Subject: Re: Clustering Postgres References: <20030310205101.65721.qmail@web41607.mail.yahoo.com> <20030310205101.65721.qmail@web41607.mail.yahoo.com> <5.1.0.14.2.20030313080301.01ebea78@mail.earthlink.net> <20030313121356.J4545@hub.org> <40ACF95D.4030802@musicrebellion.com> <1085172198.9127.1549.camel@camel> <40B1FFDC.9040303@cranel.com> <40B217F2.1080608@did-it.com> <40B222B0.7010204@cranel.com> In-Reply-To: <40B222B0.7010204@cranel.com> Content-Type: multipart/mixed; boundary="------------020903040406020308070609" X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=RCVD_IN_NJABL, RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200405/250 X-Sequence-Number: 13566 This is a multi-part message in MIME format. --------------020903040406020308070609 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit We'd be very interested in the performance, especially with the disk being used as in interconnect (I assume that that is being used to simulate global shared memory?) We did have a talk with the folks over at http://www.linuxlabs.com/clustgres They were honest enough to say that even with the Dolphon interconnects, that writing would be slower than usual. We have not made a complete decision on that yet, but are still looking at alternatives. It seems that Clustres might be a good solution. They use a SAN, the Dolphin interconnects, and multiple diskless nodes. In theory I am sure it works, but this is one of the chicken/egg problems where we want to see it in general use first before committing :-) - Ericson Greg Spiegelberg wrote: > 2 dual PIII-1.4GHz Linux RedHat 3.0 servers each with onboard AIC7xxx > and 2 U160 drives (mirrored), 2 GB of ECC memory, 2 onboard Intel Ether > Pro 100Mbps type NIC's, 1 Qlogic 2310 HBA on a 1GBs SAN using a Candera > 510 storage cluster with Xyratex SATA on the backend configured with 1+0 > LUN's. It will be using a private network and a small disk on the SAN > as the interconnect. > > Once I have it running and I've run the necessary tests for myself > I could run a few tests for anyone else who is interested. Deadline > is June 18th when either I scrap it and try a different solution or > we have to buy in which case I'll need it for our production databases. > Below is the config I intend to use for PostgreSQL 7.4.2. > > Greg > > > PostgreSQL 7.4.2 config & compile > configure \ > --prefix=/psfs1/apps/pgsql-7.4.2 \ > --enable-thread-safety \ > --enable-largefiles \ > --enable-odbc \ > --enable-multibyte \ > --enable-shared \ > --enable-syslog \ > --with-perl \ > --with-CXX \ > --with-pam \ > --with-maxbackends=128 \ > --with-tcl \ > --with-readline \ > --with-zlib > make -j 2 CPPFLAGS="-O3 -DALLOW_ABSOLUTE_DBPATHS -DLOCK_DEBUG" all > > > > Ericson Smith wrote: > >> Do you mean that you are actually testing this product now? If so, >> what's the hardware configuration (nodes, storage server, >> interconnects) that you are using? >> >> Warmest regards, Ericson Smith >> Tracking Specialist/DBA >> +-----------------------+-----------------------------------------+ >> | http://www.did-it.com | "3 Years ago I was worth $5M on paper!" | >> | eric@did-it.com | "Sweet! Can I have fries with that?" | >> | 516-255-0500 | - Tom Tomorrow | >> +-----------------------+-----------------------------------------+ >> >> >> Greg Spiegelberg wrote: >> >>> Robert, >>> >>> I am currently evaluating PolyServe Matrix Server which is a clustering >>> solution including a clustered file system (mounted read-write >>> everywhere). >>> >>> Anything special anyone wants to know? I'm using PostgreSQL 7.4.2 in >>> a Linux cluster. >>> >>> Greg >>> >>> >>> Robert Treat wrote: >>> >>>> On Thu, 2004-05-20 at 14:30, Kris Kiger wrote: >>>> >>>>> Has anyone heard of clusgres or, better yet, had any experience >>>>> with it? I came across it while searching for active clustering >>>>> projects. >>>>> >>>>> http://www.linuxlabs.com/clusgres.html >>>>> >>>>> Thanks in advance for the info! >>>>> >>>> >>>> >>>> I have heard of it but I've not heard of any reports on these lists of >>>> how well it works. If you (or anyone else) gives it a spin please >>>> try to >>>> post an account to the list and/or if you send me the info it could >>>> probably make its way on to techdocs. >>>> Robert Treat >>> >>> >>> >>> >>> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 4: Don't 'kill -9' the postmaster > > > --------------020903040406020308070609 Content-Type: text/x-vcard; charset=utf8; name="eric.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="eric.vcf" begin:vcard fn:Ericson Smith n:Smith;Ericson org:Did-it.com;Programming adr:#304;;55 Maple Avenue;Rockville Center;NY;11570;USA email;internet:eric@did-it.com title:Web Developer tel;work:516-255-0500 tel;cell:646-483-3420 note:Nothing special! x-mozilla-html:FALSE url:http://www.did-it.com version:2.1 end:vcard --------------020903040406020308070609--