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.
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.
I know that we specifically don't use the snapshot feature for a reason. I think it has to do with how snapshots are restored. But I would need to ask my colleague why exactly we're not doing it.
We do full dumps and data-only dumps in regular intervals.