Instana Announces AI Powered Monitoring for ClickHouse

March 27, 2018

Instana is pleased to announce our official, first class support for Yandex ClickHouse. The important question is, what do I mean when I say, “first-class support”?

For Instana users, first-class support means the following:

  • Automatic discovery and monitoring of ClickHouse components
  • Full integration into the Instana Dynamic Graph (Click here for an explanation of the dynamic graph) – This model is used for correlation and causation.
  • Automatic selection and collection of all relevant metrics
  • Fully AI enabled behavioral learning
    • Predictive analytics
    • Automatic root cause analysis
  • Traces generated for EVERY request
  • Fully curated expert knowledge to identify problems and suggest remediation possibilities

So what is the value to you?

  • Know with certainty when one component is impacting other components or the service as a whole
  • Monitor the metrics that most clearly indicate problems. No guesswork required.
  • Know what is normal for any metric
  • Get warned BEFORE an issue occurs to take corrective action
  • Immediate troubleshooting by a single person
  • Troubleshoot any individual request. Never miss sporadic issues.
  • Expert in a box. Supplement the knowledge of your internal experts with expert knowledge from the Instana team.

Yandex ClickHouse Monitoring

It’s always a good idea to refer back to the official documentation for the latest details but this release tracks the following information:

The following configuration values are automatically tracked by parsing the ClickHouse configuration file.

  • http_port
  • tcp_port
  • https_port
  • tcp_ssl_port
  • log
  • error_log
  • interserver_http_port
  • listen_hosts
  • max_connections
  • keep_alive_timeout
  • max_concurrent_queries
  • uncompressed_cache_size
  • mark_cache_size
  • path
  • tmp_path
  • user_config_file_name
  • default_profile
  • default_database
  • timezone
  • umask
  • builtin_dictionaries_reload_interval
  • max_session_timeout
  • default_session_timeout

Metrics

  • Merge
  • ReplicatedFetch
  • ReplicatedSend
  • ReplicatedChecks
  • BackgroundPoolTask
  • DiskSpaceReservedForMerge
  • DistributedSend
  • QueryPreempted
  • TCPConnection
  • HTTPConnection
  • InterserverConnection
  • OpenFileForRead
  • OpenFileForWrite
  • Read
  • Write
  • SendExternalTables
  • QueryThread
  • ReadonlyReplica
  • LeaderReplica
  • MemoryTracking
  • MemoryTrackingInBackgroundProcessingPool
  • MemoryTrackingForMerges
  • LeaderElection
  • EphemeralNode
  • ZooKeeperWatch
  • DelayedInserts
  • ContextLockWait
  • StorageBufferRows
  • StorageBufferBytes
  • DictCacheRequests
  • Revision
  • RWLockWaitingReaders
  • RWLockWaitingWriters
  • RWLockActiveReaders
  • RWLockActiveWriters

Screenshot of Instana infrastructure dashboard showing ClickHouse metrics

Instana continues to build upon our world class AI powered monitoring for the many components used in modern application architectures. Be sure to sign up for a free trial of Instana in your environment today.

Play with Instana’s APM Observability Sandbox

Announcement, Developer, Featured, Product, Thought Leadership
AWS Lambda, the serverless functions (or FaaS) offering from Amazon continues to grow in usage, both overall and in production applications. One of the biggest challenges is how to trace and monitor...
|
Conceptual, Featured, Thought Leadership
Building scalable systems has become more accessible over the past decade thanks to immutable infrastructure, containers, and orchestration platforms such as Kubernetes. As the complexity of these applications continues to accelerate the...
|
Featured, Product
ClickHouse has some amazing built-in monitoring capabilities accessible through the system tables (system.trace_log, system.metrics, system.query_log, etc.). They are great when diving deep into issues, but when ClickHouse is just one of the...
|

Start your FREE TRIAL today!

As the leading provider of Automatic Application Performance Monitoring (APM) solutions for microservices, Instana has developed the automatic monitoring and AI-based analysis DevOps needs to manage the performance of modern applications. Instana is the only APM solution that automatically discovers, maps and visualizes microservice applications without continuous additional engineering. Customers using Instana achieve operational excellence and deliver better software faster. Visit https://www.instana.com to learn more.