I have a druid setup in a single box in EC2 - c3.8xlarge (32 CPU and 64GB RAM)
started it with the guides here - http://druid.io/docs/latest/tutorials/quickstart.html
Added the data for aug month(21GB of json files) sep month(134GB of json files) to druid.
Installed metabase to create dashboards.
Added few questions and queries to dashboard.
When choosing the date range for one to few days, the results are fast.
When we choose the date range to one month or two months, the results takes around ten minutes.
We are keep on adding data to druid daily around 1 GB of data. I think it will take more and more time for the query results, when we have the data for few more months.
How can we increase the performance of the queries? Will adding similar one or two nodes will help?
If we add more nodes, what are the druid services to move there and how to move them?
Share your thoughts.