关于 GoGrid 与 EC2 的思考
我目前在 GoGrid（Microsoft 堆栈）托管我的 SaaS 应用程序。这是我所拥有的：
- 数据库服务器 - 物理机、12 GB RAM、2 个四核 CPU (2.13 GHz Xeon E5506)
- 2 个 Web/应用程序服务器 - 云服务器、2 GB RAM、2 个 VCPU
- 每月 300 GB 带宽
我支付大约 900 美元/月为此。我的 Web/应用程序服务器已经崩溃，需要升级到 4 GB RAM。我还需要一个防火墙，GoGrid 刚刚添加了这项服务，需要额外支付 200 美元。升级后，我将支付大约 1,400 美元。
我开始研究 Amazon EC2，特别是以下配置：
- 数据库服务器 - “高内存双超大型实例” - 34 GB RAM，13 个 EC2 计算单元
- 2 个 Web/应用程序服务器 - “大型实例” - 7.5 GB RAM，4 个 EC2 计算单元
如果我选择 1 年预留实例，则我的预付费用为 4,500 美元，每月费用为 700 美元。摊销后为每月 1,075 美元。亚马逊还免费提供防火墙。
我的问题如下：
你们中有谁有在 EC2 实例上运行数据库（尤其是 SQL Server）的经验吗？与专用机器相比，它的性能如何？我主要关心的问题之一是磁盘 I/O。
亚马逊对计算单元的描述相当模糊。关于如何比较数据库服务器上的 CPU 性能有什么想法吗？
我希望 Amazon 解决方案能够提供比我当前甚至改进的 GoGrid 设置更好的性能。拥有虚拟数据库服务器在可用性方面也很好。现在，如果我遇到任何硬件问题，我就会遇到严重的麻烦。
感谢您的任何见解...
I am currently hosting my SaaS application at GoGrid (Microsoft stack). Here's what I have:
- Database Server - physical box, 12 GB RAM, 2 X Quad Core CPU (2.13 GHz Xeon E5506)
- 2 Web / App servers - cloud servers, 2 GB RAM, 2 VCPUs
- 300 GB monthly bandwidth
I am paying around $900 / month for this. My web / app servers are busting at the seams and need to be upgraded to 4 GB of RAM. I also need a firewall, and GoGrid just added this service for an additional $200. After the upgrade, I will be paying around $1,400.
I started looking at Amazon EC2, specifically this config:
- Database server - "High Memory Double Extra Large Instance" - 34 GB RAM, 13 EC2 compute units
- 2 Web / App servers - "Large Instance" - 7.5 GB RAM, 4 EC2 compute units
If I go with 1 year reserved instances, my upfront cost would be $4,500 and my monthly would be $700. This comes to $1,075 / month when amortized. Amazon also includes a firewall for free.
Here are my questions:
Do any of you have experience running a database (especially SQL Server) on an EC2 instance? How did it perform compared to a dedicated machine? One of my major concerns is with disk I/O.
Amazon's description of a compute unit is fairly vague. Any ideas on how the CPU performance on the database servers would compare?
I am hoping that the Amazon solution will provide significantly better performance than my current or even improved GoGrid setup. Having a virtual database server would also be nice in terms of availability. Right now I would be in serious trouble if I had any hardware issues.
Thanks for any insight...
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我使用 Amazon 进行 SQL Server 托管，它非常棒。我们没有从专用机器迁移到 EC2，因此我无法提供比较，但我们在运行相对较高的交易量（每天数十万笔交易）时从未遇到过性能问题。
您可以为数据文件使用附加的 EBS 卷来提高 IO 性能。在我到达之前，我的公司使用了 GoGrid，并经历了一些糟糕的经历。我无法谈论他们今天的表现。我只能说，我们对亚马逊的性能和可靠性非常满意。
I've used Amazon for SQL Server hosting and it is great. We did not move from a dedicated machine to EC2 so I can't offer a comparison there but we have never had performance issues operating a relatively high volume - couple of hundred thousand transactions a day.
You can use an attached EBS volume for your data files to improve IO performance. My company used GoGrid before I arrived and had some bad experiences. I can't speak to how they perform today. All I can say is we are very happy with Amazon performance and reliability.