1. Packages
  2. Tencentcloud Provider
  3. API Docs
  4. MysqlIsolateInstance
tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack

tencentcloud.MysqlIsolateInstance

Explore with Pulumi AI

tencentcloud logo
tencentcloud 1.81.189 published on Wednesday, Apr 30, 2025 by tencentcloudstack

    Provides a resource to create a mysql isolate_instance

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as tencentcloud from "@pulumi/tencentcloud";
    
    const zones = tencentcloud.getAvailabilityZonesByProduct({
        product: "cdb",
    });
    const vpc = new tencentcloud.Vpc("vpc", {cidrBlock: "10.0.0.0/16"});
    const subnet = new tencentcloud.Subnet("subnet", {
        availabilityZone: zones.then(zones => zones.zones?.[0]?.name),
        vpcId: vpc.vpcId,
        cidrBlock: "10.0.0.0/16",
        isMulticast: false,
    });
    const securityGroup = new tencentcloud.SecurityGroup("securityGroup", {description: "mysql test"});
    const exampleMysqlInstance = new tencentcloud.MysqlInstance("exampleMysqlInstance", {
        internetService: 1,
        engineVersion: "5.7",
        chargeType: "POSTPAID",
        rootPassword: "PassWord123",
        slaveDeployMode: 0,
        availabilityZone: zones.then(zones => zones.zones?.[0]?.name),
        slaveSyncMode: 1,
        instanceName: "tf-example-mysql",
        memSize: 4000,
        volumeSize: 200,
        vpcId: vpc.vpcId,
        subnetId: subnet.subnetId,
        intranetPort: 3306,
        securityGroups: [securityGroup.securityGroupId],
        tags: {
            name: "test",
        },
        parameters: {
            character_set_server: "utf8",
            max_connections: "1000",
        },
    });
    const exampleMysqlIsolateInstance = new tencentcloud.MysqlIsolateInstance("exampleMysqlIsolateInstance", {
        instanceId: exampleMysqlInstance.mysqlInstanceId,
        operate: "recover",
    });
    
    import pulumi
    import pulumi_tencentcloud as tencentcloud
    
    zones = tencentcloud.get_availability_zones_by_product(product="cdb")
    vpc = tencentcloud.Vpc("vpc", cidr_block="10.0.0.0/16")
    subnet = tencentcloud.Subnet("subnet",
        availability_zone=zones.zones[0].name,
        vpc_id=vpc.vpc_id,
        cidr_block="10.0.0.0/16",
        is_multicast=False)
    security_group = tencentcloud.SecurityGroup("securityGroup", description="mysql test")
    example_mysql_instance = tencentcloud.MysqlInstance("exampleMysqlInstance",
        internet_service=1,
        engine_version="5.7",
        charge_type="POSTPAID",
        root_password="PassWord123",
        slave_deploy_mode=0,
        availability_zone=zones.zones[0].name,
        slave_sync_mode=1,
        instance_name="tf-example-mysql",
        mem_size=4000,
        volume_size=200,
        vpc_id=vpc.vpc_id,
        subnet_id=subnet.subnet_id,
        intranet_port=3306,
        security_groups=[security_group.security_group_id],
        tags={
            "name": "test",
        },
        parameters={
            "character_set_server": "utf8",
            "max_connections": "1000",
        })
    example_mysql_isolate_instance = tencentcloud.MysqlIsolateInstance("exampleMysqlIsolateInstance",
        instance_id=example_mysql_instance.mysql_instance_id,
        operate="recover")
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-terraform-provider/sdks/go/tencentcloud/tencentcloud"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		zones, err := tencentcloud.GetAvailabilityZonesByProduct(ctx, &tencentcloud.GetAvailabilityZonesByProductArgs{
    			Product: "cdb",
    		}, nil)
    		if err != nil {
    			return err
    		}
    		vpc, err := tencentcloud.NewVpc(ctx, "vpc", &tencentcloud.VpcArgs{
    			CidrBlock: pulumi.String("10.0.0.0/16"),
    		})
    		if err != nil {
    			return err
    		}
    		subnet, err := tencentcloud.NewSubnet(ctx, "subnet", &tencentcloud.SubnetArgs{
    			AvailabilityZone: pulumi.String(zones.Zones[0].Name),
    			VpcId:            vpc.VpcId,
    			CidrBlock:        pulumi.String("10.0.0.0/16"),
    			IsMulticast:      pulumi.Bool(false),
    		})
    		if err != nil {
    			return err
    		}
    		securityGroup, err := tencentcloud.NewSecurityGroup(ctx, "securityGroup", &tencentcloud.SecurityGroupArgs{
    			Description: pulumi.String("mysql test"),
    		})
    		if err != nil {
    			return err
    		}
    		exampleMysqlInstance, err := tencentcloud.NewMysqlInstance(ctx, "exampleMysqlInstance", &tencentcloud.MysqlInstanceArgs{
    			InternetService:  pulumi.Float64(1),
    			EngineVersion:    pulumi.String("5.7"),
    			ChargeType:       pulumi.String("POSTPAID"),
    			RootPassword:     pulumi.String("PassWord123"),
    			SlaveDeployMode:  pulumi.Float64(0),
    			AvailabilityZone: pulumi.String(zones.Zones[0].Name),
    			SlaveSyncMode:    pulumi.Float64(1),
    			InstanceName:     pulumi.String("tf-example-mysql"),
    			MemSize:          pulumi.Float64(4000),
    			VolumeSize:       pulumi.Float64(200),
    			VpcId:            vpc.VpcId,
    			SubnetId:         subnet.SubnetId,
    			IntranetPort:     pulumi.Float64(3306),
    			SecurityGroups: pulumi.StringArray{
    				securityGroup.SecurityGroupId,
    			},
    			Tags: pulumi.StringMap{
    				"name": pulumi.String("test"),
    			},
    			Parameters: pulumi.StringMap{
    				"character_set_server": pulumi.String("utf8"),
    				"max_connections":      pulumi.String("1000"),
    			},
    		})
    		if err != nil {
    			return err
    		}
    		_, err = tencentcloud.NewMysqlIsolateInstance(ctx, "exampleMysqlIsolateInstance", &tencentcloud.MysqlIsolateInstanceArgs{
    			InstanceId: exampleMysqlInstance.MysqlInstanceId,
    			Operate:    pulumi.String("recover"),
    		})
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Tencentcloud = Pulumi.Tencentcloud;
    
    return await Deployment.RunAsync(() => 
    {
        var zones = Tencentcloud.GetAvailabilityZonesByProduct.Invoke(new()
        {
            Product = "cdb",
        });
    
        var vpc = new Tencentcloud.Vpc("vpc", new()
        {
            CidrBlock = "10.0.0.0/16",
        });
    
        var subnet = new Tencentcloud.Subnet("subnet", new()
        {
            AvailabilityZone = zones.Apply(getAvailabilityZonesByProductResult => getAvailabilityZonesByProductResult.Zones[0]?.Name),
            VpcId = vpc.VpcId,
            CidrBlock = "10.0.0.0/16",
            IsMulticast = false,
        });
    
        var securityGroup = new Tencentcloud.SecurityGroup("securityGroup", new()
        {
            Description = "mysql test",
        });
    
        var exampleMysqlInstance = new Tencentcloud.MysqlInstance("exampleMysqlInstance", new()
        {
            InternetService = 1,
            EngineVersion = "5.7",
            ChargeType = "POSTPAID",
            RootPassword = "PassWord123",
            SlaveDeployMode = 0,
            AvailabilityZone = zones.Apply(getAvailabilityZonesByProductResult => getAvailabilityZonesByProductResult.Zones[0]?.Name),
            SlaveSyncMode = 1,
            InstanceName = "tf-example-mysql",
            MemSize = 4000,
            VolumeSize = 200,
            VpcId = vpc.VpcId,
            SubnetId = subnet.SubnetId,
            IntranetPort = 3306,
            SecurityGroups = new[]
            {
                securityGroup.SecurityGroupId,
            },
            Tags = 
            {
                { "name", "test" },
            },
            Parameters = 
            {
                { "character_set_server", "utf8" },
                { "max_connections", "1000" },
            },
        });
    
        var exampleMysqlIsolateInstance = new Tencentcloud.MysqlIsolateInstance("exampleMysqlIsolateInstance", new()
        {
            InstanceId = exampleMysqlInstance.MysqlInstanceId,
            Operate = "recover",
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.tencentcloud.TencentcloudFunctions;
    import com.pulumi.tencentcloud.inputs.GetAvailabilityZonesByProductArgs;
    import com.pulumi.tencentcloud.Vpc;
    import com.pulumi.tencentcloud.VpcArgs;
    import com.pulumi.tencentcloud.Subnet;
    import com.pulumi.tencentcloud.SubnetArgs;
    import com.pulumi.tencentcloud.SecurityGroup;
    import com.pulumi.tencentcloud.SecurityGroupArgs;
    import com.pulumi.tencentcloud.MysqlInstance;
    import com.pulumi.tencentcloud.MysqlInstanceArgs;
    import com.pulumi.tencentcloud.MysqlIsolateInstance;
    import com.pulumi.tencentcloud.MysqlIsolateInstanceArgs;
    import java.util.List;
    import java.util.ArrayList;
    import java.util.Map;
    import java.io.File;
    import java.nio.file.Files;
    import java.nio.file.Paths;
    
    public class App {
        public static void main(String[] args) {
            Pulumi.run(App::stack);
        }
    
        public static void stack(Context ctx) {
            final var zones = TencentcloudFunctions.getAvailabilityZonesByProduct(GetAvailabilityZonesByProductArgs.builder()
                .product("cdb")
                .build());
    
            var vpc = new Vpc("vpc", VpcArgs.builder()
                .cidrBlock("10.0.0.0/16")
                .build());
    
            var subnet = new Subnet("subnet", SubnetArgs.builder()
                .availabilityZone(zones.applyValue(getAvailabilityZonesByProductResult -> getAvailabilityZonesByProductResult.zones()[0].name()))
                .vpcId(vpc.vpcId())
                .cidrBlock("10.0.0.0/16")
                .isMulticast(false)
                .build());
    
            var securityGroup = new SecurityGroup("securityGroup", SecurityGroupArgs.builder()
                .description("mysql test")
                .build());
    
            var exampleMysqlInstance = new MysqlInstance("exampleMysqlInstance", MysqlInstanceArgs.builder()
                .internetService(1)
                .engineVersion("5.7")
                .chargeType("POSTPAID")
                .rootPassword("PassWord123")
                .slaveDeployMode(0)
                .availabilityZone(zones.applyValue(getAvailabilityZonesByProductResult -> getAvailabilityZonesByProductResult.zones()[0].name()))
                .slaveSyncMode(1)
                .instanceName("tf-example-mysql")
                .memSize(4000)
                .volumeSize(200)
                .vpcId(vpc.vpcId())
                .subnetId(subnet.subnetId())
                .intranetPort(3306)
                .securityGroups(securityGroup.securityGroupId())
                .tags(Map.of("name", "test"))
                .parameters(Map.ofEntries(
                    Map.entry("character_set_server", "utf8"),
                    Map.entry("max_connections", "1000")
                ))
                .build());
    
            var exampleMysqlIsolateInstance = new MysqlIsolateInstance("exampleMysqlIsolateInstance", MysqlIsolateInstanceArgs.builder()
                .instanceId(exampleMysqlInstance.mysqlInstanceId())
                .operate("recover")
                .build());
    
        }
    }
    
    resources:
      vpc:
        type: tencentcloud:Vpc
        properties:
          cidrBlock: 10.0.0.0/16
      subnet:
        type: tencentcloud:Subnet
        properties:
          availabilityZone: ${zones.zones[0].name}
          vpcId: ${vpc.vpcId}
          cidrBlock: 10.0.0.0/16
          isMulticast: false
      securityGroup:
        type: tencentcloud:SecurityGroup
        properties:
          description: mysql test
      exampleMysqlInstance:
        type: tencentcloud:MysqlInstance
        properties:
          internetService: 1
          engineVersion: '5.7'
          chargeType: POSTPAID
          rootPassword: PassWord123
          slaveDeployMode: 0
          availabilityZone: ${zones.zones[0].name}
          slaveSyncMode: 1
          instanceName: tf-example-mysql
          memSize: 4000
          volumeSize: 200
          vpcId: ${vpc.vpcId}
          subnetId: ${subnet.subnetId}
          intranetPort: 3306
          securityGroups:
            - ${securityGroup.securityGroupId}
          tags:
            name: test
          parameters:
            character_set_server: utf8
            max_connections: '1000'
      exampleMysqlIsolateInstance:
        type: tencentcloud:MysqlIsolateInstance
        properties:
          instanceId: ${exampleMysqlInstance.mysqlInstanceId}
          operate: recover
    variables:
      zones:
        fn::invoke:
          function: tencentcloud:getAvailabilityZonesByProduct
          arguments:
            product: cdb
    

    Create MysqlIsolateInstance Resource

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

    Constructor syntax

    new MysqlIsolateInstance(name: string, args: MysqlIsolateInstanceArgs, opts?: CustomResourceOptions);
    @overload
    def MysqlIsolateInstance(resource_name: str,
                             args: MysqlIsolateInstanceArgs,
                             opts: Optional[ResourceOptions] = None)
    
    @overload
    def MysqlIsolateInstance(resource_name: str,
                             opts: Optional[ResourceOptions] = None,
                             instance_id: Optional[str] = None,
                             operate: Optional[str] = None,
                             mysql_isolate_instance_id: Optional[str] = None)
    func NewMysqlIsolateInstance(ctx *Context, name string, args MysqlIsolateInstanceArgs, opts ...ResourceOption) (*MysqlIsolateInstance, error)
    public MysqlIsolateInstance(string name, MysqlIsolateInstanceArgs args, CustomResourceOptions? opts = null)
    public MysqlIsolateInstance(String name, MysqlIsolateInstanceArgs args)
    public MysqlIsolateInstance(String name, MysqlIsolateInstanceArgs args, CustomResourceOptions options)
    
    type: tencentcloud:MysqlIsolateInstance
    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 MysqlIsolateInstanceArgs
    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 MysqlIsolateInstanceArgs
    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 MysqlIsolateInstanceArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args MysqlIsolateInstanceArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args MysqlIsolateInstanceArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    MysqlIsolateInstance 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 MysqlIsolateInstance resource accepts the following input properties:

    InstanceId string
    Instance ID, the format is: cdb-c1nl9rpv, which is the same as the instance ID displayed on the cloud database console page, and you can use the [query instance list] (https://cloud.tencent.com/document/api/236/15872) interface Gets the value of the field InstanceId in the output parameter.
    Operate string
    Manipulate instance, isolate - isolate instance, recover- recover isolated instance.
    MysqlIsolateInstanceId string
    ID of the resource.
    InstanceId string
    Instance ID, the format is: cdb-c1nl9rpv, which is the same as the instance ID displayed on the cloud database console page, and you can use the [query instance list] (https://cloud.tencent.com/document/api/236/15872) interface Gets the value of the field InstanceId in the output parameter.
    Operate string
    Manipulate instance, isolate - isolate instance, recover- recover isolated instance.
    MysqlIsolateInstanceId string
    ID of the resource.
    instanceId String
    Instance ID, the format is: cdb-c1nl9rpv, which is the same as the instance ID displayed on the cloud database console page, and you can use the [query instance list] (https://cloud.tencent.com/document/api/236/15872) interface Gets the value of the field InstanceId in the output parameter.
    operate String
    Manipulate instance, isolate - isolate instance, recover- recover isolated instance.
    mysqlIsolateInstanceId String
    ID of the resource.
    instanceId string
    Instance ID, the format is: cdb-c1nl9rpv, which is the same as the instance ID displayed on the cloud database console page, and you can use the [query instance list] (https://cloud.tencent.com/document/api/236/15872) interface Gets the value of the field InstanceId in the output parameter.
    operate string
    Manipulate instance, isolate - isolate instance, recover- recover isolated instance.
    mysqlIsolateInstanceId string
    ID of the resource.
    instance_id str
    Instance ID, the format is: cdb-c1nl9rpv, which is the same as the instance ID displayed on the cloud database console page, and you can use the [query instance list] (https://cloud.tencent.com/document/api/236/15872) interface Gets the value of the field InstanceId in the output parameter.
    operate str
    Manipulate instance, isolate - isolate instance, recover- recover isolated instance.
    mysql_isolate_instance_id str
    ID of the resource.
    instanceId String
    Instance ID, the format is: cdb-c1nl9rpv, which is the same as the instance ID displayed on the cloud database console page, and you can use the [query instance list] (https://cloud.tencent.com/document/api/236/15872) interface Gets the value of the field InstanceId in the output parameter.
    operate String
    Manipulate instance, isolate - isolate instance, recover- recover isolated instance.
    mysqlIsolateInstanceId String
    ID of the resource.

    Outputs

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

    Id string
    The provider-assigned unique ID for this managed resource.
    Status double
    Instance status.
    Id string
    The provider-assigned unique ID for this managed resource.
    Status float64
    Instance status.
    id String
    The provider-assigned unique ID for this managed resource.
    status Double
    Instance status.
    id string
    The provider-assigned unique ID for this managed resource.
    status number
    Instance status.
    id str
    The provider-assigned unique ID for this managed resource.
    status float
    Instance status.
    id String
    The provider-assigned unique ID for this managed resource.
    status Number
    Instance status.

    Look up Existing MysqlIsolateInstance Resource

    Get an existing MysqlIsolateInstance 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?: MysqlIsolateInstanceState, opts?: CustomResourceOptions): MysqlIsolateInstance
    @staticmethod
    def get(resource_name: str,
            id: str,
            opts: Optional[ResourceOptions] = None,
            instance_id: Optional[str] = None,
            mysql_isolate_instance_id: Optional[str] = None,
            operate: Optional[str] = None,
            status: Optional[float] = None) -> MysqlIsolateInstance
    func GetMysqlIsolateInstance(ctx *Context, name string, id IDInput, state *MysqlIsolateInstanceState, opts ...ResourceOption) (*MysqlIsolateInstance, error)
    public static MysqlIsolateInstance Get(string name, Input<string> id, MysqlIsolateInstanceState? state, CustomResourceOptions? opts = null)
    public static MysqlIsolateInstance get(String name, Output<String> id, MysqlIsolateInstanceState state, CustomResourceOptions options)
    resources:  _:    type: tencentcloud:MysqlIsolateInstance    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:
    InstanceId string
    Instance ID, the format is: cdb-c1nl9rpv, which is the same as the instance ID displayed on the cloud database console page, and you can use the [query instance list] (https://cloud.tencent.com/document/api/236/15872) interface Gets the value of the field InstanceId in the output parameter.
    MysqlIsolateInstanceId string
    ID of the resource.
    Operate string
    Manipulate instance, isolate - isolate instance, recover- recover isolated instance.
    Status double
    Instance status.
    InstanceId string
    Instance ID, the format is: cdb-c1nl9rpv, which is the same as the instance ID displayed on the cloud database console page, and you can use the [query instance list] (https://cloud.tencent.com/document/api/236/15872) interface Gets the value of the field InstanceId in the output parameter.
    MysqlIsolateInstanceId string
    ID of the resource.
    Operate string
    Manipulate instance, isolate - isolate instance, recover- recover isolated instance.
    Status float64
    Instance status.
    instanceId String
    Instance ID, the format is: cdb-c1nl9rpv, which is the same as the instance ID displayed on the cloud database console page, and you can use the [query instance list] (https://cloud.tencent.com/document/api/236/15872) interface Gets the value of the field InstanceId in the output parameter.
    mysqlIsolateInstanceId String
    ID of the resource.
    operate String
    Manipulate instance, isolate - isolate instance, recover- recover isolated instance.
    status Double
    Instance status.
    instanceId string
    Instance ID, the format is: cdb-c1nl9rpv, which is the same as the instance ID displayed on the cloud database console page, and you can use the [query instance list] (https://cloud.tencent.com/document/api/236/15872) interface Gets the value of the field InstanceId in the output parameter.
    mysqlIsolateInstanceId string
    ID of the resource.
    operate string
    Manipulate instance, isolate - isolate instance, recover- recover isolated instance.
    status number
    Instance status.
    instance_id str
    Instance ID, the format is: cdb-c1nl9rpv, which is the same as the instance ID displayed on the cloud database console page, and you can use the [query instance list] (https://cloud.tencent.com/document/api/236/15872) interface Gets the value of the field InstanceId in the output parameter.
    mysql_isolate_instance_id str
    ID of the resource.
    operate str
    Manipulate instance, isolate - isolate instance, recover- recover isolated instance.
    status float
    Instance status.
    instanceId String
    Instance ID, the format is: cdb-c1nl9rpv, which is the same as the instance ID displayed on the cloud database console page, and you can use the [query instance list] (https://cloud.tencent.com/document/api/236/15872) interface Gets the value of the field InstanceId in the output parameter.
    mysqlIsolateInstanceId String
    ID of the resource.
    operate String
    Manipulate instance, isolate - isolate instance, recover- recover isolated instance.
    status Number
    Instance status.

    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