我可以在单个Amazon RDS实例上创建多少个数据库

How many databases can I create on a single Amazon RDS instance?

我可以在单个Amazon RDS实例上创建多少个数据库？

I need to move from Xeround to another server (they are closing for public clouds). My two options are either create a single EC2 instance with EBS backed (10,000 iOPS) or RDS. I have three databases and not too much traffic. If I need to launch RDS instance for each database it can be a bit too expensive for me.

我需要从Xeround转移到另一台服务器（它们正在关闭公共云）。我的两个选项是创建一个支持EBS（10,000 iOPS）或RDS的EC2实例。我有三个数据库，没有太多的流量。如果我需要为每个数据库启动RDS实例，对我来说可能有点贵。

1 个解决方案

#1

http://aws.amazon.com/rds/faqs/#2

Multiple MySQL databases or SQL Server databases (up to 30) or Oracle database schemas can be created on a given DB Instance.

可以在给定的数据库实例上创建多个MySQL数据库或SQL Server数据库（最多30个）或Oracle数据库模式。

Update 2013-12-16: as discussed in the comments below, the wording in the RDS FAQ is ambiguous. @Jan sent an inquiry to Amazon, and got this reply:

更新2013-12-16：如下面的评论所述，RDS常见问题解答中的措辞含糊不清。 @Jan向亚马逊发出询问，得到了这个回复：

With RDS MySQL database instances, it follows the MySQL standard where there's no limit on the number of databases - http://dev.mysql.com/doc/refman/5.5/en/database-count-limit.html. Thank you for pointing out the spotty documentation there, we'll amend that to make it more clear.

使用RDS MySQL数据库实例，它遵循MySQL标准，其中对数据库的数量没有限制 - http://dev.mysql.com/doc/refman/5.5/en/database-count-limit.html。感谢您指出那里的参差不齐的文档，我们将修改它以使其更清晰。

Thanks @Jan!

谢谢@Jan！

Update 2014-08-26: the RDS FAQ now states:

更新2014-08-26：RDS常见问题解答现在声明：

RDS for MySQL: No limit imposed by software

适用于MySQL的RDS：软件没有限制

RDS for Oracle: 1 database per instance; no limit on number of schemas per database imposed by software

RDS for Oracle：每个实例1个数据库;对软件强加的每个数据库的模式数量没有限制

RDS for SQL Server: 30 databases per instance

SQL Server的RDS：每个实例30个数据库

RDS for PostgreSQL: No limit imposed by software

PostgreSQL的RDS：软件没有限制

And that makes one wonder, "how many instances can I have?"

这让人怀疑，“我可以拥有多少个实例？”

By default, customers are allowed to have up to a total of 40 Amazon RDS DB instances. Of those 40, up to 10 can be Oracle or SQL Server DB Instances under the "License Included" model. All 40 can be used for MySQL, Oracle, SQL Server, or PostgreSQL under the "BYOL" model. If your application requires more DB Instances, you can request additional DB Instances via this request form.

默认情况下，允许客户最多拥有40个Amazon RDS数据库实例。在这40个中，在“包含许可证”模型下，最多10个可以是Oracle或SQL Server数据库实例。所有40个都可以用于“BYOL”模型下的MySQL，Oracle，SQL Server或PostgreSQL。如果您的应用程序需要更多数据库实例，您可以通过此请求表单请求其他数据库实例。

#1