This topic describes the features that are either unsupported or partially supported in some CockroachDB Cloud plans.
Change data capture
You can't collect metrics per changefeed or configure alerts on changefeeds for CockroachDB Basic and Standard clusters.
Backups
CockroachDB Basic and Standard clusters only support automated full backups. Automated incremental and revision history backups are not supported. However, you can take manual incremental and revision history backups to your own storage location.
Automated database and table level backups are not supported in CockroachDB CockroachDB Basic and Standard. However, you can take manual database and table level backups to your own storage location.
CockroachDB Basic, Standard, and Advanced clusters do not support automated locality-aware backups. However, you can take manual locality-aware backups to your own cloud storage location.
CockroachDB Basic and Standard clusters operate with a different architecture compared to CockroachDB Self-Hosted and CockroachDB Advanced clusters. These architectural differences have implications for how locality-aware backups can run. Basic and Standard clusters will scale resources depending on whether they are actively in use, which means that it is less likely to have a SQL pod available in every locality. As a result, your cluster may not have a SQL pod in the locality where the data resides, which can lead to the cluster uploading that data to a storage bucket in a locality where you do have active SQL pods. You should consider this as you plan a backup strategy that must comply with data domiciling requirements.
Adding and removing regions
You cannot currently edit an existing CockroachDB Basic and Standard to remove regions after it has been created. Instead you can back up and restore your data into a new CockroachDB Basic or Standard cluster with the desired region configuration.
Range management
The ALTER TABLE ... SPLIT AT and ALTER RANGE ... RELOCATE statements are not supported in CockroachDB Basic and Standard clusters.
Self service upgrades
CockroachDB Basic and Standard are fully managed multi-tenant deployments of CockroachDB. Major and patch upgrades of CockroachDB are handled by Cockroach Labs, and can't be initiated by users.
Monitoring workloads and cluster health
The DB Console is not supported in CockroachDB Basic and Standard. The CockroachDB Cloud Console provides metrics and graphs to monitor the health, performance, and state of your cluster.
The Cloud Console provides a subset of observability information from the DB Console including Metrics, SQL Activity, Jobs, and Databases information. The Cloud Console does not include information from the following DB Console pages:
- Non-SQL metrics
- Network Latency
- Hot ranges
- Advanced Debug
The Cloud Console also does not currently provide the following features available in the DB Console:
- Direct actions to drop unused indexes on the Insights and Databases pages
- Direct actions to create missing indexes and replace existing indexes on the Insights page
CockroachDB Basic and Standard clusters do not expose Prometheus endpoints.
Audit logs
There is no self-service way of accessing audit logs for CockroachDB Basic and Standard clusters. If you are running production workloads and need access to audit logs, contact Cockroach Labs Support.
Encryption
Cluster storage for CockroachDB Basic and Standard is encrypted at rest by the cloud provider. Customer-managed encryption keys (CMEK) are not supported in CockroachDB Basic and Standard. CMEK is available only in CockroachDB Advanced with security add-ons enabled.
Network security
Private clusters, compliance with PCI DSS, and compliance with HIPAA are not supported in Basic and Standard. These features are available only in CockroachDB Advanced with security add-ons enabled.
Was this helpful?
