Best Answer

• bryanw Employee

  October 2019 Answer ✓

  Impact:
  "It depends" on the RAID controller - Vertica can't test them all (and all the attendant controller and disk firmware permutations), so we don't vouch for any. Background disk management, even if it doesn't take an array offline, may impact throughput significantly and for a long time (possibly 24+ hours depending on disk type and size). If the throughput impact is significant, query performance may be terrible, and in severe cases Vertica may kick the node out of the cluster for timing out storage health checks.

  Advantages / Disadvantages: RAID 0 vs RAID 10
  Advantages: RAID 0 will give you twice the space, twice the write throughput, and the same read throughput vs. RAID 10. IOPS improvement will depend on read vs write mix, but Vertica cares more about throughput than IOPS.
  Disadvantages: feel free to compare the likelihood of data surviving 1, 2, etc years on RAID 0 vs RAID 10 at http://www.raid-failure.com/raid0-failure.aspx - weigh the overall impact of rebuilding a node's worth of data vs the expected frequency (the consideration is different for 2-4 SSDs vs 22-24 spinners)

  5