I am looking to set up a dedicated instance / cloud server that will only run a MySQL server. The MySQL version will be 5.7.26 and the INNODB storage engine. The server could end up having 50 different databases / schemas for different websites. However, most of the time, they will be very simple with 10 to 20 tables and should not be used much, especially at the beginning.
I would prefer that it be slightly too powerful to leave a bit of room, but honestly, I do not know the kind of resources needed for the use case described above.
What would be the ideal specification for such a machine in terms of the number of vCPUs, GB of RAM and storage?