[DOCS-15280] Investigate changes in SERVER-62656: Decouple mongos-to-config-server connection pool sizing from mongos-to-shard-server connection pool sizing Created: 25/Apr/22  Updated: 13/Nov/23  Resolved: 27/Jun/22

Status: Closed
Project: Documentation
Component/s: manual, Server
Affects Version/s: None
Fix Version/s: 6.1.0-rc0, 6.0.0-rc3, 5.0.10, 4.4.16, 4.2.22, Server_Docs_20231030, Server_Docs_20231106, Server_Docs_20231105, Server_Docs_20231113

Type: Task Priority: Major - P3
Reporter: Backlog - Core Eng Program Management Team Assignee: Jason Price
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
backported by DOCS-15284 [BACKPORT] [v6.0] Decouple mongos-to-... Closed
Documented
documents SERVER-62656 Decouple mongos-to-config-server conn... Closed
Participants:
Days since reply: 1 year, 24 weeks, 5 days ago
Epic Link: DOCSP-21764
Story Points: 3

 Description   
Original Downstream Change Summary

Adds server parameters

Description of Linked Ticket

The ShardingTaskExecutorPool{Min, Max}Size server parameters control the maximum and minimum sizes of connection pools each TaskExecutor can maintain to any mongod. (Most CRUD/agg operations will use these connection pools to reach mongod from mongos). 

The STAR team did some research and determined that different values for these parameters may have performance implications, and came up with tuning recommendations for these parameters for different sized deployments. However, in clusters where CSRS are on differently-sized machines than shards, we would want the size of the connection pools controlled by this parameter to differ depending on if the targeted mongod is a configsvr or shardsvr. 

This is not possible with the current implementation of the parameter, which controls CP sizing for all mongods. We should decouple this to allow for different CP sizing depending  on if the target is a shardserver or configserver.

 Should be doable by giving the ShardingTaskExecutorPoolController a view into the cluster topology (maybe via RSM?) or some info on it so it can determine if a host is a config server or shard server.  



 Comments   
Comment by Githook User [ 19/Aug/22 ]

Author:

{'name': 'jason-price-mongodb', 'email': '69260375+jason-price-mongodb@users.noreply.github.com', 'username': 'jason-price-mongodb'}

Message: V5.0.10 (#1362)

  • Docs-15280 mongos connection pool (#1311)

Co-authored-by: jason-price-mongodb <jshfjghsdfgjsdjh@aolsdjfhkjsdhfkjsdf.com>

  • DOCS-15436-mongos connection-pool-backport-v5.0.10

Co-authored-by: jason-price-mongodb <jshfjghsdfgjsdjh@aolsdjfhkjsdhfkjsdf.com>
Branch: v5.0
https://github.com/10gen/docs-mongodb-internal/commit/70607dfc828b16cf844b2afb1c50abc8192d2cde

Comment by Githook User [ 19/Aug/22 ]

Author:

{'name': 'jason-price-mongodb', 'email': '69260375+jason-price-mongodb@users.noreply.github.com', 'username': 'jason-price-mongodb'}

Message: V5.0.10 (#1362)

  • Docs-15280 mongos connection pool (#1311)

Co-authored-by: jason-price-mongodb <jshfjghsdfgjsdjh@aolsdjfhkjsdhfkjsdf.com>

  • DOCS-15436-mongos connection-pool-backport-v5.0.10

Co-authored-by: jason-price-mongodb <jshfjghsdfgjsdjh@aolsdjfhkjsdhfkjsdf.com>
Branch: v5.0
https://github.com/10gen/docs-mongodb-internal/commit/70607dfc828b16cf844b2afb1c50abc8192d2cde

Comment by Githook User [ 12/Jul/22 ]

Author:

{'name': 'jason-price-mongodb', 'email': '69260375+jason-price-mongodb@users.noreply.github.com', 'username': 'jason-price-mongodb'}

Message: Docs-15280 mongos connection pool (#1311)

Co-authored-by: jason-price-mongodb <jshfjghsdfgjsdjh@aolsdjfhkjsdhfkjsdf.com>
Branch: v6.1
https://github.com/10gen/docs-mongodb-internal/commit/b4c8ed6c1ed41facced06994bb48c23bc609b517

Comment by Githook User [ 12/Jul/22 ]

Author:

{'name': 'jason-price-mongodb', 'email': '69260375+jason-price-mongodb@users.noreply.github.com', 'username': 'jason-price-mongodb'}

Message: Docs-15280 mongos connection pool (#1311)

Co-authored-by: jason-price-mongodb <jshfjghsdfgjsdjh@aolsdjfhkjsdhfkjsdf.com>
Branch: v6.1
https://github.com/10gen/docs-mongodb-internal/commit/b4c8ed6c1ed41facced06994bb48c23bc609b517

Comment by Githook User [ 07/Jul/22 ]

Author:

{'name': 'jason-price-mongodb', 'email': '69260375+jason-price-mongodb@users.noreply.github.com', 'username': 'jason-price-mongodb'}

Message: DOCS-15465 mongos connection pool (BACKPORT) (#1420)

  • Docs-15280 mongos connection pool (#1311)

Co-authored-by: jason-price-mongodb <jshfjghsdfgjsdjh@aolsdjfhkjsdhfkjsdf.com>

  • DOCS-15465-BACKPORT mongo connection pool sizing
  • DOCS-15465-BACKPORT mongo connection pool sizing

Co-authored-by: jason-price-mongodb <jshfjghsdfgjsdjh@aolsdjfhkjsdhfkjsdf.com>
Branch: v4.2.22
https://github.com/10gen/docs-mongodb-internal/commit/6a1a5c388c7b97aa8a445e24c682162ab545f6c6

Comment by Githook User [ 07/Jul/22 ]

Author:

{'name': 'jason-price-mongodb', 'email': '69260375+jason-price-mongodb@users.noreply.github.com', 'username': 'jason-price-mongodb'}

Message: DOCS-15465 mongos connection pool (BACKPORT) (#1420)

  • Docs-15280 mongos connection pool (#1311)

Co-authored-by: jason-price-mongodb <jshfjghsdfgjsdjh@aolsdjfhkjsdhfkjsdf.com>

  • DOCS-15465-BACKPORT mongo connection pool sizing
  • DOCS-15465-BACKPORT mongo connection pool sizing

Co-authored-by: jason-price-mongodb <jshfjghsdfgjsdjh@aolsdjfhkjsdhfkjsdf.com>
Branch: v4.2.22
https://github.com/10gen/docs-mongodb-internal/commit/6a1a5c388c7b97aa8a445e24c682162ab545f6c6

Comment by Education Bot [ 06/Jul/22 ]

Fix Version updated for upstream SERVER-62656:
6.1.0-rc0, 6.0.0-rc3, 5.0.10, 4.4.16, 4.2.22

Comment by Education Bot [ 28/Jun/22 ]

Fix Version updated for upstream SERVER-62656:
6.1.0-rc0, 6.0.0-rc3, 5.0.10, 4.4.16

Comment by Githook User [ 28/Jun/22 ]

Author:

{'name': 'jason-price-mongodb', 'email': '69260375+jason-price-mongodb@users.noreply.github.com', 'username': 'jason-price-mongodb'}

Message: V5.0.10 (#1362)

  • Docs-15280 mongos connection pool (#1311)

Co-authored-by: jason-price-mongodb <jshfjghsdfgjsdjh@aolsdjfhkjsdhfkjsdf.com>

  • DOCS-15436-mongos connection-pool-backport-v5.0.10

Co-authored-by: jason-price-mongodb <jshfjghsdfgjsdjh@aolsdjfhkjsdhfkjsdf.com>
Branch: v5.0.10
https://github.com/10gen/docs-mongodb-internal/commit/70607dfc828b16cf844b2afb1c50abc8192d2cde

Comment by Githook User [ 28/Jun/22 ]

Author:

{'name': 'jason-price-mongodb', 'email': '69260375+jason-price-mongodb@users.noreply.github.com', 'username': 'jason-price-mongodb'}

Message: V5.0.10 (#1362)

  • Docs-15280 mongos connection pool (#1311)

Co-authored-by: jason-price-mongodb <jshfjghsdfgjsdjh@aolsdjfhkjsdhfkjsdf.com>

  • DOCS-15436-mongos connection-pool-backport-v5.0.10

Co-authored-by: jason-price-mongodb <jshfjghsdfgjsdjh@aolsdjfhkjsdhfkjsdf.com>
Branch: v5.0.10
https://github.com/10gen/docs-mongodb-internal/commit/70607dfc828b16cf844b2afb1c50abc8192d2cde

Comment by Githook User [ 27/Jun/22 ]

Author:

{'name': 'jason-price-mongodb', 'email': '69260375+jason-price-mongodb@users.noreply.github.com', 'username': 'jason-price-mongodb'}

Message: Docs-15280 mongos connection pool (#1311)

Co-authored-by: jason-price-mongodb <jshfjghsdfgjsdjh@aolsdjfhkjsdhfkjsdf.com>
Branch: master
https://github.com/10gen/docs-mongodb-internal/commit/b4c8ed6c1ed41facced06994bb48c23bc609b517

Comment by Githook User [ 27/Jun/22 ]

Author:

{'name': 'jason-price-mongodb', 'email': '69260375+jason-price-mongodb@users.noreply.github.com', 'username': 'jason-price-mongodb'}

Message: Docs-15280 mongos connection pool (#1311)

Co-authored-by: jason-price-mongodb <jshfjghsdfgjsdjh@aolsdjfhkjsdhfkjsdf.com>
Branch: master
https://github.com/10gen/docs-mongodb-internal/commit/b4c8ed6c1ed41facced06994bb48c23bc609b517

Comment by Education Bot [ 22/Jun/22 ]

Fix Version updated for upstream SERVER-62656:
6.1.0-rc0, 6.0.0-rc3, 5.0.10

Comment by Jess Mokrzecki [ 27/Apr/22 ]

Fix Version updated for upstream SERVER-62656:
6.1.0-rc0, 6.0.0-rc3

Comment by Jess Mokrzecki [ 25/Apr/22 ]

Fix Version updated for upstream SERVER-62656:
6.1.0-rc0

Generated at Thu Feb 08 08:12:28 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.