1) Regular SD cards were never designed to be OS volumes, of course they're going to fail when used for that. Buy better SD cards, like ones with high write endurance.
2) RPi 4 does not need to boot off SD card. It can boot from any USB drive of your choosing, or over Ethernet.
I don't know if I've mentioned this on HN before, but my brother works for an oil services company, and they have deployed hundreds of RPis across sea and land rigs, mostly in the middle east. The land rigs are mobile, and as you can imagine, the middle of a desert in Oman is a pretty hostile environment. Despite this, they haven't had even a single failure across all these devices in over 5 years. Not one - and they boot from SD cards!
The stuff running on the RPis isn't very write heavy, and the cases are only lightly ruggedised (I forget the brand, but they are consumer gear, nothing fancy), and I forget what brand the SD cards are - but this is why I roll my eyes every time this is mentioned on HN (which is every time RPi is mentioned on HN). I really wonder what fraction of people repeating this reliability claim even have an RPi.
Younger generations have not had these issues for me. While I assigned that to my experience, usually reducing logging to sd card, booting off of USB and fewer unexpected power losses, it may simply not be an issue any more.
Though in my experience as a technician installing 2.5" consumer grade / entry level Kingston/ADATA SSD to several clients, this is what generally will kill NAND flash devices, it's not an exclusive phenomenon to uSD cards.
I have a few running RPi's on premises for years. Ranging from v1 to now v4, certainly the only uSD 3 failures I have had has been with the early models and reliability went up with...... just a No-break power source. Just that.
It seems a lot of people think a sudden power loss it's what's only dangerous for electronics and NAND flash devices but for devices that are highly sensitive to browning down power rails (specially those first v1 raspis) any unstable power source is a rave party from which is hard to get out unscathed.
I think that reduced the number of writes to the sd card allot.
I've always wondered if any organizations have tried to make something like a Sandcrawler.
I tried to hire some to start such a project but I must have been looking in Alderaan places ...
Of course, it's not just 1 piece of equipment that moves around it's people, tech etc - some land rigs are almost semi-nomadic, with the whole camp moving around.
[0] https://www.nov.com/products/mobile-rigs
[1] https://www.nov.com/-/media/nov/files/products/rig/rig-equip...
I haven't seen reports of these particular cards being counterfeited yet, but still... you probably shouldn't buy them from Amazon...
[1] https://www.westerndigital.com/products/commercial-removable...
[2] https://shop.westerndigital.com/products/memory-cards/sandis...
I believe over-provisioning space to delay wear if you write much can also help (in conjunction with wear leveling).
[1] See this thread:
https://www.reddit.com/r/raspberry_pi/comments/ex7dvo/quick_...