Operations | Monitoring | ITSM | DevOps | Cloud

Databases

The latest News and Information on Databases and related technologies.

Flyway Desktop and MySQL

This is an early preview of the new functionality being introduced to MySQL and Flyway Desktop. Not only can you automate your deployments to MySQL through the Flyway command line, but you can capture changes to your databases, on an individual object level. Flyway Desktop will even help you generate your migration scripts for your MySQL database. Check out all this new functionality.

How to Monitor Redis with Prometheus

The current popularity of Redis is well deserved; it’s one of the best caching engines available and it addresses numerous use cases – including distributed locking, geospatial indexing, rate limiting, and more. Redis is so widely used today that many major cloud providers, including The Big 3 — offer it as one of their managed services. In this article, we’ll look at how to monitor Redis performance using Prometheus, the similarly popular open-source monitoring system.

The business value of frequent deployments: Faster time to market

In this series, we’ve been exploring the different layers of business value you can gain from deploying software more frequently. We’ve already looked at the hard costs you can save, and the valuable developer time you can recoup. But that’s not the end of the story. Not by far. Picture an iceberg. The top, the visible part, is those hard costs. Just beneath the surface is that time that can be gained by redeploying wasted time to projects that matter.

How Database Observability Increases Operational Reliability

Early on in my career as a DBA, I began to realize I wasn’t a Database Administrator as much as the Default Blame Acceptor for nearly any application problem. Let’s face it—the first thing blamed when there’s an issue is typically going to be the database, and it’s a “guilty until proven otherwise” situation.

Next Level Oracle Monitoring Options Features DeepDive NiCE 2023Q1

Next Level Oracle Monitoring | Options, Features, Deep-Dive Performance, availability, and Oracle observability are the hot topics for the next decade. Get a guided tour on advanced Oracle monitoring based on Microsoft System Center Operations Manager, run by the NiCE Product Experts. The NiCE Oracle Management Pack, in conjunction with one of the big players in IT Operations Management, easily enables end-to-end Oracle observability and thus helps reduce risk and downtime.

Monitor any SQL metrics with Netdata (and Pandas )

We recently got this great feedback from a dear user in our Discord: This is great and exactly what we want, a clear problem or improvement we could make to help make that users monitoring life a little easier. This is also where the beauty of open source comes in and being able to build on the shoulders of giants - adding such a feature turned out to be pretty easy by just extending our existing Pandas collector to support SQL queries leveraging its read_sql() capabilities.

Optimize SQL Server performance with Datadog Database Monitoring

Microsoft SQL Server is a popular relational database management system that provides a wide range of performance and reliability features (e.g., AlwaysOn availability groups) to support business-critical applications. As your SQL Server workloads scale and increase in complexity, it can be difficult to monitor all of their components and pinpoint the exact issues that are degrading your databases’ performance.

What Is SQL Performance Tuning?

As database administrators and developers, we need to know how to tune SQL queries and databases. Tuning SQL queries and databases is one of the most powerful tools in our arsenal for achieving the best possible performance results. This post will help you understand more about SQL tuning. I’ll start by explaining what SQL performance tuning is. Then, I’ll go over how to conduct SQL performance tuning in MySQL, Microsoft SQL Server, and Oracle.

VictoriaMetrics Long-Term Support (LTS): Commitment, Current and Next LTS Versions

Share: VictoriaMetrics is always improving, with frequent updates adding new features, performance improvements and bug fixes listed at the CHANGELOG page. We usually make at least a single release every month. All the new features and bug fixes go to the latest release. That’s why we recommend periodically upgrading VictoriaMetrics components to the latest available release. But the latest release may also contain bugs in the latest features.