在Amazon EC2上使用MySQL安装的网站 [英] Setup website on Amazon EC2 with mysql
问题描述
我有一个新的网站，是的Joomla驱动，包含依赖Mysql数据库在许多自定义应用程序。这是所有托管在Amazon EC2上的根设备是EBS。
I've got a new website that is Joomla driven and contains many custom apps that depend on the Mysql database. This is all hosted on Amazon EC2 with the root device being EBS.
我关心的是我的MySQL安装。我安装的MySQL服务器使用pretty的很多默认设置（除安全清理等）。
My concern is with my Mysql setup. I've installed mysql-server with pretty much default settings (other than the security cleanup).
我的问题是，如果我应该将MySQL设置一个单独的EBS卷上运行：的http：// aws.amazon.com/articles/1663 或者我应该甚至可以看着亚马逊RDS： HTTP ：？//aws.amazon.com/rds/mysql/
My question is if I should be setting up Mysql to run on a separate EBS volume: http://aws.amazon.com/articles/1663 or should I even be looking at Amazon RDS: http://aws.amazon.com/rds/mysql/?
这些似乎都矫枉过正我的启动，现在跟0个用户。我当然希望确保我积极主动地情况下，这确实增长，但我不知道这是否是一个重大的痛苦添加这些以后呢？
These both seem overkill for my startup right now with 0 users. I obviously want to make sure I'm proactive in case this does grow but I have no idea if it will be a major pain to add these later?
推荐答案
我肯定会说，你应该安装的MySQL上的另一个EBS卷的原因有很多运行。这里有几个：
I would definitely say you should setup MySQL to run on another EBS volume for many reasons. Here are a few:
-
更轻松备份。您可以快照整个EBS卷，而不是做一个MySQL转储文件并将其推到S3。当你有卷的快照，你可以恢复你的数据库不是与一个MySQL转储更快。
Easier backups. You can snapshot the entire EBS volume rather than doing a MySQL dump and pushing it to S3. When you have a snapshot of the volume, you can restore your database much quicker than with a MySQL dump.
磁盘争。你会看到一些磁盘争，当您运行一切都在同一磁盘上。特别是如果你正在尝试做MySQL的复制。我有一个体积为MySQL日志，一个用于数据，一个用于一切。
Disk contention. You will see some disk contention when you run everything on the same disk. Especially if you are trying to do MySQL replication. I have one volume for MySQL logs, one for Data, and one for everything else.
EBS卷也相对便宜。
EBS volumes are relatively cheap.
您可以将整个卷移动到另一个实例，如果您需要。
You can move the entire volume to another instance if you need to.
总的来说这是一个更好的选择。如果需要的话我可以给你更多的理由。
Overall it is a much better choice. I could give you more reasons if you need them.
我想你能得到通过EBS卷了一段时间，然后再决定要分片，重新编写应用程序的NoSQL，转移到Amazon RDS等，但我认为是使用了MySQL的，直到有一无所有。
I think you could get by on EBS volumes for a while and then decide to shard, rewrite application for NOSql, move to Amazon RDS, etc. But my opinion is to use up MySQL until there is nothing left.
这篇关于在Amazon EC2上使用MySQL安装的网站的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
