Recently I have a website which has a 4GB MySql database and 30,000 posts on WordPress. The average response time is 1,5 seconds without caching. I had 2 requests per second on a 4CPU / 8GB Machine and when I moved to a 32GB & 8CPU machine, nothing changed. Still, 2 requests per second and most of the RAM is used for caching. So I thought instead of having one bigger machine, setting up 4 smaller machines is better for concurrency. Is this correct? Anybody can suggest a better solution? I use Apache, PHP8 (.2), and MySql on the same server.
Asked
Active
Viewed 38 times
