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.

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.

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.

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.

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.

As data grows and databases become larger and more complicated, data subsetting provides a method of working with a smaller, lighter copy of a database to make development and testing faster and easier.

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.

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.

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.