tencentcloud.MysqlInstance
Explore with Pulumi AI
Provides a mysql instance resource to create master database instances.
NOTE: If this mysql has readonly instance, the terminate operation of the mysql does NOT take effect immediately, maybe takes for several hours. so during that time, VPCs associated with that mysql instance can’t be terminated also.
NOTE: The value of parameter
parameters
can be used with tencentcloud.getMysqlParameterList to obtain.
Example Usage
Create a single node instance
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 example = new tencentcloud.MysqlInstance("example", {
deviceType: "BASIC_V2",
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",
},
});
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 = tencentcloud.MysqlInstance("example",
device_type="BASIC_V2",
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",
})
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
}
_, err = tencentcloud.NewMysqlInstance(ctx, "example", &tencentcloud.MysqlInstanceArgs{
DeviceType: pulumi.String("BASIC_V2"),
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
}
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 example = new Tencentcloud.MysqlInstance("example", new()
{
DeviceType = "BASIC_V2",
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" },
},
});
});
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 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 example = new MysqlInstance("example", MysqlInstanceArgs.builder()
.deviceType("BASIC_V2")
.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());
}
}
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
example:
type: tencentcloud:MysqlInstance
properties:
deviceType: BASIC_V2
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'
variables:
zones:
fn::invoke:
function: tencentcloud:getAvailabilityZonesByProduct
arguments:
product: cdb
Create a double node instance
import * as pulumi from "@pulumi/pulumi";
import * as tencentcloud from "@pulumi/tencentcloud";
const example = new tencentcloud.MysqlInstance("example", {
internetService: 1,
engineVersion: "5.7",
chargeType: "POSTPAID",
rootPassword: "PassWord123",
slaveDeployMode: 1,
availabilityZone: data.tencentcloud_availability_zones_by_product.zones.zones[0].name,
firstSlaveZone: data.tencentcloud_availability_zones_by_product.zones.zones[1].name,
slaveSyncMode: 1,
instanceName: "tf-example-mysql",
memSize: 4000,
volumeSize: 200,
vpcId: tencentcloud_vpc.vpc.id,
subnetId: tencentcloud_subnet.subnet.id,
intranetPort: 3306,
securityGroups: [tencentcloud_security_group.security_group.id],
tags: {
name: "test",
},
parameters: {
character_set_server: "utf8",
max_connections: "1000",
},
});
import pulumi
import pulumi_tencentcloud as tencentcloud
example = tencentcloud.MysqlInstance("example",
internet_service=1,
engine_version="5.7",
charge_type="POSTPAID",
root_password="PassWord123",
slave_deploy_mode=1,
availability_zone=data["tencentcloud_availability_zones_by_product"]["zones"]["zones"][0]["name"],
first_slave_zone=data["tencentcloud_availability_zones_by_product"]["zones"]["zones"][1]["name"],
slave_sync_mode=1,
instance_name="tf-example-mysql",
mem_size=4000,
volume_size=200,
vpc_id=tencentcloud_vpc["vpc"]["id"],
subnet_id=tencentcloud_subnet["subnet"]["id"],
intranet_port=3306,
security_groups=[tencentcloud_security_group["security_group"]["id"]],
tags={
"name": "test",
},
parameters={
"character_set_server": "utf8",
"max_connections": "1000",
})
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 {
_, err := tencentcloud.NewMysqlInstance(ctx, "example", &tencentcloud.MysqlInstanceArgs{
InternetService: pulumi.Float64(1),
EngineVersion: pulumi.String("5.7"),
ChargeType: pulumi.String("POSTPAID"),
RootPassword: pulumi.String("PassWord123"),
SlaveDeployMode: pulumi.Float64(1),
AvailabilityZone: pulumi.Any(data.Tencentcloud_availability_zones_by_product.Zones.Zones[0].Name),
FirstSlaveZone: pulumi.Any(data.Tencentcloud_availability_zones_by_product.Zones.Zones[1].Name),
SlaveSyncMode: pulumi.Float64(1),
InstanceName: pulumi.String("tf-example-mysql"),
MemSize: pulumi.Float64(4000),
VolumeSize: pulumi.Float64(200),
VpcId: pulumi.Any(tencentcloud_vpc.Vpc.Id),
SubnetId: pulumi.Any(tencentcloud_subnet.Subnet.Id),
IntranetPort: pulumi.Float64(3306),
SecurityGroups: pulumi.StringArray{
tencentcloud_security_group.Security_group.Id,
},
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
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Tencentcloud = Pulumi.Tencentcloud;
return await Deployment.RunAsync(() =>
{
var example = new Tencentcloud.MysqlInstance("example", new()
{
InternetService = 1,
EngineVersion = "5.7",
ChargeType = "POSTPAID",
RootPassword = "PassWord123",
SlaveDeployMode = 1,
AvailabilityZone = data.Tencentcloud_availability_zones_by_product.Zones.Zones[0].Name,
FirstSlaveZone = data.Tencentcloud_availability_zones_by_product.Zones.Zones[1].Name,
SlaveSyncMode = 1,
InstanceName = "tf-example-mysql",
MemSize = 4000,
VolumeSize = 200,
VpcId = tencentcloud_vpc.Vpc.Id,
SubnetId = tencentcloud_subnet.Subnet.Id,
IntranetPort = 3306,
SecurityGroups = new[]
{
tencentcloud_security_group.Security_group.Id,
},
Tags =
{
{ "name", "test" },
},
Parameters =
{
{ "character_set_server", "utf8" },
{ "max_connections", "1000" },
},
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.tencentcloud.MysqlInstance;
import com.pulumi.tencentcloud.MysqlInstanceArgs;
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) {
var example = new MysqlInstance("example", MysqlInstanceArgs.builder()
.internetService(1)
.engineVersion("5.7")
.chargeType("POSTPAID")
.rootPassword("PassWord123")
.slaveDeployMode(1)
.availabilityZone(data.tencentcloud_availability_zones_by_product().zones().zones()[0].name())
.firstSlaveZone(data.tencentcloud_availability_zones_by_product().zones().zones()[1].name())
.slaveSyncMode(1)
.instanceName("tf-example-mysql")
.memSize(4000)
.volumeSize(200)
.vpcId(tencentcloud_vpc.vpc().id())
.subnetId(tencentcloud_subnet.subnet().id())
.intranetPort(3306)
.securityGroups(tencentcloud_security_group.security_group().id())
.tags(Map.of("name", "test"))
.parameters(Map.ofEntries(
Map.entry("character_set_server", "utf8"),
Map.entry("max_connections", "1000")
))
.build());
}
}
resources:
example:
type: tencentcloud:MysqlInstance
properties:
internetService: 1
engineVersion: '5.7'
chargeType: POSTPAID
rootPassword: PassWord123
slaveDeployMode: 1
availabilityZone: ${data.tencentcloud_availability_zones_by_product.zones.zones[0].name}
firstSlaveZone: ${data.tencentcloud_availability_zones_by_product.zones.zones[1].name}
slaveSyncMode: 1
instanceName: tf-example-mysql
memSize: 4000
volumeSize: 200
vpcId: ${tencentcloud_vpc.vpc.id}
subnetId: ${tencentcloud_subnet.subnet.id}
intranetPort: 3306
securityGroups:
- ${tencentcloud_security_group.security_group.id}
tags:
name: test
parameters:
character_set_server: utf8
max_connections: '1000'
Create MysqlInstance Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new MysqlInstance(name: string, args: MysqlInstanceArgs, opts?: CustomResourceOptions);
@overload
def MysqlInstance(resource_name: str,
args: MysqlInstanceArgs,
opts: Optional[ResourceOptions] = None)
@overload
def MysqlInstance(resource_name: str,
opts: Optional[ResourceOptions] = None,
instance_name: Optional[str] = None,
volume_size: Optional[float] = None,
mem_size: Optional[float] = None,
param_template_id: Optional[float] = None,
second_slave_zone: Optional[str] = None,
engine_type: Optional[str] = None,
engine_version: Optional[str] = None,
fast_upgrade: Optional[float] = None,
first_slave_zone: Optional[str] = None,
force_delete: Optional[bool] = None,
cpu: Optional[float] = None,
internet_service: Optional[float] = None,
intranet_port: Optional[float] = None,
max_deay_time: Optional[float] = None,
charge_type: Optional[str] = None,
mysql_instance_id: Optional[str] = None,
auto_renew_flag: Optional[float] = None,
device_type: Optional[str] = None,
parameters: Optional[Mapping[str, str]] = None,
slave_deploy_mode: Optional[float] = None,
prepaid_period: Optional[float] = None,
project_id: Optional[float] = None,
root_password: Optional[str] = None,
pay_type: Optional[float] = None,
security_groups: Optional[Sequence[str]] = None,
period: Optional[float] = None,
slave_sync_mode: Optional[float] = None,
subnet_id: Optional[str] = None,
tags: Optional[Mapping[str, str]] = None,
upgrade_subversion: Optional[float] = None,
availability_zone: Optional[str] = None,
vpc_id: Optional[str] = None,
wait_switch: Optional[float] = None)
func NewMysqlInstance(ctx *Context, name string, args MysqlInstanceArgs, opts ...ResourceOption) (*MysqlInstance, error)
public MysqlInstance(string name, MysqlInstanceArgs args, CustomResourceOptions? opts = null)
public MysqlInstance(String name, MysqlInstanceArgs args)
public MysqlInstance(String name, MysqlInstanceArgs args, CustomResourceOptions options)
type: tencentcloud:MysqlInstance
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 MysqlInstanceArgs
- 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 MysqlInstanceArgs
- 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 MysqlInstanceArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args MysqlInstanceArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args MysqlInstanceArgs
- The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
MysqlInstance 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 MysqlInstance resource accepts the following input properties:
- Instance
Name string - The name of a mysql instance.
- Mem
Size double - Memory size (in MB).
- Volume
Size double - Disk size (in GB).
- Auto
Renew doubleFlag - Auto renew flag. NOTES: Only supported prepaid instance.
- Availability
Zone string - Indicates which availability zone will be used.
- Charge
Type string - Pay type of instance. Valid values:
PREPAID
,POSTPAID
. Default isPOSTPAID
. - Cpu double
- CPU cores.
- Device
Type string - Specify device type, available values:
UNIVERSAL
(default): universal instance,EXCLUSIVE
: exclusive instance,BASIC_V2
: ONTKE single-node instance,CLOUD_NATIVE_CLUSTER
: cluster version standard type,CLOUD_NATIVE_CLUSTER_EXCLUSIVE
: cluster version enhanced type. If it is not specified, it defaults to a universal instance.
- Engine
Type string - Instance engine type. The default value is
InnoDB
. Supported values includeInnoDB
andRocksDB
. - Engine
Version string - The version number of the database engine to use. Supported versions include 5.5/5.6/5.7/8.0, and default is 5.7. Upgrade the instance engine version to support 5.6/5.7 and switch immediately.
- Fast
Upgrade double - Specify whether to enable fast upgrade when upgrade instance spec, available value:
1
- enabled,0
- disabled. - First
Slave stringZone - Zone information about first slave instance.
- Force
Delete bool - Indicate whether to delete instance directly or not. Default is
false
. If set true, the instance will be deleted instead of staying recycle bin. Note: only works forPREPAID
instance. When the main mysql instance set true, this para of the readonly mysql instance will not take effect. - Internet
Service double - Indicates whether to enable the access to an instance from public network: 0 - No, 1 - Yes.
- Intranet
Port double - Public access port. Valid value ranges: [1024~65535]. The default value is
3306
. - Max
Deay doubleTime - Latency threshold. Value range 1~10. Only need to fill in when upgrading kernel subversion and engine version.
- Mysql
Instance stringId - ID of the resource.
- Param
Template doubleId - Specify parameter template id.
- Parameters Dictionary<string, string>
- List of parameters to use.
- Pay
Type double - It has been deprecated from version 1.36.0. Please use
charge_type
instead. Pay type of instance. Valid values:0
,1
.0
: prepaid,1
: postpaid. - Period double
- It has been deprecated from version 1.36.0. Please use
prepaid_period
instead. Period of instance. NOTES: Only supported prepaid instance. - Prepaid
Period double - Period of instance. NOTES: Only supported prepaid instance.
- Project
Id double - Project ID, default value is 0.
- Root
Password string - Password of root account. This parameter can be specified when you purchase master instances, but it should be ignored when you purchase read-only instances or disaster recovery instances.
- Second
Slave stringZone - Zone information about second slave instance.
- Security
Groups List<string> - Security groups to use.
- Slave
Deploy doubleMode - Availability zone deployment method. Available values: 0 - Single availability zone; 1 - Multiple availability zones.
- Slave
Sync doubleMode - Data replication mode. 0 - Async replication; 1 - Semisync replication; 2 - Strongsync replication.
- Subnet
Id string - Private network ID. If
vpc_id
is set, this value is required. - Dictionary<string, string>
- Instance tags.
- Upgrade
Subversion double - Whether it is a kernel subversion upgrade, supported values: 1 - upgrade the kernel subversion; 0 - upgrade the database engine version. Only need to fill in when upgrading kernel subversion and engine version.
- Vpc
Id string - ID of VPC, which can be modified once every 24 hours and can't be removed.
- Wait
Switch double - Switch the method of accessing new instances, default is
0
. Supported values include:0
- switch immediately,1
- switch in time window.
- Instance
Name string - The name of a mysql instance.
- Mem
Size float64 - Memory size (in MB).
- Volume
Size float64 - Disk size (in GB).
- Auto
Renew float64Flag - Auto renew flag. NOTES: Only supported prepaid instance.
- Availability
Zone string - Indicates which availability zone will be used.
- Charge
Type string - Pay type of instance. Valid values:
PREPAID
,POSTPAID
. Default isPOSTPAID
. - Cpu float64
- CPU cores.
- Device
Type string - Specify device type, available values:
UNIVERSAL
(default): universal instance,EXCLUSIVE
: exclusive instance,BASIC_V2
: ONTKE single-node instance,CLOUD_NATIVE_CLUSTER
: cluster version standard type,CLOUD_NATIVE_CLUSTER_EXCLUSIVE
: cluster version enhanced type. If it is not specified, it defaults to a universal instance.
- Engine
Type string - Instance engine type. The default value is
InnoDB
. Supported values includeInnoDB
andRocksDB
. - Engine
Version string - The version number of the database engine to use. Supported versions include 5.5/5.6/5.7/8.0, and default is 5.7. Upgrade the instance engine version to support 5.6/5.7 and switch immediately.
- Fast
Upgrade float64 - Specify whether to enable fast upgrade when upgrade instance spec, available value:
1
- enabled,0
- disabled. - First
Slave stringZone - Zone information about first slave instance.
- Force
Delete bool - Indicate whether to delete instance directly or not. Default is
false
. If set true, the instance will be deleted instead of staying recycle bin. Note: only works forPREPAID
instance. When the main mysql instance set true, this para of the readonly mysql instance will not take effect. - Internet
Service float64 - Indicates whether to enable the access to an instance from public network: 0 - No, 1 - Yes.
- Intranet
Port float64 - Public access port. Valid value ranges: [1024~65535]. The default value is
3306
. - Max
Deay float64Time - Latency threshold. Value range 1~10. Only need to fill in when upgrading kernel subversion and engine version.
- Mysql
Instance stringId - ID of the resource.
- Param
Template float64Id - Specify parameter template id.
- Parameters map[string]string
- List of parameters to use.
- Pay
Type float64 - It has been deprecated from version 1.36.0. Please use
charge_type
instead. Pay type of instance. Valid values:0
,1
.0
: prepaid,1
: postpaid. - Period float64
- It has been deprecated from version 1.36.0. Please use
prepaid_period
instead. Period of instance. NOTES: Only supported prepaid instance. - Prepaid
Period float64 - Period of instance. NOTES: Only supported prepaid instance.
- Project
Id float64 - Project ID, default value is 0.
- Root
Password string - Password of root account. This parameter can be specified when you purchase master instances, but it should be ignored when you purchase read-only instances or disaster recovery instances.
- Second
Slave stringZone - Zone information about second slave instance.
- Security
Groups []string - Security groups to use.
- Slave
Deploy float64Mode - Availability zone deployment method. Available values: 0 - Single availability zone; 1 - Multiple availability zones.
- Slave
Sync float64Mode - Data replication mode. 0 - Async replication; 1 - Semisync replication; 2 - Strongsync replication.
- Subnet
Id string - Private network ID. If
vpc_id
is set, this value is required. - map[string]string
- Instance tags.
- Upgrade
Subversion float64 - Whether it is a kernel subversion upgrade, supported values: 1 - upgrade the kernel subversion; 0 - upgrade the database engine version. Only need to fill in when upgrading kernel subversion and engine version.
- Vpc
Id string - ID of VPC, which can be modified once every 24 hours and can't be removed.
- Wait
Switch float64 - Switch the method of accessing new instances, default is
0
. Supported values include:0
- switch immediately,1
- switch in time window.
- instance
Name String - The name of a mysql instance.
- mem
Size Double - Memory size (in MB).
- volume
Size Double - Disk size (in GB).
- auto
Renew DoubleFlag - Auto renew flag. NOTES: Only supported prepaid instance.
- availability
Zone String - Indicates which availability zone will be used.
- charge
Type String - Pay type of instance. Valid values:
PREPAID
,POSTPAID
. Default isPOSTPAID
. - cpu Double
- CPU cores.
- device
Type String - Specify device type, available values:
UNIVERSAL
(default): universal instance,EXCLUSIVE
: exclusive instance,BASIC_V2
: ONTKE single-node instance,CLOUD_NATIVE_CLUSTER
: cluster version standard type,CLOUD_NATIVE_CLUSTER_EXCLUSIVE
: cluster version enhanced type. If it is not specified, it defaults to a universal instance.
- engine
Type String - Instance engine type. The default value is
InnoDB
. Supported values includeInnoDB
andRocksDB
. - engine
Version String - The version number of the database engine to use. Supported versions include 5.5/5.6/5.7/8.0, and default is 5.7. Upgrade the instance engine version to support 5.6/5.7 and switch immediately.
- fast
Upgrade Double - Specify whether to enable fast upgrade when upgrade instance spec, available value:
1
- enabled,0
- disabled. - first
Slave StringZone - Zone information about first slave instance.
- force
Delete Boolean - Indicate whether to delete instance directly or not. Default is
false
. If set true, the instance will be deleted instead of staying recycle bin. Note: only works forPREPAID
instance. When the main mysql instance set true, this para of the readonly mysql instance will not take effect. - internet
Service Double - Indicates whether to enable the access to an instance from public network: 0 - No, 1 - Yes.
- intranet
Port Double - Public access port. Valid value ranges: [1024~65535]. The default value is
3306
. - max
Deay DoubleTime - Latency threshold. Value range 1~10. Only need to fill in when upgrading kernel subversion and engine version.
- mysql
Instance StringId - ID of the resource.
- param
Template DoubleId - Specify parameter template id.
- parameters Map<String,String>
- List of parameters to use.
- pay
Type Double - It has been deprecated from version 1.36.0. Please use
charge_type
instead. Pay type of instance. Valid values:0
,1
.0
: prepaid,1
: postpaid. - period Double
- It has been deprecated from version 1.36.0. Please use
prepaid_period
instead. Period of instance. NOTES: Only supported prepaid instance. - prepaid
Period Double - Period of instance. NOTES: Only supported prepaid instance.
- project
Id Double - Project ID, default value is 0.
- root
Password String - Password of root account. This parameter can be specified when you purchase master instances, but it should be ignored when you purchase read-only instances or disaster recovery instances.
- second
Slave StringZone - Zone information about second slave instance.
- security
Groups List<String> - Security groups to use.
- slave
Deploy DoubleMode - Availability zone deployment method. Available values: 0 - Single availability zone; 1 - Multiple availability zones.
- slave
Sync DoubleMode - Data replication mode. 0 - Async replication; 1 - Semisync replication; 2 - Strongsync replication.
- subnet
Id String - Private network ID. If
vpc_id
is set, this value is required. - Map<String,String>
- Instance tags.
- upgrade
Subversion Double - Whether it is a kernel subversion upgrade, supported values: 1 - upgrade the kernel subversion; 0 - upgrade the database engine version. Only need to fill in when upgrading kernel subversion and engine version.
- vpc
Id String - ID of VPC, which can be modified once every 24 hours and can't be removed.
- wait
Switch Double - Switch the method of accessing new instances, default is
0
. Supported values include:0
- switch immediately,1
- switch in time window.
- instance
Name string - The name of a mysql instance.
- mem
Size number - Memory size (in MB).
- volume
Size number - Disk size (in GB).
- auto
Renew numberFlag - Auto renew flag. NOTES: Only supported prepaid instance.
- availability
Zone string - Indicates which availability zone will be used.
- charge
Type string - Pay type of instance. Valid values:
PREPAID
,POSTPAID
. Default isPOSTPAID
. - cpu number
- CPU cores.
- device
Type string - Specify device type, available values:
UNIVERSAL
(default): universal instance,EXCLUSIVE
: exclusive instance,BASIC_V2
: ONTKE single-node instance,CLOUD_NATIVE_CLUSTER
: cluster version standard type,CLOUD_NATIVE_CLUSTER_EXCLUSIVE
: cluster version enhanced type. If it is not specified, it defaults to a universal instance.
- engine
Type string - Instance engine type. The default value is
InnoDB
. Supported values includeInnoDB
andRocksDB
. - engine
Version string - The version number of the database engine to use. Supported versions include 5.5/5.6/5.7/8.0, and default is 5.7. Upgrade the instance engine version to support 5.6/5.7 and switch immediately.
- fast
Upgrade number - Specify whether to enable fast upgrade when upgrade instance spec, available value:
1
- enabled,0
- disabled. - first
Slave stringZone - Zone information about first slave instance.
- force
Delete boolean - Indicate whether to delete instance directly or not. Default is
false
. If set true, the instance will be deleted instead of staying recycle bin. Note: only works forPREPAID
instance. When the main mysql instance set true, this para of the readonly mysql instance will not take effect. - internet
Service number - Indicates whether to enable the access to an instance from public network: 0 - No, 1 - Yes.
- intranet
Port number - Public access port. Valid value ranges: [1024~65535]. The default value is
3306
. - max
Deay numberTime - Latency threshold. Value range 1~10. Only need to fill in when upgrading kernel subversion and engine version.
- mysql
Instance stringId - ID of the resource.
- param
Template numberId - Specify parameter template id.
- parameters {[key: string]: string}
- List of parameters to use.
- pay
Type number - It has been deprecated from version 1.36.0. Please use
charge_type
instead. Pay type of instance. Valid values:0
,1
.0
: prepaid,1
: postpaid. - period number
- It has been deprecated from version 1.36.0. Please use
prepaid_period
instead. Period of instance. NOTES: Only supported prepaid instance. - prepaid
Period number - Period of instance. NOTES: Only supported prepaid instance.
- project
Id number - Project ID, default value is 0.
- root
Password string - Password of root account. This parameter can be specified when you purchase master instances, but it should be ignored when you purchase read-only instances or disaster recovery instances.
- second
Slave stringZone - Zone information about second slave instance.
- security
Groups string[] - Security groups to use.
- slave
Deploy numberMode - Availability zone deployment method. Available values: 0 - Single availability zone; 1 - Multiple availability zones.
- slave
Sync numberMode - Data replication mode. 0 - Async replication; 1 - Semisync replication; 2 - Strongsync replication.
- subnet
Id string - Private network ID. If
vpc_id
is set, this value is required. - {[key: string]: string}
- Instance tags.
- upgrade
Subversion number - Whether it is a kernel subversion upgrade, supported values: 1 - upgrade the kernel subversion; 0 - upgrade the database engine version. Only need to fill in when upgrading kernel subversion and engine version.
- vpc
Id string - ID of VPC, which can be modified once every 24 hours and can't be removed.
- wait
Switch number - Switch the method of accessing new instances, default is
0
. Supported values include:0
- switch immediately,1
- switch in time window.
- instance_
name str - The name of a mysql instance.
- mem_
size float - Memory size (in MB).
- volume_
size float - Disk size (in GB).
- auto_
renew_ floatflag - Auto renew flag. NOTES: Only supported prepaid instance.
- availability_
zone str - Indicates which availability zone will be used.
- charge_
type str - Pay type of instance. Valid values:
PREPAID
,POSTPAID
. Default isPOSTPAID
. - cpu float
- CPU cores.
- device_
type str - Specify device type, available values:
UNIVERSAL
(default): universal instance,EXCLUSIVE
: exclusive instance,BASIC_V2
: ONTKE single-node instance,CLOUD_NATIVE_CLUSTER
: cluster version standard type,CLOUD_NATIVE_CLUSTER_EXCLUSIVE
: cluster version enhanced type. If it is not specified, it defaults to a universal instance.
- engine_
type str - Instance engine type. The default value is
InnoDB
. Supported values includeInnoDB
andRocksDB
. - engine_
version str - The version number of the database engine to use. Supported versions include 5.5/5.6/5.7/8.0, and default is 5.7. Upgrade the instance engine version to support 5.6/5.7 and switch immediately.
- fast_
upgrade float - Specify whether to enable fast upgrade when upgrade instance spec, available value:
1
- enabled,0
- disabled. - first_
slave_ strzone - Zone information about first slave instance.
- force_
delete bool - Indicate whether to delete instance directly or not. Default is
false
. If set true, the instance will be deleted instead of staying recycle bin. Note: only works forPREPAID
instance. When the main mysql instance set true, this para of the readonly mysql instance will not take effect. - internet_
service float - Indicates whether to enable the access to an instance from public network: 0 - No, 1 - Yes.
- intranet_
port float - Public access port. Valid value ranges: [1024~65535]. The default value is
3306
. - max_
deay_ floattime - Latency threshold. Value range 1~10. Only need to fill in when upgrading kernel subversion and engine version.
- mysql_
instance_ strid - ID of the resource.
- param_
template_ floatid - Specify parameter template id.
- parameters Mapping[str, str]
- List of parameters to use.
- pay_
type float - It has been deprecated from version 1.36.0. Please use
charge_type
instead. Pay type of instance. Valid values:0
,1
.0
: prepaid,1
: postpaid. - period float
- It has been deprecated from version 1.36.0. Please use
prepaid_period
instead. Period of instance. NOTES: Only supported prepaid instance. - prepaid_
period float - Period of instance. NOTES: Only supported prepaid instance.
- project_
id float - Project ID, default value is 0.
- root_
password str - Password of root account. This parameter can be specified when you purchase master instances, but it should be ignored when you purchase read-only instances or disaster recovery instances.
- second_
slave_ strzone - Zone information about second slave instance.
- security_
groups Sequence[str] - Security groups to use.
- slave_
deploy_ floatmode - Availability zone deployment method. Available values: 0 - Single availability zone; 1 - Multiple availability zones.
- slave_
sync_ floatmode - Data replication mode. 0 - Async replication; 1 - Semisync replication; 2 - Strongsync replication.
- subnet_
id str - Private network ID. If
vpc_id
is set, this value is required. - Mapping[str, str]
- Instance tags.
- upgrade_
subversion float - Whether it is a kernel subversion upgrade, supported values: 1 - upgrade the kernel subversion; 0 - upgrade the database engine version. Only need to fill in when upgrading kernel subversion and engine version.
- vpc_
id str - ID of VPC, which can be modified once every 24 hours and can't be removed.
- wait_
switch float - Switch the method of accessing new instances, default is
0
. Supported values include:0
- switch immediately,1
- switch in time window.
- instance
Name String - The name of a mysql instance.
- mem
Size Number - Memory size (in MB).
- volume
Size Number - Disk size (in GB).
- auto
Renew NumberFlag - Auto renew flag. NOTES: Only supported prepaid instance.
- availability
Zone String - Indicates which availability zone will be used.
- charge
Type String - Pay type of instance. Valid values:
PREPAID
,POSTPAID
. Default isPOSTPAID
. - cpu Number
- CPU cores.
- device
Type String - Specify device type, available values:
UNIVERSAL
(default): universal instance,EXCLUSIVE
: exclusive instance,BASIC_V2
: ONTKE single-node instance,CLOUD_NATIVE_CLUSTER
: cluster version standard type,CLOUD_NATIVE_CLUSTER_EXCLUSIVE
: cluster version enhanced type. If it is not specified, it defaults to a universal instance.
- engine
Type String - Instance engine type. The default value is
InnoDB
. Supported values includeInnoDB
andRocksDB
. - engine
Version String - The version number of the database engine to use. Supported versions include 5.5/5.6/5.7/8.0, and default is 5.7. Upgrade the instance engine version to support 5.6/5.7 and switch immediately.
- fast
Upgrade Number - Specify whether to enable fast upgrade when upgrade instance spec, available value:
1
- enabled,0
- disabled. - first
Slave StringZone - Zone information about first slave instance.
- force
Delete Boolean - Indicate whether to delete instance directly or not. Default is
false
. If set true, the instance will be deleted instead of staying recycle bin. Note: only works forPREPAID
instance. When the main mysql instance set true, this para of the readonly mysql instance will not take effect. - internet
Service Number - Indicates whether to enable the access to an instance from public network: 0 - No, 1 - Yes.
- intranet
Port Number - Public access port. Valid value ranges: [1024~65535]. The default value is
3306
. - max
Deay NumberTime - Latency threshold. Value range 1~10. Only need to fill in when upgrading kernel subversion and engine version.
- mysql
Instance StringId - ID of the resource.
- param
Template NumberId - Specify parameter template id.
- parameters Map<String>
- List of parameters to use.
- pay
Type Number - It has been deprecated from version 1.36.0. Please use
charge_type
instead. Pay type of instance. Valid values:0
,1
.0
: prepaid,1
: postpaid. - period Number
- It has been deprecated from version 1.36.0. Please use
prepaid_period
instead. Period of instance. NOTES: Only supported prepaid instance. - prepaid
Period Number - Period of instance. NOTES: Only supported prepaid instance.
- project
Id Number - Project ID, default value is 0.
- root
Password String - Password of root account. This parameter can be specified when you purchase master instances, but it should be ignored when you purchase read-only instances or disaster recovery instances.
- second
Slave StringZone - Zone information about second slave instance.
- security
Groups List<String> - Security groups to use.
- slave
Deploy NumberMode - Availability zone deployment method. Available values: 0 - Single availability zone; 1 - Multiple availability zones.
- slave
Sync NumberMode - Data replication mode. 0 - Async replication; 1 - Semisync replication; 2 - Strongsync replication.
- subnet
Id String - Private network ID. If
vpc_id
is set, this value is required. - Map<String>
- Instance tags.
- upgrade
Subversion Number - Whether it is a kernel subversion upgrade, supported values: 1 - upgrade the kernel subversion; 0 - upgrade the database engine version. Only need to fill in when upgrading kernel subversion and engine version.
- vpc
Id String - ID of VPC, which can be modified once every 24 hours and can't be removed.
- wait
Switch Number - Switch the method of accessing new instances, default is
0
. Supported values include:0
- switch immediately,1
- switch in time window.
Outputs
All input properties are implicitly available as output properties. Additionally, the MysqlInstance resource produces the following output properties:
- Gtid double
- Indicates whether GTID is enable.
0
- Not enabled;1
- Enabled. - Id string
- The provider-assigned unique ID for this managed resource.
- Internet
Host string - host for public access.
- Internet
Port double - Access port for public access.
- Intranet
Ip string - instance intranet IP.
- Locked double
- Indicates whether the instance is locked. Valid values:
0
,1
.0
- No;1
- Yes. - Status double
- Instance status. Valid values:
0
,1
,4
,5
.0
- Creating;1
- Running;4
- Isolating;5
- Isolated. - Task
Status double - Indicates which kind of operations is being executed.
- Gtid float64
- Indicates whether GTID is enable.
0
- Not enabled;1
- Enabled. - Id string
- The provider-assigned unique ID for this managed resource.
- Internet
Host string - host for public access.
- Internet
Port float64 - Access port for public access.
- Intranet
Ip string - instance intranet IP.
- Locked float64
- Indicates whether the instance is locked. Valid values:
0
,1
.0
- No;1
- Yes. - Status float64
- Instance status. Valid values:
0
,1
,4
,5
.0
- Creating;1
- Running;4
- Isolating;5
- Isolated. - Task
Status float64 - Indicates which kind of operations is being executed.
- gtid Double
- Indicates whether GTID is enable.
0
- Not enabled;1
- Enabled. - id String
- The provider-assigned unique ID for this managed resource.
- internet
Host String - host for public access.
- internet
Port Double - Access port for public access.
- intranet
Ip String - instance intranet IP.
- locked Double
- Indicates whether the instance is locked. Valid values:
0
,1
.0
- No;1
- Yes. - status Double
- Instance status. Valid values:
0
,1
,4
,5
.0
- Creating;1
- Running;4
- Isolating;5
- Isolated. - task
Status Double - Indicates which kind of operations is being executed.
- gtid number
- Indicates whether GTID is enable.
0
- Not enabled;1
- Enabled. - id string
- The provider-assigned unique ID for this managed resource.
- internet
Host string - host for public access.
- internet
Port number - Access port for public access.
- intranet
Ip string - instance intranet IP.
- locked number
- Indicates whether the instance is locked. Valid values:
0
,1
.0
- No;1
- Yes. - status number
- Instance status. Valid values:
0
,1
,4
,5
.0
- Creating;1
- Running;4
- Isolating;5
- Isolated. - task
Status number - Indicates which kind of operations is being executed.
- gtid float
- Indicates whether GTID is enable.
0
- Not enabled;1
- Enabled. - id str
- The provider-assigned unique ID for this managed resource.
- internet_
host str - host for public access.
- internet_
port float - Access port for public access.
- intranet_
ip str - instance intranet IP.
- locked float
- Indicates whether the instance is locked. Valid values:
0
,1
.0
- No;1
- Yes. - status float
- Instance status. Valid values:
0
,1
,4
,5
.0
- Creating;1
- Running;4
- Isolating;5
- Isolated. - task_
status float - Indicates which kind of operations is being executed.
- gtid Number
- Indicates whether GTID is enable.
0
- Not enabled;1
- Enabled. - id String
- The provider-assigned unique ID for this managed resource.
- internet
Host String - host for public access.
- internet
Port Number - Access port for public access.
- intranet
Ip String - instance intranet IP.
- locked Number
- Indicates whether the instance is locked. Valid values:
0
,1
.0
- No;1
- Yes. - status Number
- Instance status. Valid values:
0
,1
,4
,5
.0
- Creating;1
- Running;4
- Isolating;5
- Isolated. - task
Status Number - Indicates which kind of operations is being executed.
Look up Existing MysqlInstance Resource
Get an existing MysqlInstance 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?: MysqlInstanceState, opts?: CustomResourceOptions): MysqlInstance
@staticmethod
def get(resource_name: str,
id: str,
opts: Optional[ResourceOptions] = None,
auto_renew_flag: Optional[float] = None,
availability_zone: Optional[str] = None,
charge_type: Optional[str] = None,
cpu: Optional[float] = None,
device_type: Optional[str] = None,
engine_type: Optional[str] = None,
engine_version: Optional[str] = None,
fast_upgrade: Optional[float] = None,
first_slave_zone: Optional[str] = None,
force_delete: Optional[bool] = None,
gtid: Optional[float] = None,
instance_name: Optional[str] = None,
internet_host: Optional[str] = None,
internet_port: Optional[float] = None,
internet_service: Optional[float] = None,
intranet_ip: Optional[str] = None,
intranet_port: Optional[float] = None,
locked: Optional[float] = None,
max_deay_time: Optional[float] = None,
mem_size: Optional[float] = None,
mysql_instance_id: Optional[str] = None,
param_template_id: Optional[float] = None,
parameters: Optional[Mapping[str, str]] = None,
pay_type: Optional[float] = None,
period: Optional[float] = None,
prepaid_period: Optional[float] = None,
project_id: Optional[float] = None,
root_password: Optional[str] = None,
second_slave_zone: Optional[str] = None,
security_groups: Optional[Sequence[str]] = None,
slave_deploy_mode: Optional[float] = None,
slave_sync_mode: Optional[float] = None,
status: Optional[float] = None,
subnet_id: Optional[str] = None,
tags: Optional[Mapping[str, str]] = None,
task_status: Optional[float] = None,
upgrade_subversion: Optional[float] = None,
volume_size: Optional[float] = None,
vpc_id: Optional[str] = None,
wait_switch: Optional[float] = None) -> MysqlInstance
func GetMysqlInstance(ctx *Context, name string, id IDInput, state *MysqlInstanceState, opts ...ResourceOption) (*MysqlInstance, error)
public static MysqlInstance Get(string name, Input<string> id, MysqlInstanceState? state, CustomResourceOptions? opts = null)
public static MysqlInstance get(String name, Output<String> id, MysqlInstanceState state, CustomResourceOptions options)
resources: _: type: tencentcloud:MysqlInstance 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.
- Auto
Renew doubleFlag - Auto renew flag. NOTES: Only supported prepaid instance.
- Availability
Zone string - Indicates which availability zone will be used.
- Charge
Type string - Pay type of instance. Valid values:
PREPAID
,POSTPAID
. Default isPOSTPAID
. - Cpu double
- CPU cores.
- Device
Type string - Specify device type, available values:
UNIVERSAL
(default): universal instance,EXCLUSIVE
: exclusive instance,BASIC_V2
: ONTKE single-node instance,CLOUD_NATIVE_CLUSTER
: cluster version standard type,CLOUD_NATIVE_CLUSTER_EXCLUSIVE
: cluster version enhanced type. If it is not specified, it defaults to a universal instance.
- Engine
Type string - Instance engine type. The default value is
InnoDB
. Supported values includeInnoDB
andRocksDB
. - Engine
Version string - The version number of the database engine to use. Supported versions include 5.5/5.6/5.7/8.0, and default is 5.7. Upgrade the instance engine version to support 5.6/5.7 and switch immediately.
- Fast
Upgrade double - Specify whether to enable fast upgrade when upgrade instance spec, available value:
1
- enabled,0
- disabled. - First
Slave stringZone - Zone information about first slave instance.
- Force
Delete bool - Indicate whether to delete instance directly or not. Default is
false
. If set true, the instance will be deleted instead of staying recycle bin. Note: only works forPREPAID
instance. When the main mysql instance set true, this para of the readonly mysql instance will not take effect. - Gtid double
- Indicates whether GTID is enable.
0
- Not enabled;1
- Enabled. - Instance
Name string - The name of a mysql instance.
- Internet
Host string - host for public access.
- Internet
Port double - Access port for public access.
- Internet
Service double - Indicates whether to enable the access to an instance from public network: 0 - No, 1 - Yes.
- Intranet
Ip string - instance intranet IP.
- Intranet
Port double - Public access port. Valid value ranges: [1024~65535]. The default value is
3306
. - Locked double
- Indicates whether the instance is locked. Valid values:
0
,1
.0
- No;1
- Yes. - Max
Deay doubleTime - Latency threshold. Value range 1~10. Only need to fill in when upgrading kernel subversion and engine version.
- Mem
Size double - Memory size (in MB).
- Mysql
Instance stringId - ID of the resource.
- Param
Template doubleId - Specify parameter template id.
- Parameters Dictionary<string, string>
- List of parameters to use.
- Pay
Type double - It has been deprecated from version 1.36.0. Please use
charge_type
instead. Pay type of instance. Valid values:0
,1
.0
: prepaid,1
: postpaid. - Period double
- It has been deprecated from version 1.36.0. Please use
prepaid_period
instead. Period of instance. NOTES: Only supported prepaid instance. - Prepaid
Period double - Period of instance. NOTES: Only supported prepaid instance.
- Project
Id double - Project ID, default value is 0.
- Root
Password string - Password of root account. This parameter can be specified when you purchase master instances, but it should be ignored when you purchase read-only instances or disaster recovery instances.
- Second
Slave stringZone - Zone information about second slave instance.
- Security
Groups List<string> - Security groups to use.
- Slave
Deploy doubleMode - Availability zone deployment method. Available values: 0 - Single availability zone; 1 - Multiple availability zones.
- Slave
Sync doubleMode - Data replication mode. 0 - Async replication; 1 - Semisync replication; 2 - Strongsync replication.
- Status double
- Instance status. Valid values:
0
,1
,4
,5
.0
- Creating;1
- Running;4
- Isolating;5
- Isolated. - Subnet
Id string - Private network ID. If
vpc_id
is set, this value is required. - Dictionary<string, string>
- Instance tags.
- Task
Status double - Indicates which kind of operations is being executed.
- Upgrade
Subversion double - Whether it is a kernel subversion upgrade, supported values: 1 - upgrade the kernel subversion; 0 - upgrade the database engine version. Only need to fill in when upgrading kernel subversion and engine version.
- Volume
Size double - Disk size (in GB).
- Vpc
Id string - ID of VPC, which can be modified once every 24 hours and can't be removed.
- Wait
Switch double - Switch the method of accessing new instances, default is
0
. Supported values include:0
- switch immediately,1
- switch in time window.
- Auto
Renew float64Flag - Auto renew flag. NOTES: Only supported prepaid instance.
- Availability
Zone string - Indicates which availability zone will be used.
- Charge
Type string - Pay type of instance. Valid values:
PREPAID
,POSTPAID
. Default isPOSTPAID
. - Cpu float64
- CPU cores.
- Device
Type string - Specify device type, available values:
UNIVERSAL
(default): universal instance,EXCLUSIVE
: exclusive instance,BASIC_V2
: ONTKE single-node instance,CLOUD_NATIVE_CLUSTER
: cluster version standard type,CLOUD_NATIVE_CLUSTER_EXCLUSIVE
: cluster version enhanced type. If it is not specified, it defaults to a universal instance.
- Engine
Type string - Instance engine type. The default value is
InnoDB
. Supported values includeInnoDB
andRocksDB
. - Engine
Version string - The version number of the database engine to use. Supported versions include 5.5/5.6/5.7/8.0, and default is 5.7. Upgrade the instance engine version to support 5.6/5.7 and switch immediately.
- Fast
Upgrade float64 - Specify whether to enable fast upgrade when upgrade instance spec, available value:
1
- enabled,0
- disabled. - First
Slave stringZone - Zone information about first slave instance.
- Force
Delete bool - Indicate whether to delete instance directly or not. Default is
false
. If set true, the instance will be deleted instead of staying recycle bin. Note: only works forPREPAID
instance. When the main mysql instance set true, this para of the readonly mysql instance will not take effect. - Gtid float64
- Indicates whether GTID is enable.
0
- Not enabled;1
- Enabled. - Instance
Name string - The name of a mysql instance.
- Internet
Host string - host for public access.
- Internet
Port float64 - Access port for public access.
- Internet
Service float64 - Indicates whether to enable the access to an instance from public network: 0 - No, 1 - Yes.
- Intranet
Ip string - instance intranet IP.
- Intranet
Port float64 - Public access port. Valid value ranges: [1024~65535]. The default value is
3306
. - Locked float64
- Indicates whether the instance is locked. Valid values:
0
,1
.0
- No;1
- Yes. - Max
Deay float64Time - Latency threshold. Value range 1~10. Only need to fill in when upgrading kernel subversion and engine version.
- Mem
Size float64 - Memory size (in MB).
- Mysql
Instance stringId - ID of the resource.
- Param
Template float64Id - Specify parameter template id.
- Parameters map[string]string
- List of parameters to use.
- Pay
Type float64 - It has been deprecated from version 1.36.0. Please use
charge_type
instead. Pay type of instance. Valid values:0
,1
.0
: prepaid,1
: postpaid. - Period float64
- It has been deprecated from version 1.36.0. Please use
prepaid_period
instead. Period of instance. NOTES: Only supported prepaid instance. - Prepaid
Period float64 - Period of instance. NOTES: Only supported prepaid instance.
- Project
Id float64 - Project ID, default value is 0.
- Root
Password string - Password of root account. This parameter can be specified when you purchase master instances, but it should be ignored when you purchase read-only instances or disaster recovery instances.
- Second
Slave stringZone - Zone information about second slave instance.
- Security
Groups []string - Security groups to use.
- Slave
Deploy float64Mode - Availability zone deployment method. Available values: 0 - Single availability zone; 1 - Multiple availability zones.
- Slave
Sync float64Mode - Data replication mode. 0 - Async replication; 1 - Semisync replication; 2 - Strongsync replication.
- Status float64
- Instance status. Valid values:
0
,1
,4
,5
.0
- Creating;1
- Running;4
- Isolating;5
- Isolated. - Subnet
Id string - Private network ID. If
vpc_id
is set, this value is required. - map[string]string
- Instance tags.
- Task
Status float64 - Indicates which kind of operations is being executed.
- Upgrade
Subversion float64 - Whether it is a kernel subversion upgrade, supported values: 1 - upgrade the kernel subversion; 0 - upgrade the database engine version. Only need to fill in when upgrading kernel subversion and engine version.
- Volume
Size float64 - Disk size (in GB).
- Vpc
Id string - ID of VPC, which can be modified once every 24 hours and can't be removed.
- Wait
Switch float64 - Switch the method of accessing new instances, default is
0
. Supported values include:0
- switch immediately,1
- switch in time window.
- auto
Renew DoubleFlag - Auto renew flag. NOTES: Only supported prepaid instance.
- availability
Zone String - Indicates which availability zone will be used.
- charge
Type String - Pay type of instance. Valid values:
PREPAID
,POSTPAID
. Default isPOSTPAID
. - cpu Double
- CPU cores.
- device
Type String - Specify device type, available values:
UNIVERSAL
(default): universal instance,EXCLUSIVE
: exclusive instance,BASIC_V2
: ONTKE single-node instance,CLOUD_NATIVE_CLUSTER
: cluster version standard type,CLOUD_NATIVE_CLUSTER_EXCLUSIVE
: cluster version enhanced type. If it is not specified, it defaults to a universal instance.
- engine
Type String - Instance engine type. The default value is
InnoDB
. Supported values includeInnoDB
andRocksDB
. - engine
Version String - The version number of the database engine to use. Supported versions include 5.5/5.6/5.7/8.0, and default is 5.7. Upgrade the instance engine version to support 5.6/5.7 and switch immediately.
- fast
Upgrade Double - Specify whether to enable fast upgrade when upgrade instance spec, available value:
1
- enabled,0
- disabled. - first
Slave StringZone - Zone information about first slave instance.
- force
Delete Boolean - Indicate whether to delete instance directly or not. Default is
false
. If set true, the instance will be deleted instead of staying recycle bin. Note: only works forPREPAID
instance. When the main mysql instance set true, this para of the readonly mysql instance will not take effect. - gtid Double
- Indicates whether GTID is enable.
0
- Not enabled;1
- Enabled. - instance
Name String - The name of a mysql instance.
- internet
Host String - host for public access.
- internet
Port Double - Access port for public access.
- internet
Service Double - Indicates whether to enable the access to an instance from public network: 0 - No, 1 - Yes.
- intranet
Ip String - instance intranet IP.
- intranet
Port Double - Public access port. Valid value ranges: [1024~65535]. The default value is
3306
. - locked Double
- Indicates whether the instance is locked. Valid values:
0
,1
.0
- No;1
- Yes. - max
Deay DoubleTime - Latency threshold. Value range 1~10. Only need to fill in when upgrading kernel subversion and engine version.
- mem
Size Double - Memory size (in MB).
- mysql
Instance StringId - ID of the resource.
- param
Template DoubleId - Specify parameter template id.
- parameters Map<String,String>
- List of parameters to use.
- pay
Type Double - It has been deprecated from version 1.36.0. Please use
charge_type
instead. Pay type of instance. Valid values:0
,1
.0
: prepaid,1
: postpaid. - period Double
- It has been deprecated from version 1.36.0. Please use
prepaid_period
instead. Period of instance. NOTES: Only supported prepaid instance. - prepaid
Period Double - Period of instance. NOTES: Only supported prepaid instance.
- project
Id Double - Project ID, default value is 0.
- root
Password String - Password of root account. This parameter can be specified when you purchase master instances, but it should be ignored when you purchase read-only instances or disaster recovery instances.
- second
Slave StringZone - Zone information about second slave instance.
- security
Groups List<String> - Security groups to use.
- slave
Deploy DoubleMode - Availability zone deployment method. Available values: 0 - Single availability zone; 1 - Multiple availability zones.
- slave
Sync DoubleMode - Data replication mode. 0 - Async replication; 1 - Semisync replication; 2 - Strongsync replication.
- status Double
- Instance status. Valid values:
0
,1
,4
,5
.0
- Creating;1
- Running;4
- Isolating;5
- Isolated. - subnet
Id String - Private network ID. If
vpc_id
is set, this value is required. - Map<String,String>
- Instance tags.
- task
Status Double - Indicates which kind of operations is being executed.
- upgrade
Subversion Double - Whether it is a kernel subversion upgrade, supported values: 1 - upgrade the kernel subversion; 0 - upgrade the database engine version. Only need to fill in when upgrading kernel subversion and engine version.
- volume
Size Double - Disk size (in GB).
- vpc
Id String - ID of VPC, which can be modified once every 24 hours and can't be removed.
- wait
Switch Double - Switch the method of accessing new instances, default is
0
. Supported values include:0
- switch immediately,1
- switch in time window.
- auto
Renew numberFlag - Auto renew flag. NOTES: Only supported prepaid instance.
- availability
Zone string - Indicates which availability zone will be used.
- charge
Type string - Pay type of instance. Valid values:
PREPAID
,POSTPAID
. Default isPOSTPAID
. - cpu number
- CPU cores.
- device
Type string - Specify device type, available values:
UNIVERSAL
(default): universal instance,EXCLUSIVE
: exclusive instance,BASIC_V2
: ONTKE single-node instance,CLOUD_NATIVE_CLUSTER
: cluster version standard type,CLOUD_NATIVE_CLUSTER_EXCLUSIVE
: cluster version enhanced type. If it is not specified, it defaults to a universal instance.
- engine
Type string - Instance engine type. The default value is
InnoDB
. Supported values includeInnoDB
andRocksDB
. - engine
Version string - The version number of the database engine to use. Supported versions include 5.5/5.6/5.7/8.0, and default is 5.7. Upgrade the instance engine version to support 5.6/5.7 and switch immediately.
- fast
Upgrade number - Specify whether to enable fast upgrade when upgrade instance spec, available value:
1
- enabled,0
- disabled. - first
Slave stringZone - Zone information about first slave instance.
- force
Delete boolean - Indicate whether to delete instance directly or not. Default is
false
. If set true, the instance will be deleted instead of staying recycle bin. Note: only works forPREPAID
instance. When the main mysql instance set true, this para of the readonly mysql instance will not take effect. - gtid number
- Indicates whether GTID is enable.
0
- Not enabled;1
- Enabled. - instance
Name string - The name of a mysql instance.
- internet
Host string - host for public access.
- internet
Port number - Access port for public access.
- internet
Service number - Indicates whether to enable the access to an instance from public network: 0 - No, 1 - Yes.
- intranet
Ip string - instance intranet IP.
- intranet
Port number - Public access port. Valid value ranges: [1024~65535]. The default value is
3306
. - locked number
- Indicates whether the instance is locked. Valid values:
0
,1
.0
- No;1
- Yes. - max
Deay numberTime - Latency threshold. Value range 1~10. Only need to fill in when upgrading kernel subversion and engine version.
- mem
Size number - Memory size (in MB).
- mysql
Instance stringId - ID of the resource.
- param
Template numberId - Specify parameter template id.
- parameters {[key: string]: string}
- List of parameters to use.
- pay
Type number - It has been deprecated from version 1.36.0. Please use
charge_type
instead. Pay type of instance. Valid values:0
,1
.0
: prepaid,1
: postpaid. - period number
- It has been deprecated from version 1.36.0. Please use
prepaid_period
instead. Period of instance. NOTES: Only supported prepaid instance. - prepaid
Period number - Period of instance. NOTES: Only supported prepaid instance.
- project
Id number - Project ID, default value is 0.
- root
Password string - Password of root account. This parameter can be specified when you purchase master instances, but it should be ignored when you purchase read-only instances or disaster recovery instances.
- second
Slave stringZone - Zone information about second slave instance.
- security
Groups string[] - Security groups to use.
- slave
Deploy numberMode - Availability zone deployment method. Available values: 0 - Single availability zone; 1 - Multiple availability zones.
- slave
Sync numberMode - Data replication mode. 0 - Async replication; 1 - Semisync replication; 2 - Strongsync replication.
- status number
- Instance status. Valid values:
0
,1
,4
,5
.0
- Creating;1
- Running;4
- Isolating;5
- Isolated. - subnet
Id string - Private network ID. If
vpc_id
is set, this value is required. - {[key: string]: string}
- Instance tags.
- task
Status number - Indicates which kind of operations is being executed.
- upgrade
Subversion number - Whether it is a kernel subversion upgrade, supported values: 1 - upgrade the kernel subversion; 0 - upgrade the database engine version. Only need to fill in when upgrading kernel subversion and engine version.
- volume
Size number - Disk size (in GB).
- vpc
Id string - ID of VPC, which can be modified once every 24 hours and can't be removed.
- wait
Switch number - Switch the method of accessing new instances, default is
0
. Supported values include:0
- switch immediately,1
- switch in time window.
- auto_
renew_ floatflag - Auto renew flag. NOTES: Only supported prepaid instance.
- availability_
zone str - Indicates which availability zone will be used.
- charge_
type str - Pay type of instance. Valid values:
PREPAID
,POSTPAID
. Default isPOSTPAID
. - cpu float
- CPU cores.
- device_
type str - Specify device type, available values:
UNIVERSAL
(default): universal instance,EXCLUSIVE
: exclusive instance,BASIC_V2
: ONTKE single-node instance,CLOUD_NATIVE_CLUSTER
: cluster version standard type,CLOUD_NATIVE_CLUSTER_EXCLUSIVE
: cluster version enhanced type. If it is not specified, it defaults to a universal instance.
- engine_
type str - Instance engine type. The default value is
InnoDB
. Supported values includeInnoDB
andRocksDB
. - engine_
version str - The version number of the database engine to use. Supported versions include 5.5/5.6/5.7/8.0, and default is 5.7. Upgrade the instance engine version to support 5.6/5.7 and switch immediately.
- fast_
upgrade float - Specify whether to enable fast upgrade when upgrade instance spec, available value:
1
- enabled,0
- disabled. - first_
slave_ strzone - Zone information about first slave instance.
- force_
delete bool - Indicate whether to delete instance directly or not. Default is
false
. If set true, the instance will be deleted instead of staying recycle bin. Note: only works forPREPAID
instance. When the main mysql instance set true, this para of the readonly mysql instance will not take effect. - gtid float
- Indicates whether GTID is enable.
0
- Not enabled;1
- Enabled. - instance_
name str - The name of a mysql instance.
- internet_
host str - host for public access.
- internet_
port float - Access port for public access.
- internet_
service float - Indicates whether to enable the access to an instance from public network: 0 - No, 1 - Yes.
- intranet_
ip str - instance intranet IP.
- intranet_
port float - Public access port. Valid value ranges: [1024~65535]. The default value is
3306
. - locked float
- Indicates whether the instance is locked. Valid values:
0
,1
.0
- No;1
- Yes. - max_
deay_ floattime - Latency threshold. Value range 1~10. Only need to fill in when upgrading kernel subversion and engine version.
- mem_
size float - Memory size (in MB).
- mysql_
instance_ strid - ID of the resource.
- param_
template_ floatid - Specify parameter template id.
- parameters Mapping[str, str]
- List of parameters to use.
- pay_
type float - It has been deprecated from version 1.36.0. Please use
charge_type
instead. Pay type of instance. Valid values:0
,1
.0
: prepaid,1
: postpaid. - period float
- It has been deprecated from version 1.36.0. Please use
prepaid_period
instead. Period of instance. NOTES: Only supported prepaid instance. - prepaid_
period float - Period of instance. NOTES: Only supported prepaid instance.
- project_
id float - Project ID, default value is 0.
- root_
password str - Password of root account. This parameter can be specified when you purchase master instances, but it should be ignored when you purchase read-only instances or disaster recovery instances.
- second_
slave_ strzone - Zone information about second slave instance.
- security_
groups Sequence[str] - Security groups to use.
- slave_
deploy_ floatmode - Availability zone deployment method. Available values: 0 - Single availability zone; 1 - Multiple availability zones.
- slave_
sync_ floatmode - Data replication mode. 0 - Async replication; 1 - Semisync replication; 2 - Strongsync replication.
- status float
- Instance status. Valid values:
0
,1
,4
,5
.0
- Creating;1
- Running;4
- Isolating;5
- Isolated. - subnet_
id str - Private network ID. If
vpc_id
is set, this value is required. - Mapping[str, str]
- Instance tags.
- task_
status float - Indicates which kind of operations is being executed.
- upgrade_
subversion float - Whether it is a kernel subversion upgrade, supported values: 1 - upgrade the kernel subversion; 0 - upgrade the database engine version. Only need to fill in when upgrading kernel subversion and engine version.
- volume_
size float - Disk size (in GB).
- vpc_
id str - ID of VPC, which can be modified once every 24 hours and can't be removed.
- wait_
switch float - Switch the method of accessing new instances, default is
0
. Supported values include:0
- switch immediately,1
- switch in time window.
- auto
Renew NumberFlag - Auto renew flag. NOTES: Only supported prepaid instance.
- availability
Zone String - Indicates which availability zone will be used.
- charge
Type String - Pay type of instance. Valid values:
PREPAID
,POSTPAID
. Default isPOSTPAID
. - cpu Number
- CPU cores.
- device
Type String - Specify device type, available values:
UNIVERSAL
(default): universal instance,EXCLUSIVE
: exclusive instance,BASIC_V2
: ONTKE single-node instance,CLOUD_NATIVE_CLUSTER
: cluster version standard type,CLOUD_NATIVE_CLUSTER_EXCLUSIVE
: cluster version enhanced type. If it is not specified, it defaults to a universal instance.
- engine
Type String - Instance engine type. The default value is
InnoDB
. Supported values includeInnoDB
andRocksDB
. - engine
Version String - The version number of the database engine to use. Supported versions include 5.5/5.6/5.7/8.0, and default is 5.7. Upgrade the instance engine version to support 5.6/5.7 and switch immediately.
- fast
Upgrade Number - Specify whether to enable fast upgrade when upgrade instance spec, available value:
1
- enabled,0
- disabled. - first
Slave StringZone - Zone information about first slave instance.
- force
Delete Boolean - Indicate whether to delete instance directly or not. Default is
false
. If set true, the instance will be deleted instead of staying recycle bin. Note: only works forPREPAID
instance. When the main mysql instance set true, this para of the readonly mysql instance will not take effect. - gtid Number
- Indicates whether GTID is enable.
0
- Not enabled;1
- Enabled. - instance
Name String - The name of a mysql instance.
- internet
Host String - host for public access.
- internet
Port Number - Access port for public access.
- internet
Service Number - Indicates whether to enable the access to an instance from public network: 0 - No, 1 - Yes.
- intranet
Ip String - instance intranet IP.
- intranet
Port Number - Public access port. Valid value ranges: [1024~65535]. The default value is
3306
. - locked Number
- Indicates whether the instance is locked. Valid values:
0
,1
.0
- No;1
- Yes. - max
Deay NumberTime - Latency threshold. Value range 1~10. Only need to fill in when upgrading kernel subversion and engine version.
- mem
Size Number - Memory size (in MB).
- mysql
Instance StringId - ID of the resource.
- param
Template NumberId - Specify parameter template id.
- parameters Map<String>
- List of parameters to use.
- pay
Type Number - It has been deprecated from version 1.36.0. Please use
charge_type
instead. Pay type of instance. Valid values:0
,1
.0
: prepaid,1
: postpaid. - period Number
- It has been deprecated from version 1.36.0. Please use
prepaid_period
instead. Period of instance. NOTES: Only supported prepaid instance. - prepaid
Period Number - Period of instance. NOTES: Only supported prepaid instance.
- project
Id Number - Project ID, default value is 0.
- root
Password String - Password of root account. This parameter can be specified when you purchase master instances, but it should be ignored when you purchase read-only instances or disaster recovery instances.
- second
Slave StringZone - Zone information about second slave instance.
- security
Groups List<String> - Security groups to use.
- slave
Deploy NumberMode - Availability zone deployment method. Available values: 0 - Single availability zone; 1 - Multiple availability zones.
- slave
Sync NumberMode - Data replication mode. 0 - Async replication; 1 - Semisync replication; 2 - Strongsync replication.
- status Number
- Instance status. Valid values:
0
,1
,4
,5
.0
- Creating;1
- Running;4
- Isolating;5
- Isolated. - subnet
Id String - Private network ID. If
vpc_id
is set, this value is required. - Map<String>
- Instance tags.
- task
Status Number - Indicates which kind of operations is being executed.
- upgrade
Subversion Number - Whether it is a kernel subversion upgrade, supported values: 1 - upgrade the kernel subversion; 0 - upgrade the database engine version. Only need to fill in when upgrading kernel subversion and engine version.
- volume
Size Number - Disk size (in GB).
- vpc
Id String - ID of VPC, which can be modified once every 24 hours and can't be removed.
- wait
Switch Number - Switch the method of accessing new instances, default is
0
. Supported values include:0
- switch immediately,1
- switch in time window.
Import
MySQL instance can be imported using the id, e.g.
$ pulumi import tencentcloud:index/mysqlInstance:MysqlInstance foo cdb-12345678
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.