TIP: Click on subject to list as thread! ANSI
echo: rberrypi
to: DAVE LIQUORICE
from: DRUCK
date: 2017-03-01 23:27:00
subject: Re: High traffic in MySQL

On 01/03/2017 21:54, Dave Liquorice wrote:
> On Wed, 1 Mar 2017 20:51:59 +0000, druck wrote:
>
>> Yes, anything that does a lot of writing to an SD card will kill it
>> sooner or later. If you are using a database, I recommend getting a
>> small SSD (32/64/128GB) plus an SATA to USB adaptor, and put the OS and
>> database on that. It will then last practically forever.
>
> Er, isn't a SSD just a scaled up SD card or is the underlying storage
> technology radicaly different?

No, and SSD has a far more sophisticated controller and wear levelling
strategy designed for use as a computer storage device. An SD card is
designed to store large photos and videos from cameras, not 24/7 use.

> I'd have the OS and programs on an SD card but the database on
> something else. So when the media with the database falls over it
> doesn't take the OS and programs with it.

Again no, if you use the SD for the OS, it will still wear out due to
continually writing from logging. Only use the SD card to boot from and
put everything else the more reliable medium which wont fall over. There
are numerous easy to follow guides on how to do this on Raspberry Pi
related websites.

---druck


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

--- SoupGate-Win32 v1.05
* Origin: Agency HUB, Dunedin - New Zealand | FidoUsenet Gateway (3:770/3)

SOURCE: echomail via QWK@docsplace.org

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.