AWS Database Blog
Category: MySQL compatible
Amazon Aurora MySQL version 2 (with MySQL 5.7 compatibility) to version 3 (with MySQL 8.0 compatibility) upgrade checklist, Part 2
In the first part, we discussed the most common issues that will cause upgrade prechecks from Amazon Aurora MySQL-Compatible Edition v2 to v3 to fail. In this post, we discuss the most common causes of prolonged and unsuccessful upgrade. Cluster has XA transactions in the prepared state Amazon Aurora MySQL cancels the upgrade if it […]
Amazon Aurora MySQL version 2 (with MySQL 5.7 compatibility) to version 3 (with MySQL 8.0 compatibility) upgrade checklist, Part 1
Amazon Aurora MySQL-Compatible Edition version 2 (with MySQL 5.7 compatibility) is planned to reach the end of standard support on October 31, 2024. The Amazon Aurora MySQL version 2 end of standard support timeline is discussed in our public documentation. We recommend that you upgrade your databases to the default minor version of Amazon Aurora […]
Implement advanced replication features with Amazon RDS for MySQL and Amazon Aurora MySQL using intermediate replication servers
In this post, we show you how to use advanced replication features between MySQL-compatible databases such as Amazon Aurora MySQL-Compatible Edition clusters or Amazon Relational Database Service (Amazon RDS) for MySQL instances. We discuss two replication capabilities in Amazon RDS and Amazon Aurora: multi-source replication and replication filtering. Multi-source replication is supported only in Amazon […]
Perform cross-account major version upgrades from Amazon RDS for MySQL 5.7 to Amazon Aurora 3.04.x with minimum downtime
As businesses continue to scale, the need for highly performant, scalable, and reliable databases becomes paramount. Amazon Aurora, with its advanced features and cloud-native architecture, offers an attractive solution for organizations seeking to upgrade their databases. For mission-critical, large, and complex databases, it is challenging to upgrade databases with near-zero downtime for cutover. In this […]
Trigger an AWS Lambda function from Amazon RDS for MySQL or Amazon RDS for MariaDB using audit logs and Amazon CloudWatch
AWS Lambda is a serverless compute offering that helps you design event-driven architectures. It provides direct integration with multiple AWS services, including Amazon Aurora MySQL-Compatible Edition. In this post, we show you how to invoke Lambda functions from Amazon Relational Databases Service (Amazon RDS) for MySQL and Amazon RDS for MariaDB using Amazon CloudWatch and […]
Upgrade to Amazon Aurora MySQL version 3 (with MySQL 8.0 compatibility)
Amazon Aurora MySQL-Compatible Edition version 3 (with MySQL 8.0 compatibility) is the most current major version supported on Amazon Aurora MySQL. You can use Amazon Aurora MySQL version 3 to get the latest MySQL-compatible features and performance improvements. MySQL 8.0 introduces several new features, including JSON functions, window functions, common table expressions (CTEs), and role-based […]
Detect PII data in Amazon Aurora with Amazon Comprehend
In this post, we demonstrate how to build a mechanism to automate the detection of sensitive data, in particular personally identifiable information (PII), in your relational database. PII is information connected to an individual and can be used to identify them. Handling PII data in a relational database, such as Amazon Aurora, requires planning and […]
Introducing the Data API for Amazon Aurora Serverless v2 and Amazon Aurora provisioned clusters
Traditionally, applications that communicate with relational databases use drivers that provide a persistent connection between the application and the database server. With the advent of serverless applications, including those created using AWS Lambda, persistent connections from the application are no longer practical because serverless applications are, by nature, stateless. What’s more, traditional database drivers often […]
Supercharge your MySQL database on AWS
Over the past 15 years, cloud-managed databases have evolved to allow you to take advantage of the cloud’s agility, scalability, and flexibility in architecture. Open source databases have accelerated this transformation as an essential part of a cost-effective, modern data strategy. Amazon’s journey with managed open source databases started in 2009 with the launch of […]
Encrypt an unencrypted Amazon Aurora MySQL cluster with minimal downtime using AWS DMS homogeneous data migrations
In this post, we show how you can encrypt an Amazon Aurora MySQL-Compatible Edition database from an existing unencrypted cluster using AWS Database Migration Service (AWS DMS) with minimal downtime. Amazon Aurora encrypted DB clusters provide an additional layer of data protection by securing your data from unauthorized access to the underlying storage. You can […]