3 ms·
I've done something similar, you start out with something naive and simple like mysqldump that takes an age, and move on to more specialised tools like Percona
by kawsper 3y ago
I've done something similar, you start out with something naive and simple like mysqldump that takes an age, and move on to more specialised tools like Percona XtraBackup that allows for incremental backups.
- forgingahead 3y agoAny tips on similar tools for Postgres?
- __s 3y agoDepends on environment. If you can do disk snapshots that's the way to go (can be hard with disk striping). wal-g works for storing both base backups & wal to various storages in parallel & can be throttled with env variables Source: worked on Azure's managed Citus pg