RDS for multiple small databases

Question

Hello!  
  
In RDS you can run multiple databases on 1 instance, so far so good. But if you create a database in RDS the minimum storage to allocate is 20GB per database. I have about 35 small MySQL-databases (all together make up less than 20GB). Is there a way for them to share the 20GB / run on the same storage and to make it cost-effective (the 35 x 20GB add up to about USD 1000 per year)?  
  
Or is RDS not suitable for this specific use case and I need to run it on an EC2-instance instead?  
  
Thanks  
  
Georg

Answer

You're welcome

Answer

Hi HalTemp!  
Thanks for your reply. You are 100% right. My misunderstanding was, that I would have to use the RDS Console on the website, where the button "Create Database" actually leads to "Create Database Instance". With the SQL Statement "CREATE DATABASE" it works fine.  
Thanks again!

Answer

The 20GB minimum is for the RDS database INSTANCE. You can create as many MySQL databases as you'd like within that instance without allocating more space. I just tried it to verify, and it happily lets me execute as many CREATE DATABASE statements against the single instance as I'd like.  
  
If you do end up needing more than the 20GB you can either manually grow the volume or let RDS autogrow it. But if the databases are small enough you can support quite a few before that is necessary.

RDS for multiple small databases

Contenuto pertinente