AMD Configuration

Does anyone have experience running S2 on AMD hardware?

I guess S2 is the internal name for SingleStore? :joy: We are running on AMD :thinking:

Yes, we call SingleStore S2 for short.

SingleStore does run well on AMD hardware that’s Intel x64 instruction-set compatible. For best performance it needs to have AVX2 SIMD support, which the modern AMD Intel-compatible chips all do.

Some newer AMD chips have a NUMA-like architecture and we recently made some changes to our installation capabilities, SingleStore toolbox, to take advantage of this. See SingleStore Toolbox Release Notes · SingleStore Documentation

We added the --bind-to-l3 flag to the sdb-admin optimize command, that passes --bind-to-l3 to underlying memsqlctl optimize commands. So if you’re using a modern, many-core AMD chip, use the --bind-to-l3 flag on sdb-admin when you install SingleStore with toolbox.

The updates primarily focus on enabling the SingleStore toolbox to perform process bindings to CPU Complex (CCX) units on AMD hardware, akin to how it handles NUMA nodes on Intel systems. This binding ensures that clusters operate efficiently without performance degradation typically observed when proper NUMA-like configuration is missing.