The MSSQL developer experience is ok, until you want to pipe the backup over ssh. Then you understand that the Linux support is a joke, with no stdout(https://linux.die.net/man/3/stdout) support.
Yes CX5 can offload more. I believe CX4 has similar offloading capabilities as CX3, except that it supports 100G.
Another note: In my experience, RoCE works much better on CX4+ generation. CX3 is best with Infiniband. I think some firmwares on the CX3 generation, has a messed up config for RoCE. But running Infiniband is not a complex task, is way easier than people think, like 10x easier and faster to setup than Ethernet.
Maybe you have priced it wrong? I just checked Ebay, a 16GB 12800 Registered ECC module goes for 40-50USD ea. That is crazy! Last year they were like 5 USD each.
I disagree, I play a lot around with enterprise stuff. Its insane that I need to buy enterprise grade hardware that costs 1000x more for lab/experimentation/learning. My only alternative is to wait a few years, and get it from Ebay.
I also believe that a strong reason that Optane pdimm's failed, was that it was only available on enterprise servers so hackers didn't get a chance to play with it and build software that took advantage of this special hardware.
Just look at how specialized Infiniband is, even though its awesome and has some great use cases. If it was a commodity tech, there would be 100x times more applications/software that took advantage of it.
But that is his point.
If you cannot find the session id in redis, you login again.
If your Redis server crash, you start a new one and everyone just login again. No data is lost.
When I look at the oil & gas sector, I remember MS-DOS + Wordperfect was the beginning. Then Windows 3.1 + Microsoft Office took over, and since that, its been Microsoft, Azure, and SAP.
They refuse Google Cloud, AWS, and many still believe open-source is cancer. They are Microsofts best customers. They prefer consultants over hiring software developers, and the consultants just to what they're told and never question the status quo.
Whenever I spending time at these companies, my head is filled with dinosaurs.
Where I live we have something called The ONS event/Exhibition, where the oil sector gathers to promote themself. 2 years ago AWS had a big stand there, but it was mostly empty. This year, AWS doesn't participate at all.
Every time I give Photoshop a chance I give completely up, the thing doesn't even start on neither Fedora or Ubuntu and I have no interest in configuring Wine for this. GIMP is the least painful way to get the job done. I have been using it for over 20 years, and it has been a pain-free experience. That GIMP is bad is just as wrong as the people who say Java is bad.
But you know what's even worse, people that use Illustrator to create SVG's for the web. Inkscape creates proper readable SVG's at 5KB, compared to 50MB SVG's I get from Illustrator experts.
It is a bit different, Mellanox with iSCSI/iSER over IB/RoCE is much less complex than iSCSI over TCP. RoCE runs over UDP, but requires switches with PFC, and ECN. Chelsio plays nice with any switch. Mellanox has much better offloading of NVMe-oF, where the network card can directly communicate with the NVMe device over pci-express so it can completely bypass system ram and host cpu. In fact, Linux will know nothing about the transfers to and from the NVMe device.
To get accelerated iSCSI, you need to install Chelsio or Mellanox drivers. While both work out of the box with the inbox drivers, they have special drivers that you have to download and install to unlock the extra performance. I think Chelsio has everything included in FreeBSD, so there the inbox drivers already come with top performance unlocked.
ZFS supports self healing, you do not have scrub, it will be corrected during a bad read as long you have a copy. Metadata has 2 copies by default for additional safety for a single disk.
Using a proper NIC (Chelsio) with their iSCSI accelerator will boost your iSCSI performance significantly.
Another alternative is Mellanox with RDMA. You need CX4+ for optimal performance over TCP/IP, while the cheap CX3 is excellent with IPoIB.
If you have a lot of packet drops and retransmissions, another option for boosting iSCSI performance is getting a network switch with a lot of memory for packet buffering. This helps with incast congestion. There are special switches with gigabytes of memory built for this.
NVMe-oF is the best protocol with least overhead for network drives, with a proper setup you lose only 10-20% latency compared to local disk even with Intel Optane. Throughput should be almost similar.
A 42U rack filled with 1u servers with 8 drives each, will have 84PB of data. It feels like it was a few month ago where you could buy a rack with 1PB of storage, and that was awesome. Not anymore.
I would not worry about running a distro. Most things are similar, there are some minor differences between the GNU applications and the FreeBSD alternatives. But for most people there is nothing to worry about.
Most applications runs fine on BSD. Bind, PowerDNS, Java Applications, PostgreSQL, Python, rsync and many more. Getting PyTorch to work with Nvidia and Cuda is most likely another story.
My main culprit with FreeBSD is that upgrading the kernel is not a simple dnf update command. But its still easier than upgrading RHEL from 9 to 10.
I just started with FreeCAD this weekend, and in 3 hours I managed to create a simple pci bracket that I could 3dprint. I just followed some YouTube tutorials. When I learned 3D Studio Max 25 years ago, I struggled a lot more.
Gitea is one of the easiest projects to to self-host. And to do regular upgrades, you only need to update one file. It has been a joy to self-host for many years now.
You are correct that writes are not guaranteed to be atomic.
PostgreSQL has a feature to handle torn pages: full_page_writes = on, which is enabled by default. This means you do double write.
For RocksDB I believe torn pages are not a problem as SST files are immutable. But correct me if I am wrong.