Howdy, Stranger!

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


SYS or OVH - for mysql heavy usage
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 Member
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 Member, Patron Provider

    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.