Re: MVCC for massively parallel inserts

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: MVCC for massively parallel inserts
Дата
Msg-id 87k7451u1y.fsf@stark.dyndns.tv
обсуждение исходный текст
Ответ на Re: MVCC for massively parallel inserts  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-general
"Joshua D. Drake" <jd@commandprompt.com> writes:

> Something I have been toying with is getting two of the 12 drive 3Ware cards
> and running RAID 0+1 across them (with LVM). At just under 300 for the cards
> and only 80 bucks a drive (80 Gig)... that is alot of space, and a lot of
> speed for not a lot of money.

Unless I have things backwards, raid 0+1 means if any drive fails the whole
side of the mirror fails. if two drives fail you have a 50/50 chance of the
them being on opposite sides of the mirror and losing the whole thing.

Even if you don't have a double failure, resyncing seems like it would be a
pain in this situation. LVM wouldn't know about the stripe set so it would
mean resyncing the entire 12-disk array on the failed side of the mirror.

I thought it was generally preferable to do Raid 1+0 (aka "raid 10") where any
two drives can fail and as long as they aren't precisely opposite each other
you're still ok. And resyncing just means resyncing the one replacement drive,
not the whole array.

--
greg

В списке pgsql-general по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: release notes/Appendix E in documentation
Следующее
От: Jan Poslusny
Дата:
Сообщение: pg_dump and client_encoding