Need Server and database recommendation

[Sheba]

Using Magento 2.3.5p-1 for a multi seller / buyer site. 

Using MySQL for a database which will grow to 1.4 Million Rows. 

::  Any thoughts on MongoDB?

Anticipating 1 million hits per day.  

1.  What database is best to handle these many records?

2.  What server is best - VPS? How much memory, etc.?

Thanks for your attention.

[JLHC]

It depends on how the site is built, what theme and extensions you use, etc. 

If your site isn't large from the start, you may want to go with something scalable so you can scale up as your site grows. 

You should also take a look at Magento 2's Hardware Recommendations here:-

https://devdocs.magento.com/guides/v2.3/performance-best-practices/hardware.html

[Sheba]

Hi James,

Thanks for your prompt response.  I read the info on the link you sent.  Can I use Varnish and Redis? Using WebKul Marketplace with basic extensions - currency converter, social login.

Given you are Magento Master, what would server you for an Amazon type website?

Thanks again 

[JLHC · Accepted solution]

Yes, you should definitely use Redis and a Full Page Cache like Varnish or LiteMage Cache. 

How much CPU you need is also detailed in the link above which has an equation for you but at the end of the day you may need more or less depending on real life usage which you will only know once the site goes live. 

You should definitely go with a scalable Cloud provider so you can easily scale up and scale out as your store and traffic grows. 

[Sheba]

Thanks James!  Have a restful weekend.