I am working in the IT and we are replacing most of the hardware after it has run 5 years. The chance that the hardware will die is getting higher and higher after that mark. In the worst case, if CPU/Mainboard die (in my FreeNAS build), it will take me several days to find the defective component, some more days to get a replacement (probably a newer generation) and then I maybe have to reinstall FreeNAS unplanned because the mainboard changed. Therefore I planned to upgrade now, but I know it might seem unnecessary.
There's so much wrong in this post.
I am working in the IT and we are replacing most of the hardware after it has run 5 years.
Yes that is usually what happens in large Enterprise environments but usually only for the laptops etc that they hand out to their employees. And that's because the warranty is usually around that much. Do you really think that these enterprises clean house every 5 years for their server rooms? No they don't. I know of Fortune 500 companies that still have AS400 machines and even mainframes that are chugging along since decades.
The chance that the hardware will die is getting higher and higher after that mark.
The chance that your hardware will die gets higher the minute you purchase it. I have seen brand new hardware fail too. Of course you can RMA the new hardware but that's still a failure. But just because the hardware is X years old does NOT mean it will die on you randomly. All of these devices have built-in warning systems that will alert you about impending failure.
if CPU/Mainboard die (in my FreeNAS build), it will take me several days to find the defective component,
Again, if you create the right kind of monitoring scripts, you wouldn't get to this point. You would have advance warning of impending failure and you would take the appropriate steps to mitigate the problem.
some more days to get a replacement (probably a newer generation)
That depends on your location and the general availability of server grade components in your area, but again see my point about monitoring scripts and advance warning.
and then I maybe have to reinstall FreeNAS unplanned because the mainboard changed.
Search the forums. Many users have changed hardware without a problem without having the need to re-install FreeNAS. Now if the failure is in the boot drive, then yes you have to re-install FreeNAS -- but that takes all of 15 mins and then uploading your previously backed up FreeNAS config.
I had in mind that onboard (RAID) controllers should be avoided and that the LSI (working in IT mode) would be the most common and recommended method to access drives.
That is still correct -- but you can use the on-board SATA ports for your drives -- if your motherboard has enough SATA ports. If not, use an add-on PCIe HBA card. Your original question about using the intel chipset 246 has nothing to do with RAID.
To get the maximum space and still allow one drive to fail. Of course I know I have to have an additional backup of the data.
Don't do this. Especially with drives larger than 1 TB. I had a drive failure last week on my Proxmox server --- and it took 3.5 hours to re-silver a 500 GB drive. This was not on ZFS, but on hardware RAID6. But the point is that larger drives take much much longer and if any other drive fails (of which chances are high because of the heavy loads on the disks during re-silvering process), all your data will be lost.
Oh and by the way I ran SMART on the failed drive just to check -- and it had Power On Hours of 62489 -- That's 7.13 years. Think about that. Even HDDs last more than 5 years. Motherboards, CPUs and RAM are built for much more than that. I have my Proxmox server running 24/7 since the last 6+ years. FreeNAS backup running since 7+ and the new main FreeNAS running since 6-7 months. I also have a Dell desktop that I bought way back in 2009 -- It's running ArchLinux and it's what I use everyday and currently using the same desktop to type up this post.
Bottom line even desktop grade hardware is built to last much more than 5 years.
PS: If you are going to upgrade nonetheless, can you just send me the old hardware since it's just trash for you anyway? I can take it from there ;-)