One of our production apps has been on Amazon RDS (MySql) for a few months now. I must say, all is well. Except for the fact that Amazon RDS does periodic backups of the db, causing a temporary downtime (few minutes).
我们的一个生产应用程序已经在Amazon RDS(MySql)上使用了几个月。我必须说,一切都很好。除了Amazon RDS定期备份数据库外,导致临时停机(几分钟)。
I did some reading, and found out that having the Multi-AZ setup will prevent this. However, this setup will increase the costs by 2x! Which is almost the equivalent to a dedicated db plan at Heroku.
我做了一些阅读,发现使用多可用区设置可以防止这种情况发生。但是,这种设置会使成本增加2倍!这几乎相当于Heroku的专用数据库计划。
Anyone from experience. Is such a move beneficial? Should I just stick with my MySql setup? We currently have 3 months of production data.
有经验的人。这样的举动有益吗?我应该坚持使用MySql设置吗?我们目前有3个月的生产数据。
For the ones that have migrated over to Postgres from MySql. Was the effort in doing so long and tedious?
对于从MySql迁移到Postgres的那些。这样做的努力是漫长而乏味的吗?
1 个解决方案
#1
2
Have a read of this article: http://blog.sendhub.com/switching-to-heroku-a-django-app-story (dead link, see mirrors: #1, #2)
阅读本文:http://blog.sendhub.com/switching-to-heroku-a-django-app-story(死链接,见镜像:#1,#2)
It's Django related but there's a section on migrating from MySQL to Postgres which is relevant to you.
它与Django有关,但是有一节关于从MySQL迁移到Postgres的部分与你相关。
#1
2
Have a read of this article: http://blog.sendhub.com/switching-to-heroku-a-django-app-story (dead link, see mirrors: #1, #2)
阅读本文:http://blog.sendhub.com/switching-to-heroku-a-django-app-story(死链接,见镜像:#1,#2)
It's Django related but there's a section on migrating from MySQL to Postgres which is relevant to you.
它与Django有关,但是有一节关于从MySQL迁移到Postgres的部分与你相关。