Why early-in-career?
I accidentally rm -rf'd the @euskalencounter postgresql DB once, by exiting one ssh level too many from a testing VM out into the prod host.
Thankfully there were hourly backups (which I'd set up), so I took the chance to upgrade postgresql :-)https://twitter.com/delroth_/status/1256041866354712577 …
We actually have a standby slave now (was set up after the incident too), but it's not delayed.
-
-
i probably rely on it more than i should (like multiple times a month). gdpr delete request accidentally applied by support team to wrong user? no worries ssh delayed 'mysqldump -w "user_id=1234" --insert-ignore -ntfq --skip-add-locks --skip-disable-keys osu' | ssh master mysql
-
of course have to first catch it up to just before the mistake happened if you want to avoid data loss, but indispensable as a tool :D
End of conversation
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.
emoji into the zsh prompt of prod hosts.
The only data lost was a user that had registered themselves in the time between the backup and the accident. We have structured logs which include everything but the password, so I manually re-created them.