Database Server Workload
The following workload tests have been around for so long that they're considered industry standards. The way we present the average response times are not. The first line graph shows workload performance with scaling queue depth. The second chart shows average response time correlated to the number of IOPS. In many of these tests, users target a maximum amount of latency. An application may require less than 10 milliseconds of latency, so the system administrator will aim for workloads that stay under the target. The amount of IOPS tells the administrator how much load the system can handle while staying within the response time range.
In order to make the graphs presentable, we had to use a different scale for the response time. The first three sections show the response time to 100ms. The next line shows the scaling to 1000ms, a 10x increase from one line to the next. Without the large scale increase, the FreeNAS Mini barely lifts off of the baseline.
The fact that we had to adjust the scale speaks volumes about the FreeNAS Mini. The system is in another product category with this type of workload and pushed to maximum load.
How much is the case itself? That I might be interested in, but...
The case is a Supermicro CSE-721TQ-250B which is $160.
A great motherboard would be the X10SDV-F which is $850 (dual GBe Intel nics, Xeon-D 8 core, check Anandtech they did a great review on it). Stronger CPU than the one in this review.
Then for $1017 you can get the X10SDV-TLN4F which includes built in 2x Intel 10GBe as well as 2x Intel GBe.
or for $?? (probably more) the X10SDV-8C-TLN4F which is the same as above but has Hyperthreading (16 threads).
The price still seems kinda high, I'd like to see "real world use" as opposed to benchmarks but that's so difficult to actually do.
If the price seems high then it's not for you, but as said this is not a consumer product for home users. You want a basic, easy solution then investigate some of the WDMYCLOUD options instead. I bought a 4TB model and added a 4TB WD Elements as backup but that's for video storage and not as reliable nor as fast as a business class solution.
$2000 with drives for business is really not bad considering the cost to run a business, loss of data costs, and the fact you can probably write of some as a business expense.
On a side note, some guy vehemently argued against using ECC memory with ZFS. He admitted it was really stupid to *not* using ECC memory but he just couldn't admit he was wrong so he kept doubling down on dumb. His major argument? I was a few dollars off on the price of ECC memory.
You have to love the Internet.