Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

At the Amazon RDS FAQ there is the question "What is a database instance (DB Instance)?".

The entire answer (as of mid-June 2012) is:

You can think of a DB Instance as a database environment in the cloud with the compute and storage resources you specify. You can create and delete DB Instances, define/refine infrastructure attributes of your DB Instance(s), and control access and security via the AWS Management Console, Amazon RDS APIs, and Command Line Tools. Multiple MySQL databases or SQL Server databases (up to 30) or Oracle database schemas can be created on a given DB Instance.

The last part of that quote, "Multiple MySQL databases or SQL Server databases (up to 30) Oracle database schemas" I interpret to mean that you can have an "unlimited" number of databases on an RDS MySQL or Oracle instance but only 30 databases on an MS SQL Server instance ("unlimited" meaning not limited by the RDS infrastructure itself).

This was asked in the Stackoverflow question Does Amazon RDS support multiple databases per instance?. The answer quoted an older version of the FAQ.

What I am looking for is an Amazon document that clarifies this question, or else someone who has experience using Amazon RDS who can attest what the situation actually is.

share|improve this question
    
I did a test and created 40 MySQL schemas in a single RDS MySQL instance, so this suggests that the RDS infrastructure does not limit the number MySQL schemas you can create. –  user35042 Jul 10 '12 at 15:43
add comment

2 Answers 2

As an AWS customer using MSSQL in RDS, I can confirm the maximum amount of databases per instance (t1.micro) using SQL Express is indeed 30.

I am testing other instance sizes, and will post further if I get different results.

share|improve this answer
    
I increased my instance to a t1.small and have the same 30 database limit. –  Glenn Geller Aug 13 '12 at 18:34
    
MSSQL seem to have the limit, not MySQL –  Chida Aug 13 '12 at 19:42
add comment

RDS MySQL does not have limits for size of database or the number of databases.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.