instances_secondary

Creates, updates, deletes, gets or lists a instances_secondary resource.

Overview

Name	instances_secondary
Type	Resource
Id	google.alloydb.instances_secondary

Fields

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

Name	Accessible by	Required Params	Description
createsecondary	INSERT	clustersId, locationsId, projectsId	Creates a new SECONDARY Instance in a given project and location.

INSERT example

Use the following StackQL query and manifest file to create a new instances_secondary resource.

All Properties

/*+ create */
INSERT INTO google.alloydb.instances_secondary (
clustersId,
locationsId,
projectsId,
displayName,
labels,
instanceType,
machineConfig,
availabilityType,
gceZone,
databaseFlags,
queryInsightsConfig,
readPoolConfig,
etag,
annotations,
clientConnectionConfig,
pscInstanceConfig,
networkConfig
)
SELECT 
'{{ clustersId }}',
'{{ locationsId }}',
'{{ projectsId }}',
'{{ displayName }}',
'{{ labels }}',
'{{ instanceType }}',
'{{ machineConfig }}',
'{{ availabilityType }}',
'{{ gceZone }}',
'{{ databaseFlags }}',
'{{ queryInsightsConfig }}',
'{{ readPoolConfig }}',
'{{ etag }}',
'{{ annotations }}',
'{{ clientConnectionConfig }}',
'{{ pscInstanceConfig }}',
'{{ networkConfig }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: displayName
      value: '{{ displayName }}'
    - name: labels
      value: '{{ labels }}'
    - name: instanceType
      value: '{{ instanceType }}'
    - name: machineConfig
      value:
        - name: cpuCount
          value: '{{ cpuCount }}'
    - name: availabilityType
      value: '{{ availabilityType }}'
    - name: gceZone
      value: '{{ gceZone }}'
    - name: databaseFlags
      value: '{{ databaseFlags }}'
    - name: queryInsightsConfig
      value:
        - name: recordApplicationTags
          value: '{{ recordApplicationTags }}'
        - name: recordClientAddress
          value: '{{ recordClientAddress }}'
        - name: queryStringLength
          value: '{{ queryStringLength }}'
        - name: queryPlansPerMinute
          value: '{{ queryPlansPerMinute }}'
    - name: readPoolConfig
      value:
        - name: nodeCount
          value: '{{ nodeCount }}'
    - name: etag
      value: '{{ etag }}'
    - name: annotations
      value: '{{ annotations }}'
    - name: clientConnectionConfig
      value:
        - name: requireConnectors
          value: '{{ requireConnectors }}'
        - name: sslConfig
          value:
            - name: sslMode
              value: '{{ sslMode }}'
            - name: caSource
              value: '{{ caSource }}'
    - name: pscInstanceConfig
      value:
        - name: allowedConsumerProjects
          value:
            - name: type
              value: '{{ type }}'
    - name: networkConfig
      value:
        - name: authorizedExternalNetworks
          value:
            - name: $ref
              value: '{{ $ref }}'
        - name: enablePublicIp
          value: '{{ enablePublicIp }}'
        - name: enableOutboundPublicIp
          value: '{{ enableOutboundPublicIp }}'