RDS for multiple small databases

0

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

asked 4 years ago3322 views
3 Answers
0

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.

HalTemp
answered 4 years ago
0

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!

answered 4 years ago
0

You're welcome

HalTemp
answered 4 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions