AWS Database Blog

Category: Amazon RDS

Migrate end of support Microsoft SQL Server databases to Amazon RDS for SQL Server confidently

Customers running end of support (EOS) Microsoft SQL Server workloads on premises often ask us how they can confidently migrate those workloads to AWS fully managed database services like Amazon Relational Database Service (Amazon RDS) for SQL Server. Amazon RDS for SQL Server makes it simple to set up, operate, and scale SQL Server deployment […]

How Amazon DevOps Guru for RDS helps NRI Digital with database performance monitoring

This guest post is co-authored by Ryota Shima, Application Architect, and Kazuki Matsumura, Lead Architect at NRI Digital. NRI Digital has a wide variety of systems in production, both on-premises and cloud-based. Among them, many systems are built on AWS, and Amazon Aurora and Amazon Relational Database Service (Amazon RDS) are often used as the […]

Understand and build a hybrid database with Amazon RDS and AWS Outposts

Many customers are faced with the challenge of building and operating a hybrid infrastructure to support workloads that must run both in the cloud and on premises. In many cases, these hybrid workloads rely on a relational database to support the workload, which can be particularly challenging to build and support across a hybrid infrastructure. […]

How to use Amazon RDS and Amazon Aurora with a static IP address

When you use Amazon Relational Database Service (Amazon RDS) and Amazon Aurora, you may have noticed that the IP addresses of your database instances keep changing. There are several reasons for this. The IP address changes when the primary database of Amazon RDS fails over to a standby database. Furthermore, when Amazon RDS is restarted […]

Automate Amazon RDS for PostgreSQL horizontal scaling and system integration with Amazon EventBridge and AWS Lambda

You may have a workload where you want to automate scaling, such as a reporting application with unpredictable increases in queries, or an application with database utilization increasing at predictable times like end-of-month reporting. Scaling a database to appropriately handle workload demand is important to help manage cost, operations, performance, security, and reliability. With Amazon […]

Migrate to Amazon RDS for Oracle with cost optimization

When migrating Oracle Database applications to AWS, you have many opportunities to modernize and optimize your architecture. This migration provides increased agility and flexibility, as well as the potential to migrate to a fully managed service, such as Amazon Relational Database Service (Amazon RDS) for Oracle. RDS for Oracle offers compute scaling, automated backups, event […]

Archive and Purge Data for Amazon RDS for PostgreSQL and Amazon Aurora with PostgreSQL Compatibility using pg_partman and Amazon S3

The structured data industry has been experiencing exponential data growth year by year. It’s important for the relational database users to get smart with its data storage footprint by understanding data relevance while keeping its business needs in mind. Data archive is the critical part of data management, as it enables us to keep business […]

Amazon DevOps Guru for RDS under the hood

Amazon DevOps Guru for RDS is a new capability for Amazon DevOps Guru that helps developers using Amazon Aurora database instances detect, diagnose, and resolve database performance issues fast and at scale. DevOps Guru for RDS uses machine learning (ML) to automatically identify and analyze a wide range of performance-related database issues, such as over-utilization […]

Migrate TDE-enabled SQL Server databases to Amazon RDS for SQL Server

Amazon Relational Database Service (Amazon RDS) for SQL Server now supports the direct migration of transparent database encryption (TDE)-enabled databases by using the native backup and restore feature. Previously, to migrate a TDE-enabled database from on premises to Amazon RDS for SQL Server, you had to disable the TDE at your on-premises (source) database and […]

View Amazon CloudWatch logs for Amazon RDS in Splunk Cloud Platform

You can use Splunk Cloud Platform to monitor your entire infrastructure, including database servers hosted in AWS, on premises, or both. In this post we provide you detailed steps on how Splunk can connect to Amazon CloudWatch Logs using AWS Identity and Access Management (IAM) user credentials and pull database log files for Amazon Relational […]