Operations | Monitoring | ITSM | DevOps | Cloud

September 2023

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.

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.

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.

The Ultimate RDS Instance Types Guide: What You Need To Know

Amazon’s Relational Database Service (Amazon RDS) offers a variety of database instances, which can be confusing at first. In this guide, we'll clarify what each RDS instance class, family, type, and size means in under 15 minutes. Let's start at the beginning.

SQL Sentry Then and Now

With the release of SQL Sentry 2023.3, I look back at the past 18 years I have worked with the product to admire where it is today versus then. It’s been an incredible experience with a lot of moving parts, but no matter what market forces or acquisitions happen along the way, the core intention of “Improving the lives of Microsoft DBAs everywhere” has stayed the same. This is a two-part blog post: below, I’ll talk about our history and where we’ve come from.

Scaling AWS Lambda and Postgres to thousands of simultaneous uptime checks

When you're building a serverless web app, it can be pretty easy to forget about the database. You build a backend, send some data to a frontend, write some tests, and it'll scale to infinity with no effort, right? Not quite. Especially not with a tiny Postgres server. As the number of users of your frontend increases, your app will open more and more database connections until the database is unable to accept any more. That's just the frontend - it gets worse on the backend.
Sponsored Post

The Future of SQL Sentry

This month, I celebrate 11 years of working on SQL Sentry. I started as employee number 15 at SentryOne and then moved through various roles in support, customer success, and professional services to my current role as product manager. In an industry where innovation and adaptation are key, the journey of SQL Sentry and its team has been remarkable. SQL Sentry has come a long way since its early days.

Amazon RDS: managed database vs. database self-management

Amazon RDS or Relational Database Service is a collection of managed services offered by Amazon Web Services that simplify the processing of setting up, operating, and scaling relational databases on the AWS cloud. It is a fully managed service that provides highly scalable, cost-effective, and efficient database deployment.

Deploying Scalable Next.js Applications on Netlify with PostgreSQL and Redis

Deploying an application at scale can be challenging. In this video, we address this challenge using Netlify and Aiven. Dewan Ahmed, a developer advocate at Aiven, assists a fictional developer (Alex) who has limited knowledge of production-grade databases and deployment. Together, they master the process of deploying robust, secure, and scalable Next.js applications on Netlify, integrating seamlessly with PostgreSQL and Redis on the Aiven platform.

Navigating the risk of sharing database access

With the huge growth in volume and complexity, data management has become a key priority in most Enterprises. But for this data to be utilised in a meaningful way, how do you tackle the added complexity of controlling access across both technical and business departments? Our CPO, David Gummer recently interviewed the CEO of the popular Universal Database management tool, DBeaver, Tatiana Krupenya, to discuss the often-feared topic of sharing access to the database. Prefer video? Watch the interview here.

Azure SQL database cost optimization to maximize savings

Azure SQL is a versatile and powerful database service, and it is an increasingly popular choice for storing and managing application data due to its scalability, high availability, security, and simplicity of integration. A common demand for cloud workloads is cost optimization. To maximize cloud savings, this article discusses Azure SQL Database Cost Optimization.

The BSL is a short-term fix: Why we choose open source

On August 13 2023, users of HashiCorp’s Terraform forked the software under the name OpenTF. This was a strong and rapid community reaction to HashiCorp switching the license on their products merely three days before. The list of companies and individuals pledging their support to the new fork has been overwhelming. The new license that HashiCorp has chosen for its products, the Business Source License (BSL), is no longer open source, but instead source-available.

The Benefits and Challenges of Managing Hybrid Estates

More and more organizations are migrating their data to the cloud but the majority are likely to end up managing hybrid estates, with some data managed through a cloud provider and some managed locally. This leads to some unique issues, especially around monitoring and services. If the objective of migrating to the cloud is simply to implement virtual machines (VMs) in a different location than you traditionally do, there will be fewer challenges.

Exploring Postgres and Aiven Platform

Welcome to our "Exploring Postgres and Aiven Platform"! In this tutorial, we'll take you on a journey to learn the fundamentals of Postgres database management and how to leverage the powerful features of the Aiven platform. Whether you're new to Postgres or looking to enhance your skills, this series is designed to provide you with step-by-step instructions, practical examples, and valuable insights. From setting up and deploying Postgres on the Aiven platform to exploring advanced configurations and optimizations, we've got you covered.