I am planning to use rpi with sd card as mysql server.
I am going to give these raspberries to customers.
I am little bit worried about SD card endurance.
I did a research for three days by searching articles with this topic.
Now I am using archlinux-arm:
1) f2fs formatted partitions
2) All logs are in journald, which uses RAM only
3) apps like nginx, uwsgi and redis are using RAM only
4) mariadb server is the only thing which writes to the SD card
I think writes will be like every minute or even less for 12 hours a day...
Database won't use more than 200MB.
I don't have enough money to buy 4GB SLC, so I have to stay with MLC.
Also I tried combination with SLC usb and so on, but I don't want to my raspberry look like transformer.
I have found this SD card: https://www.transcend-info.com/Embedded/Products/No-739
That looks like holy grail for me.
30k write cycles should be enough for two years?
What do you think?
And can I somehow tweak mysql to lower writes?
Or are there some other things that should I consider?