Server help!

[MrRifu]

Hi! I'm new in the forum and I need some help.

 

I have a Dell PowerEdge R540 with the following hardware:

• Xeon Silver 4110
• 32GB RAM
• 1 TB SSD with Ubuntu Server 18.
• RAID 0 (via BIOS): 2 TB HDD + 2 TB HDD. They are the same model.
• 1 HDD 5 TB.
• 4 HDDs 8 TB (Seagate Iron Wolf NAS) brand new.

The server is used primarily to run big queries in PostgreSQL with postGIS and to store data. Also, in the future I want to take advantage of the number CPU cores, but don't know how yet.

 

The big question is:

How can I manage the HDDs installed on it? RAID?

The idea is to have plenty of space and the possibility to recover data if a HDD "breaks"

 

A friend told me that I should do RAID 10 with the 4 HDDs (16TB - 16TB). But I want opinions :D

 

Sorry for my english, I'm Spanish-speaking.

 

Thanks!

[Windows7ge]

Your most popular options would be RAID10, RAID5, or RAID6.

• RAID10
  • You get the performance of RAID0 across 1/2 the drives.
  • You can lose a drive from any pair and retain your data.
  • Higher IOPS over RAID5/6. Good for virtual machines.
  • You lose 50% of your usable storage.
• RAID5
  • You get increased read/write speeds but with the penalty of 1 parity bit
  • You can lose any one disk and retain your data.
  • You lose 1 disk worth of usable storage
• RAID6
  • You get increased read/write speeds but with the penalty of 2 parity bits
  • You can lose any 2 disk and retain all your data.
  • You lose 2 disks worth of usable storage.

There's also RAID50, RAID60, RAID51, RAID61, which are just mixes of what's above.

[Jarsky]

Running it as a SQL server, probably go RAID10 for the performance. 

RAID5 is still fast but its not a good idea to have single disk parity if this is important data. RAID6 with dual parity calculations adds a lot of overhead.  

[BloodKnight7]

Hola Mr. Rifu!

 

Para las bases de datos algunos puntos basicos son los siguientes:

 

-El sistema operativo de tu servidor configuralo en un RAID 1, estos pueden ser discos mecanicos SAS o SATA.

-Separa los Logs en un arreglo RAID 1, preferentemente puedes usar SSDs o SAS de 10k o 15k.

-Para los datos de tu BD (discos SAS o SSD son recomendados):

• Usa RAID 10  para bases de datos que requieran alto I/O para escritura de datos. Solo toma en cuenta que el 50% de la capacidad se la lleva el mirroring. En resumen, RAID 10 es el mejor RAID para escribir pero su capacidad en la lectura de los datos es menor a RAID 5/6.
• Usa RAID 5 (50) / RAID 6 (60) son para bases de datos que requieran alta capacidad de lectura (consultas). RAID 5/6 tiene peor velocidad de escritura de datos pero mucha mejor velocidad de lectura y son ampliamente usados en mineria de datos o en bases de datos solo lectura, cubos de informacion, etc.. 

Recuerda siempre actualizar el bios, idrac y el firmware de tu hardware Dell, hay varias maneras de lograr esto. https://www.dell.com/support/article/en-us/sln300662/updating-firmware-and-drivers-on-dell-emc-poweredge-servers?lang=en

 

Para tomar ventaja de los multiples nucleos de tu procesador en PostgreSQL debes primero que nada estar preferentemente en la versión 10, asi entonces puedes usar las operaciones denominadas "Parallel queries" Parallel Scan / Parallel Join / Parallel Aggregates (max_parallel_workers_per_gather) siendo estas las que te permitirán ejecutar multiples tareas haciendo uso de todos los threads disponibles en los Xeon.

 

 

 

 

 

 

[TBKemp]

I have a ASRock X570 Creator, Ryzen 3900X cooled w/ a CM 360, RX 5700 XT, 1T Sabrent Q NVMe M.2 2280 SSD, G.SKILL Trident Z Royal Series 128K DDR4 3600RAM, All in a Corsair Obsidian 500D. I would like to add 5 2.5" SSD Raid plus one more NVMe M.2 SSD Possilbely going Raid 0 with the one I already have. What SSDs do you think I get for my Raid? I am looking to use it as a NAS.