Mixed use ZFS ssd mirror

I really want to move my ubuntu homeserver to more manageable and set-and-forget hardware.

I can get a pretty good deal on two 8tb kingston DC1500M, which I want to mirror as my main data drives, with some mechanicals as archive-drives. I might be able to get a P11C-M/4L, to make use of my basic g5400 ecc support and IPMI. I will use m.2 to u.2 converters.

Most of my application (the usual plex, jelly, hass etc) run on podman with minimal VM-usage. I use VM’s just to experiment (usually they are not active). Configuration is done via ansible, with the OS set on a 250gb mlc drive (I can just rip it out and reset with ansible).

I’m getting mixed signals if I zould mirror with ZFS or with mdadm and ext4. ZFS adds overhead and wear and tear on SSD’s, especially with some DB’s (so seems the consensus). I run some MariaDB containers (Nextcloud) and Postgres (Synapse), Clickhouse (Plausible) and Prometheus for monitoring. But this is just home-use, so I don’t really know if this applies at all.

do you have anything else on this that will be using ZFS? if you only are doing this 1 mirror and it will be local storage for this 1 machine and the things running on it, just use mdadm.