how should I dimension my server for a shop with 36,000 products (7k configurables)? The products have up to 220 attributes, of which about 60 are displayed on the PDP. 30 attributes are searchable.
We have a maximum of 30 users on the site at the same time.
I am currently struggling with performance problems on a CCX32 cloud server at Hetzner (8 core, 32GB RAM). It runs Varnish, ElasticSearch, database, MySql, Redis and Magento/PHP). The server is actually working at full capacity. (CPU Load 6 +-2; Memory always more then 2.5gb free and 13gb buffer cache) But is that really normal? I have already tried to switch to MariaDb for the query cache, but then the indexing processes no longer ran.
I am slowly getting desperate. How would you size the server for such a shop?
Thanks in advance.