I want to ask a question related to Amazon services (AWS/EC2) and databases. Basically here is my question (could add more details once asked on the right place):
We are an online shop. We have a couple of self managed servers, production and development, with some databases on a MS SQL Server 2008R2 express intance. Also we have another database hosted on the Amazon RDS service. Right now I've been asked to investigate the option of migrating all the production/devolpment databases to Amazon AWS. Also check the viability of using EC2. Sorry if I'm miss using some terms, I'm just learning about all these services.
Where should I start, doing some tests, creating a dummy database to test the different setups? Can I have some recommendation on tutorial/blog/faq's where to find some usefull information? Any recommendation will be welcomed as well as any previous experience doing this kind of migration to the AWS.
I see there are lot of questions about these subjects on different sites:
- SO: [amazon-ec2] 3,348 questions
[aws] 955 questions
aws+database: 71 questions
- serverfault: [amazon-ec2] 2411 questions
[aws] 1512 questions
aws+database: 3374 questions
- dba: [amazon-ec2] 45 questions
[aws] 36 questions
aws+database: 0 questions
The DBA site has not much about the subject. But my question is more DBA tasks related question. I'm thinking on either asking on Serverfault as it seems to hold the greater number of questions about the subject or replicating the question on the three sites. Second option seems to me not the correct one. But I'm afraid asking only on one of the sites and not only not having the needed answer, but not having an answer at all.