AWS Database Blog
Understanding and optimizing Amazon Timestream Compute Units for efficient time series data management
In this post, we provide an overview of Timestream Compute Units (TCUs), cost controls using TCUs, and how to estimate the desired compute units for your workload for optimal price-performance.
How Apollo Tyres built their tyre genealogy solution using Amazon Neptune and Amazon Bedrock
This is a joint post co-authored with Shailender Gupta, Global Head of Data Engineering, Reporting and Analytics at Apollo Tyres Apollo Tyres, headquartered in Gurgaon, India, is a prominent global tyre manufacturer with production facilities in India and Europe. The company has a widespread presence, selling tyres to consumers and industrial customers across over 100 […]
Migrate SQL Server databases to Babelfish for Aurora PostgreSQL using change tracking with a linked server
In this post, we provide instructions to replicate ongoing changes using the change tracking feature available in SQL Server Web Edition (source) with the linked server feature available in the Babelfish for Aurora PostgreSQL (target).
Connect to an Amazon RDS or Amazon Aurora instance using a federated user with AWS IAM Identity Center and IAM database authentication
In this post, we share the steps to connect to an Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition instance using a federated user with IAM Identity Center and IAM database authentication.To enhance security and streamline access, you can connect to your RDS or Aurora instances using federated users with AWS IAM Identity Center and AWS Identity and Access Management (IAM) database authentication. This integration allows you to manage database access through IAM Identity Center, providing secure, centralized authentication.
How Samsung Cloud optimized Amazon DynamoDB costs
Samsung Cloud is a cloud-based service that provides services such as backup/restore and synchronization, sharing, and device authentication of user data for all Samsung devices, including Galaxy smartphones around the world. This blog post introduces five approaches Samsung Cloud has taken to continuously lower the total cost of ownership (TCO) for Amazon DynamoDB since migrating from Apache Cassandra to DynamoDB in 2015.
How Amazon stores deliver trustworthy shopping and seller experiences using Amazon Neptune
Nearly three decades ago, Amazon set out to be Earth’s most customer-centric company, where people can discover and purchase the widest possible selection of safe and authentic goods. When a customer makes a purchase in our store, they trust they will receive an authentic product, whether the item is sold by Amazon Retail or by one […]
Move Amazon Aurora instances from public subnets to private subnets with minimal downtime
In this post, we demonstrate how you can migrate your instances within an Aurora cluster from a public subnet to a private subnet while keeping downtime to an absolute minimum.
Learn how Presence migrated off a monolithic Amazon RDS for MySQL instance, with near-zero downtime, using replication filters
Presence is a leading provider of live therapy and evaluation services for PreK-12 schools throughout the United States. Amazon RDS for MySQL has been a core part of Presence’s data architecture for many years. Presence used RDS read replicas, with replication filtering, to migrate applications from their centralized RDS for MySQL DB instance to dedicated DB instances. This approach allowed them to migrate each service, on its own schedule, with little downtime. In this post, we provide a practical example for migrating using the same method.
High availability for Oracle GoldenGate Microservices Architecture in AWS
GoldenGate supports Classic and Microservices Architectures. In Part 1 of this series, we covered high availability for GoldenGate classic architecture in AWS. In this post, we discuss a reference architecture for GoldenGate Microservices Architecture (MA) in AWS. The GoldenGate Hub is a widely used deployment model that simplifies operations and lessens the use of system resources on both the source and target systems. This is in contrast to the conventional method where GoldenGate components run directly on the source and target systems.
Analyzing PL/SQL and T-SQL code using Amazon Bedrock
In this post, we use the Anthropic Claude3 Sonnet large language model (LLM) on Amazon Bedrock to provide a detailed breakdown of the complex PL/SQL and T-SQL code, making it more understandable and comprehensible for developers who are new to a code base or working with unfamiliar code, because it helps them understand the logic and flow of the code more effectively.