We have Raid 10 configured as Node.Now we want to remove the Raid 10 and configured as Raid 0. Will it impact current execution,if i take back and restore the data ? AND also what is the disadvantage of Raid 0.
"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 10Advantages: 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)
Thank you Bryanw