Instana Announces AI Powered Monitoring for ClickHouse

March 27, 2018

Instana - Enterprise Observability and APM for Cloud-Native Applications

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_portInstana - Enterprise Observability and APM for Cloud-Native Applications
  • tcp_ssl_port
  • log
  • error_log
  • interserver_http_port
  • listen_hosts
  • max_connectInstana - Enterprise Observability and APM for Cloud-Native Applicationsions
  • 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

Instana - Enterprise Observability and APM for Cloud-Native ApplicationsScreenshot 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!

Instana, an IBM company, provides an Enterprise Observability Platform with automated application monitoring capabilities to businesses operating complex, modern, cloud-native applications no matter where they reside – on-premises or in public and private clouds, including mobile devices or IBM Z.

Control hybrid modern applications with Instana’s AI-powered discovery of deep contextual dependencies inside hybrid applications. Instana also gives visibility into development pipelines to help enable closed-loop DevOps automation.

This provides actionable feedback needed for clients as they to optimize application performance, enable innovation and mitigate risk, helping Dev+Ops add value and efficiency to software delivery pipelines while meeting their service and business level objectives.

For further information, please visit instana.com.