Category: RDS for MySQL

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 […]

May 2023: This post was reviewed and updated for accuracy. 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 […]

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, […]

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 […]

December, 2022: Amazon Relational Database Service (Amazon RDS) now supports Amazon RDS Blue/Green Deployments to help you with safer, simpler, and faster updates to your Amazon Aurora and Amazon RDS databases. Blue/Green Deployments create a fully managed staging environment that allows you to deploy and test production changes, keeping your current production database safe. Learn […]

Updated 04/2022 to reflect product changes. 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 […]

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 […]

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 […]

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 […]

This blog post was last reviewed or updated January, 2023. In the previous blog post of this series, I discuss MySQL parameters used to optimize replication in Amazon Relational Database Service (Amazon RDS) for MySQL and best practices related to them. In today’s post, I discuss the most important and commonly used MySQL parameters for […]