-
Notifications
You must be signed in to change notification settings - Fork 84
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Improve CRDB storage performance #1033
Comments
The default is indeed In the meantime, this can be configured depending on the deployment strategy: TerraformThe storage class can be set using the terraform variable TankaAs documented here, the storage class can be configured using the field HelmThe storage class can be defined using Helm Chart value: |
Is your feature request related to a problem? Please describe.
A production GCP deployment was observed having relatively high request completion latency and was root-caused to likely be due to the storage type used for CockroachDB.
Cockroach Labs recommends the use of
pd-ssd
storage to avoid performance bottlenecks due to slow random-access storage. Thepd-standard
disks used for thestandard
storage class in GCP are intended for more traditional append-only / sequential read workloads, but we currently use thestandard
storage class in our deployment.Describe the solution you'd like
![image](https://private-user-images.githubusercontent.com/11224086/331371060-337f4963-5687-488e-b141-936e6c68efe1.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTg3NjQxMTQsIm5iZiI6MTcxODc2MzgxNCwicGF0aCI6Ii8xMTIyNDA4Ni8zMzEzNzEwNjAtMzM3ZjQ5NjMtNTY4Ny00ODhlLWIxNDEtOTM2ZTZjNjhlZmUxLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA2MTklMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNjE5VDAyMjMzNFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWFjNGExMDcxZTE2NjU4MjE2YWQxYmU2YTc1MTJhNTJhNGQ3ZjQzNjVlYmY2MjY1MTRkNGYzM2JmN2VhYjM5NTkmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.EQdjMEro3o1Jrxq3A31d8dCJhY16HY4mqbGsrA5IE44)
Add a deployment configuration option to select the storage class to be used for CockroachDB nodes (all other deployment components can probably keep the
standard
storage class), default topremium-rwo
(which selectspd-ssd
disks), and document thatstandard
orstandard-rwo
can be selected for cost savings.Describe alternatives you've considered
We could hardcode the recommended storage solution to match Cockroach Labs' recommendation, but a configurable variable would allow us to serve more use cases, especially R&D instances with low performance needs but high cost sensitivity.
The text was updated successfully, but these errors were encountered: