Operations | Monitoring | ITSM | DevOps | Cloud

One of the biggest mistakes I’ve had to repeatedly help companies fix has been poor partitioning design. I’ve seen many database architectures designed in an attempt to make queries faster. While faster queries can be a product of implementing partitioning correctly for a given design, I’ve often seen query response times get much slower from implementing partitioning incorrectly for the database design.

Database management systems are an essential component of business applications. Over the years, MS SQL has earned its place in the hearts of database administrators (DBAs) as the most trusted relational database management system. It is still the go-to choice for many DBAs as it helps them leverage its extensive capabilities across various dimensions such as security, portability, transaction processing and analytics.

Today, we are excited to announce that Upsun now offers the latest version of MongoDB to our Enterprise and Elite customers. Clients can now enjoy improved visibility via one source of control, the ability to track multiple applications and users, and native, at-rest encryption that meets the latest security compliance standards. There are more details about the benefits of MongoDB below.

Monitor Oracle DB in Google Cloud Platform with the Google Ops Agent. The Ops Agent is available on GitHub, and makes it easy to collect and ship telemetry from dozens of sources directly to your Google Cloud Platform. You can check it out here! Below are steps to get up and running quickly with observIQ’s Google Cloud Platform integrations, and monitor metrics and logs from Oracle DB in your Google Cloud Platform.

While working on improving the Netdata PostgreSQL collector, we were monitoring our production PostgreSQL instance and something caught our attention immediately. The rows fetched ratio seemed really, really low for one particular database… there were missing indexes in PostgreSQL! Rows fetched ratio is the percentage of rows that contain data needed to execute the query (rows fetched), out of the total number of rows scanned (rows returned).

In monitoring, the term cardinality defines the number of unique time series stored in a time series database (TSDB). The higher the cardinality, the more resources are usually required for metrics processing and querying.

We all know we shouldn't use naughty words. Learn how to remove them from your streaming data using DataCater.

MongoDB is a cross-platform NoSQL database that uses JSON-like documents with optional schema to store data. It was designed for high availability, high performance for high-data persistance use cases, and automatic scaling. Of course, all with the right infrastructure in mind. It is usually a good choice for document-oriented use cases when you need quick prototyping or massive scale. With the massive scale comes massive traffic, though.

Redis is a popular open-source, in-memory data store used across industries by a variety of companies, including Github, Stack Overflow, Twitter and Netdata! Redis supports multiple use-cases including.