InfoQ Homepage Relational Databases Content on InfoQ
-
ProxySQL Introduces Multi-Tier Release Strategy with Stable, Innovative, and AI Tracks
ProxySQL 3.0.6 was recently released, along with a new multi-tier release strategy. The Stable Tier focuses on reliability and production use, the Innovative Tier introduces newer features earlier, and the AI/MCP Tier explores future capabilities, including AI integrations.
-
From Minutes to Seconds: Uber Boosts MySQL Cluster Uptime with Consensus Architecture
Uber redesigned its MySQL fleet using a consensus-driven architecture based on MySQL Group Replication, reducing cluster failover time from minutes to seconds. By moving leader election and failure detection into the database layer, Uber improved availability, simplified external orchestration, and strengthened consistency across thousands of production clusters.
-
Netflix Automates RDS PostgreSQL to Aurora PostgreSQL Migration across 400 Production Clusters
Netflix engineers describe an internal automation platform that migrates nearly 400 RDS PostgreSQL clusters to Aurora, reducing downtime and operational risk. The platform coordinates replication, CDC handling, controlled cutover, and rollback, while supporting service teams in a self-service migration workflow.
-
MySQL 9.6 Changes Foreign Key Constraints and Cascade Handling
MySQL is changing the way foreign key constraints and cascades are managed. Starting with MySQL 9.6, foreign key validation and cascade actions are handled by the SQL layer rather than the InnoDB storage engine. This will improve change tracking, replication accuracy, and data consistency, making MySQL more reliable for CDC pipelines, mixed-database environments, and analytics workloads.
-
Databricks Introduces Lakebase, a PostgreSQL Database for AI Workloads
Databricks has recently announced the general availability of Lakebase, a serverless, PostgreSQL-based OLTP database that scales compute and storage independently. Lakebase is designed to integrate with the Databricks platform, providing a hybrid solution that combines both transactional and analytical capabilities.
-
AWS Enables Lambda Function Triggers from RDS for SQL Server Database Events
In a blog post, AWS recently described an event-driven pattern for Amazon RDS for SQL Server, allowing developers to trigger Lambda functions in response to database events via CloudWatch Logs and SQS.
-
OpenEverest: Open Source Platform for Database Automation
Percona recently announced OpenEverest, an open-source platform for automated database provisioning and management that supports multiple database technologies. Launched initially as Percona Everest, OpenEverest can be hosted on any Kubernetes infrastructure, in the cloud, or on-premises.
-
Expired Oracle Patent Opens Fast Sorting Algorithm to Open Source Databases
A recent article reports that an Oracle patent on a fast sorting method has expired, allowing open source databases to use it freely. Mark Callaghan, the inventor behind the sorting algorithm, shows how this 20-year-old approach can speed up sorting similar data and could make database systems faster and more efficient.
-
Prisma 7: Rust-Free Architecture and Performance Gains
Prisma ORM 7.0 has revolutionized the TypeScript-first ORM landscape with a Rust-free architecture, delivering 3x faster queries, 90% smaller bundles, and improved developer experience. With dynamic configurations and streamlined artifact management, Prisma enhances productivity while supporting major databases. Elevate your Node.js projects with cutting-edge performance and type safety.
-
Microsoft Introduces Postgres-Compatible Azure HorizonDB
During the recent Microsoft Ignite conference, the cloud provider announced the early preview of Azure HorizonDB, a managed Postgres-compatible database service for enterprise workloads.
-
Atlassian's 4 Million PostgreSQL Database Migration: When Standard Cloud Strategies Fail
Atlassian recently migrated 4 million Jira databases to Amazon Aurora, intending to reduce costs and improve the reliability of its Jira Cloud platform. Due to the large number of files involved and the constraints of managed services, the team developed a custom tool to orchestrate the process, as traditional cloud migration strategies were not viable.
-
Databases in 2024: Growth, Change and Controversy
Andrew Pavlo’s annual retrospective on the database world has recently been released, covering trends and innovations from the past year. The opinionated report, "Databases in 2024: A Year in Review," highlights that while we may indeed be in the "golden era of databases," last year brought significant license changes, the rapid growth of DuckDB, and some surprising new releases.
-
Amazon Aurora DSQL: Distributed SQL Database with Active-Active High Availability
At the recent AWS re:Invent conference in Las Vegas, Amazon announced the public preview of Aurora DSQL, a serverless, distributed SQL database featuring active-active high availability. This new PostgreSQL-compatible database option has generated significant excitement within the AWS community and was widely regarded by attendees as the standout announcement of the conference.
-
From Aurora DSQL to Amazon Nova: Highlights of re:Invent 2024
The 2024 edition of re:Invent has just ended in Las Vegas. As anticipated, AI was a key focus of the conference, with Amazon Nova and a new version of Sagemaker among the most significant highlights. However, the announcement that generated the most excitement in the community was the preview of Amazon Aurora DSQL, a serverless, distributed SQL database with active-active high availability.
-
Aurora Limitless: AWS Introduces New PostgreSQL Database with Automated Horizontal Scaling
AWS has announced the general availability of Amazon Aurora PostgreSQL Limitless Database, a relational database designed to provide automated horizontal scaling. This new option can handle millions of write transactions per second and manage petabytes of data, all within a single database environment.