Volcengine v0.0.27 published on Tuesday, Dec 10, 2024 by Volcengine
volcengine.vedb_mysql.Databases
Explore with Pulumi AI
Use this data source to query detailed information of vedb mysql databases
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as volcengine from "@pulumi/volcengine";
import * as volcengine from "@volcengine/pulumi";
const fooZones = volcengine.ecs.Zones({});
const fooVpc = new volcengine.vpc.Vpc("fooVpc", {
vpcName: "acc-test-vpc",
cidrBlock: "172.16.0.0/16",
});
const fooSubnet = new volcengine.vpc.Subnet("fooSubnet", {
subnetName: "acc-test-subnet",
cidrBlock: "172.16.0.0/24",
zoneId: fooZones.then(fooZones => fooZones.zones?.[2]?.id),
vpcId: fooVpc.id,
});
const fooInstance = new volcengine.vedb_mysql.Instance("fooInstance", {
chargeType: "PostPaid",
storageChargeType: "PostPaid",
dbEngineVersion: "MySQL_8_0",
dbMinorVersion: "3.0",
nodeNumber: 2,
nodeSpec: "vedb.mysql.x4.large",
subnetId: fooSubnet.id,
instanceName: "tf-test",
projectName: "testA",
tags: [
{
key: "tftest",
value: "tftest",
},
{
key: "tftest2",
value: "tftest2",
},
],
});
const fooDatabase = new volcengine.vedb_mysql.Database("fooDatabase", {
dbName: "tf-table",
instanceId: fooInstance.id,
});
const fooDatabases = volcengine.vedb_mysql.DatabasesOutput({
dbName: fooDatabase.dbName,
instanceId: fooInstance.id,
});
import pulumi
import pulumi_volcengine as volcengine
foo_zones = volcengine.ecs.zones()
foo_vpc = volcengine.vpc.Vpc("fooVpc",
vpc_name="acc-test-vpc",
cidr_block="172.16.0.0/16")
foo_subnet = volcengine.vpc.Subnet("fooSubnet",
subnet_name="acc-test-subnet",
cidr_block="172.16.0.0/24",
zone_id=foo_zones.zones[2].id,
vpc_id=foo_vpc.id)
foo_instance = volcengine.vedb_mysql.Instance("fooInstance",
charge_type="PostPaid",
storage_charge_type="PostPaid",
db_engine_version="MySQL_8_0",
db_minor_version="3.0",
node_number=2,
node_spec="vedb.mysql.x4.large",
subnet_id=foo_subnet.id,
instance_name="tf-test",
project_name="testA",
tags=[
volcengine.vedb_mysql.InstanceTagArgs(
key="tftest",
value="tftest",
),
volcengine.vedb_mysql.InstanceTagArgs(
key="tftest2",
value="tftest2",
),
])
foo_database = volcengine.vedb_mysql.Database("fooDatabase",
db_name="tf-table",
instance_id=foo_instance.id)
foo_databases = volcengine.vedb_mysql.databases_output(db_name=foo_database.db_name,
instance_id=foo_instance.id)
package main
import (
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
"github.com/volcengine/pulumi-volcengine/sdk/go/volcengine/ecs"
"github.com/volcengine/pulumi-volcengine/sdk/go/volcengine/vedb_mysql"
"github.com/volcengine/pulumi-volcengine/sdk/go/volcengine/vpc"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
fooZones, err := ecs.Zones(ctx, nil, nil)
if err != nil {
return err
}
fooVpc, err := vpc.NewVpc(ctx, "fooVpc", &vpc.VpcArgs{
VpcName: pulumi.String("acc-test-vpc"),
CidrBlock: pulumi.String("172.16.0.0/16"),
})
if err != nil {
return err
}
fooSubnet, err := vpc.NewSubnet(ctx, "fooSubnet", &vpc.SubnetArgs{
SubnetName: pulumi.String("acc-test-subnet"),
CidrBlock: pulumi.String("172.16.0.0/24"),
ZoneId: pulumi.String(fooZones.Zones[2].Id),
VpcId: fooVpc.ID(),
})
if err != nil {
return err
}
fooInstance, err := vedb_mysql.NewInstance(ctx, "fooInstance", &vedb_mysql.InstanceArgs{
ChargeType: pulumi.String("PostPaid"),
StorageChargeType: pulumi.String("PostPaid"),
DbEngineVersion: pulumi.String("MySQL_8_0"),
DbMinorVersion: pulumi.String("3.0"),
NodeNumber: pulumi.Int(2),
NodeSpec: pulumi.String("vedb.mysql.x4.large"),
SubnetId: fooSubnet.ID(),
InstanceName: pulumi.String("tf-test"),
ProjectName: pulumi.String("testA"),
Tags: vedb_mysql.InstanceTagArray{
&vedb_mysql.InstanceTagArgs{
Key: pulumi.String("tftest"),
Value: pulumi.String("tftest"),
},
&vedb_mysql.InstanceTagArgs{
Key: pulumi.String("tftest2"),
Value: pulumi.String("tftest2"),
},
},
})
if err != nil {
return err
}
fooDatabase, err := vedb_mysql.NewDatabase(ctx, "fooDatabase", &vedb_mysql.DatabaseArgs{
DbName: pulumi.String("tf-table"),
InstanceId: fooInstance.ID(),
})
if err != nil {
return err
}
_ = vedb_mysql.DatabasesOutput(ctx, vedb_mysql.DatabasesOutputArgs{
DbName: fooDatabase.DbName,
InstanceId: fooInstance.ID(),
}, nil)
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Volcengine = Pulumi.Volcengine;
return await Deployment.RunAsync(() =>
{
var fooZones = Volcengine.Ecs.Zones.Invoke();
var fooVpc = new Volcengine.Vpc.Vpc("fooVpc", new()
{
VpcName = "acc-test-vpc",
CidrBlock = "172.16.0.0/16",
});
var fooSubnet = new Volcengine.Vpc.Subnet("fooSubnet", new()
{
SubnetName = "acc-test-subnet",
CidrBlock = "172.16.0.0/24",
ZoneId = fooZones.Apply(zonesResult => zonesResult.Zones[2]?.Id),
VpcId = fooVpc.Id,
});
var fooInstance = new Volcengine.Vedb_mysql.Instance("fooInstance", new()
{
ChargeType = "PostPaid",
StorageChargeType = "PostPaid",
DbEngineVersion = "MySQL_8_0",
DbMinorVersion = "3.0",
NodeNumber = 2,
NodeSpec = "vedb.mysql.x4.large",
SubnetId = fooSubnet.Id,
InstanceName = "tf-test",
ProjectName = "testA",
Tags = new[]
{
new Volcengine.Vedb_mysql.Inputs.InstanceTagArgs
{
Key = "tftest",
Value = "tftest",
},
new Volcengine.Vedb_mysql.Inputs.InstanceTagArgs
{
Key = "tftest2",
Value = "tftest2",
},
},
});
var fooDatabase = new Volcengine.Vedb_mysql.Database("fooDatabase", new()
{
DbName = "tf-table",
InstanceId = fooInstance.Id,
});
var fooDatabases = Volcengine.Vedb_mysql.Databases.Invoke(new()
{
DbName = fooDatabase.DbName,
InstanceId = fooInstance.Id,
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.volcengine.ecs.EcsFunctions;
import com.pulumi.volcengine.ecs.inputs.ZonesArgs;
import com.pulumi.volcengine.vpc.Vpc;
import com.pulumi.volcengine.vpc.VpcArgs;
import com.pulumi.volcengine.vpc.Subnet;
import com.pulumi.volcengine.vpc.SubnetArgs;
import com.pulumi.volcengine.vedb_mysql.Instance;
import com.pulumi.volcengine.vedb_mysql.InstanceArgs;
import com.pulumi.volcengine.vedb_mysql.inputs.InstanceTagArgs;
import com.pulumi.volcengine.vedb_mysql.Database;
import com.pulumi.volcengine.vedb_mysql.DatabaseArgs;
import com.pulumi.volcengine.vedb_mysql.Vedb_mysqlFunctions;
import com.pulumi.volcengine.vedb_mysql.inputs.DatabasesArgs;
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 fooZones = EcsFunctions.Zones();
var fooVpc = new Vpc("fooVpc", VpcArgs.builder()
.vpcName("acc-test-vpc")
.cidrBlock("172.16.0.0/16")
.build());
var fooSubnet = new Subnet("fooSubnet", SubnetArgs.builder()
.subnetName("acc-test-subnet")
.cidrBlock("172.16.0.0/24")
.zoneId(fooZones.applyValue(zonesResult -> zonesResult.zones()[2].id()))
.vpcId(fooVpc.id())
.build());
var fooInstance = new Instance("fooInstance", InstanceArgs.builder()
.chargeType("PostPaid")
.storageChargeType("PostPaid")
.dbEngineVersion("MySQL_8_0")
.dbMinorVersion("3.0")
.nodeNumber(2)
.nodeSpec("vedb.mysql.x4.large")
.subnetId(fooSubnet.id())
.instanceName("tf-test")
.projectName("testA")
.tags(
InstanceTagArgs.builder()
.key("tftest")
.value("tftest")
.build(),
InstanceTagArgs.builder()
.key("tftest2")
.value("tftest2")
.build())
.build());
var fooDatabase = new Database("fooDatabase", DatabaseArgs.builder()
.dbName("tf-table")
.instanceId(fooInstance.id())
.build());
final var fooDatabases = Vedb_mysqlFunctions.Databases(DatabasesArgs.builder()
.dbName(fooDatabase.dbName())
.instanceId(fooInstance.id())
.build());
}
}
resources:
fooVpc:
type: volcengine:vpc:Vpc
properties:
vpcName: acc-test-vpc
cidrBlock: 172.16.0.0/16
fooSubnet:
type: volcengine:vpc:Subnet
properties:
subnetName: acc-test-subnet
cidrBlock: 172.16.0.0/24
zoneId: ${fooZones.zones[2].id}
vpcId: ${fooVpc.id}
fooInstance:
type: volcengine:vedb_mysql:Instance
properties:
chargeType: PostPaid
storageChargeType: PostPaid
dbEngineVersion: MySQL_8_0
dbMinorVersion: '3.0'
nodeNumber: 2
nodeSpec: vedb.mysql.x4.large
subnetId: ${fooSubnet.id}
instanceName: tf-test
projectName: testA
tags:
- key: tftest
value: tftest
- key: tftest2
value: tftest2
fooDatabase:
type: volcengine:vedb_mysql:Database
properties:
dbName: tf-table
instanceId: ${fooInstance.id}
variables:
fooZones:
fn::invoke:
Function: volcengine:ecs:Zones
Arguments: {}
fooDatabases:
fn::invoke:
Function: volcengine:vedb_mysql:Databases
Arguments:
dbName: ${fooDatabase.dbName}
instanceId: ${fooInstance.id}
Using Databases
Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.
function databases(args: DatabasesArgs, opts?: InvokeOptions): Promise<DatabasesResult>
function databasesOutput(args: DatabasesOutputArgs, opts?: InvokeOptions): Output<DatabasesResult>
def databases(db_name: Optional[str] = None,
instance_id: Optional[str] = None,
name_regex: Optional[str] = None,
output_file: Optional[str] = None,
opts: Optional[InvokeOptions] = None) -> DatabasesResult
def databases_output(db_name: Optional[pulumi.Input[str]] = None,
instance_id: Optional[pulumi.Input[str]] = None,
name_regex: Optional[pulumi.Input[str]] = None,
output_file: Optional[pulumi.Input[str]] = None,
opts: Optional[InvokeOptions] = None) -> Output[DatabasesResult]
func Databases(ctx *Context, args *DatabasesArgs, opts ...InvokeOption) (*DatabasesResult, error)
func DatabasesOutput(ctx *Context, args *DatabasesOutputArgs, opts ...InvokeOption) DatabasesResultOutput
public static class Databases
{
public static Task<DatabasesResult> InvokeAsync(DatabasesArgs args, InvokeOptions? opts = null)
public static Output<DatabasesResult> Invoke(DatabasesInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<DatabasesResult> databases(DatabasesArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
fn::invoke:
function: volcengine:vedb_mysql:Databases
arguments:
# arguments dictionary
The following arguments are supported:
- Instance
Id string - The instance id.
- Db
Name string - Database name.
- Name
Regex string - A Name Regex of Resource.
- Output
File string - File name where to save data source results.
- Instance
Id string - The instance id.
- Db
Name string - Database name.
- Name
Regex string - A Name Regex of Resource.
- Output
File string - File name where to save data source results.
- instance
Id String - The instance id.
- db
Name String - Database name.
- name
Regex String - A Name Regex of Resource.
- output
File String - File name where to save data source results.
- instance
Id string - The instance id.
- db
Name string - Database name.
- name
Regex string - A Name Regex of Resource.
- output
File string - File name where to save data source results.
- instance_
id str - The instance id.
- db_
name str - Database name.
- name_
regex str - A Name Regex of Resource.
- output_
file str - File name where to save data source results.
- instance
Id String - The instance id.
- db
Name String - Database name.
- name
Regex String - A Name Regex of Resource.
- output
File String - File name where to save data source results.
Databases Result
The following output properties are available:
- Databases
List<Databases
Database> - The collection of query.
- Id string
- The provider-assigned unique ID for this managed resource.
- Instance
Id string - Total
Count int - The total count of query.
- Db
Name string - The name of the database. Naming rules: Unique name. Start with a lowercase letter and end with a letter or number. The length is within 2 to 64 characters. Consist of lowercase letters, numbers, underscores (_), or hyphens (-). The name cannot contain certain reserved words.
- Name
Regex string - Output
File string
- Databases
[]Databases
Database - The collection of query.
- Id string
- The provider-assigned unique ID for this managed resource.
- Instance
Id string - Total
Count int - The total count of query.
- Db
Name string - The name of the database. Naming rules: Unique name. Start with a lowercase letter and end with a letter or number. The length is within 2 to 64 characters. Consist of lowercase letters, numbers, underscores (_), or hyphens (-). The name cannot contain certain reserved words.
- Name
Regex string - Output
File string
- databases
List<Databases
Database> - The collection of query.
- id String
- The provider-assigned unique ID for this managed resource.
- instance
Id String - total
Count Integer - The total count of query.
- db
Name String - The name of the database. Naming rules: Unique name. Start with a lowercase letter and end with a letter or number. The length is within 2 to 64 characters. Consist of lowercase letters, numbers, underscores (_), or hyphens (-). The name cannot contain certain reserved words.
- name
Regex String - output
File String
- databases
Databases
Database[] - The collection of query.
- id string
- The provider-assigned unique ID for this managed resource.
- instance
Id string - total
Count number - The total count of query.
- db
Name string - The name of the database. Naming rules: Unique name. Start with a lowercase letter and end with a letter or number. The length is within 2 to 64 characters. Consist of lowercase letters, numbers, underscores (_), or hyphens (-). The name cannot contain certain reserved words.
- name
Regex string - output
File string
- databases
Sequence[Databases
Database] - The collection of query.
- id str
- The provider-assigned unique ID for this managed resource.
- instance_
id str - total_
count int - The total count of query.
- db_
name str - The name of the database. Naming rules: Unique name. Start with a lowercase letter and end with a letter or number. The length is within 2 to 64 characters. Consist of lowercase letters, numbers, underscores (_), or hyphens (-). The name cannot contain certain reserved words.
- name_
regex str - output_
file str
- databases List<Property Map>
- The collection of query.
- id String
- The provider-assigned unique ID for this managed resource.
- instance
Id String - total
Count Number - The total count of query.
- db
Name String - The name of the database. Naming rules: Unique name. Start with a lowercase letter and end with a letter or number. The length is within 2 to 64 characters. Consist of lowercase letters, numbers, underscores (_), or hyphens (-). The name cannot contain certain reserved words.
- name
Regex String - output
File String
Supporting Types
DatabasesDatabase
- Character
Set stringName - Database character set: utf8mb4 (default), utf8, latin1, ascii.
- Databases
Privileges List<DatabasesDatabase Databases Privilege> - Db
Name string - Database name.
- Character
Set stringName - Database character set: utf8mb4 (default), utf8, latin1, ascii.
- Databases
Privileges []DatabasesDatabase Databases Privilege - Db
Name string - Database name.
- character
Set StringName - Database character set: utf8mb4 (default), utf8, latin1, ascii.
- databases
Privileges List<DatabasesDatabase Databases Privilege> - db
Name String - Database name.
- character
Set stringName - Database character set: utf8mb4 (default), utf8, latin1, ascii.
- databases
Privileges DatabasesDatabase Databases Privilege[] - db
Name string - Database name.
- character_
set_ strname - Database character set: utf8mb4 (default), utf8, latin1, ascii.
- databases_
privileges Sequence[DatabasesDatabase Databases Privilege] - db_
name str - Database name.
- character
Set StringName - Database character set: utf8mb4 (default), utf8, latin1, ascii.
- databases
Privileges List<Property Map> - db
Name String - Database name.
DatabasesDatabaseDatabasesPrivilege
- Account
Name string - Account name that requires authorization.
- Account
Privilege string - Authorization database privilege types: ReadWrite: Read and write privilege. ReadOnly: Read-only privilege. DDLOnly: Only DDL privilege. DMLOnly: Only DML privilege. Custom: Custom privilege.
- Account
Privilege stringDetail - The specific SQL operation permissions contained in the permission type are separated by English commas (,) between multiple strings. When used as a request parameter in the CreateDatabase interface, when the AccountPrivilege value is Custom, this parameter is required. Value range (multiple selections allowed): SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER. When used as a return parameter in the DescribeDatabases interface, regardless of the value of AccountPrivilege, the details of the SQL operation permissions contained in this permission type are returned. For the specific SQL operation permissions contained in each permission type, please refer to the account permission list.
- Account
Name string - Account name that requires authorization.
- Account
Privilege string - Authorization database privilege types: ReadWrite: Read and write privilege. ReadOnly: Read-only privilege. DDLOnly: Only DDL privilege. DMLOnly: Only DML privilege. Custom: Custom privilege.
- Account
Privilege stringDetail - The specific SQL operation permissions contained in the permission type are separated by English commas (,) between multiple strings. When used as a request parameter in the CreateDatabase interface, when the AccountPrivilege value is Custom, this parameter is required. Value range (multiple selections allowed): SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER. When used as a return parameter in the DescribeDatabases interface, regardless of the value of AccountPrivilege, the details of the SQL operation permissions contained in this permission type are returned. For the specific SQL operation permissions contained in each permission type, please refer to the account permission list.
- account
Name String - Account name that requires authorization.
- account
Privilege String - Authorization database privilege types: ReadWrite: Read and write privilege. ReadOnly: Read-only privilege. DDLOnly: Only DDL privilege. DMLOnly: Only DML privilege. Custom: Custom privilege.
- account
Privilege StringDetail - The specific SQL operation permissions contained in the permission type are separated by English commas (,) between multiple strings. When used as a request parameter in the CreateDatabase interface, when the AccountPrivilege value is Custom, this parameter is required. Value range (multiple selections allowed): SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER. When used as a return parameter in the DescribeDatabases interface, regardless of the value of AccountPrivilege, the details of the SQL operation permissions contained in this permission type are returned. For the specific SQL operation permissions contained in each permission type, please refer to the account permission list.
- account
Name string - Account name that requires authorization.
- account
Privilege string - Authorization database privilege types: ReadWrite: Read and write privilege. ReadOnly: Read-only privilege. DDLOnly: Only DDL privilege. DMLOnly: Only DML privilege. Custom: Custom privilege.
- account
Privilege stringDetail - The specific SQL operation permissions contained in the permission type are separated by English commas (,) between multiple strings. When used as a request parameter in the CreateDatabase interface, when the AccountPrivilege value is Custom, this parameter is required. Value range (multiple selections allowed): SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER. When used as a return parameter in the DescribeDatabases interface, regardless of the value of AccountPrivilege, the details of the SQL operation permissions contained in this permission type are returned. For the specific SQL operation permissions contained in each permission type, please refer to the account permission list.
- account_
name str - Account name that requires authorization.
- account_
privilege str - Authorization database privilege types: ReadWrite: Read and write privilege. ReadOnly: Read-only privilege. DDLOnly: Only DDL privilege. DMLOnly: Only DML privilege. Custom: Custom privilege.
- account_
privilege_ strdetail - The specific SQL operation permissions contained in the permission type are separated by English commas (,) between multiple strings. When used as a request parameter in the CreateDatabase interface, when the AccountPrivilege value is Custom, this parameter is required. Value range (multiple selections allowed): SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER. When used as a return parameter in the DescribeDatabases interface, regardless of the value of AccountPrivilege, the details of the SQL operation permissions contained in this permission type are returned. For the specific SQL operation permissions contained in each permission type, please refer to the account permission list.
- account
Name String - Account name that requires authorization.
- account
Privilege String - Authorization database privilege types: ReadWrite: Read and write privilege. ReadOnly: Read-only privilege. DDLOnly: Only DDL privilege. DMLOnly: Only DML privilege. Custom: Custom privilege.
- account
Privilege StringDetail - The specific SQL operation permissions contained in the permission type are separated by English commas (,) between multiple strings. When used as a request parameter in the CreateDatabase interface, when the AccountPrivilege value is Custom, this parameter is required. Value range (multiple selections allowed): SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER. When used as a return parameter in the DescribeDatabases interface, regardless of the value of AccountPrivilege, the details of the SQL operation permissions contained in this permission type are returned. For the specific SQL operation permissions contained in each permission type, please refer to the account permission list.
Package Details
- Repository
- volcengine volcengine/pulumi-volcengine
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
volcengine
Terraform Provider.