Posted On: May 30, 2023
Amazon Relational Database Service (Amazon RDS) for MySQL now supports Amazon RDS Optimized Reads for up to 50% faster query processing compared to previous generation instances on Multi-AZ deployment option with two readable standby database instances. Optimized Read-enabled instances achieve faster query processing by placing temporary tables generated by MySQL on the local NVMe-based SSD block-level storage that’s physically connected to the host server. Complex queries that utilize temporary tables, such as queries involving sorts, hash aggregations, high-load joins, and Common Table Expressions (CTEs) can now execute up to 50% faster with Optimized Reads on RDS for MySQL.
Amazon RDS Optimized Reads is available by default on RDS for MySQL versions 8.0.28 and higher on Multi-AZ deployments with two readable standby instances. For a full list of the Amazon RDS Multi-AZ with two readable standbys regional availability and supported engine versions, refer the Amazon RDS User Guide.
Learn more about Amazon RDS Multi-AZ deployments in the Amazon RDS User Guide and in the AWS News Blog. Create or update a fully managed Amazon RDS Multi-AZ database with two readable standby instances in the Amazon RDS Management Console.