amazon-web-services - Amazon RDS 实例类型连接限制

Question

我正在尝试决定使用哪种 AWS RDS 实例类型。

我有应用程序所需的数据库连接数量的统计信息。

是否可以知道哪种 AWS RDS 实例类型大约支持多少个数据库连接？

我有以下列表，但我不确定它迄今为止有多准确:

t2.micro   66
t2.small   150
m3.medium  296
t2.medium  312
m3.large   609
t2.large   648
m4.large   648
m3.xlarge  1237
r3.large   1258
m4.xlarge  1320
m2.xlarge  1412
m3.2xlarge 2492
r3.xlarge  2540

是否有相同的官方 AWS 文档？

Answer 1

您还可以验证 max_db_connection 值

# mysql>show max_connections;

或

单击默认参数组并搜索 max_connections，您将看到公式。就我而言，它是 {DBInstanceClassMemory/magic_number}。

但是 max_connections 列中的数字看起来有点尴尬，因为它们实际上是根据公式 DBInstanceClassMemory/magic_number 计算得出的，其中 ma​​gic_number 根据不同的情况而有所不同您的实例的类。

您可以查看此链接以获取更新的文档 MySQL Managing Performance .

这意味着内存越高，实例将能够处理更多的连接。您检查数据库实例类大小 here .

The maximum number of connections allowed to an Amazon RDS MySQL DB instance is based on the amount of memory available for the DB instance class of the DB instance. A DB instance class with more memory available will result in a larger amount of connections available

Choose RDS class .

If you create a new parameter group to customize your own default for the connection limit, you'll see that the default connection limit is derived using a formula based on the DBInstanceClassMemory value. As shown in the preceding table, the formula produces connection limits that increase by 1000 as the memory doubles between progressively larger R3, R4, and R5 instances, and by 45 for different memory sizes of T2 instances. The much lower connectivity limits for T2 instances are because T2 instances are intended only for development and test scenarios, not for production workloads. The default connection limits are tuned for systems that use the default values for other major memory consumers, such as the buffer pool and query cache. If you change those other settings for your cluster, consider adjusting the connection limit to account for the increase or decrease in available memory on the DB instances.