SD cards max write and MySQL

[NiclasG]

I have been thinking of using the Raspberry PI as a kind of message broker. I was thinking of installing MySQL to store and handle all messages. What I am afraid of that an even stream of messages (maybe 1 to 100 every minute) that is stored in MySQL DB, the SD card will reach the max amount of write operations pretty quick. What I have read the max write operations is about 100 000. So the life time of the SD card will then be pretty short. Have someone experience of similar situations or could give recommendations on how to avoid reaching max amount of writes on the SD card?

[hojnikb]

First of all SD cards dont have 100k write life (maybe there are some very expensive SLC ones), but more like 10k or even less, when newer generation memory is used (for example 2xnm TLC flash is only good for like 750 rewrites).

But not all is bad though. Since most if not all of the sdcards use some kind of wear leveling, that means all cells will be used up evenly, no matter where you physically write stuff (for example on the begging of the partrition).

So to increase the life of sd card, buy as big card as you can (so more data can be writen on it before it dies) and possibly buy a fast card, since these tend to use better MLC flash.
Also use ext2 fs which also writes less to card.

[jors]

This document was intended for SSD's but could also be useful for SD's:

http://wiki.debian.org/SSDoptimization

Cheers.