Amazon RDS Aurora与RDS MySQL与EC2上的MySQL吗? [英] Amazon RDS Aurora vs RDS MySQL vs MySQL on EC2?
问题描述
在云上建立数据库时，我一直在寻找最佳实践，但是我仍然不清楚我们应该选择以下哪种解决方案?
- Amazon RDS Aurora
- Amazon RDS MySQL
- 在EC2实例上使用MySQL
我认为Amazon Aurora被作为更好的替代品进行市场营销，但是经过一些研究，人们似乎并没有在使用它.这有问题吗?
在考虑Aurora之前，应仔细进行基准测试.启动实例并设置应用程序和数据库的测试实例.产生尽可能高的负载.我在上一家公司工作时发现，尽管亚马逊宣称高性能，但Aurora却失败了.比RDS慢两个数量级.我们的应用程序的写入流量很高.
我们的结论:如果您有二级索引并且写入流量很高，则Aurora不适合.我敢打赌，这对只读流量很有用.
(我正在描述的测试是在2017年第一季度完成的.与大多数AWS服务一样，我希望Aurora会随着时间的推移而改善.亚马逊的明确策略是" 解决方案
You should benchmark Aurora carefully before you consider it. Launch an instance and set up a test instance of your application and your database. Generate as high of load as you can. I did at my last company, and I found that despite Amazon's claims of high performance, Aurora failed spectacularly. Two orders of magnitude slower than RDS. Our app had a high rate of write traffic.
Our conclusion: if you have secondary indexes and have high write traffic, Aurora is not suitable. I bet it's good for read-only traffic though.
(Edit: the testing I'm describing was done in Q1 of 2017. As with most AWS services, I expect Aurora to improve over time. Amazon has an explicit strategy of "Release ideas at 70% and then iterate." From this, we should conclude that a new product from AWS is worth testing, but probably not production-ready for at least a few years after it's introduced).
At that company, I recommended RDS. They had no dedicated DBA staff, and the automation that RDS gives you for DB operations like upgrades and backups was very helpful. You sacrifice a little bit of flexibility on tuning options, but that shouldn't be a problem.
The worst inconvenience of RDS is that you can't have a MySQL user with SUPER privilege, but RDS provides stored procs for most common tasks you would need SUPER privilege for.
I compared a multi-AZ RDS instance versus a replica set of EC2 instances, managed by Orchestrator. Because Orchestrator requires three nodes so you can have quorum, RDS was the clear winner on cost here, as well as ease of setup and operations.
这篇关于Amazon RDS Aurora与RDS MySQL与EC2上的MySQL吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
