Instana Blog

Date: March 27, 2018

Instana Announces AI Powered Monitoring for ClickHouse

Category: Featured, Product

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.

14 days, no credit card, full version

Free Trial

Sign up for our blog updates!
|
Category: Developer, Engineering, Events
Last month I had the chance to visit SRECON19 EMEA in Dublin for the very first time (or any SRECON for that...
|
Category: Events
Instana’s been busy leading up to our sponsorship of SpringOne, announcing support for Pivotal Cloud Foundry with the release of...
|
Category: Events, Featured
This week, we’re heading to SFO - Valley of Silicon and home to Pym Industries - for DevOps World (or...

Start your FREE TRIAL today!

Free Trial

About Instana

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.