Posted On: Aug 31, 2023

Amazon Relational Database Service (Amazon RDS) Optimized Writes now supports r5 database (DB) instances. With Amazon RDS Optimized Writes you can improve the write throughput for Amazon RDS for MySQL and MariaDB workloads by up to 2x at no additional cost. This is especially useful for write-intensive database workloads, commonly found in applications such as digital payments, financial trading, and online gaming.

In MySQL or MariaDB, you are protected from data loss due to unexpected events, such as a power failure, using a built-in feature called the “doublewrite buffer” that takes up to twice as long, consumes twice as much I/O bandwidth, and reduces the throughput and performance of your database. Amazon RDS Optimized Writes protects you from data loss by writing only once.

Amazon RDS Optimized Writes is available as a default option from RDS for MySQL version 8.0.30 and higher, and RDS for MariaDB version 10.6.10 and higher. For a complete list of all the supported instances, refer Amazon RDS User Guide for MySQL and Amazon RDS User Guide for MariaDB. Optimized Writes is available in all AWS regions including the AWS GovCloud (US-East, US-West) Regions where these instances are supported.

Learn more about Amazon RDS Optimized Writes in the Amazon RDS features page. Create a fully managed Amazon RDS for MySQL or Amazon RDS for MariaDB database with Optimized Writes in the Amazon RDS Management Console.