InfoQ Homepage Relational Databases Content on InfoQ
-
Amazon RDS for MySQL Zero-ETL Integration with Amazon Redshift
Amazon RDS for MySQL's zero-ETL integration with Amazon Redshift is now generally available, enabling near real-time analytics and machine learning on transactional data. This powerful feature allows customized data replication from a single RDS database and facilitates seamless scalability, ensuring businesses gain insights while controlling costs and maintaining data freshness.
-
How Amazon Aurora Serverless Manages Resources and Scaling for Fleets of 10K+ Instances
AWS engineers published a paper describing the evolution and latest design of resource management and scaling for the Amazon Aurora Serverless platform. Aurora Serverless uses a combination of components at different levels to create a holistic approach for dynamically scaling and adjusting resources to satisfy the needs of customer workloads.
-
Google Provides Extended Support for Cloud SQL MySQL and PostgreSQL End-of-Life Versions
Google Cloud has announced extended support for end-of-life Cloud SQL MySQL and PostgreSQL versions to help users maintain database operations and plan upgrades more efficiently. Starting February 1, 2025, versions such as MySQL 5.6, 5.7 and PostgreSQL 9.6 to 12 will enter an extended support phase, allowing customers to continue using these versions beyond their standard support dates.
-
QCon London: Meta Used Monolithic Architecture to Ship Threads in Only Five Months
Zahan Malkani talked during QCon London 2024 about Meta’s journey from identifying the opportunity in the market to shipping the Threads application only five months later. The company leveraged Instagram's existing monolithic architecture and quickly iterated to create a new text-first microblogging service in record time.
-
Cloudflare D1, Workers Analytics Engine and Hyperdrive: Q&A with Rita Kozlov and Matt Silverlock
Cloudflare recently announced the “production ready” switch on three products: their serverless SQL database D1, time series Workers Analytics Engine, and Hyperdrive.
-
Reddit Migrates Media Metadata from S3 and Other Systems into AWS Aurora Postgres
Reddit consolidated its media metadata storage into a new architecture using AWS Aurora Postgres. Previously, the company sourced media metadata from various systems, including directly from AWS S3. The new solution simplifies media metadata retrieval and handles 100k+ requests per second with latency below 5ms (p90).
-
Transactional Serverless Computing: PostgreSQL Creator Announces DBOS Cloud
The creators of DBOS have recently introduced DBOS Cloud, a transactional serverless application platform tailored for TypeScript developers. With all state information stored in a highly available DBMS, this new platform assures transactional serverless computing, offering reliable execution alongside so-called "time travel" capabilities.
-
Vitess Version 19 Released: Ends Support for MySQL 5.7, Improves MySQL Compatibility
Recently, Vitess launched its latest stable release v19. The highlights of this update include metrics for monitoring stream consolidations, improved query compatibility with MySQL for multi-table delete operations, support for incremental backups, and various performance enhancements, among other features.
-
Copilot in Azure SQL Database in Private Preview
Microsoft has announced a private preview of Copilot for SQL Azure, which offers a natural language for SQL conversion and self-help for database administration.
-
Amazon RDS Introduces Faster Storage for High-Performance Database Workloads
AWS has recently introduced support for io2 Block Express volumes on Amazon RDS. Priced as the existing Provisioned IOPS (PIOPS) io1, the new io2 Block Express volumes are compatible with all database engines and are designed for high-performance, high-throughput, and low-latency database workloads.
-
The Guardian Creates a Newsroom Collaboration Tool Using Serverless, React and GraphQL
The Guardian created Pinboard, a discussion and asset-sharing tool integrated into a variety of content management platforms used by the company. The solution uses a range of technologies, including Typescript for coding the business logic, different serverless services for code execution, API endpoints, and GraphQL server, as well as AWS RDS (PostgreSQL) for storage.
-
Uber's CacheFront: Powering 40M Reads per Second with Significantly Reduced Latency
Uber developed an innovative caching solution, CacheFront, for its in-house distributed database, Docstore. CacheFront enables over 40M reads per second from online storage and achieves substantial performance improvements, including a 75% reduction in P75 latency and over 67% reduction in P99.9 latency, demonstrating its effectiveness in enhancing system efficiency and scalability.
-
.NET Aspire Preview 3: Expanded Component Support with Azure OpenAI, MySQL, CosmosDB, Kafka and More
Last week, Microsoft revealed the availability of the .NET Aspire - third preview. Preview 3 brings changes including UI improvements to the dashboard, and new component support for Azure OpenAI, Kafka, Oracle, MySQL, CosmosDB & Orleans, and many more.
-
Instacart Creates Real-Time Item Availability Architecture with ML and Event Processing
Instacart combined machine learning with event-based processing to create an architecture that provides customers with an indication of item availability in near real-time. The new solution helped to improve user satisfaction and retention by reducing order cancellations due to out-of-stock items. The team also created a multi-model experimentation framework to help enhance model quality.
-
GitHub Upgrades its MySQL Infrastructure from v5.7 to 8.0
GitHub recently upgraded its MySQL infrastructure from version 5.7 to 8.0. The motivation behind this upgrade was 5.7 reaching the end of life, and a need to leverage the latest security patches, bug fixes, and performance enhancements offered by MySQL 8.0.