4 ms·
That's good as well! If you are hosting your database on ec2, using only wal-e means that all of your data is hosted on amazon. If they were to cancel your ser
by joevandyk 13y ago
That's good as well!
If you are hosting your database on ec2, using only wal-e means that all of your data is hosted on amazon. If they were to cancel your service, you'd lose your data.
Running pg_basebackup+pg_receivexlog on a different provider is cheap insurance against that.
Be sure to test how fast wal-e can restore your data, btw. Restoring from s3 was significantly slower than restoring from a local disk (in my testing a while ago).
- wiredfool 13y agoI ship wal logs to s3 for backup, and I do test restores on EC2. What I've found is that most of the files can be grabbed really quickly, in the 3mb/sec range, but there's always a handful that run at 300k/sec. Running the downloads 8 or more at a time tends to help with that so that we're mostly maxing out the local network.