4 ms·
I really would like to know details on how people backup, dump, migrate and upgrade DBs of this size.
by nunesvn 3y ago
I really would like to know details on how people backup, dump, migrate and upgrade DBs of this size.
- halfstar91 3y agoIncrementally usually :)
- nunesvn 3y agoYes, but a usual pattern for smaller DBs is, for example, to run a full backup weekly and then daily incremental backups. Also, SQL dumps makes easier to do partial recovery, like for a single table. On this size class (~1TB) I see PITR backups using something like Barman as the only viable alternative. (Of course you can also copy the whole VM/Disk etc)