cancel
Showing results for 
Search instead for 
Did you mean: 

Need Server and database recommendation

SOLVED
Highlighted

Need Server and database recommendation

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Need Server and database recommendation

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. 

View solution in original post

4 REPLIES 4
Highlighted

Re: Need Server and database recommendation

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

Highlighted

Re: Need Server and database recommendation

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 Smiley Very Happy

Highlighted

Re: Need Server and database recommendation

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. 

View solution in original post

Highlighted

Re: Need Server and database recommendation

Thanks James!  Have a restful weekend.