News for hackers. Stuff that matters.

A comment on Shopify Ruby on Rails distributed monolith runs 19M queries per second on MySQL. Parent comment

Re:Shopify Ruby on Rails distributed monolith runs 19M queri... by kawsper on Wednesday November 29, 2023 @04:21AM (#38457269)
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.
[ Parent | on HN ]
Re:Shopify Ruby on Rails distributed monolith runs 19M queri... by forgingahead on Wednesday November 29, 2023 @05:57AM (#38457898)
Any tips on similar tools for Postgres?
[ Parent | on HN ]
Re:Shopify Ruby on Rails distributed monolith runs 19M queri... by __s on Wednesday November 29, 2023 @08:34AM (#38459129)
Depends 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

[ Parent | on HN ]