AWS Database Blog

Category: RDS for MySQL

Use the TempTable storage engine on Amazon RDS for MySQL and Amazon Aurora MySQL

MySQL 8.0 has introduced TempTable as the new, default internal temporary table storage engine to speed up query processing. The MySQL query optimizer creates temporary tables internally to store intermediate datasets while processing complex queries. In AWS, you can deploy MySQL 8.0 using Amazon Relational Database Service (Amazon RDS) for MySQL, a managed service for […]

Read More

Readable standby instances in Amazon RDS Multi-AZ deployments: A new high availability option

Amazon RDS Multi-AZ deployments are ideal for production database workloads. When you have Multi-AZ deployment, Amazon Relational Database Service (Amazon RDS) provisions one primary and one standby DB instance with synchronous physical replication of Amazon Elastic Block Store (Amazon EBS) storage for high availability and failover without data loss. However, you can’t read from the […]

Read More

Monitor errors in Amazon Aurora MySQL and Amazon RDS for MySQL using Amazon CloudWatch and send notifications using Amazon SNS

Monitoring databases is essential for any DBA, from dev-test databases to mission-critical databases. You want to capture system and user-defined events for monitoring and troubleshooting problems related to your database instance. MySQL records these events in error logs. In this post, we show you how to monitor different events, such as deadlocks, access denied errors, […]

Read More

Upgrade Amazon RDS for MySQL or MariaDB database schemas with minimal downtime

Modifying the schema of an SQL database can be time-consuming, resource-intensive, and error-prone, and often requires long application maintenance windows that negatively affect the end-user experience. Amazon Relational Database Service (Amazon RDS) for MySQL or MariaDB allows you to upgrade your schema while your application is still running, with minimal or zero downtime. In this post, […]

Read More
The performance increase is one of the crucial reasons to stay current with the latest releases.

Upgrading from Amazon RDS for MySQL version 5.5

Amazon Relational Database Service (Amazon RDS) for MySQL 5.5 major version is reaching end of life, and it’s recommended to upgrade to newer supported major versions. Amazon Relational Database Service (Amazon RDS) provides newer versions of databases so you can keep your DB instances up to date. These versions include bug fixes, security enhancements, and […]

Read More
The following diagram illustrates this architecture.

Best practices for using a MySQL read replica to upgrade an Amazon RDS for MySQL database

The following common technique is used to perform maintenance on a MySQL database: Create a read replica of the database. Perform maintenance on the read replica. Promote the read replica to replace the original database. This post walks you through some best practices for performing a major version upgrade on an Amazon Relational Database Service […]

Read More

Recap of Amazon RDS and Aurora features launched in 2019

Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity. At the same time, it automates time-consuming administration tasks such as hardware provisioning, database setup, patching, and backups. It frees you to focus on your applications so you […]

Read More

Running sysbench on RDS MySQL, RDS MariaDB, and Amazon Aurora MySQL via SSL/TLS

sysbench is an ideal tool for running synthetic benchmarking on MySQL compatible databases. The Amazon Aurora Performance Assessment Technical Guide helps you assess the performance of Amazon Aurora MySQL by using sysbench. However, if you want to run sysbench on MySQL-compatible databases running on RDS or Aurora via SSL/TLS, you also need to consider some […]

Read More

Migrating mission-critical SaaS production workloads to Aurora MySQL from RDS Classic

Sumo Logic started around the same time as the AWS stack was starting to mature. The company initially chose infrastructure that was tried and tested, but also cutting-edge at the time, namely Amazon RDS for MySQL instances. However, over time, that choice started to cost us a significant number of developer hours. Developers spent time […]

Read More

How to determine whether Kaigen (Japan era name transition) affects your MySQL compatible engines running on RDS

If you have software or systems that support Japanese customers, and if your software or systems need to display a Japan era name, you may need to make changes to display the new name. The new Japan era name comes into effect on May 1, 2019, when the current Japanese Emperor abdicates. In this blog […]

Read More