We have several rack servers, all with SATA3 Transcend SSD's. Most SSD's are 250GB and they usually have 50% free space most of the time.
When there are unexpected shutdowns, not all the data is properly written to disk, so we can't retreive the data anymore.
The amount of data we write is more or less 8000 rows every 10 seconds. Obviously that the lower the number of rows, the higher the chance for all of them to be written properly. We passed from HDD to SSD for this reason, the maximum amount of rows for a HDD to be all written prperly was around 700, above that quantity the data would be unrecoverable. The SSD's rised this limit to around 5000-6000, but it is not enough.
Is there any solution for this? All the data comes from Ethernet port, I mean there is no data generated locally.