Never underestimate the power of a properly configured server with 1TB of RAM running MySQL off of SSD.
In my experience, people used to cloud services misjudge the power of correctly tuned modern hardware by two-three orders of magnitude.
Giving a general answer to your question is hard in the absence of further information.