When installing SingleStore, is there a specific CPU that is the best to use for max performance? Intel Extreme Edition? Xeon 2288G’s? Ryzen? Threadripper? It’s not too clear what CPU seems to do best with SingleStore, though it appears as if it’s probably meant to be used with Intel Platinum or Gold.
Also, can you run SingleStore on an IBM power processor? I’m assuming no since it doesn’t have the AVX2 or SSE4.2 instruction set, though IBM does support Linux.
Is bare metal an option with SingleStore? It seems like it’s meant to be run inside a container of some sort, but would running it on bare metal be possible and practical?
Finally, is it possible to run SingleStore on persistent memory and have it utilize ram at the same time?
You can use SingleStore on any type of Intel-compatible 64-bit processor. We do recommend that the chip supports AVX2 SIMD instructions, which most built in the last 4 years do.
The best processors to run on (to get the best performance) are typically the higher-end Intel Xeon server chips. Sure, you can run SingleStore in bare metal or in the cloud.
You can run SingleStore on persistent memory. See some thoughts here about that:
Sorry for reviving an old topic. It has been several years since op posted the question. Anything changed in the past few years? Considering threadripper CPUs usually have much high clock frequency than Xeon CPUs with similar core counts, is threadripper a better choice for performance consideration?
Newer CPUs released from AMD in the past several years also support AVX2 SIMD. Is there still any benefits to choose Xeon instead of AMD Threadrippers?
Both modern Intel and AMD chips can run SingleStore really well. We don’t have anything to add here really, except that if you do use many-core AMD CPUs, there’s a different way to set up NUMA-like configuration than for Intel CPUs.