We’re planning to set up production clusters using Vertica Eon on MinIO. After reading Vertica Document about Number of Shards which has the recommended shard count and initial node count base on the working data size as the below table.
And currently we have 260TB Vertica license which is bigger than “Extra large” Cluster Type (Up to 192TB) in Vertica document a bit.
and we have new 80 servers plus 26 older servers. And we need to use some of them for MinIO cluster also. And at least we should have 3 sub-clusters (Ingest + Query + Query).
So, could you give us a suggestion about number of shard and number of Vertica node?
We also found that in Vertica 10.x.x, Vertica already implemented elastic crunch scaling (ECS) for query performance scaling.
New 80 servers:
Model: ProLiant DL360 Gen10
CPU: Intel xeon gold 6240 @ 2.60ghz
RAM: 768GB
Disk: 7680GB SSD x 2 (RAID 1)
Network: 50Gpbs (25Gbps + 25Gbps Aggregated)
Old 8 servers:
Model: ProLiant DL360 Gen9
CPU: Intel xeon 2690 v3 @ 2.60ghz
RAM: 512GB
Disk: 900GB HDD x 2 (RAID 1) for OS, 1920GB SSD x 5 (RAID 5) for Data
Network: 10Gpbs (Active/Standby) [We’re checking with network team, is it possible to Aggregated)
Old 18 servers:
Model: ProLiant DL360 Gen10
CPU: Intel xeon gold 6150 (13 Servers)/ 6126 (5 Servers) @ 2.70ghz
RAM: 512GB
Disk: 7680GB SSD x 2 (RAID 1)
Network: 10Gpbs (Active/Standby) [We’re checking with network team, is it possible to Aggregated)
Refer: https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/Eon/SizingEonCluster.htm
https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/Eon/Elasticity.htm
