AWS EC2 + RDS recommendation for Magento 2.2.6 with 1M products

[chathuramk]

Hi all,

I'm developing a huge Magento store with 1 million Products, 7.5k Categories, 4.2k Brands. Can you guys recommend a AWS instance type and RDS instance for handle large number of Products,Categories smoothly.

[Manthan Dave · Accepted solution]

Hi @chathuramk

Based on the above details and based on our experience here  i would suggest you to use below resources :

1. AWS EC2 with Auto Scaling + Amazon Aurora Serverless
2. Automatic scale capacity up or down based on your application's needs.
3. Compute Instance category is recommended.
4. You can have c5.xlarge or any other instance class based on the requirement.

Amazon Aurora Serverless - On-demand, Auto-scaling Relational Database - AWS
https://aws.amazon.com

Hope it helps !

[chathuramk]

Thank you @Manthan Dave for your suggestion. Any idea about high performance theme for us? (Multi Vendor/Market place theme)?? 

[Manthan Dave]

Hi @chathuramk

There are couple of themes available for the same - below i am listing links : 

https://cmsmart.net/magento-themes/multistore-marketplace-magento-2-marketplace-theme-integrated-mul...

https://themeforest.net/item/bicomart-powerful-magento-2-theme-for-marketplace/22610207?s_rank=1

But for better and high performance - i would always suggest to go with custom theme - rather than adopting a readymade theme - because sometimes it requires lot of time to debug the issues.

Hope it helps  !

[chathuramk]

Hi @Manthan Dave I tried with bicomart. after install the theme site was super slow. home page load time was 25s. TTFB was around 20s. (ecs t3.medium and RDS Mysql t2.medium).

[rohan_sharma2]

We are migrating our M1 store to M2.3 and experience the same slow response for all catalog pages within Admin & Frontend.

All other pages are loading pretty fast but its just the catalog pages which are extremely slow and taking approx 15 secs to load.

We have nearly 100K products with flat tables enabled. We deployed our application on EC2 with Mysql RDS (2vCPU + 8GB RAM)

Can you please let me know how did you optimised your store for 1M products?