在 Heroku 上创建数据库备份会影响性能吗？
Heroku 有一个非常简单的数据库备份实用程序。显然，数据库必须做一些工作来创建备份。我想知道的是多少钱？
如果我在频繁使用的生产环境中运行此程序，我的用户是否会遇到任何停机或速度缓慢的情况？每天运行此操作是否有任何危害？在非高峰时段执行此操作有多重要？
听到任何现实生活中的经历都会很棒。干杯!
Heroku has a wonderfully simple backup utility for databases. Obviously, the database will have to do some work to create a backup. What I'm wondering is how much?
If I run this on a production environment with heavy use, are my users going to experience any downtime or slowness? Would there be any harm to running this daily, and how important would it be to do this during non-peak hours?
Hearing about any real-life experiences with this would be wonderful. Cheers!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
因为它只是复制文件，所以备份数据库通常不是一个非常耗时的过程，并且不应该锁定您的表。也就是说，我没有使用过非常大的数据库（以千兆字节为单位）。
无论如何，我建议您在非高峰时段通过 cron 自动运行它，这样您就不必担心手动执行此操作，这个 gem： https://github.com/joemsak/heroku_backup_task 似乎正是这样做的。
希望有帮助！
Because it's simply copying the file, backing up a database usually isn't a very time consuming process and shouldn't lock up your tables. That said, I haven't worked with very large databases (in the gigabytes).
Regardless, I suggest you run it automatically via cron on non-peak hours so you don't have to worry about doing it manually anyways, this gem: https://github.com/joemsak/heroku_backup_task seems to do exactly that.
Hope that helps!