I've been trying to use HP Vertica installation from Azure Marketplace:
https://azuremarketplace.microsoft.com/en-us/marketplace/apps/hpe.verica?tab=Overview
The performance results are quite inconsistent though.
I was able to get better results on physical machine with just 6CPU 2.2GHz and 10GB RAM!
The weirdest thing is that on DS14_v2 machines which has twice the cpu and memory then DS13_v2 I got test times 10% slower. Even though I got the same data, scenarios, statistics, projections, etc.
I did some verification on how the cluster is configured and deployed, and it seems fine in theory, but there are some glitches.
[root@VertNode0 ~]# VERT_DBA_DATA_DIR=/data /opt/vertica/oss/python/bin/python -m vertica.local_verify
CheckNodeDisk.check_io_scheduler_none (0.076s)
HINT (S0151): These disks do not have known IO schedulers: '/dev/md126' ('md126') = 'none'
https://my.vertica.com/docs/8.0.x/HTML/index.htm#cshid=S0151
CheckNodeDisk.check_readahead (0.075s)
FAIL (S0020): Readahead size of md126 (/dev/md126) is too high for typical systems: 12288 > 8192
https://my.vertica.com/docs/8.0.x/HTML/index.htm#cshid=S0020
Summary:
fail: 2
pass: 48
Shouldn't this verification pass? Could it be caused by software raid?
Network parameters doesn't seem perfect either.
test | date | node | index | rtt latency (us) | clock skew (us)
latency | 2017-03-13_07:29:39,610 | 10.0.0.21 | 0 | 269 | -657331
latency | 2017-03-13_07:29:39,610 | 10.0.0.22 | 1 | 523 | -211663
date | test | rate limit (MB/s) | node | MB/s (sent)
2017-03-13_07:29:42,621 | udp-throughput | 256 | 10.0.0.21 | 222.969
2017-03-13_07:29:42,621 | udp-throughput | 256 | 10.0.0.22 | 215.714
2017-03-13_07:29:42,621 | udp-throughput | 256 | average | 219.341
2017-03-13_07:29:43,623 | udp-throughput | 512 | 10.0.0.21 | 230.82
2017-03-13_07:29:43,623 | udp-throughput | 512 | 10.0.0.22 | 229.864
2017-03-13_07:29:43,623 | udp-throughput | 512 | average | 230.342
date | test | rate limit (MB/s) | node | MB/s (sent)
2017-03-13_07:29:54,650 | tcp-throughput | 256 | 10.0.0.21 | 244.17
2017-03-13_07:29:54,650 | tcp-throughput | 256 | 10.0.0.22 | 244.17
2017-03-13_07:29:54,650 | tcp-throughput | 256 | average | 244.17
2017-03-13_07:29:56,652 | tcp-throughput | 512 | 10.0.0.21 | 488.302
2017-03-13_07:29:56,652 | tcp-throughput | 512 | 10.0.0.22 | 456.768
2017-03-13_07:29:56,652 | tcp-throughput | 512 | average | 472.535
