Operations | Monitoring | ITSM | DevOps | Cloud

Databases

The latest News and Information on Databases and related technologies.

Monitoring Kubernetes costs with OpenCost and VictoriaMetrics

Control over operational costs is pivotal in Kubernetes' deployment and management. Although Kubernetes brings power and control over your deployments, it also necessitates thorough understanding and management of costs. OpenCost, specifically designed for Kubernetes cost monitoring, combined with VictoriaMetrics, an efficient time series database, offers a comprehensive solution for this challenge.

How to Monitor SQL Server with OpenTelemetry

At observIQ, we've seen growing interest in observing the health of Windows systems and applications using OpenTelemetry. Requests on the SQL Server receiver continue to garner the most interest, so let's start there. Below are steps to get up and running quickly with the contrib distribution of the OpenTelemetry collector. We'll be collecting and shipping SQL Server metrics to a popular backend, Google Cloud.

Tutorial: Monitoring MySQL Server Performance with Prometheus and sql_exporter

Databases in one form or another are almost an inseparable part of modern applications. A popular one among them is MySQL on which this article will focus. But how to monitor MySQL? This article will give an introduction to this topic.

Planning and Baselining a Migration to Azure SQL

A migration from on-premises SQL Server to Azure SQL offers many customers a number of advantages. It can enable scalability, reduce costs, enhance security, ensure high availability, and simplifies maintenance. Many organizations are looking to equivalent cloud services to move on-prem workloads such as SQL databases to the cloud, freeing themselves from the overheads of purchasing, configuring and maintaining physical hardware and infrastructure.

SSO is now available

We now support SSO (single-sign on), offering an improved login experience for our customers. SSO can be enabled on our website. We want our customers to have a great experience when using our products and part of that is an easy sign-in experience for users. Enabling SSO will remove the need for users to use their Redgate ID and password when signing into the customer portal and compatible products.

How to get your security team on board with your cloud migration

To find out more about cloud migrations, the pitfalls that await the unwary, and what the security implications are, I recently sat down with Dustin Dorsey, Systems & Data Architect at Biobot Analytics, based in Cambridge, MA. In the first post in this series, we talked about cloud providers being responsible for security ‘of’ the cloud, while their clients are responsible for security ‘in’ the cloud.

Elastic SQL inputs: A generic solution for database metrics observability

Elastic® SQL inputs (metricbeat module and input package) allows the user to execute SQL queries against many supported databases in a flexible way and ingest the resulting metrics to Elasticsearch®. This blog dives into the functionality of generic SQL and provides various use cases for advanced users to ingest custom metrics to Elastic®, for database observability. The blog also introduces the fetch from all database new capability, released in 8.10.

Create MySQL tasks easily

Databases are a critical component of our systems and their malfunction can affect business productivity. Therefore, we must make sure that they are working correctly. PandoraFMS has a plugin that allows the remote monitoring of MySQL databases through a Discovery task, by means of this task we can obtain information about the performance and status of the database, such as the number of connections, the availability of the database, the number of queries that are being made, buffer status and cache status, among other types of information.

Security in the cloud: Whose responsibility is it?

While the cloud is recognized as more secure than on-premises servers and infrastructures, it does come with the often talked about shared responsibility model. Cloud providers are responsible for security ‘of’ the cloud, while their clients are responsible for security ‘in’ the cloud. It’s ‘differently secure’, rather than the traditionally secure organizations have been used to when working with on-premises environments.