Which solution addresses this performance issue?
Change the storage type to Provisioned IOPS SSD.
Change the DB instance to a memory optimized instance class.
Change the DB instance to a burstable performance instance class.
Enable Multi-AZ RDS read replicas with MySQL native asynchronous replication.
Explanations:
Changing the storage type to Provisioned IOPS SSD increases I/O performance, providing consistent and faster I/O operations, which is ideal for handling millions of updates and addressing the performance issue.
While a memory-optimized instance can improve performance for read-heavy workloads, it doesn’t directly address the issue of slow insert operations caused by inadequate storage performance.
Burstable performance instances are designed for workloads with variable CPU usage but won’t enhance the underlying storage performance, which is the root cause of the slow insert operations.
Enabling Multi-AZ RDS read replicas focuses on improving read performance and availability but does not resolve the underlying storage performance issues affecting insert operations.
As far as I’m aware, the answer is:
Change the storage type to Provisioned IOPS SSD.