Hello,
I have a Magento CE 2.3.1 installation whit 7 stores and a total of 24 store views, in each store I got ~60 000 product's, so that's almost ~1.440.000 of different product data. I'm using multi-source inventory whit 8 sources.
Running indexer on schedule. If I import a CSV file whit 8000 rows ( SKU / price / custom_attribute ) it takes 1 days to reindex all the data.
What would be the server requirements to run this site in a decent manner?
Any suggestions or recommendations about what I can do to optimize is deeply appreciated!
------------
Current SV specs:
1 dedicated DB SV (20cores) running MySQL 5.6.43
1 hosting (master) SV running LiteSpeed
-php 7.2.4
-64 ram
-16 cores
1 load balance SV
1 slave SV (an HTML copy of master SV)