Operations | Monitoring | ITSM | DevOps | Cloud

Databases

The latest News and Information on Databases and related technologies.

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.

SolarWinds Day September 2023 Database Session

Now more than ever, it is important for professionals across various roles, levels, and functions to easily access and use operational tools designed to add value and accelerate the business. To achieve this, tools must be simple to use and integrate. This SolarWinds day you can: Discover how we are making it easier than ever for database professionals to quickly detect, remediate, and prevent issues with the latest SQL Sentry® release.

SQL Performance Tuning: 7 Practical Tips for Developers

Being able to execute SQL performance tuning is a vital skill for software teams that rely on relational databases. Vital isn’t the only adjective that we can apply to it, though. Rare also comes to mind, unfortunately. Many software professionals think that they can just leave all the RDBMS settings as they came by default. They’re wrong. Often, the default settings your RDBMS comes configured with are far from being the optimal ones.

Seamlessly correlate DBM and APM telemetry to understand end-to-end query performance

When the services in your distributed application interact with a database, you need telemetry that gives you end-to-end visibility into query performance to troubleshoot application issues. But often there are obstacles: application developers don’t have visibility into the database or its infrastructure, and database administrators (DBAs) can’t attribute the database load to specific services.