Vertica Sizing recommendation with SSD drives
I was looking for recommendation on a new production cluster that we need to configure based on following parameters.
1) Total raw data volume approx. 8 TB
2) Need extremely fast reporting performance for our dashboards and queries which could be very complex
3) High availability
We were thinking of using SSD drive so as to get very high I/O. Here are the questions that I have.
A) What is the recommended Hardware ? How many nodes?
How many SSD drives per node and what size?
C) Does SSD drive require RAID 10 or RAID 5 setup ?
D) In your testing with SSD drive how do they compare with normal drives? How does drive failure rate compare?
E) Do you have any performance benchmarks using SSD drive?
F) Any other information that you can provide for us to consider?
G) What kind of SSD drive ( make , model etc ) that you recommend ?
H) How much growth of data can the recommended H/W can accommodate?
I) Currently our application uses Vertica version V 7.2.3-22. Would it help in terms of performance if we use Vertica 8.1.1-X without changing any application code?