Sizing for Store with 36k Products and 220 Attributes

Hi,
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.

submitted by /u/Dear_Chance2955
[link] [comments]