Amazon AWS RDS MySQL - Instances and Pricing

2
votes

I have 15 databases that are running off my shared hosting account for $5/mnth. I would like to use AWS RDS.

1) Do I have to create a new INSTANCE for each database?

2) Won't this be expensive $191/mnth ($12.75/mnth x 15DBs for the cheapest db.t2.micro instance)? http://aws.amazon.com/rds/pricing/

3) How can I optimize the management of resources? (eg. Is putting more tables into a single DB instance the best solution?)

1
mysqlamazon-web-servicesamazon-rds

1 Answers

1
votes

  1. No. One instance can host multiple databases. If they are used for different purposes, you will want to set up separate grants for each for security.

  2. As i said in 1, you don't need to use multiple instances. Although depending on your workload, a micro may or may not be large enough.

  3. That's a complicated question. Security requirements often come into play.