Vertica in virtual enviroment - three-node cluster necessary
We are presented an application/system by a vendor that utilize the Vertica database. We are told that we need to follow your recommendation to have a three-node cluster. However we have a Vmware enviroment that handles OS failure (e.g. CPU, RAM, ...etc) and we have NetAPP storage system that would handle Disk failure and throuput requirement. I have run those perf tests and the results are all good. In this case, do we still need three-node cluster, or will one-node cluster will be sufficient? I mean, even we still have three nodes they will be in the exactly same enviroment, competing with each other.
Of course that this one node will be much more powerful. I know that you do distributed processing, meaning that all nodes work at the same time. However will a VM with double the processing power be able to handle what three nodes can do (considering no waste of energy doing sync between the nodes)?
Our data is not heavy. Vendor estimated 2TB uncompressed data for 13-month
The vendor themselves don't have much experience with virtualization of your system so I figure I just ask experts here to have an authoritive answer.