Apr 3, 2018

Getting Groovy with Mongo Monitoring

MongoDB does something interesting that we aren’t used to in the Java world – if you use the MongoClient object, it manages the pooling for you on the server side. This is different than how most databases connect, which leaves pooling up to the application or the Java server.

Anyway, I was working with a Grails application that used MongoClient and the Mongos kept running out of memory. Therefore tickets were opened, words were said, and fingers were pointed. In the past, they had used Grails connection pooling for Mongo, ran into these problems, and switched to a single MongoClient. They said it was happening again but we developers needed evidence to show that (or, disprove it).

Doing some research showed that the Java Driver for Mongo has some good JMX endpoints to monitor. But the problem was that we needed to track these values over a long period of time – more than just what VisualVM would show. And I didn’t have access to the server but they did have the Grails console running inside the applications.

So I wrote a simple Groovy script that queries the Mongo’s JMX values every second and prints it out in something resembling a CSV file. I wrote this to run inside a Grails console, but there is no Grails in it – it’s pure Groovy. You may have to make minor changes to get it to run on the command line. Anyway, here is the Gist:

https://gist.github.com/squarepegsys/faff5dff8666ffddaa06cd0ea14752d8

About the Author

Mike Hostetler profile.

Mike Hostetler

Principal Technologist

Mike has almost 20 years of experience in technology. He started in networking and Unix administration, and grew into technical support and QA testing. But he has always done some development on the side and decided a few years ago to pursue it full-time. His history of working with users gives Mike a unique perspective on writing software.

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Blog Posts
Feature Flags in Terraform
Feature flagging any code can be useful to developers but many don’t know how to or even that you can do it in Terraform. Some benefits of Feature Flagging your code You can enable different […]
Infrastructure as Code – The Wrong Way
You are probably familiar with the term “infrastructure as code”. It’s a great concept, and it’s gaining steam in the industry. Unfortunately, just as we had a lot to learn about how to write clean […]
Snowflake CI/CD using Jenkins and Schemachange
CI/CD and Management of Data Warehouses can be a serious challenge. In this blog you will learn how to setup CI/CD for Snowflake using Schemachange, Github, and Jenkins. For access to the code check out […]
How to get your pull requests approved more quickly
TL;DR The fewer reviews necessary, the quicker your PR gets approved. Code reviews serve an essential function on any software codebase. Done right, they help ensure correctness, reliability, and maintainability of code. On many teams, […]