Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Tencentcloud Provider
  3. API Docs
  4. SqlserverConfigInstanceRoGroup
tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack
tencentcloudstack/terraform-provider-tencentcloud

tencentcloud.SqlserverConfigInstanceRoGroup

Explore with Pulumi AI

tencentcloud logo
tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack
tencentcloudstack/terraform-provider-tencentcloud

    Provides a resource to create a sqlserver config_instance_ro_group

    Example Usage

    Coming soon!

    Coming soon!

    Coming soon!

    Coming soon!

    Coming soon!

    resources:
  vpc:
    type: tencentcloud:Vpc
    properties:
      cidrBlock: 10.0.0.0/16
  subnet:
    type: tencentcloud:Subnet
    properties:
      availabilityZone: ${zones.zones[4].name}
      vpcId: ${vpc.vpcId}
      cidrBlock: 10.0.0.0/16
      isMulticast: false
  securityGroup:
    type: tencentcloud:SecurityGroup
    properties:
      description: desc.
  exampleSqlserverBasicInstance:
    type: tencentcloud:SqlserverBasicInstance
    properties:
      availabilityZone: ${zones.zones[4].name}
      chargeType: POSTPAID_BY_HOUR
      vpcId: ${vpc.vpcId}
      subnetId: ${subnet.subnetId}
      projectId: 0
      memory: 4
      storage: 100
      cpu: 2
      machineType: CLOUD_PREMIUM
      maintenanceWeekSets:
        - 1
        - 2
        - 3
      maintenanceStartTime: 09:00
      maintenanceTimeSpan: 3
      securityGroups:
        - ${securityGroup.securityGroupId}
      tags:
        test: test
  exampleSqlserverReadonlyInstance:
    type: tencentcloud:SqlserverReadonlyInstance
    properties:
      availabilityZone: ${zones.zones[4].name}
      chargeType: POSTPAID_BY_HOUR
      vpcId: ${vpc.vpcId}
      subnetId: ${subnet.subnetId}
      memory: 4
      storage: 20
      masterInstanceId: ${exampleSqlserverBasicInstance.sqlserverBasicInstanceId}
      readonlyGroupType: 2
      readOnlyGroupName: tf_example_ro
      isOfflineDelay: 1
      readOnlyMaxDelayTime: 10
      minReadOnlyInGroup: 0
      forceUpgrade: true
  exampleSqlserverConfigInstanceRoGroup:
    type: tencentcloud:SqlserverConfigInstanceRoGroup
    properties:
      instanceId: ${exampleSqlserverReadonlyInstance.masterInstanceId}
      readOnlyGroupId: ${exampleSqlserverReadonlyInstance.readonlyGroupId}
      readOnlyGroupName: tf_example_ro_update
      isOfflineDelay: 1
      readOnlyMaxDelayTime: 5
      minReadOnlyInGroup: 1
variables:
  zones:
    fn::invoke:
      function: tencentcloud:getAvailabilityZonesByProduct
      arguments:
        product: sqlserver

    Create SqlserverConfigInstanceRoGroup Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new SqlserverConfigInstanceRoGroup(name: string, args: SqlserverConfigInstanceRoGroupArgs, opts?: CustomResourceOptions);
    @overload
def SqlserverConfigInstanceRoGroup(resource_name: str,
                                   args: SqlserverConfigInstanceRoGroupArgs,
                                   opts: Optional[ResourceOptions] = None)

@overload
def SqlserverConfigInstanceRoGroup(resource_name: str,
                                   opts: Optional[ResourceOptions] = None,
                                   instance_id: Optional[str] = None,
                                   read_only_group_id: Optional[str] = None,
                                   auto_weight: Optional[float] = None,
                                   balance_weight: Optional[float] = None,
                                   is_offline_delay: Optional[float] = None,
                                   min_read_only_in_group: Optional[float] = None,
                                   read_only_group_name: Optional[str] = None,
                                   read_only_max_delay_time: Optional[float] = None,
                                   sqlserver_config_instance_ro_group_id: Optional[str] = None,
                                   weight_pairs: Optional[Sequence[SqlserverConfigInstanceRoGroupWeightPairArgs]] = None)
    func NewSqlserverConfigInstanceRoGroup(ctx *Context, name string, args SqlserverConfigInstanceRoGroupArgs, opts ...ResourceOption) (*SqlserverConfigInstanceRoGroup, error)
    public SqlserverConfigInstanceRoGroup(string name, SqlserverConfigInstanceRoGroupArgs args, CustomResourceOptions? opts = null)
    public SqlserverConfigInstanceRoGroup(String name, SqlserverConfigInstanceRoGroupArgs args)
public SqlserverConfigInstanceRoGroup(String name, SqlserverConfigInstanceRoGroupArgs args, CustomResourceOptions options)

    type: tencentcloud:SqlserverConfigInstanceRoGroup
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

    Parameters

    name string
    The unique name of the resource.
    args SqlserverConfigInstanceRoGroupArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args SqlserverConfigInstanceRoGroupArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args SqlserverConfigInstanceRoGroupArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args SqlserverConfigInstanceRoGroupArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args SqlserverConfigInstanceRoGroupArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    SqlserverConfigInstanceRoGroup Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

    The SqlserverConfigInstanceRoGroup resource accepts the following input properties:

    InstanceId string
    Instance ID.
    ReadOnlyGroupId string
    Read-only group ID.
    AutoWeight double
    0-user-defined weight (adjusted according to WeightPairs), 1-system automatically assigns weight (WeightPairs is invalid), the default is 0.
    BalanceWeight double
    0-do not rebalance the load, 1-rebalance the load, the default is 0.
    IsOfflineDelay double
    Whether to enable timeout culling function. 0- Disable the culling function. 1- Enable the culling function.
    MinReadOnlyInGroup double
    After the timeout removal function is enabled, the number of read-only copies retained by the read-only group at least, if this parameter is not filled, it will not be modified.
    ReadOnlyGroupName string
    Read-only group name. If this parameter is not specified, it is not modified.
    ReadOnlyMaxDelayTime double
    After the timeout elimination function is enabled, the timeout threshold used, if this parameter is not filled, it will not be modified.
    SqlserverConfigInstanceRoGroupId string
    ID of the resource.
    WeightPairs List<SqlserverConfigInstanceRoGroupWeightPair>
    Read-only group instance weight modification set, if this parameter is not filled, it will not be modified.
    InstanceId string
    Instance ID.
    ReadOnlyGroupId string
    Read-only group ID.
    AutoWeight float64
    0-user-defined weight (adjusted according to WeightPairs), 1-system automatically assigns weight (WeightPairs is invalid), the default is 0.
    BalanceWeight float64
    0-do not rebalance the load, 1-rebalance the load, the default is 0.
    IsOfflineDelay float64
    Whether to enable timeout culling function. 0- Disable the culling function. 1- Enable the culling function.
    MinReadOnlyInGroup float64
    After the timeout removal function is enabled, the number of read-only copies retained by the read-only group at least, if this parameter is not filled, it will not be modified.
    ReadOnlyGroupName string
    Read-only group name. If this parameter is not specified, it is not modified.
    ReadOnlyMaxDelayTime float64
    After the timeout elimination function is enabled, the timeout threshold used, if this parameter is not filled, it will not be modified.
    SqlserverConfigInstanceRoGroupId string
    ID of the resource.
    WeightPairs []SqlserverConfigInstanceRoGroupWeightPairArgs
    Read-only group instance weight modification set, if this parameter is not filled, it will not be modified.
    instanceId String
    Instance ID.
    readOnlyGroupId String
    Read-only group ID.
    autoWeight Double
    0-user-defined weight (adjusted according to WeightPairs), 1-system automatically assigns weight (WeightPairs is invalid), the default is 0.
    balanceWeight Double
    0-do not rebalance the load, 1-rebalance the load, the default is 0.
    isOfflineDelay Double
    Whether to enable timeout culling function. 0- Disable the culling function. 1- Enable the culling function.
    minReadOnlyInGroup Double
    After the timeout removal function is enabled, the number of read-only copies retained by the read-only group at least, if this parameter is not filled, it will not be modified.
    readOnlyGroupName String
    Read-only group name. If this parameter is not specified, it is not modified.
    readOnlyMaxDelayTime Double
    After the timeout elimination function is enabled, the timeout threshold used, if this parameter is not filled, it will not be modified.
    sqlserverConfigInstanceRoGroupId String
    ID of the resource.
    weightPairs List<SqlserverConfigInstanceRoGroupWeightPair>
    Read-only group instance weight modification set, if this parameter is not filled, it will not be modified.
    instanceId string
    Instance ID.
    readOnlyGroupId string
    Read-only group ID.
    autoWeight number
    0-user-defined weight (adjusted according to WeightPairs), 1-system automatically assigns weight (WeightPairs is invalid), the default is 0.
    balanceWeight number
    0-do not rebalance the load, 1-rebalance the load, the default is 0.
    isOfflineDelay number
    Whether to enable timeout culling function. 0- Disable the culling function. 1- Enable the culling function.
    minReadOnlyInGroup number
    After the timeout removal function is enabled, the number of read-only copies retained by the read-only group at least, if this parameter is not filled, it will not be modified.
    readOnlyGroupName string
    Read-only group name. If this parameter is not specified, it is not modified.
    readOnlyMaxDelayTime number
    After the timeout elimination function is enabled, the timeout threshold used, if this parameter is not filled, it will not be modified.
    sqlserverConfigInstanceRoGroupId string
    ID of the resource.
    weightPairs SqlserverConfigInstanceRoGroupWeightPair[]
    Read-only group instance weight modification set, if this parameter is not filled, it will not be modified.
    instance_id str
    Instance ID.
    read_only_group_id str
    Read-only group ID.
    auto_weight float
    0-user-defined weight (adjusted according to WeightPairs), 1-system automatically assigns weight (WeightPairs is invalid), the default is 0.
    balance_weight float
    0-do not rebalance the load, 1-rebalance the load, the default is 0.
    is_offline_delay float
    Whether to enable timeout culling function. 0- Disable the culling function. 1- Enable the culling function.
    min_read_only_in_group float
    After the timeout removal function is enabled, the number of read-only copies retained by the read-only group at least, if this parameter is not filled, it will not be modified.
    read_only_group_name str
    Read-only group name. If this parameter is not specified, it is not modified.
    read_only_max_delay_time float
    After the timeout elimination function is enabled, the timeout threshold used, if this parameter is not filled, it will not be modified.
    sqlserver_config_instance_ro_group_id str
    ID of the resource.
    weight_pairs Sequence[SqlserverConfigInstanceRoGroupWeightPairArgs]
    Read-only group instance weight modification set, if this parameter is not filled, it will not be modified.
    instanceId String
    Instance ID.
    readOnlyGroupId String
    Read-only group ID.
    autoWeight Number
    0-user-defined weight (adjusted according to WeightPairs), 1-system automatically assigns weight (WeightPairs is invalid), the default is 0.
    balanceWeight Number
    0-do not rebalance the load, 1-rebalance the load, the default is 0.
    isOfflineDelay Number
    Whether to enable timeout culling function. 0- Disable the culling function. 1- Enable the culling function.
    minReadOnlyInGroup Number
    After the timeout removal function is enabled, the number of read-only copies retained by the read-only group at least, if this parameter is not filled, it will not be modified.
    readOnlyGroupName String
    Read-only group name. If this parameter is not specified, it is not modified.
    readOnlyMaxDelayTime Number
    After the timeout elimination function is enabled, the timeout threshold used, if this parameter is not filled, it will not be modified.
    sqlserverConfigInstanceRoGroupId String
    ID of the resource.
    weightPairs List<Property Map>
    Read-only group instance weight modification set, if this parameter is not filled, it will not be modified.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the SqlserverConfigInstanceRoGroup resource produces the following output properties:

    Id string
    The provider-assigned unique ID for this managed resource.
    Id string
    The provider-assigned unique ID for this managed resource.
    id String
    The provider-assigned unique ID for this managed resource.
    id string
    The provider-assigned unique ID for this managed resource.
    id str
    The provider-assigned unique ID for this managed resource.
    id String
    The provider-assigned unique ID for this managed resource.

    Look up Existing SqlserverConfigInstanceRoGroup Resource

    Get an existing SqlserverConfigInstanceRoGroup resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: SqlserverConfigInstanceRoGroupState, opts?: CustomResourceOptions): SqlserverConfigInstanceRoGroup
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        auto_weight: Optional[float] = None,
        balance_weight: Optional[float] = None,
        instance_id: Optional[str] = None,
        is_offline_delay: Optional[float] = None,
        min_read_only_in_group: Optional[float] = None,
        read_only_group_id: Optional[str] = None,
        read_only_group_name: Optional[str] = None,
        read_only_max_delay_time: Optional[float] = None,
        sqlserver_config_instance_ro_group_id: Optional[str] = None,
        weight_pairs: Optional[Sequence[SqlserverConfigInstanceRoGroupWeightPairArgs]] = None) -> SqlserverConfigInstanceRoGroup
    func GetSqlserverConfigInstanceRoGroup(ctx *Context, name string, id IDInput, state *SqlserverConfigInstanceRoGroupState, opts ...ResourceOption) (*SqlserverConfigInstanceRoGroup, error)
    public static SqlserverConfigInstanceRoGroup Get(string name, Input<string> id, SqlserverConfigInstanceRoGroupState? state, CustomResourceOptions? opts = null)
    public static SqlserverConfigInstanceRoGroup get(String name, Output<String> id, SqlserverConfigInstanceRoGroupState state, CustomResourceOptions options)
    resources:  _:    type: tencentcloud:SqlserverConfigInstanceRoGroup    get:      id: ${id}
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    AutoWeight double
    0-user-defined weight (adjusted according to WeightPairs), 1-system automatically assigns weight (WeightPairs is invalid), the default is 0.
    BalanceWeight double
    0-do not rebalance the load, 1-rebalance the load, the default is 0.
    InstanceId string
    Instance ID.
    IsOfflineDelay double
    Whether to enable timeout culling function. 0- Disable the culling function. 1- Enable the culling function.
    MinReadOnlyInGroup double
    After the timeout removal function is enabled, the number of read-only copies retained by the read-only group at least, if this parameter is not filled, it will not be modified.
    ReadOnlyGroupId string
    Read-only group ID.
    ReadOnlyGroupName string
    Read-only group name. If this parameter is not specified, it is not modified.
    ReadOnlyMaxDelayTime double
    After the timeout elimination function is enabled, the timeout threshold used, if this parameter is not filled, it will not be modified.
    SqlserverConfigInstanceRoGroupId string
    ID of the resource.
    WeightPairs List<SqlserverConfigInstanceRoGroupWeightPair>
    Read-only group instance weight modification set, if this parameter is not filled, it will not be modified.
    AutoWeight float64
    0-user-defined weight (adjusted according to WeightPairs), 1-system automatically assigns weight (WeightPairs is invalid), the default is 0.
    BalanceWeight float64
    0-do not rebalance the load, 1-rebalance the load, the default is 0.
    InstanceId string
    Instance ID.
    IsOfflineDelay float64
    Whether to enable timeout culling function. 0- Disable the culling function. 1- Enable the culling function.
    MinReadOnlyInGroup float64
    After the timeout removal function is enabled, the number of read-only copies retained by the read-only group at least, if this parameter is not filled, it will not be modified.
    ReadOnlyGroupId string
    Read-only group ID.
    ReadOnlyGroupName string
    Read-only group name. If this parameter is not specified, it is not modified.
    ReadOnlyMaxDelayTime float64
    After the timeout elimination function is enabled, the timeout threshold used, if this parameter is not filled, it will not be modified.
    SqlserverConfigInstanceRoGroupId string
    ID of the resource.
    WeightPairs []SqlserverConfigInstanceRoGroupWeightPairArgs
    Read-only group instance weight modification set, if this parameter is not filled, it will not be modified.
    autoWeight Double
    0-user-defined weight (adjusted according to WeightPairs), 1-system automatically assigns weight (WeightPairs is invalid), the default is 0.
    balanceWeight Double
    0-do not rebalance the load, 1-rebalance the load, the default is 0.
    instanceId String
    Instance ID.
    isOfflineDelay Double
    Whether to enable timeout culling function. 0- Disable the culling function. 1- Enable the culling function.
    minReadOnlyInGroup Double
    After the timeout removal function is enabled, the number of read-only copies retained by the read-only group at least, if this parameter is not filled, it will not be modified.
    readOnlyGroupId String
    Read-only group ID.
    readOnlyGroupName String
    Read-only group name. If this parameter is not specified, it is not modified.
    readOnlyMaxDelayTime Double
    After the timeout elimination function is enabled, the timeout threshold used, if this parameter is not filled, it will not be modified.
    sqlserverConfigInstanceRoGroupId String
    ID of the resource.
    weightPairs List<SqlserverConfigInstanceRoGroupWeightPair>
    Read-only group instance weight modification set, if this parameter is not filled, it will not be modified.
    autoWeight number
    0-user-defined weight (adjusted according to WeightPairs), 1-system automatically assigns weight (WeightPairs is invalid), the default is 0.
    balanceWeight number
    0-do not rebalance the load, 1-rebalance the load, the default is 0.
    instanceId string
    Instance ID.
    isOfflineDelay number
    Whether to enable timeout culling function. 0- Disable the culling function. 1- Enable the culling function.
    minReadOnlyInGroup number
    After the timeout removal function is enabled, the number of read-only copies retained by the read-only group at least, if this parameter is not filled, it will not be modified.
    readOnlyGroupId string
    Read-only group ID.
    readOnlyGroupName string
    Read-only group name. If this parameter is not specified, it is not modified.
    readOnlyMaxDelayTime number
    After the timeout elimination function is enabled, the timeout threshold used, if this parameter is not filled, it will not be modified.
    sqlserverConfigInstanceRoGroupId string
    ID of the resource.
    weightPairs SqlserverConfigInstanceRoGroupWeightPair[]
    Read-only group instance weight modification set, if this parameter is not filled, it will not be modified.
    auto_weight float
    0-user-defined weight (adjusted according to WeightPairs), 1-system automatically assigns weight (WeightPairs is invalid), the default is 0.
    balance_weight float
    0-do not rebalance the load, 1-rebalance the load, the default is 0.
    instance_id str
    Instance ID.
    is_offline_delay float
    Whether to enable timeout culling function. 0- Disable the culling function. 1- Enable the culling function.
    min_read_only_in_group float
    After the timeout removal function is enabled, the number of read-only copies retained by the read-only group at least, if this parameter is not filled, it will not be modified.
    read_only_group_id str
    Read-only group ID.
    read_only_group_name str
    Read-only group name. If this parameter is not specified, it is not modified.
    read_only_max_delay_time float
    After the timeout elimination function is enabled, the timeout threshold used, if this parameter is not filled, it will not be modified.
    sqlserver_config_instance_ro_group_id str
    ID of the resource.
    weight_pairs Sequence[SqlserverConfigInstanceRoGroupWeightPairArgs]
    Read-only group instance weight modification set, if this parameter is not filled, it will not be modified.
    autoWeight Number
    0-user-defined weight (adjusted according to WeightPairs), 1-system automatically assigns weight (WeightPairs is invalid), the default is 0.
    balanceWeight Number
    0-do not rebalance the load, 1-rebalance the load, the default is 0.
    instanceId String
    Instance ID.
    isOfflineDelay Number
    Whether to enable timeout culling function. 0- Disable the culling function. 1- Enable the culling function.
    minReadOnlyInGroup Number
    After the timeout removal function is enabled, the number of read-only copies retained by the read-only group at least, if this parameter is not filled, it will not be modified.
    readOnlyGroupId String
    Read-only group ID.
    readOnlyGroupName String
    Read-only group name. If this parameter is not specified, it is not modified.
    readOnlyMaxDelayTime Number
    After the timeout elimination function is enabled, the timeout threshold used, if this parameter is not filled, it will not be modified.
    sqlserverConfigInstanceRoGroupId String
    ID of the resource.
    weightPairs List<Property Map>
    Read-only group instance weight modification set, if this parameter is not filled, it will not be modified.

    Supporting Types

    SqlserverConfigInstanceRoGroupWeightPair, SqlserverConfigInstanceRoGroupWeightPairArgs

    ReadOnlyInstanceId string
    Read-only instance ID, in the format: mssqlro-3l3fgqn7.
    ReadOnlyWeight double
    Read-only instance weight, the range is 0-100.
    ReadOnlyInstanceId string
    Read-only instance ID, in the format: mssqlro-3l3fgqn7.
    ReadOnlyWeight float64
    Read-only instance weight, the range is 0-100.
    readOnlyInstanceId String
    Read-only instance ID, in the format: mssqlro-3l3fgqn7.
    readOnlyWeight Double
    Read-only instance weight, the range is 0-100.
    readOnlyInstanceId string
    Read-only instance ID, in the format: mssqlro-3l3fgqn7.
    readOnlyWeight number
    Read-only instance weight, the range is 0-100.
    read_only_instance_id str
    Read-only instance ID, in the format: mssqlro-3l3fgqn7.
    read_only_weight float
    Read-only instance weight, the range is 0-100.
    readOnlyInstanceId String
    Read-only instance ID, in the format: mssqlro-3l3fgqn7.
    readOnlyWeight Number
    Read-only instance weight, the range is 0-100.

    Import

    sqlserver config_instance_ro_group can be imported using the id, e.g.

    $ pulumi import tencentcloud:index/sqlserverConfigInstanceRoGroup:SqlserverConfigInstanceRoGroup example mssql-ds1xhnt9#mssqlro-o6dv2ugx#0#0

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    tencentcloud tencentcloudstack/terraform-provider-tencentcloud
    License
    Notes
    This Pulumi package is based on the tencentcloud Terraform Provider.
    tencentcloud logo
    tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack
    tencentcloudstack/terraform-provider-tencentcloud