Amazon RDS 与带有 MySQL 的 EC2 的各自优势/限制是什么?

问题描述

我意识到两者之间的一些基本差异，即

I realize a couple of basic differences between the two, i.e.

1. EC2 会更便宜

1. EC2 is going to be cheaper

RDS 我不需要维护

除了这两个之外，与充当 MySQL 服务器的单独 EC2 服务器相比，从 RDS 运行我的数据库是否有任何优势.假设实例大小相似，两者在处理负载方面是否会遇到相同的限制?

Other than those two, are there any advantages to running my database from RDS as opposed to a separate EC2 server acting as a MySQL server. Assuming similar instance sizes, are both going to run into the same limitations in terms of being able to handle a load?

为了给你更多关于我使用的信息，我有一个数据库，没有太大或任何东西(最大的表有 100 万行)，只是高 SELECT 卷.

To give you a little bit more info about my use, I've got a database, nothing too big or anything (biggest table 1 million rows), just high SELECT volume.

推荐答案

这是一个很简单的问题，但答案却很复杂！

This is a simple question with a very complicated answer!

简而言之:如果您使用 RAID0 EBS，EC2 将提供最高性能.执行 RAID0 EBS 需要大量的维护开销，例如:

In short: EC2 will provide maximum performance if you go with a RAID0 EBS. Doing RAID0 EBS requires a pretty significant amount of maintenance overhead, for example:

http://alestic.com/2009/06/ec2-ebs-raid

http://alestic.com/2009/09/ec2-consistent-snapshot

没有 RAID0 EBS 的 EC2 将提供糟糕的 I/O 性能，因此它甚至不是一个真正的选择.

EC2 without RAID0 EBS will provide crappy I/O performance, thus it's not even really an option.

RDS 将提供非常好的(虽然不是最大的)开箱即用的性能.管理控制台很棒，升级实例很容易.只需点击一下即可实现高可用性和只读从站.真是太棒了.

RDS will provide very good (though not maximum) performance out of the box. The management console is fantastic and it's easy to upgrade instances. High availability and read only slaves are a click away. It's REALLY awesome.

简短回答:使用 RDS.还在篱笆上?和RDS一起去！！！如果您喜欢头疼的事，并且每时每刻都在调整以获得最佳性能，那么您可以考虑 EC2 + EBS RAID 0.Vanilla EC2 是 MySQL 托管的一个糟糕选择.

Short answer: Go with RDS. Still on the fence? Go with RDS!!! if you enjoy headaches and tuning every last little bit for maximum performance, then you can consider EC2 + EBS RAID 0. Vanilla EC2 is a terrible option for MySQL hosting.

这篇关于Amazon RDS 与带有 MySQL 的 EC2 的各自优势/限制是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！