As you can see, these three dashboard templates will give any developer a huge boost in monitoring their data clusters with little to no additional work needed.
DoubleCloud’s ClickHouse® Hybrid Storage
It doesn’t end there though.
One of the things that sets DoubleCloud’s managed ClickHouse® clusters apart is that they allow users to store data separately, with your frequently used (hot data) in local disk storage and the bulk of your rarely used (cold data) in object storage (S3). Store your logs and metrics for use in Grafana in hybrid storage tables. If your dashboards default to 24 hours or one week, set that as your hybrid storage option. This ensures your default dashboards are performant and return results quickly.
DoubleCloud’s managed ClickHouse® offering is over 10x cheaper on object storage in most regions… As an example, we typically only charge around $0.25/GB-month on SSD whereas we pass-through object storage pricing, currently around $0.023 per GB on S3.
I advise my customers to leverage the Pareto principle. 80% of the most frequently used queries should hit the SSD storage rather than the S3, contributing to the sub-second analytical queries on ClickHouse® that people have come to love while still leveraging the object storage for cost efficiency.
When data access is repeated, the DoubleCloud platform caches queries to speed up the queries.
The platform also allows developers to create customized rules based on the most frequently accessed data, massively reducing costs associated with maintaining longer-term storage.
It’s no different for your end-users either. Query a table and DoubleCloud’s managed ClickHouse® will instantly access the needed partitions in S3. In fact, if a cluster runs out of provisioned SSD storage, we will automatically spill onto object storage, preventing down time and lost data.
In summary, empowering Grafana with DoubleCloud allows developers to save money with our hybrid storage solutions.
Thanks to ClickHouse’s® tech, retrieving data is lightning fast and the managed service provided by DoubleCloud offers robust backup processes, monitoring, configuration sharding and free updates, meaning developers can do what they do best… develop (instead of boring, repetitive tasks related to data warehousing)!
The one thing I haven’t mentioned yet, but you should definitely get in touch and ask me about is, the scalability of the platform.
We made sure you can easily change the number of hosts in a cluster, upgrade their size and enable sharding to improve cluster performance.