Rails + Amazon RDS:延迟问题 [英] Rails + Amazon RDS : latency issues

问题描述

我有一个应用程序，其数据库正在迁移到Amazon RDS.

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

由于RDS与我们的服务器之间的查询延迟(例如仅由于查询而导致的30年代的加载时间)，我的性能出现了大幅下降.没有显式缓存，可以对请求进行更多优化，但这仍然比本地数据库慢10倍以上.

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?

推荐答案

有人报告了人们对RDS性能不佳的问题.尽管据我所知，亚马逊尚未意识到这些问题.

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(这只是mysql的自定义版本)使用ESB作为存储后端，并且我敢肯定，您已经很清楚他们在使用该服务时会遇到的故障.

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.

我读过很多公司都在EC2实例中运行自己的mysql数据库，因为它显示出更可靠的性能.

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.

这篇关于Rails + Amazon RDS:延迟问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！