Operations | Monitoring | ITSM | DevOps | Cloud

November 2023

Compound Alerts Within Database Observability Drive Actionable Alerting

The latest edition to the SolarWinds® Observability Platform, Database Observability, is live! Previously, you’ve relied on Database Manager to help monitor your database and generate alerts, and while it was ahead of its time for years, the time has come for the next generation of database monitoring. Key features of Database Observability are: The compound alerting feature is what I want to focus on in this post, though. In my opinion, compound altering is a game changer.

Anomaly Detection for Time Series Data: Techniques and Models

Welcome to the third chapter of the handbook on Anomaly Detection for Time Series Data! This series of blog posts aims to provide an in-depth look into the fundamentals of anomaly detection and root cause analysis. It will also address the challenges posed by the time-series characteristics of the data and demystify technical jargon by breaking it down into easily understandable language.

How to Monitor MongoDB Metrics with OpenTelemetry

For high throughput systems that focus on gathering continuous data or have a heavy read-only traffic, NoSQL databases came as a blessing. NoSQL databases, due to their unstructured nature of data, allow relatively faster inserts as well as reads compared to relational databases. One such database that’s quite popular today is MongoDB. In this article, our focus would be to understand how to extract metrics out of MongoDB and ship them to Signoz using the Open Telemetry collector.

Memcached Metrics Monitoring with OpenTelemetry

Let's dive deep into the realm of Memcached, where we'll uncover the power of monitoring with OpenTelemetry and SigNoz. This isn't just about caching data; it's about watching over Memcached like a vigilant guardian, ensuring it performs at its best, and optimizing your application's speed. In this tutorial, you will install OpenTelemetry Collector to collect Memcached metrics that should be monitored for performance and then send the collected data to SigNoz for visualization and alerts.

Managing Databases on AWS: A Practical Guide

Amazon Web Services (AWS) provides a range of managed database services that provide multiple database technologies to handle various use cases. They are designed to free businesses from tasks like database administration, maintenance, upgrades, and backup. AWS databases come in several types to cater to different business needs.

Monitoring Microsoft SQL Server login audit events in Graylog

One of the most important events you should be monitoring on your network is failed and successful logon events. What comes to most people’s minds when they think of authentication auditing is OS level login events, but you should be logging all authentication events regardless of application or platform. Not only should we monitor these events across our network, but we should also normalize this data so that we can correlate events between these platforms.

How to Monitor MySQL Metrics with OpenTelemetry

Database monitoring is an important aspect to look at for a high-volume or high-traffic system. The database performance drastically impacts the response times for the application. In this tutorial, you will install OpenTelemetry Collector to collect MySQL metrics and then send the collected data to SigNoz for monitoring and visualization. In this tutorial, we cover: If you want to jump straight into implementation, start with this pre-requisites section.

How to unlock your leadership potential on a cloud migration project: A guide for the DBA, part 2

In this two-part Q&A series, we’re looking at how to seize the full potential of cloud migrations to advance your career. In part one, we talked with four industry experts about the skills DBAs can gain, the unique career opportunities that come up, and the best way to get involved in a cloud project. Chris Yates from Republic Bank, Kendra Little from Dutchie, and Matt Gordon and Joshua Higginbotham from Centric Consulting shared their insights and provided some really valuable advice.

Why every user can now fly first class with Flyway

Flyway v10 has arrived, bringing with it some major advantages for Community users, open source contributors and developers everywhere. The big news? Every user can now download the latest, most secure version of Flyway, however old their database, and Redgate is affirming its commitment to open source to make it easier to accept and manage community updates.

Performance optimization techniques in time series databases: function caching

Relabeling is an important feature that allows users to modify metadata (labels) of scraped metrics before they ever make it to the database. As an example, some of your scrape targets may generate metric labels with underscores (_), and some of your targets may generate labels with hyphens (-). Relabeling allows you to make this consistent, making database queries easier to write.

How to unlock your leadership potential on a cloud migration project: A guide for the DBA, part 1

If your organization is embarking on a cloud migration project, it can be a great opportunity to develop skills and qualities that will help unlock your leadership potential. But what skills should you look to be honing, what areas should you focus on, how do you get involved in a cloud project in the first place, and what qualities can prepare you for leadership responsibilities? We spoke to some notable industry experts to find out.

Performance optimization techniques in time series databases: strings interning

VictoriaMetrics is an open-source time-series database (TSDB) written in Go, and I’ve had the pleasure of working on it for the past couple of years. TSDBs have stringent performance requirements, and building VictoriaMetrics has taught me a thing or two about optimization. In this blog post, I’ll share some of the performance tips I’ve learned during my time at VictoriaMetrics.

A guide to PostgreSQL documentation and useful resources | PostgreSQL 101

Join Ryan Booz, PostgreSQL Advocate at Redgate, and Grant Fritchey, Microsoft Data Platform MVP, and discover: How to navigate PostgreSQL documentation The essential things you need to know about PostgreSQL documentation Other useful learning resources to help make your journey to using PostgreSQL easier.

Why PostgreSQL in 2023 | PostgreSQL 101

PostgreSQL has risen to be the dominant choice for new projects and cost-saving migrations in an increasingly cloud-first, price-conscious world. Join Ryan Booz, PostgreSQL Advocate at Redgate, in the first of a series of PostgreSQL 101 webinars as he talks through the the history of PostgreSQL, the different PostgreSQL variants and the reasons behind the increasing popularity of PostgreSQL.

The Journey Towards PostgreSQL - Tips and Lessons | PostgreSQL 101

Grant Fritchey, Microsoft Data Platform MVP, started working with SQL Server in 1995 but more recently has needed to support and understand PostgreSQL. In this webinar, he will go on a deeper dive into the PostgreSQL database and will share top tips from his own learning journey.

The Present and Future of Data Management Roles

In January 2015, I wrote about the future of professional database administrators (DBAs) in a three-part series of articles for Database Trends & Applications magazine. Back then I predicted we would see strong growth in DBA salaries because of the acute and persistent shortage of talent, very little means of training new DBAs, and a median age of DBAs creeping closer to retirement age with each passing year.

How we upgraded to MySQL 8 in Grafana Cloud

Starting around June this year, we upgraded our Grafana databases in Grafana Cloud from MySQL 5.7 to MySQL 8, due to MySQL 5.7 reaching end-of-life in October. This project involved tens of thousands of customer databases across dozens of MySQL database servers, multiple cloud providers, and many Kubernetes clusters.

Monitoring Redis Performance Metrics

Redis, as an in-memory data store, excels at providing high-speed data access and manipulation. However, without effective monitoring, the potential advantages of Redis can be compromised due to performance bottlenecks, scalability issues, and resource constraints. By closely scrutinizing key metrics, Redis monitoring allows you to proactively detect and address potential problems, ensuring the stability, reliability, and high-performance operation of your Redis environment.

Momentum: Announcing 268 Million Downloads & 320% Growth in 2023

We’re happy to announce a landmark 320% growth in 2023! VictoriaMetrics, our open source time series database and monitoring solution, already hit 268 million downloads this year (still counting), and received close to 13,000 stars on GitHub.

Grafana Tempo 2.3 release: faster trace queries, TraceQL upgrades

Grafana Tempo 2.3 has been unleashed upon the world, bringing with it the latest iteration of the vParquet backend! Tempo 2.3 has a little bit of everything, but the headline item here is vParquet3 and new features that improve search speeds. Watch the video above for all the details, or continue reading to get a quick overview of the latest updates in Tempo. If you’re looking for something more in-depth, don’t hesitate to jump into the changelog or our Grafana Tempo 2.3 release notes.