铁轨 + Amazon RDS:延迟问题

发布于 2024-11-06 03:41:08 字数 190 浏览 0 评论 0原文

我有一个应用程序,其数据库正在迁移到亚马逊RDS。

由于 RDS 和我们的服务器之间的查询延迟(例如仅因为查询而导致加载时间长达 30 秒),我的性能显着下降。没有显式缓存,并且请求可以进一步优化,但这仍然比本地数据库慢 10 倍以上。

这种业绩下降是我预料之中的吗?如果是的话,有没有一种方法可以使用与本地数据库性能相似的云数据库?

I have an app whose database is being migrated to amazon RDS.

I experienced a significant drop of performance, due to the latency of the queries between RDS and our server (like 30s of loading time only because of the queries). There is no explicit caching, and the requests could be optimized a bit more, but this is still more than 10x slower than with a local database.

I this kind of performance drop expected? If yes, is there a way to use a cloud database with similar performances as a local one?

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

筱果果 2024-11-13 03:41:08

人们报告了一些 RDS 性能不佳的问题。尽管据我所知亚马逊尚未承认这些问题。

RDS(只是 mysql 的自定义版本)使用 ESB 作为存储后端,我相信您很清楚他们刚刚使用该服务时遇到的失败。

我读过很多公司只是在 EC2 实例中运行自己的 mysql 数据库,因为它被证明具有更可靠的性能。

There have been some reported issues with poor performance of RDS by people. Although amazon as far as I've seen hasn't acknowledged these issues.

RDS (which is just a custom version of mysql) uses the ESB for the storage backend, and as I'm sure you are well aware of the failure they just had with that service.

I've read a lot of companies just running their own mysql DBs in EC2 instances becuase it's showns to have more reliable performance.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文