Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


New on LowEndTalk? Please Register and read our Community Rules.

All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.

SYS or OVH - for mysql heavy usage

xrzxrz Barred
edited March 2016 in Providers

SYS
E5-SAT-2
Intel Xeon E5 1650 6 c / 12 t 3.1 GHz+
64 GB ram
2x 3 To SATA Soft

OVH
SP-32
Intel Xeon E3 E3-1231v3 4/8t 3,4 / 3,8 GHz
32 GB RAM DDR3 ECC 1600 MHz
2 x2TB SOFT

which one is better ? for mysql ...

Comments

  • Very similar to me. But I'd recommend using a SSD if under heavy usage.

  • There's a SP-32 config with 2x480GB SSD, about $15 more. Might be worth it.

  • bacloudbacloud Host Rep, Veteran

    For mysql you need soemthing like 2 x SSD RAID1 or better 4 x SSD RAID10

  • Personally I would go with more RAM, the more you can cache the better! Make sure you optimise your config for the available RAM, caching and innodb buffer.

    Thanked by 1exception0x876
  • exception0x876exception0x876 Member, Host Rep, LIR

    Most MySQL workloads are read heavy. Increasing your RAM will help you even better than going SSD. So I vote E5-SAT-2

  • SP-32 as ECC

  • Estimated Table size and Read/write mix is important to know.

    If < 25G, go with the E3 and save some money.

    If extremely write-intensive , choice of HWRAID controller (presence of Battery backed cache on it) matters.

    Cache everything at every layer.

Sign In or Register to comment.