Hi, What is the best ec2 instance type to use for ...
# questions-and-troubleshooting
j
Hi, What is the best ec2 instance type to use for starrocks? I am seeing that the cpu is barely used but the memory is spiking a lot. Should memory optimized instance be used? Which one? Any experience on this, what ec2 instance type people are using? Thanks, Julien
s
Of course, it depends. Your data size, query patterns, concurrency, and cluster architecture all play a role. Here are the recommendations from starrocks: https://docs.starrocks.io/docs/deployment/plan_cluster/#cpu-and-memory How are you using starrocks? Data size? Concurrency?
j
Thanks for the link
We are exploring starrocks for realtime analytics data store connected to our BI tool. We have star schema and multi fact joins on 100 millions rows and concurrency in the hundreds
We are using the shared data mode
In the link it seems it’s just for shared nothing ?
Also there is no mention on instance type, like graviton or cpu optimized or mem optimized
s
Sorry for missing some of the details of your use case. I don't have any more experience specific to AWS. But a common approach is to set up a dev environment and try some queries on semi-realistic data and measure cpu and memory usage. Based on ratios that you see in cpu vs memory, you can make an informed decision about cpu- or memory-optimized instances. As for graviton: https://www.starrocks.io/blog/get-a-50-price-performance-boost-with-starrocks-on-aws-graviton3
j
Yes that’s what we are experimenting and we were just curious about what others are doing and recommending based on their findings are we might all go through this testing phase