从Amazon RDS(MySql)迁移到Heroku Postgres需要付出多少努力?

时间:2022-12-18 20:15:00

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的部分与你相关。