Spanner is a fully managed, mission-critical database service that brings together relational, graph, key-value, and search. Spanner offers transactional consistency at global scale, automatic, synchronous replication for high availability, and support for the following SQL dialects:
- GoogleSQL
- PostgreSQL
For more information, see Instances overview.
This document describes the parameters you can configure when using App Design Center to create a Spanner instance.
Required configuration parameters
If your template includes a Spanner component, you must configure the following parameters before you deploy.
Feature |
Parameter name |
Description and constraints |
Background information |
---|---|---|---|
Project ID |
The project where you want to deploy the Spanner instance. |
Configure components | |
Instance Name |
A unique identifier for the instance, which cannot be changed after the instance is created. The name must be between 6 and 30 characters in length. | name | |
Instance Config |
config | Instance configurations |
Optional configuration parameters
The following parameters are optional. To display advanced parameters, in the Configuration area, select Show advanced fields.
Feature |
Parameter name |
Description and constraint information |
Background information |
---|---|---|---|
Instance Size | Num Nodes |
nodeCount | Compute capacity, nodes and processing units |
Processing Units |
processingUnits | Compute capacity, nodes and processing units | |
Instance Display Name |
displayName | Change the display name | |
Create Instance |
By default, a new Spanner instance is created. Clear the checkbox to use an existing instance. | Create and manage instances | |
Enable Autoscaling |
Select to enable autoscaling on the Spanner instance. | Autoscaling overview | |
Instance IAM |
A comma-separated list of permissions on the instance. For example, user:user1@cymbalgroup.com=>roles/spanner.databaseAdmin, user:user2@cymbalgroup.com=>roles/spanner.databaseAdmin |
IAM overview | |
Instance Labels | Key |
labels | Label an instance |
Value |
labels | Label an instance | |
Database Config | Key |
The database_config map object key. |
database_config |
Version Retention Period |
versionRetentionPeriod | Point-in-time (PITR) recovery overview | |
DDL |
ddl | GoogleSQL or PostgreSQL | |
KMS Key Name |
kmsKeyName | Customer-managed encryption keys (CMEK) overview | |
Deletion Protection |
Select to prevent Terraform from deleting the database. | deletion_protection | |
Database IAM |
A comma-separated list of permissions on the database. For example, user:user1@cymbalgroup.com=>roles/spanner.databaseAdmin, user:user2@cymbalgroup.com=>roles/spanner.databaseAdmin |
IAM overview | |
Enable Backup |
By default, an automated database backup is created. If you don't want a backup, clear the checkbox. | Backups overview | |
Backup Retention |
retentionDuration | Incremental backups | |
Create DB |
By default, a database is created. If you don't want a database, clear the checkbox. | Databases overview | |
Cron Spec Text |
text | Create and manage backup schedules | |
Min Processing Units |
minProcessingUnits | Managed autoscaler | |
Max Processing Units |
maxProcessingUnits | Managed autoscaler | |
Min Nodes |
minNodes | Managed autoscaler | |
Max Nodes |
maxNodes | Managed autoscaler | |
High Priority CPU Utilization Percent |
highPriorityCpuUtilizationPercent | Managed autoscaler | |
Storage Utilization Percent |
storageUtilizationPercent | Managed autoscaler | |
Replica Location |
location | Asymmetric read-only autoscaling | |
Override Min Nodes |
AutoscalingConfigOverrides | Managed autoscaler parameters | |
Override Max Nodes |
AutoscalingConfigOverrides | Managed autoscaler parameters | |
Edition |
Edition | Spanner editions overview | |
Default Backup Schedule Type |
defaultBackupScheduleType | Default backup schedules | |
Force Destroy |
Select to delete backups when you delete the Spanner instance. | force_destroy | |
Use Full Backup Spec |
fullBackupSpec | Backup schedules | |
Use Incremental Backup Spec |
incrementalBackupSpec | Incremental backups |