Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

Less is more ... or more is more? Decide for yourself with Icinga DB Web list view modes

With Icinga DB Web you can now customise Icinga Web’s list views to your needs. While in one scenario you might be more interested to see as many objects as possible at a glance, in another scenario detail attributes of only a few objects will be more important to you. Yet, in the first case, you would even be distracted by more detailed information.

Understanding N+1 Database Queries

N+1 queries are the most common problems among developers. N+1 database query problems occur when you have to call the database for N items, and those N items have again N additional data fields which are not in the same table, and those extra N data fields are required for the use case. Generally, this issue is handled at the time of database designing, but every problem cannot be solved efficiently by one solution, some need to be solved by brute force.

A Modern Guide to MySQL Performance Monitoring

According to results from the Stack Overflow Developer Survey 2022, nearly half (46%) of respondents say they use MySQL, making it the most widely-adopted database technology among developers today. This popularity is due in no small part to MySQL’s unique features that help it handily meet the needs of modern applications, from small software projects to business-critical systems.

Redis: Open Source vs. Enterprise

Are you curious about the difference between open-source Redis and Redis enterprise? Of course, Redis Enterprise is a hosted service that runs Redis db on behalf of its customers, while open-source Redis is available for anyone to use. However, there's also a key difference between open source and enterprise in how the clusters are implemented. In order to understand the difference, we need to know what Redis Clusters are. ‍

InfluxDB is 5x Faster vs. MongoDB for Time Series Workloads

At InfluxData, one of the common questions we regularly get asked by developers and architects alike the last few months is, “How does InfluxDB compare to MongoDB for time series workloads?” This question might be prompted for a few reasons. First, if they’re starting a brand new project and doing the due diligence of evaluating a few solutions head-to-head, it can be helpful in creating their comparison grid.

Scaling Throughput and Performance in a Sharding Database System

Understand the two dimensions of scaling for database query and ingest workloads, and how sharding can make scaling elastic — or not. Scaling throughput and performance are critical design topics for all distributed databases, and sharding is usually a part of the solution. However, a design that increases throughput does not always help with performance and vice versa. Even when a design supports both, scaling them up and down at the same time is not always easy.

Where Financial Services businesses should focus their digital transformation efforts in 2023

Like every business sector, Financial Services has been on a rollercoaster ride over the past couple of years. The pandemic forced a change in the way businesses work, and the way products and services are delivered to customers. Deloitte summed it up beautifully in the introduction to its ‘Finance 2025 Revisited report’1: “COVID-19 has sped up business innovation and stress-tested the concept of 100% remote work.”

Relational Database vs. Non-Relational Database

Relational database or non-relational database: which should you use for your projects? It’s a common question. When choosing the database type that’s right for your requirements, it’s important to understand the differences between the two. Both database types are practical in different situations and use cases and have commonalities.