Monitoring CouchDB Performance With Datadog | Datadog

Monitoring CouchDB performance with Datadog

Author Marshal Ma
@MarshalMa

Published: July 13, 2016

Apache CouchDB is an open source NoSQL database, tailored for the web. As a document-oriented database that stores data in JSON, CouchDB is accessible and queryable via HTTP request. It can complete complex document indexing and view updating on the fly with JavaScript. CouchDB replicates changes among peer hosts asynchronously and guarantees eventual consistency, making the data store globally scalable and a good fit for many types of public-facing web/mobile apps.

Boost awareness with CouchDB monitoring

Datadog takes CouchDB monitoring beyond ad hoc command line checks and manual inspection of the runtime statistics report. You can see graphs of real-time and historical metrics on request traffic, latency, and read/write workload from all your CouchDB servers in one place.

CouchDB monitoring default screen board

Monitoring CouchDB throughput and workload

You can break down CouchDB traffic in terms of HTTP status codes and request methods. Though not explicitly for database service, those metrics can provide insights on database activity and host health. For example you can set alerts on too many “forbidden” responses (403) or if the number of internal server errors (500) suddenly increases.

CouchDB monitoring request breakdown

If you are seeing a high number of delete requests, you may consider optimizing the application logic, as document deletion is the kind of operation that’s better and more effectively handled with a bulk update.

Know when it’s time to compact a bloated database

CouchDB supports distributed scaling over multiple host clusters. To minimize the amount of communication between each host, incremental replication is commonly used to propagate document changes. During the process, CouchDB automatically detects conflicts but leaves the resolution up to the application. Thus, as in a version control system, all changes, even delete operations, are diligently recorded. As a result, the database can swell in size with old document revisions.

One way to get around the problem is to compact the database from time to time. But since this is a heavy disk I/O operation, when is it reasonable to run a compaction?

CouchDB monitoring disk size comparison

Monitoring CouchDB with Datadog can help you find the answer, by tracking database size in real time. By multiplying the current document count by the estimated average size of a document designed for that database, you can get a sense of how big the database should be. If the disk size is much greater than the expected size of documents stored in the database, it’s very likely that the disk is overpopulated by the fragments of past revisions, and it may be a good time to compact the database.

Safeguard the authentication cache

CouchDB monitoring authentication cache

Another important aspect of CouchDB that Datadog monitors is the authentication cache. CouchDB stores a fair amount of user credentials in memory to speed up the authentication process. Monitoring usage of the authentication cache can alert you for possible attempts to gain unauthorized access.

If CouchDB reports a high number of auth_cache_misses, then either the cache is undersized to service the volume of legitimate user requests, or a brute force password/username attack is taking place. Correlating the auth_cache_misses with httpd_status_codes.401 (unauthorized request) metrics helps shed light on which scenario it might be.

CouchDB monitoring authentication cache with unauthorized request

Get started

If you’re already a Datadog customer, you can easily start monitoring CouchDB in minutes here. CouchDB is one of more than 700 technologies that Datadog integrates with, so you can monitor your entire infrastructure in one place, from servers and containers to load balancers, caches, and custom applications. If you’re new to Datadog, you can sign up for a full-featured free trial.

Acknowledgments

Thanks to Jan Lehnardt, CEO of Neighbourhood.ie, for his technical assistance with this article.