AWS Database Blog

Best practices for successful SSL connections to Amazon RDS for Oracle

In this post, we show you how to successfully set up SSL connectivity with Amazon Relational Database Service (Amazon RDS) for Oracle. For the purpose of this post, we have considered scenarios of SSL connectivity with the source as a SQL Plus client over a Linux platform and also a Java application client. SSL connectivity […]

Accelerate database development in Amazon RDS and Amazon Aurora with Amazon CodeWhisperer

As organizations continue to scale applications, the need for database developers to quickly pick up new skills becomes increasingly important. Amazon CodeWhisperer is an AI-powered productivity tool for the integrated development environment (IDE) and command line that helps improve developer productivity by generating code recommendations based on your comments in natural language and code in […]

Run Polygon nodes on AWS

In this post, we dive deep into establishing your infrastructure and deploying Polygon blockchain nodes on AWS. We provide recommendations for selecting optimal compute and storage options tailored to various use cases. We discuss the approach to speed up the horizontal scaling of Polygon full nodes on AWS with Amazon Simple Storage Service (Amazon S3) […]

Upgrade Amazon DocumentDB 3.6 to 5.0 with near-zero downtime

Amazon DocumentDB (with MongoDB compatibility) is a fully managed native JSON database designed for scaling enterprise workloads. You can use the same MongoDB API 3.6, 4.0, and 5.0 application code, drivers, and tools to run, manage, and scale workloads on Amazon DocumentDB without worrying about managing the underlying infrastructure. As a document database, Amazon DocumentDB makes it simple to store, query, and index JSON data. With Amazon DocumentDB version 5.0, you can now perform a major version upgrade of your Amazon DocumentDB clusters from version 3.6 and 4.0 to 5.0 in order to unlock latest features including support for vector search, I/O-optimized storage, document compression, text search, partial index and more. In this post, we explore how to perform an upgrade with near-zero downtime from Amazon DocumentDB 3.6 to 5.0 by using an in-place major version upgrade and Amazon DocumentDB volume cloning.

Automate SQL Server discovery and assessment to accelerate migration to AWS

Adopting lift and shift or rehost migration approach can be a viable option for time-sensitive scenarios, particularly when transitioning from an on-premises data center environment. However, it’s crucial to ensure that the chosen migration strategy aligns with your organization’s overall cloud adoption strategy to realize the long-term benefits of cloud-native architectures. For many applications, a […]

Common financial services use cases for Amazon DynamoDB

Financial services customers choose DynamoDB for security, resilience, performance, and scale. In this post, we discuss how Amazon DynamoDB helps financial services customers overcome these challenges for common industry use cases. We also share customer examples, such as Fidelity Investments, Experian, Moody’s, and other financial services applications that are built with DynamoDB.

Achieve faster switchover for Amazon RDS Blue/Green Deployments with large number of connections

In this post, we show you a recent improvement for Amazon RDS Blue/Green Deployment switchovers to reduce your overall downtime when you have a large number of connections to your database. Blue/Green Deployments enforce safety measures to make sure that the switchover from your blue environment to the green environment maintains data consistency. For reference, […]

How RocketReach stabilized Amazon Aurora costs and improved performance with Amazon Aurora I/O-Optimized

Over 16 million users around the world, including 95% of the S&P Fortune 500, use RocketReach to power their sales, recruitment, and marketing teams. RocketReach connects professionals to new people and opportunities, powered by the most comprehensive, accurate contact information database with easy-to-use tools to simplify their customer’s workflow. High-quality data is the North Star […]

Replicate data between partitioned and non-partitioned tables using trigger functions in Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL

In this post, we show you how to replicate data between partitioned and non-partitioned tables using trigger functions in Amazon Aurora PostgreSQL-Compatible Edition. The solution also works with Amazon Relational Database Service (Amazon RDS) for PostgreSQL. Customers often decide to migrate partial applications and their associated database objects to AWS, which requires synchronizing data from […]