From: Ericson Smith <eric@did-it.com>
To: Greg Spiegelberg <gspiegelberg@cranel.com>
Cc: pgsql-admin@postgresql.org, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Subject: Re: Clustering Postgres
Date: Mon, 24 May 2004 13:13:12 -0400
Message-ID: <40B22D28.7010307@did-it.com> (raw)
In-Reply-To: <40B222B0.7010204@cranel.com>
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>
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
>
>
>
Attachments:eric.vcf (text/x-vcard, 313B) download
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: eric@did-it.com, gspiegelberg@cranel.com, pgsql-general@postgresql.org
Subject: Re: Clustering Postgres
In-Reply-To: <40B22D28.7010307@did-it.com>
References: <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> <40B22D28.7010307@did-it.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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