On Wed, 2005-09-14 at 11:25 -0700, Peter Darley wrote:
> I'm getting a new server for our database, and I have a quick question
> about RAID controllers with a battery backed cache. I understand that the
> cache will allow the cache to be written out if the power fails to the box,
> which allows it to report a write as committed safely when it's not actually
> committed.
Actually the cache will just hold its contents while the power is out.
When the power is restored, the RAID controller will complete the writes
to disk. If the battery does not last through the outage, the data is
lost.
> My question is, if the power goes off, and the drives stop, how does the
> battery backed cache save things out to the dead drives? Is there another
> component that is implied that will provide power to the drives that I
> should be looking into as well?
A UPS would allow you to do an orderly shutdown and write contents to
disk during a power failure. However a UPS can be an extra point of
failure.
-jwb
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
