I am trying to figure out the optimal way to connect an 8 bay drive enclosure to a Dell Optiplex 7040 Micro. The end goal is to have the drives made available to a Proxmox cluster and kubernetes cluster. This is all for learning experience as well as to run services for personal use.

The cluster will be made up of 2x Optiplex 7040 and 2x Optiplex 3040. All have i7-6700t CPUs, the 3040s have 16GB DDR3 and 1TB SATA SSD each, and the 7040s each have 32GB DDR4 and 2TB NVMe drive with an additional empty SATA port on the motherboard. The enclosure is a MediaSonic ProBox with USB3.0 and eSATA interfaces available

I have heard that you shouldn’t use USB to connect to storage so I have been trying to figure out a way to use eSATA even though the Optiplex does not have an eSATA port. I found some SATA to eSATA cables on eBay, would that enable me to connect the enclosure directly to the free SATA port on the Optiplex?

Would this setup work? Is it worth it to sacrifice the additional SATA port on one of the 7040s in order to avoid using USB? I would like to maximize stability and speed.

I have not yet decided how I want to configure the drives but was planning to look into either a ZFS pool or ceph. All drives in the enclosure will be for media storage (movies/tv/music, was planning to keep pictures and documents elsewhere) and passed to LXCs and a kubernetes cluster I plan to run on Proxmox.

Any guidance on the connection setup, storage configuration, or my plans in general would be appreciated. Thanks in advance!