So I have a DBMS, MySQL, installed on an EC2 c4.compute instance. The problem is that it can only handle up to 8 RPS, before reaching 100% CPU, and then having problems.
For a project, I need at least 20+ RPS. I think the storage (SSD) is not the problem, but the CPU just isn't powerful enough to handle that many requests. So logically, the solution would be to use more than one CPU/instance to handle the load. (I do not want to use a more powerful instance)
Is there a way to accomplish this with EC2+MySQL/MariaDB in a way such that queries from a PHP application do not experience noticeable slowdowns?