Re: Table locking problems?

From: Dan Harris <fbsd(at)drivefaster(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Table locking problems?
Date: 2005-08-09 22:05:34
Message-ID: 17797211-4C5F-4410-B38E-53ECC10D0752@drivefaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Aug 9, 2005, at 3:51 PM, John A Meinel wrote:

> Dan Harris wrote:
>
>> On Aug 10, 2005, at 12:49 AM, Steve Poe wrote:
>>
>>> Dan,
>>>
>>> Do you mean you did RAID 1 + 0 (RAID 10) or RAID 0 + 1? Just a
>>> clarification, since RAID 0 is still a single-point of failure
>>> even if
>>> RAID1 is on top of RAID0.
>>>
>> Well, you tell me if I stated incorrectly. There are two raid
>> enclosures with 7 drives in each. Each is on its own bus on a
>> dual- channel controller. Each box has a stripe across its drives
>> and the enclosures are mirrors of each other. I understand the
>> controller could be a single point of failure, but I'm not sure I
>> understand your concern about the RAID structure itself.
>>
>
> In this configuration, if you have a drive fail on both
> controllers, the entire RAID dies. Lets label them A1-7, B1-7,
> because you stripe within a set, if a single one of A dies, and a
> single one of B dies, you have lost your entire mirror.
>
> The correct way of doing it, is to have A1 be a mirror of B1, and
> then stripe above that. Since you are using 2 7-disk enclosures,
> I'm not sure how you can do it well, since it is not an even number
> of disks. Though if you are using software RAID, there should be no
> problem.
>
> The difference is that in this scenario, *all* of the A drives can
> die, and you haven't lost any data. The only thing you can't lose
> is a matched pair (eg losing both A1 and B1 will cause complete
> data loss)
>
> I believe the correct notation for this last form is RAID 1 + 0
> (RAID10) since you have a set of RAID1 drives, with a RAID0 on-top
> of them.
>

I have read up on the difference now. I don't understand why it's a
"single point of failure". Technically any array could be a "single
point" depending on your level of abstraction. In retrospect, I
probably should have gone 8 drives in each and used RAID 10 instead
for the better fault-tolerance, but it's online now and will require
some planning to see if I want to reconfigure that in the future. I
wish HP's engineer would have promoted that method instead of 0+1..

-Dan

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message John A Meinel 2005-08-09 22:30:17 Re: Table locking problems?
Previous Message John A Meinel 2005-08-09 21:51:22 Re: Table locking problems?