-
Notifications
You must be signed in to change notification settings - Fork 4.1k
server: sql server cold start [meta issue] #85612
Copy link
Copy link
Closed
Labels
A-multiregionRelated to multi-regionRelated to multi-regionC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-shared-systemsShared Systems TeamShared Systems Team
Description
Is your feature request related to a problem? Please describe.
This issue is a placeholder to track issues related to WAN round-trips required during the SQL server startup protocol. The goal is to get the number of WAN RPCs to zero. This issue will track work items required to reach that goal.
- sqlliveness: partition table so that sessions can be created without WAN RPCs #85736 partition
sqllivenesstable for more efficient cold-start - sqlinstance: optimize for MR cold-start #85737 optimize
sql_instances - settings: utilize LOCALITY GLOBAL for cluster settings #85738 optimize reading of cluster settings
- kvtenantccl: serve
Connectormethods needed for startup from local region #85740 ensureConnectormethods don't leave the local region - sql/catalog/lease: optimize descriptor leasing protocol for cold start #85741 optimize descriptor leasing protocol
- Note that this ends up also containing the work to make user metadata and role membership access local
- multitenant: demo startup performance is poor with multiple tenants and simulated latencies #76305 improve the speed of startup migrations
- The issue above is strangely named, but is related to the speed of startup migrations when creating and first activating a tenant. Note that this isn't directly related to cold start latency, but is related to the first start after tenant creation, which is also important to optimize.
Jira issue: CRDB-18341
Epic: CRDB-18596
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-multiregionRelated to multi-regionRelated to multi-regionC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-shared-systemsShared Systems TeamShared Systems Team