From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Jeff Davis <pgsql@j-davis.com>
Cc: Peter Kovacs <maxottovonstirlitz@gmail.com>
Cc: Shane Ambler <pgsql@sheeky.biz>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Carlos Moreno <moreno_pg@mochima.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Two hard drives --- what to do with them?
Date: Tue, 27 Feb 2007 13:38:56 -0600
Message-ID: <1172605135.20651.81.camel@state.g2switchworks.com> (raw)
In-Reply-To: <1172604229.10824.365.camel@dogma.v10.wvs>
References: <45DF3B15.1070609@3times25.net>
<45DF94BF.6050904@3times25.net>
<45E0A500.1010707@commandprompt.com>
<45E104DD.3080600@mochima.com>
<2055.1172375931@sss.pgh.pa.us>
<b6e8f2e80702251411q5a27eb53re9c2a299b8e3880a@mail.gmail.com>
<1172526666.10824.315.camel@dogma.v10.wvs>
<b6e8f2e80702261611j598b1771g3dbcfc9bb1f9cdf2@mail.gmail.com>
<1172535914.10824.327.camel@dogma.v10.wvs>
<45E3BC09.60100@Sheeky.Biz>
<b6e8f2e80702270027s1c684f42vb3eca0a1d87ed5fb@mail.gmail.com>
<1172604229.10824.365.camel@dogma.v10.wvs>
On Tue, 2007-02-27 at 13:23, Jeff Davis wrote:
> Also, put things in context. The chances of failure due to these kinds
> of things are fairly low. If it's more likely that someone spills coffee
> on your server than the UPS fails, it doesn't make sense to spend huge
> amounts of money on NVRAM (or something) to store your data. So identify
> the highest-risk scenarios and prevent those first.
>
> Also keep in mind what the cost of failure is: a few hundred bucks more
> on a better RAID controller is probably a good value if it prevents a
> day of chaos and unhappy customers.
Just FYI, I can testify to the happiness a good battery backed caching
RAID controller can bring. I had the only server that survived a
complete power grid failure in the data center where I used to work. A
piece of wire blew out a power conditioner, which killed the other power
conditioner, all three UPSes and the switch to bring the diesel
generator online.
the only problem the pgsql server had coming back up was that it had
remote nfs mounts it used for file storage that weren't able to boot up
fast enough so we just waited a few minutes and rebooted it.
All of our other database servers had to be restored from backup due to
massive data corruption because someone had decided that NFS mounts were
a good idea under databases.
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: smarlowe@g2switchworks.com, pgsql@j-davis.com, maxottovonstirlitz@gmail.com, pgsql@sheeky.biz, tgl@sss.pgh.pa.us, moreno_pg@mochima.com
Subject: Re: Two hard drives --- what to do with them?
In-Reply-To: <1172605135.20651.81.camel@state.g2switchworks.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