DEVOPSdigest

Redgate announced a wide range of product updates supporting multiple database management systems (DBMS) across its entire portfolio, designed to support IT professionals grappling with today’s complex database landscape.

“At Redgate, we believe in providing support across the most popular database management systems, but with rich functionality to make professionals’ lives easier,” said David Gummer, Chief Product Officer at Redgate. “Our strategic portfolio development choices are therefore based both in providing foundational and advanced capabilities across a carefully chosen set of DBMS, as prompted by user feedback among our community. By providing foundational capability support across popular DBMS, we are able to make database migrations easy for our largest user base. For example, foundational capabilities for more than 50 DBMS are available in all editions of Flyway, including our free edition Flyway Community, while we have rolled out significant PostgreSQL support for Redgate Monitor.”

Delivering PostgreSQL support for Redgate Monitor: In 2024, Redgate’s engineering teams have focused on deepening PostgreSQL support for Redgate’s Monitor solution, offering cross-database, multi-platform monitoring to ensure optimal performance, providing our customers with greater reliability, improved performance, and more efficient management for PostgreSQL environments.

Query analysis is at the heart of any database monitoring tool, and during 2024 Redgate has enhanced the Postgres functionality for Monitoring, introducing alerting for replication and high availability health, query performance, and server configuration.

The company now also offers PostgreSQL query tuning recommendations to optimize query performance and real-time current activity monitoring to keep users informed instantly.

Broadening the range of what can be monitored from the initial support for Linux and Amazon RDS managed database services, in 2024 Redgate has added Amazon Aurora managed service support. The team will expand support for those in cloud or hybrid environments by adding support for monitoring Azure Flex, which should be in place by the end of 2024.

As Redgate pursues its vision to support users of multiple database platforms, the Monitor engineering team are also building out foundational support for Oracle, MySQL and MongoDB, to be delivered in Q1 2025, addressing the need to effectively and efficiently monitor diverse, multi-platform database environments.

The team have also developed the ability for Redgate Monitor to run on Linux environments, making the solution a more natural fit for PostgreSQL-only customers, and this will be available by H1 2025.

Automated Database DevOps: Redgate’s Automate solution Flyway accelerates and de-risks software delivery with continuous integration and delivery. In 2024, the team has released further advanced capabilities for DBMS across SQL Server, Postgres, Oracle and MySQL.

Advanced capability support for EnterpriseDB Advanced Server and TimescaleDB means that Flyway users benefit from auto-generation of migration scripts, object-level version control, drift detection and change reporting. All of these capabilities are designed to help enterprise organizations deliver database deployments with increased speed, reliability and quality.

Redgate has also made foundational capabilities for ClickHouse, Cassandra and Databricks generally available, and has brought MongoDB and Amazon DocumentDB into preview. More database platforms will be explored in 2025.

End-to-end Database DevOps: As a key part of Redgate’s end-to-end Database DevOps portfolio, in 2024 engineering teams have continued to strengthen Redgate Test Data Manager, launched late last year.

New product features in the areas of data virtualization, subsetting, automated deterministic masking and more offer better support to organizations to improve the efficiency and quality of software updates with accurate and reliable, anonymous test data. Built with multiple database platform support from day one, Test Data Manager supports Postgres, Oracle, MySQL, and SQL Server environments. Multi-RDBMS support with Redgate Test Data Manager means you can standardize workflows, approaches and technology across teams, reducing complexity.