Which raid is preferable for high mysql performance?

A

Alexey2015-01-21 21:59:32

linux

Alexey, 2015-01-21 21:59:32

Good day!
The question is - there are 4 SAS disks in the hardware raid, I would like to understand what level is currently selected?
For a high load on the database (mysql), they advised RAID 10, how correct is this?
Thanks in advance for the clarifications!

Reply

Answer the question

In order to leave comments, you need to log in

6 answer(s)

V

Vladimir, 2015-01-21
@MechanID

The current settings of the raid controller are looked by the utility depending on the manufacturer of the raid controller
MegaCLI, arcconf, TW cli and so on.
In the presence of 4 hards, raid 10 is the most optimal solution. don't forget to configure monitoring of the state of the raid array.

K

Konstantin, 2015-01-21
@TheSpbra1n

Everything is subjective, there are a lot of moments, for example - what size of the database, how much RAM, how many read / write operations. But in general, yes, if you need fast disks, then raid0 will be fast, but without fault tolerance, raid10 is the same 0, only with fault tolerance, plus it is worth considering who controls the raid, if the raid is soft, then the load on the percentage will go

V

Vlad Zhivotnev, 2015-01-22
@inkvizitor68sl

Just keep in mind that with any raid, except for the first, the probability of losing data due to a logical error in the controller or mdadm is quite high (well, that is, it is different from zero).
And so - raid10. But in my practice (thousands of servers), dozens flew often - at least one car per month, but they buried it. There, a bug with iron was also involved, but this did not make it any easier - at the same time, a few survived.

P

Puma Thailand, 2015-01-22
@opium

And what was the point of taking sas disks for high performance? When the same ssd for the same price or less will give more performance.
Raid0 only if losing all data at once is completely painless for you

S

Sergey Petrikov, 2015-01-22
@RicoX

This is the right option in terms of reliability-speed, add a cache on an SSD to the array and you will immediately get another 20 percent more performance.

V

Victor Taran, 2016-03-03
@shambler81

ssd plus raid 1 because it's mostly select for sites.
10 is cool, of course, but very expensive if the same 4 screws are given for reading, there will be more profit.
5 and so on, a lot of load on the soft part of the raid (if you don’t have a good controller)
, so in fact 1 and ssd