什么是各自的优点/亚马逊RDS的与EC2与MySQL限制?亚马逊、优点、RDS、MySQL

2023-09-11 23:39:08 作者:茶靡微凉ァ

我意识到两者之间的几个基本区别,即

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

EC2将是更便宜的

EC2 is going to be cheaper

RDS我也不会做保养

RDS I wouldn't have to do maintenance

除了这两个,还有什么好处运行从RDS我的数据库,而不是作为一个MySQL服务器的单独的EC2服务器。假设类似的实例大小,都将遇到同样的限制,在能够处理的负载条件?

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?

为了让你我用多一点点信息,我有一个数据库,没有什么太大或任何东西(最大的表1万行),只是高选择音量。

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需要pretty的显著量的维护开销,例如:

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

EC2没有RAID0 EBS将提供糟糕的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香草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.