Posted on June 14, 2017, 2:56 pm, by Rhys, under
DBA,
MongoDB.
Here’s just a quick walkthrough showing how to create a dockerized instance of a standalone MongoDB instance. First, from within a terminal, create a folder to hold the Dockerfile… mkdir Docker_MongoDB_Image cd Docker_MongoDB_Image touch Dockerfile Edit the Dockerfile… vi Dockerfile Enter the following text. You may wish to modify the file slightly. For example; if […]
Posted on May 13, 2017, 6:07 pm, by Rhys, under
DBA,
MongoDB.
There’s a big initiative at my employers to improve the uptime of the services we provide. The goal is 100% uptime as perceived by the customer. There’s obviously a certain level of flexibility one could take in the interpretation of this. I choose to be as strict as I can about this to avoid any […]
Posted on April 30, 2017, 1:03 pm, by Rhys, under
DBA,
MongoDB.
It’s no secret that databases like uniqueness and high cardinality. Low cardinality columns do not make good candidates for indexes. A recent issue I had with MongoDB proved that NoSQL is no different in this regard. The MongoDB Query Planner is quite simple and works as follows (simplified)… If there are no usable indexes; perform a collation […]
Posted on March 21, 2017, 1:03 pm, by Rhys, under
DBA,
MongoDB.
Here’s a few Splunk queries I’ve used to supply some data for a dashboard I used to manage a MongoDB Cluster. Election events If any MongoDB elections happen at 3AM on a Wednesday night I want to know about it. This query, added to a single value panel allows me to do this easily… host=mongo* […]
Posted on January 20, 2017, 3:30 pm, by Rhys, under
DBA,
MongoDB.
I’ve been working a little with the PlanCache in MongoDB to troubleshoot some performance problems we’ve been experiencing. The contents of the Plan Cache are json documents (obviously) and this isn’t great to work with in the shell. Here’s a couple of javascript functions I’ve come up with to make things a little easier. These […]