AWS Database Blog

Category: Amazon Aurora

Deploy Amazon RDS databases for applications in Kubernetes

The Kubernetes container orchestration system provides numerous resources for managing applications in distributed environments. Many of these applications need a searchable storage system for their data that is secure, durable, and performant. Developers want to focus on continuously improving their apps rather than having to worry about the operational functions of their databases. They also […]

DB-1899-plprofiler-report-1

Profile Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL PL/pgSQL code using plprofiler

PostgreSQL is considered to be the primary open-source database choice when migrating from commercial databases such as Oracle. AWS provides two managed PostgreSQL options: Amazon Relational Database Service (Amazon RDS) for PostgreSQL and Amazon Aurora PostgreSQL-Compatible Edition. Identifying slow queries and tuning for better performance is an important task for developers and database administrators managing […]

Hidden dangers of duplicate key violations in PostgreSQL and how to avoid them

A common coding strategy is to have multiple application servers attempt to insert the same data into the same table at the same time and rely on the database unique constraint to prevent duplication. The “duplicate key violates unique constraint” error notifies the caller that a retry is needed. This seems like an intuitive approach, […]

Auditing for highly regulated industries using Amazon Aurora PostgreSQL

Financial services industry (FSI) customers and other highly regulated industries often need to audit every action made by each database user and administrator as well as identify each person logged in to their databases, usually using their identity provider (IdP). In such cases, the IdP is considered the source of truth for mapping users against […]

Automate PostgreSQL log exports to Amazon S3 using extensions

Do you want to copy or archive your Amazon Relational Database Service (Amazon RDS) for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition logs directly to Amazon Simple Storage Service (Amazon S3)? Does your organization have the regulatory requirements to audit all the DDL or DML activity against your RDS for PostgreSQL database? With the addition of […]

Improve application availability with the AWS JDBC Driver for Amazon Aurora MySQL

In this post, we demonstrate how to use the Amazon Web Services (AWS) JDBC Driver for MySQL, which allows an application to take advantage of the features of clustered MySQL databases. You can use this driver as a drop-in replacement for the MySQL Connector/J Driver to connect to an Amazon Aurora MySQL-Compatible Edition cluster. Amazon […]

Migrate from Amazon RDS for Oracle to Aurora PostgreSQL or Amazon RDS for PostgreSQL using this self-service guide

Today, we’re introducing the Amazon Database Migration Accelerator (DMA) Connect program which is designed to help you migrate from Amazon Relational Database Service (Amazon RDS) for Oracle to Amazon Aurora PostgreSQL-Compatible Edition or Amazon RDS for PostgreSQL. Migration to Amazon RDS for Oracle is a common first step for many customers making their foray into […]

How Panasonic Avionics used Amazon Aurora MySQL to modernize their environment

This is a guest post by Jeremy Welch, Data Software Engineer Sr. Staff on the Cloud, Data Management And Governance team with Panasonic Avionics Corporation, in partnership with AWS Sr. Database Solutions Architect Saikat Banerjee and Sr. Partner SA (Database) Venkatesh Periyathambi. Panasonic Avionics Corporation (PAC) is the world’s leading supplier of in-flight entertainment and […]

Migrate from SQL Server to Aurora PostgreSQL using SSIS and Babelfish

Babelfish for Aurora PostgreSQL understands T-SQL, Microsoft SQL Server’s proprietary SQL dialect, and supports the same communications protocol, so your applications that were originally written for SQL Server can now work with Amazon Aurora PostgreSQL-Compatible Edition with fewer code changes. With Babelfish, you still have to migrate the data from your SQL Server database to […]

Migration options for MySQL to Amazon RDS for MySQL or Amazon Aurora MySQL

MySQL is one of the most popular open-source relational databases in the world. Many customers choose to run their MySQL workload in Amazon Relational Database Service (Amazon RDS) for MySQL because it takes care of heavy lifting tasks such as hardware provisioning, database setup, patching, configuration, monitoring, backups, and scaling. Amazon Aurora is a great […]