InfoQ Homepage Relational Databases Content on InfoQ
-
How GitHub Partitioned Its Relational Database to Improve Reliability at Scale
GitHub has been working for the last couple of years on partitioning their relational database and moving the data to multiple independent clusters. This effort led to a 50% load reduction and a significant reduction of database-related incidents, explains GitHub engineer Thomas Maurer.
-
Amazon Aurora Supports PostgreSQL 13
AWS has recently announced that Amazon Aurora supports major version 13 of PostgreSQL. The compatibility with the latest major PostgreSQL version adds improvements such higher performing partitioned table queries and deduplication of B-tree index entries.
-
Google Bolsters Cloud Spanner with Point-in-Time Recovery
Google recently released a point-in-time-recovery feature for its Cloud Spanner database that aims to help protect against accidental data loss and corruption. The new point-in-time recovery (PITR) features seek to provide users more granular control over data recovery processes.
-
Cloud Spanner Adds Support for Liquibase
Google Cloud has recently added support for Liquibase on Cloud Spanner. The new extension allows developers to use the open-source database library to manage and automate schema changes for the globally distributed SQL database on Google Cloud.
-
AWS Announces Amazon Aurora Supports PostgreSQL 12
AWS has recently announced that Amazon Aurora, a MySQL and PostgreSQL-compatible relational Database built for the Cloud, now supports major version 12 of PostgreSQL.
-
AWS Introduces Preview of Aurora Serverless v2
During the first keynote of re:Invent 2020, AWS announced the next version of Amazon Aurora Serverless in preview. The new serverless version for the MySQL 5.7-compatible edition of Amazon Aurora scales in fraction of a second and introduces multi-AZ support, global databases, and read replicas.
-
Oracle Introduces the MySQL Database Service on Its Cloud Infrastructure
In a recent blog post, Oracle introduced the MySQL Database Service in the Oracle Cloud Infrastructure (OCI). The service is now available as a fully-managed service running on Oracle Generation 2 Cloud Infrastructure.
-
AWS Announces General Availability of Amazon RDS Proxy
Amazon RDS Proxy is a new fully managed, highly available database proxy for MySQL and PostgreSQL databases running on Amazon RDS and Aurora. The service is tailored to serverless architectures and other applications that open and close database connections at a high rate.
-
Google Updates Cloud Spanner with New Features: Backup on Demand, Local Emulator, and More
In a recent blog post, Google announced a slew of new features for Cloud Spanner. The public cloud provider released the service with new updates including the managed backup-restore feature, foreign key support, query optimizer versioning feature, a C++ client library, and a local emulator.
-
GRIT Protocol Enables Distributed Transactions across Multi-Database Microservices
At the IEEE International Conference on Data Engineering (ICDE) 2019, eBay engineers presented a paper introducing a protocol for distributed ACID transactions using multiple databases, GRIT. Support for multiple databases is key to enabling GRIT's use across microservices, which are usually implemented in different languages and may use multiple underlying databases.
-
Cockroach Labs Announces CockroachCloud, a Fully-Managed Distributed SQL Database in Beta
Recently, Cockroach Labs announced the beta program of CockroachCloud, a fully-managed service for its CockroachDB distributed SQL database. With CockroachCloud, customers can provision, scale and manage a complex, highly available distributed SQL database within minutes.
-
DigitalOcean Adds Managed MySQL and Redis Services
Cloud provider DigitalOcean recently released a pair of new managed data services. Their Managed MySQL and Redis offerings are on-demand and elastic, and offer a variety of sizes and high-availablity options.
-
FoundationDB's Record Layer Supports Relational Database Semantics, Schema Management and Indexing
FoundationDB NoSQL database's new Record Layer supports relational database semantics, schema management, primary and secondary indexes, and query capabilities. The FoundationDB team announced last month the open source release of the Record Layer.
-
Google Updates Cloud Spanner: Query Introspection, New Regions, and New Multi-Region Configurations
In a recent blog post, Google announced a few enhancements for Cloud Spanner - a globally distributed NewSQL database. Based on customer requests, Google updated the service with query introspection improvements, new region availability, and new multi-region configurations.
-
Building Resilience in Netflix Production Data Migrations: Sangeeta Handa at QCon SF
At QCon SF, Sangeeta Handa discussed how Netflix had learned to build resilience into production migrations across a number of use cases. Key lessons learned included: aim for perceived or actual zero downtime, even for data migrations; invest in early feedback loops to build confidence; find ways to decouple customer interactions from your services; and build independent checks and balances.