MySQL on SSD. What is the user experience?

Question

MySQL

On file servers, I've been running SSDs for hot cache for quite some time. This week I decided to move mysql to an SSD.
I lived for 2 whole days .. It's good that I decided to make backups every hour.
Maybe there is someone who has been using it for a long time?
At the moment, to replace the solution with an SSD and even more gain in performance, the idea flashes of putting mysql in general in ramfs and dumping it on disks once an hour .. But this is probably a very stupid idea.

Answer 1

I put 2x120 GB in RAID 1, mounted the root to the folder with the database files.
The load has dropped from 95-97% to 2-4%, they have been working for a year, everything is OK.
tmpfs (now it is relevant) is quite dangerous, but it depends on what data you have and how critical the data loss is over a certain period of time.
By the way, I do a full dump every 15 minutes on the second RAID 1 from a pair of HDDs, you never know)

Answer 2

Until you wrote, I did not even think about how unsteady the world is unreliable, probably DigitalOcean!
I rushed to make a backup on S3.

Answer 3

1. In principle, SSDs are considered consumables, especially for a database
2. Server SSDs will be better, but they cost the same as a good raid array.
3. Well, depending on what bases to drive on them.