Global fashion e-commerce retailer shortens SQL query time by 30% using Amazon EBS io2 Block Express

This article discusses how a global fashion e-commerce retailer improved the performance of its MySQL database by migrating to Amazon EBS io2 Block Express volumes, resulting in a 30% reduction in SQL query time and a 20% increase in transactions per second.

Specifically, the article covers:

• The retailer's initial use of Amazon EC2 R6i instances and EBS gp3 volumes for its MySQL databases, which proved insufficient for their growing performance needs.
• The benefits of Amazon EBS io2 Block Express volumes, including up to 4,000 MB/s throughput, 256,000 IOPS/volume, 64 TiB storage capacity, and sub-millisecond latency.
• The retailer's migration process, moving existing MySQL databases to io2 Block Express using Elastic Volumes, and deploying new databases directly on io2 Block Express.
• The improved performance and scalability achieved with io2 Block Express, allowing the retailer to provide a smooth shopping experience during peak events.
• The retailer's implementation of a multi-AZ architecture with binary log replication and EBS Snapshots for high availability and disaster recovery.