I have a web application which currently relies on MySQL. I have it running on AWS at the moment (using a stock RDS) and it can tolerate about 500 requests a second (with a 50/50 mix of INSERTS and SELECTS) and under 1 second response time. However, I am concerned if this number increases to 1000 for example, the RDS will simply not be able to keep up and response times will increase. To reduce this, I've created a "Read Replica" for performing reads to reduce the load on the "Master" server.
I was wondering however, if it was worth me setting up my own MySQL Cluster instead. Would this give me true scaling "out"? Could I simply fire up more nodes when my MySQL cluster was getting busy etc etc? Would it remove the need for "Read Replicas"? Does anyone have any experience with this on AWS?
Thanks in advance for any advice!