I have came across Percona xtrabackup but I am curious what is the best production deployment best practices and tools that are actually used by companies.

  • mwguy@infosec.pub
    link
    fedilink
    arrow-up
    2
    ·
    4 months ago

    You should be able to take the binlogs and upload them. Then in a restore situation you’d restore your last full db snapshot and replay your binlogs up until the point you lost the server.

  • ExperimentalGuy@programming.dev
    link
    fedilink
    arrow-up
    1
    ·
    6 months ago

    I bet you could make a lambda function that periodically backs up your database. That’s probably the route that I’d go down because it’s more cost effective than other things. Only thing I’d be concerned ab is configuring perms for the lambda function and s3 bucket. Take this with a grain of salt, I’ve only recently started getting into cloud stuff.