Hacker News new | ask | show | jobs
by hijinks 4781 days ago
Replication and Raid isn't a backup because what if i do this in mysql

mysql> drop database production;

No way raid/replication will save you then. Same thing for some rogue delete statement gets in the code that deletes too much data.

Raid isn't a good backup because groups of drives are known to die at once or around the same time.

1 comments

You can't drop a database on postgres if anyone is connected to it, which is likely the case on production.
TRUNCATE TABLE users; should work and will have similar disastrous effects.
You can revoke truncate from public.
Oh, sure. I'll just do "DELETE FROM users" and forget about the WHERE clause. Same effect.