AWS Database Blog

Category: Amazon Aurora

Sending notifications from Amazon Aurora PostgreSQL

Enterprise customers execute many day-to-day batch jobs on Amazon Aurora PostgreSQL databases, and need notification methods such as email or text after completing such jobs to keep track of their activity. Because Aurora PostgreSQL is a managed service, it restricts access to database extensions such as pgsmtp and pgplpythonu for security reasons. This raises the […]

Read More

Validating database objects after migration using AWS SCT and AWS DMS

Database migration can be a complicated task. It presents all the challenges of changing your software platform, understanding source data complexity, data loss checks, thoroughly testing existing functionality, comparing application performance, and validating your data. AWS provides several tools and services that provide a pre-migration checklist and migration assessments. You can use the AWS Schema […]

Read More

Reducing Aurora PostgreSQL storage I/O costs

Cost reduction is one of the biggest drivers for many IT departments to explore migration of on-premises workloads to the cloud. This post shares experiences in cost management, with a focus on Amazon Aurora PostgreSQL tuning. History I recently had the privilege of leading the implementation of our Auto Telematics Application in AWS. To provide […]

Read More

IAM role-based authentication to Amazon Aurora from serverless applications

Storing user names and passwords directly in applications is not a best practice. Saving credentials as plaintext should never occur in a secure application. As a solution, AWS Identity and Access Management (IAM) policies can assign permissions that determine who is allowed to manage Amazon Aurora resources. For example, you can use IAM to determine […]

Read More

Optimizing and tuning queries in Amazon RDS PostgreSQL based on native and external tools

PostgreSQL is one of the most popular open-source relational database systems. The product of more than 30 years of development work, PostgreSQL has proven to be a highly reliable and robust database that can handle a large number of complicated data workloads. PostgreSQL is considered to be the primary open-source database choice when migrating from […]

Read More

Performing SQL database client-side encryption for multi-Region high availability

Amazon Relational Database Service (RDS) and Amazon Aurora natively provide encryption at rest to protect the underlying storage of database instances, automated backups, Read Replicas, and snapshots. However, some customers may have greater data protection requirements which require encrypting data in use. For example, encryption is required where tokenization solutions do not fit, such as when […]

Read More

Build highly available MySQL applications using Amazon Aurora Multi-Master

Do you have transactional applications that have high uptime requirements? Do you want a relational database in the cloud to help you meet those requirements? The newly launched Amazon Aurora Multi-Master, is designed for applications that need a relational database resilient to node failures and highly available for both reads and writes. Amazon Aurora is […]

Read More

Use the Data API to interact with an Amazon Aurora Serverless MySQL database

Amazon Aurora Serverless is an on-demand, automatically scaling configuration for Amazon Aurora (MySQL-compatible edition). The database automatically starts up, shuts down, and scales capacity based on your application’s needs. It enables you to run your database in the cloud without managing any database instances. It’s a simple, cost-effective option for infrequent, intermittent, or unpredictable workloads. Recently, AWS announced […]

Read More

Select the right encryption options for Amazon RDS and Amazon Aurora database engines

Customers are increasingly choosing to encrypt their AWS Cloud databases and data stores by default. This trend is only gaining speed with the evolving meaning of sensitive data (personally identifiable information [PII], etc.) within various regulatory frameworks. Customers also ask AWS for guidance on how to best adopt the latest database encryption options, while maintaining […]

Read More

Improve Business Continuity with Amazon Aurora Global Database

As your business grows increasingly global, your database needs similarly expand. Resources must be just as available to your team in Zurich as they are to your office in Beijing, with the same speed, security, and ease of access. Amazon Aurora Global Database expands your Amazon Aurora database across the planet. Aurora builds its storage volumes […]

Read More