I currently have a small MySQL RDS instance. It's for a webapp that on average does more reads than writes (maybe 75/25) with daily bursts of heavy writing. I set the database size at 305 GB after hearing about rumors of striping at 300 GB+.
What I'm wondering is what's the best way to improve performance?
1) Upgrade my instance size. 2) Increase allotted IOPS. 3) Or consider another strategy like a read replica.
For metrics, my write IOPS are very low. Typically, 25-50 with bursts of 100 and 200 at different times. Read IOPS never go hire that 50 and are usually much lower. Database CPU usage is usually in the 30-40% range except for bursts.