MySQL 我可以在单个 Amazon RDS 实例上创建多少个数据库
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/16328807/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How many databases can I create on a single Amazon RDS instance
提问by Idan Shechter
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 实例，对我来说可能有点太贵了。
回答by Bill Karwin
http://aws.amazon.com/rds/faqs/#2
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 年 8 月 26 日更新：RDS 常见问题解答现在指出：
- RDS for MySQL: No limit imposed by software
- RDS for Oracle: 1 database per instance; no limit on number of schemas per database imposed by software
- RDS for SQL Server: 30 databases per instance
- RDS for PostgreSQL: No limit imposed by software
- RDS for MySQL：不受软件限制
- RDS for Oracle：每个实例 1 个数据库；软件对每个数据库的模式数量没有限制
- RDS for SQL Server：每个实例 30 个数据库
- RDS for PostgreSQL：不受软件限制
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。如果您的应用程序需要更多数据库实例，您可以通过此请求表请求更多数据库实例。
回答by Ajit
As per the AWS document-
根据 AWS文档-
- RDS for Amazon Aurora: No limit imposed by software
- RDS for MySQL: No limit imposed by software
- RDS for MariaDB: No limit imposed by software
- RDS for Oracle: 1 database per instance; no limit on number of schemas per database imposed by software
- RDS for SQL Server: Up to 100 databases per instance(The maximum number of databases supported on a DB instance depends on the instance class type and the availability mode—Single-AZ, Multi-AZ Database Mirroring, or Multi-AZ Availability Groups. The Microsoft SQL Server system databases don't count toward this limit.) see here: Amazon RDS SQL Server User Guide
- RDS for PostgreSQL: No limit imposed by software
- RDS for Amazon Aurora：不受软件限制
- RDS for MySQL：不受软件限制
- RDS for MariaDB：不受软件限制
- RDS for Oracle：每个实例 1 个数据库；软件对每个数据库的模式数量没有限制
- RDS for SQL Server：每个实例最多 100 个数据库（一个数据库实例支持的最大数据库数取决于实例类类型和可用性模式——单可用区、多可用区数据库镜像或多可用区可用性组。 Microsoft SQL Server 系统数据库不计入此限制。）请参阅此处：Amazon RDS SQL Server 用户指南
- RDS for PostgreSQL：不受软件限制
