Operations | Monitoring | ITSM | DevOps | Cloud

Databases

The latest News and Information on Databases and related technologies.

How Do MySQL Indexes Work? An In-Depth Tutorial on Creating Clustered and Secondary Indexes and The Effect on Database Performance

MySQL is the most used database in the world. And as it continues to grow in popularity as an open-source database system for developers, understanding how these indexes work is an important step for database developers and administrators. This tutorial is going to explore clustered indexes and secondary indexes in MySQL. MySQL also has other types of indexes besides the B-tree indexes I’ll be discussing, such as fulltext indexes and hash indexes.

Never too late for database performance monitoring

A reliable database system is necessary in the IT operations of an organization to ensure unhindered delivery of information. This is especially true when it comes to business-critical applications, as disruptions in a database system directly impact the end-user experience, ultimately harming your revenue and reputation. Learn about the difficulties inherent to database systems and how monitoring helps resolve these problems.

A Deep-dive into VictoriaMetrics - The Open Source Time Series Database & Monitoring Solution

This video walks you through the inner workings of VictoriaMetrics: All combined and in a nutshell, VictoriaMetrics boasts: Enjoy the video and let us know if you have any questions via the comments section.

7 types of Redis latency and how to fix it

Redis is designed to be fast. In most cases, it is. However, there are times when Redis may be slow, due to network issues, disk latency, or other factors. When this happens, it is important to be able to detect the slow down and investigate the cause. Latency is the maximum delay between the time a client issues a command and the time the reply to the command is received by the client. Redis has strict requirements on average and worst case latency.

A Simplified Introduction to Azure Database for PostgreSQL Flexible Server

I find it amazing how much opportunity and flexibility cloud environments are creating for organizations of all sizes. I’m seeing more and more companies experimenting with open-source software (OSS) relational database systems, which years ago would’ve been too complicated for the customer to set up. With Azure, you can spin up OSS systems like MySQL or PostgreSQL quickly to determine if the engine fits their needs. If it does, you can continue development on it.

Redis Monitoring: What Metrics Should You Measure to Ensure Performance

Redis is an open-sourced, BSD 3 licensed, highly efficient in-memory data store. It is used widely in the industry because of its incredible performance and ease of use. It can easily be used as a distributed, in-memory key-value store, cache, or message broker. It can hold virtually any data structure, making it highly versatile. Redis was architectured and developed with speed in mind and designed to keep all the data in memory.

Three Years in the Making: Redgate Launches Enterprise Version of Popular Open Source Migrations Tool, Flyway

Redgate Software announced today the launch of Flyway Enterprise, a feature-rich version of Flyway which standardizes and automates database deployments across teams and database technologies, increasing both their frequency and reliability.

Monitor Azure Cosmos DB for PosgreSQL with Datadog

Azure Cosmos DB for PostgreSQL is a fully managed relational database service for PostgreSQL that is powered by the open source Citus extension. With remote query execution and support for JSON-B, geospatial data, rich indexing, and high-performance scale-out, Cosmos DB for PostgreSQL enables users to build applications on single- or multi-node clusters.