Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Vultr
  3. API Docs
  4. Database
Vultr v2.23.1 published on Tuesday, Dec 10, 2024 by dirien
dirien/pulumi-vultr

vultr.Database

Explore with Pulumi AI

Vultr v2.23.1 published on Tuesday, Dec 10, 2024 by dirien
dirien/pulumi-vultr

Provides a Vultr database resource. This can be used to create, read, modify, and delete managed databases on your Vultr account.

Example Usage

Create a new database:

import * as pulumi from "@pulumi/pulumi";
import * as vultr from "@ediri/vultr";

const myDatabase = new vultr.Database("myDatabase", {
    databaseEngine: "pg",
    databaseEngineVersion: "15",
    label: "my_database_label",
    plan: "vultr-dbaas-startup-cc-1-55-2",
    region: "ewr",
});
Copy
import pulumi
import ediri_vultr as vultr

my_database = vultr.Database("myDatabase",
    database_engine="pg",
    database_engine_version="15",
    label="my_database_label",
    plan="vultr-dbaas-startup-cc-1-55-2",
    region="ewr")
Copy
package main

import (
	"github.com/dirien/pulumi-vultr/sdk/v2/go/vultr"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := vultr.NewDatabase(ctx, "myDatabase", &vultr.DatabaseArgs{
			DatabaseEngine:        pulumi.String("pg"),
			DatabaseEngineVersion: pulumi.String("15"),
			Label:                 pulumi.String("my_database_label"),
			Plan:                  pulumi.String("vultr-dbaas-startup-cc-1-55-2"),
			Region:                pulumi.String("ewr"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}
Copy
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Vultr = ediri.Vultr;

return await Deployment.RunAsync(() => 
{
    var myDatabase = new Vultr.Database("myDatabase", new()
    {
        DatabaseEngine = "pg",
        DatabaseEngineVersion = "15",
        Label = "my_database_label",
        Plan = "vultr-dbaas-startup-cc-1-55-2",
        Region = "ewr",
    });

});
Copy
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.vultr.Database;
import com.pulumi.vultr.DatabaseArgs;
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 myDatabase = new Database("myDatabase", DatabaseArgs.builder()
            .databaseEngine("pg")
            .databaseEngineVersion("15")
            .label("my_database_label")
            .plan("vultr-dbaas-startup-cc-1-55-2")
            .region("ewr")
            .build());

    }
}
Copy
resources:
  myDatabase:
    type: vultr:Database
    properties:
      databaseEngine: pg
      databaseEngineVersion: '15'
      label: my_database_label
      plan: vultr-dbaas-startup-cc-1-55-2
      region: ewr
Copy

Create a new database with options:

import * as pulumi from "@pulumi/pulumi";
import * as vultr from "@ediri/vultr";

const myDatabase = new vultr.Database("myDatabase", {
    clusterTimeZone: "America/New_York",
    databaseEngine: "pg",
    databaseEngineVersion: "15",
    label: "my_database_label",
    maintenanceDow: "sunday",
    maintenanceTime: "01:00",
    plan: "vultr-dbaas-startup-cc-1-55-2",
    region: "ewr",
    tag: "some tag",
});
Copy
import pulumi
import ediri_vultr as vultr

my_database = vultr.Database("myDatabase",
    cluster_time_zone="America/New_York",
    database_engine="pg",
    database_engine_version="15",
    label="my_database_label",
    maintenance_dow="sunday",
    maintenance_time="01:00",
    plan="vultr-dbaas-startup-cc-1-55-2",
    region="ewr",
    tag="some tag")
Copy
package main

import (
	"github.com/dirien/pulumi-vultr/sdk/v2/go/vultr"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := vultr.NewDatabase(ctx, "myDatabase", &vultr.DatabaseArgs{
			ClusterTimeZone:       pulumi.String("America/New_York"),
			DatabaseEngine:        pulumi.String("pg"),
			DatabaseEngineVersion: pulumi.String("15"),
			Label:                 pulumi.String("my_database_label"),
			MaintenanceDow:        pulumi.String("sunday"),
			MaintenanceTime:       pulumi.String("01:00"),
			Plan:                  pulumi.String("vultr-dbaas-startup-cc-1-55-2"),
			Region:                pulumi.String("ewr"),
			Tag:                   pulumi.String("some tag"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}
Copy
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Vultr = ediri.Vultr;

return await Deployment.RunAsync(() => 
{
    var myDatabase = new Vultr.Database("myDatabase", new()
    {
        ClusterTimeZone = "America/New_York",
        DatabaseEngine = "pg",
        DatabaseEngineVersion = "15",
        Label = "my_database_label",
        MaintenanceDow = "sunday",
        MaintenanceTime = "01:00",
        Plan = "vultr-dbaas-startup-cc-1-55-2",
        Region = "ewr",
        Tag = "some tag",
    });

});
Copy
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.vultr.Database;
import com.pulumi.vultr.DatabaseArgs;
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 myDatabase = new Database("myDatabase", DatabaseArgs.builder()
            .clusterTimeZone("America/New_York")
            .databaseEngine("pg")
            .databaseEngineVersion("15")
            .label("my_database_label")
            .maintenanceDow("sunday")
            .maintenanceTime("01:00")
            .plan("vultr-dbaas-startup-cc-1-55-2")
            .region("ewr")
            .tag("some tag")
            .build());

    }
}
Copy
resources:
  myDatabase:
    type: vultr:Database
    properties:
      clusterTimeZone: America/New_York
      databaseEngine: pg
      databaseEngineVersion: '15'
      label: my_database_label
      maintenanceDow: sunday
      maintenanceTime: 01:00
      plan: vultr-dbaas-startup-cc-1-55-2
      region: ewr
      tag: some tag
Copy

Create Database Resource

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

Constructor syntax

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

@overload
def Database(resource_name: str,
             opts: Optional[ResourceOptions] = None,
             label: Optional[str] = None,
             region: Optional[str] = None,
             plan: Optional[str] = None,
             database_engine: Optional[str] = None,
             database_engine_version: Optional[str] = None,
             mysql_slow_query_log: Optional[bool] = None,
             plan_brokers: Optional[int] = None,
             eviction_policy: Optional[str] = None,
             maintenance_dow: Optional[str] = None,
             maintenance_time: Optional[str] = None,
             mysql_long_query_time: Optional[int] = None,
             mysql_require_primary_key: Optional[bool] = None,
             access_cert: Optional[str] = None,
             mysql_sql_modes: Optional[Sequence[str]] = None,
             password: Optional[str] = None,
             cluster_time_zone: Optional[str] = None,
             ferretdb_credentials: Optional[Mapping[str, str]] = None,
             plan_disk: Optional[int] = None,
             plan_replicas: Optional[int] = None,
             public_host: Optional[str] = None,
             read_replicas: Optional[Sequence[DatabaseReadReplicaArgs]] = None,
             access_key: Optional[str] = None,
             sasl_port: Optional[str] = None,
             tag: Optional[str] = None,
             trusted_ips: Optional[Sequence[str]] = None,
             vpc_id: Optional[str] = None)
func NewDatabase(ctx *Context, name string, args DatabaseArgs, opts ...ResourceOption) (*Database, error)
public Database(string name, DatabaseArgs args, CustomResourceOptions? opts = null)
public Database(String name, DatabaseArgs args)
public Database(String name, DatabaseArgs args, CustomResourceOptions options)

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

Parameters

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

Constructor example

The following reference example uses placeholder values for all input properties.

var databaseResource = new Vultr.Database("databaseResource", new()
{
    Label = "string",
    Region = "string",
    Plan = "string",
    DatabaseEngine = "string",
    DatabaseEngineVersion = "string",
    MysqlSlowQueryLog = false,
    PlanBrokers = 0,
    EvictionPolicy = "string",
    MaintenanceDow = "string",
    MaintenanceTime = "string",
    MysqlLongQueryTime = 0,
    MysqlRequirePrimaryKey = false,
    AccessCert = "string",
    MysqlSqlModes = new[]
    {
        "string",
    },
    Password = "string",
    ClusterTimeZone = "string",
    FerretdbCredentials = 
    {
        { "string", "string" },
    },
    PlanDisk = 0,
    PlanReplicas = 0,
    PublicHost = "string",
    ReadReplicas = new[]
    {
        new Vultr.Inputs.DatabaseReadReplicaArgs
        {
            Label = "string",
            Region = "string",
            MysqlRequirePrimaryKey = false,
            FerretdbCredentials = 
            {
                { "string", "string" },
            },
            MysqlSqlModes = new[]
            {
                "string",
            },
            EvictionPolicy = "string",
            Password = "string",
            Host = "string",
            Id = "string",
            DatabaseEngineVersion = "string",
            LatestBackup = "string",
            MaintenanceDow = "string",
            MaintenanceTime = "string",
            Plan = "string",
            ClusterTimeZone = "string",
            MysqlSlowQueryLog = false,
            Dbname = "string",
            DateCreated = "string",
            MysqlLongQueryTime = 0,
            PlanDisk = 0,
            PlanRam = 0,
            PlanReplicas = 0,
            PlanVcpus = 0,
            Port = "string",
            PublicHost = "string",
            DatabaseEngine = "string",
            Status = "string",
            Tag = "string",
            TrustedIps = new[]
            {
                "string",
            },
            User = "string",
            VpcId = "string",
        },
    },
    AccessKey = "string",
    SaslPort = "string",
    Tag = "string",
    TrustedIps = new[]
    {
        "string",
    },
    VpcId = "string",
});
Copy
example, err := vultr.NewDatabase(ctx, "databaseResource", &vultr.DatabaseArgs{
	Label:                  pulumi.String("string"),
	Region:                 pulumi.String("string"),
	Plan:                   pulumi.String("string"),
	DatabaseEngine:         pulumi.String("string"),
	DatabaseEngineVersion:  pulumi.String("string"),
	MysqlSlowQueryLog:      pulumi.Bool(false),
	PlanBrokers:            pulumi.Int(0),
	EvictionPolicy:         pulumi.String("string"),
	MaintenanceDow:         pulumi.String("string"),
	MaintenanceTime:        pulumi.String("string"),
	MysqlLongQueryTime:     pulumi.Int(0),
	MysqlRequirePrimaryKey: pulumi.Bool(false),
	AccessCert:             pulumi.String("string"),
	MysqlSqlModes: pulumi.StringArray{
		pulumi.String("string"),
	},
	Password:        pulumi.String("string"),
	ClusterTimeZone: pulumi.String("string"),
	FerretdbCredentials: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
	PlanDisk:     pulumi.Int(0),
	PlanReplicas: pulumi.Int(0),
	PublicHost:   pulumi.String("string"),
	ReadReplicas: vultr.DatabaseReadReplicaArray{
		&vultr.DatabaseReadReplicaArgs{
			Label:                  pulumi.String("string"),
			Region:                 pulumi.String("string"),
			MysqlRequirePrimaryKey: pulumi.Bool(false),
			FerretdbCredentials: pulumi.StringMap{
				"string": pulumi.String("string"),
			},
			MysqlSqlModes: pulumi.StringArray{
				pulumi.String("string"),
			},
			EvictionPolicy:        pulumi.String("string"),
			Password:              pulumi.String("string"),
			Host:                  pulumi.String("string"),
			Id:                    pulumi.String("string"),
			DatabaseEngineVersion: pulumi.String("string"),
			LatestBackup:          pulumi.String("string"),
			MaintenanceDow:        pulumi.String("string"),
			MaintenanceTime:       pulumi.String("string"),
			Plan:                  pulumi.String("string"),
			ClusterTimeZone:       pulumi.String("string"),
			MysqlSlowQueryLog:     pulumi.Bool(false),
			Dbname:                pulumi.String("string"),
			DateCreated:           pulumi.String("string"),
			MysqlLongQueryTime:    pulumi.Int(0),
			PlanDisk:              pulumi.Int(0),
			PlanRam:               pulumi.Int(0),
			PlanReplicas:          pulumi.Int(0),
			PlanVcpus:             pulumi.Int(0),
			Port:                  pulumi.String("string"),
			PublicHost:            pulumi.String("string"),
			DatabaseEngine:        pulumi.String("string"),
			Status:                pulumi.String("string"),
			Tag:                   pulumi.String("string"),
			TrustedIps: pulumi.StringArray{
				pulumi.String("string"),
			},
			User:  pulumi.String("string"),
			VpcId: pulumi.String("string"),
		},
	},
	AccessKey: pulumi.String("string"),
	SaslPort:  pulumi.String("string"),
	Tag:       pulumi.String("string"),
	TrustedIps: pulumi.StringArray{
		pulumi.String("string"),
	},
	VpcId: pulumi.String("string"),
})
Copy
var databaseResource = new Database("databaseResource", DatabaseArgs.builder()
    .label("string")
    .region("string")
    .plan("string")
    .databaseEngine("string")
    .databaseEngineVersion("string")
    .mysqlSlowQueryLog(false)
    .planBrokers(0)
    .evictionPolicy("string")
    .maintenanceDow("string")
    .maintenanceTime("string")
    .mysqlLongQueryTime(0)
    .mysqlRequirePrimaryKey(false)
    .accessCert("string")
    .mysqlSqlModes("string")
    .password("string")
    .clusterTimeZone("string")
    .ferretdbCredentials(Map.of("string", "string"))
    .planDisk(0)
    .planReplicas(0)
    .publicHost("string")
    .readReplicas(DatabaseReadReplicaArgs.builder()
        .label("string")
        .region("string")
        .mysqlRequirePrimaryKey(false)
        .ferretdbCredentials(Map.of("string", "string"))
        .mysqlSqlModes("string")
        .evictionPolicy("string")
        .password("string")
        .host("string")
        .id("string")
        .databaseEngineVersion("string")
        .latestBackup("string")
        .maintenanceDow("string")
        .maintenanceTime("string")
        .plan("string")
        .clusterTimeZone("string")
        .mysqlSlowQueryLog(false)
        .dbname("string")
        .dateCreated("string")
        .mysqlLongQueryTime(0)
        .planDisk(0)
        .planRam(0)
        .planReplicas(0)
        .planVcpus(0)
        .port("string")
        .publicHost("string")
        .databaseEngine("string")
        .status("string")
        .tag("string")
        .trustedIps("string")
        .user("string")
        .vpcId("string")
        .build())
    .accessKey("string")
    .saslPort("string")
    .tag("string")
    .trustedIps("string")
    .vpcId("string")
    .build());
Copy
database_resource = vultr.Database("databaseResource",
    label="string",
    region="string",
    plan="string",
    database_engine="string",
    database_engine_version="string",
    mysql_slow_query_log=False,
    plan_brokers=0,
    eviction_policy="string",
    maintenance_dow="string",
    maintenance_time="string",
    mysql_long_query_time=0,
    mysql_require_primary_key=False,
    access_cert="string",
    mysql_sql_modes=["string"],
    password="string",
    cluster_time_zone="string",
    ferretdb_credentials={
        "string": "string",
    },
    plan_disk=0,
    plan_replicas=0,
    public_host="string",
    read_replicas=[{
        "label": "string",
        "region": "string",
        "mysql_require_primary_key": False,
        "ferretdb_credentials": {
            "string": "string",
        },
        "mysql_sql_modes": ["string"],
        "eviction_policy": "string",
        "password": "string",
        "host": "string",
        "id": "string",
        "database_engine_version": "string",
        "latest_backup": "string",
        "maintenance_dow": "string",
        "maintenance_time": "string",
        "plan": "string",
        "cluster_time_zone": "string",
        "mysql_slow_query_log": False,
        "dbname": "string",
        "date_created": "string",
        "mysql_long_query_time": 0,
        "plan_disk": 0,
        "plan_ram": 0,
        "plan_replicas": 0,
        "plan_vcpus": 0,
        "port": "string",
        "public_host": "string",
        "database_engine": "string",
        "status": "string",
        "tag": "string",
        "trusted_ips": ["string"],
        "user": "string",
        "vpc_id": "string",
    }],
    access_key="string",
    sasl_port="string",
    tag="string",
    trusted_ips=["string"],
    vpc_id="string")
Copy
const databaseResource = new vultr.Database("databaseResource", {
    label: "string",
    region: "string",
    plan: "string",
    databaseEngine: "string",
    databaseEngineVersion: "string",
    mysqlSlowQueryLog: false,
    planBrokers: 0,
    evictionPolicy: "string",
    maintenanceDow: "string",
    maintenanceTime: "string",
    mysqlLongQueryTime: 0,
    mysqlRequirePrimaryKey: false,
    accessCert: "string",
    mysqlSqlModes: ["string"],
    password: "string",
    clusterTimeZone: "string",
    ferretdbCredentials: {
        string: "string",
    },
    planDisk: 0,
    planReplicas: 0,
    publicHost: "string",
    readReplicas: [{
        label: "string",
        region: "string",
        mysqlRequirePrimaryKey: false,
        ferretdbCredentials: {
            string: "string",
        },
        mysqlSqlModes: ["string"],
        evictionPolicy: "string",
        password: "string",
        host: "string",
        id: "string",
        databaseEngineVersion: "string",
        latestBackup: "string",
        maintenanceDow: "string",
        maintenanceTime: "string",
        plan: "string",
        clusterTimeZone: "string",
        mysqlSlowQueryLog: false,
        dbname: "string",
        dateCreated: "string",
        mysqlLongQueryTime: 0,
        planDisk: 0,
        planRam: 0,
        planReplicas: 0,
        planVcpus: 0,
        port: "string",
        publicHost: "string",
        databaseEngine: "string",
        status: "string",
        tag: "string",
        trustedIps: ["string"],
        user: "string",
        vpcId: "string",
    }],
    accessKey: "string",
    saslPort: "string",
    tag: "string",
    trustedIps: ["string"],
    vpcId: "string",
});
Copy
type: vultr:Database
properties:
    accessCert: string
    accessKey: string
    clusterTimeZone: string
    databaseEngine: string
    databaseEngineVersion: string
    evictionPolicy: string
    ferretdbCredentials:
        string: string
    label: string
    maintenanceDow: string
    maintenanceTime: string
    mysqlLongQueryTime: 0
    mysqlRequirePrimaryKey: false
    mysqlSlowQueryLog: false
    mysqlSqlModes:
        - string
    password: string
    plan: string
    planBrokers: 0
    planDisk: 0
    planReplicas: 0
    publicHost: string
    readReplicas:
        - clusterTimeZone: string
          databaseEngine: string
          databaseEngineVersion: string
          dateCreated: string
          dbname: string
          evictionPolicy: string
          ferretdbCredentials:
            string: string
          host: string
          id: string
          label: string
          latestBackup: string
          maintenanceDow: string
          maintenanceTime: string
          mysqlLongQueryTime: 0
          mysqlRequirePrimaryKey: false
          mysqlSlowQueryLog: false
          mysqlSqlModes:
            - string
          password: string
          plan: string
          planDisk: 0
          planRam: 0
          planReplicas: 0
          planVcpus: 0
          port: string
          publicHost: string
          region: string
          status: string
          tag: string
          trustedIps:
            - string
          user: string
          vpcId: string
    region: string
    saslPort: string
    tag: string
    trustedIps:
        - string
    vpcId: string
Copy

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

DatabaseEngine
This property is required.
Changes to this property will trigger replacement.
string
The database engine of the new managed database.
DatabaseEngineVersion This property is required. string
The database engine version of the new managed database.
Label This property is required. string
A label for the managed database.
Plan This property is required. string
The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
Region This property is required. string
The ID of the region that the managed database is to be created in. See List Regions
AccessCert string
The certificate to authenticate the default user (Kafka engine types only).
AccessKey string
The private key to authenticate the default user (Kafka engine types only).
ClusterTimeZone string
The configured time zone for the Managed Database in TZ database format (e.g. UTC, America/New_York, Europe/London).
EvictionPolicy string
The configuration value for the data eviction policy on the managed database (Redis engine types only - noeviction, allkeys-lru, volatile-lru, allkeys-random, volatile-random, volatile-ttl, volatile-lfu, allkeys-lfu).
FerretdbCredentials Dictionary<string, string>
An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
MaintenanceDow string
The preferred maintenance day of week for the managed database.
MaintenanceTime string
The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g. 01:00, 13:00, 23:00).
MysqlLongQueryTime int
The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
MysqlRequirePrimaryKey bool
The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
MysqlSlowQueryLog bool
The configuration value for slow query logging on the managed database (MySQL engine types only).
MysqlSqlModes List<string>
A list of SQL modes to configure for the managed database (MySQL engine types only - ALLOW_INVALID_DATES, ANSI, ANSI_QUOTES, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_SPACE, NO_AUTO_VALUE_ON_ZERO, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, NO_UNSIGNED_SUBTRACTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, PIPES_AS_CONCAT, REAL_AS_FLOAT, STRICT_ALL_TABLES, STRICT_TRANS_TABLES, TIME_TRUNCATE_FRACTIONAL, TRADITIONAL).
Password string
The password for the managed database's primary admin user.
PlanBrokers int
The number of brokers available on the managed database (Kafka engine types only).
PlanDisk int
The description of the disk(s) on the managed database.
PlanReplicas int
The number of standby nodes available on the managed database (excluded for Kafka engine types).
PublicHost string
The public hostname assigned to the managed database (VPC-attached only).
ReadReplicas List<ediri.Vultr.Inputs.DatabaseReadReplica>
A list of read replicas attached to the managed database.
SaslPort string
The SASL connection port for the managed database (Kafka engine types only).
Tag string
The tag to assign to the managed database.
TrustedIps List<string>
A list of allowed IP addresses for the managed database.
VpcId string
The ID of the VPC Network to attach to the Managed Database.
DatabaseEngine
This property is required.
Changes to this property will trigger replacement.
string
The database engine of the new managed database.
DatabaseEngineVersion This property is required. string
The database engine version of the new managed database.
Label This property is required. string
A label for the managed database.
Plan This property is required. string
The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
Region This property is required. string
The ID of the region that the managed database is to be created in. See List Regions
AccessCert string
The certificate to authenticate the default user (Kafka engine types only).
AccessKey string
The private key to authenticate the default user (Kafka engine types only).
ClusterTimeZone string
The configured time zone for the Managed Database in TZ database format (e.g. UTC, America/New_York, Europe/London).
EvictionPolicy string
The configuration value for the data eviction policy on the managed database (Redis engine types only - noeviction, allkeys-lru, volatile-lru, allkeys-random, volatile-random, volatile-ttl, volatile-lfu, allkeys-lfu).
FerretdbCredentials map[string]string
An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
MaintenanceDow string
The preferred maintenance day of week for the managed database.
MaintenanceTime string
The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g. 01:00, 13:00, 23:00).
MysqlLongQueryTime int
The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
MysqlRequirePrimaryKey bool
The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
MysqlSlowQueryLog bool
The configuration value for slow query logging on the managed database (MySQL engine types only).
MysqlSqlModes []string
A list of SQL modes to configure for the managed database (MySQL engine types only - ALLOW_INVALID_DATES, ANSI, ANSI_QUOTES, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_SPACE, NO_AUTO_VALUE_ON_ZERO, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, NO_UNSIGNED_SUBTRACTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, PIPES_AS_CONCAT, REAL_AS_FLOAT, STRICT_ALL_TABLES, STRICT_TRANS_TABLES, TIME_TRUNCATE_FRACTIONAL, TRADITIONAL).
Password string
The password for the managed database's primary admin user.
PlanBrokers int
The number of brokers available on the managed database (Kafka engine types only).
PlanDisk int
The description of the disk(s) on the managed database.
PlanReplicas int
The number of standby nodes available on the managed database (excluded for Kafka engine types).
PublicHost string
The public hostname assigned to the managed database (VPC-attached only).
ReadReplicas []DatabaseReadReplicaArgs
A list of read replicas attached to the managed database.
SaslPort string
The SASL connection port for the managed database (Kafka engine types only).
Tag string
The tag to assign to the managed database.
TrustedIps []string
A list of allowed IP addresses for the managed database.
VpcId string
The ID of the VPC Network to attach to the Managed Database.
databaseEngine
This property is required.
Changes to this property will trigger replacement.
String
The database engine of the new managed database.
databaseEngineVersion This property is required. String
The database engine version of the new managed database.
label This property is required. String
A label for the managed database.
plan This property is required. String
The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
region This property is required. String
The ID of the region that the managed database is to be created in. See List Regions
accessCert String
The certificate to authenticate the default user (Kafka engine types only).
accessKey String
The private key to authenticate the default user (Kafka engine types only).
clusterTimeZone String
The configured time zone for the Managed Database in TZ database format (e.g. UTC, America/New_York, Europe/London).
evictionPolicy String
The configuration value for the data eviction policy on the managed database (Redis engine types only - noeviction, allkeys-lru, volatile-lru, allkeys-random, volatile-random, volatile-ttl, volatile-lfu, allkeys-lfu).
ferretdbCredentials Map<String,String>
An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
maintenanceDow String
The preferred maintenance day of week for the managed database.
maintenanceTime String
The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g. 01:00, 13:00, 23:00).
mysqlLongQueryTime Integer
The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
mysqlRequirePrimaryKey Boolean
The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
mysqlSlowQueryLog Boolean
The configuration value for slow query logging on the managed database (MySQL engine types only).
mysqlSqlModes List<String>
A list of SQL modes to configure for the managed database (MySQL engine types only - ALLOW_INVALID_DATES, ANSI, ANSI_QUOTES, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_SPACE, NO_AUTO_VALUE_ON_ZERO, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, NO_UNSIGNED_SUBTRACTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, PIPES_AS_CONCAT, REAL_AS_FLOAT, STRICT_ALL_TABLES, STRICT_TRANS_TABLES, TIME_TRUNCATE_FRACTIONAL, TRADITIONAL).
password String
The password for the managed database's primary admin user.
planBrokers Integer
The number of brokers available on the managed database (Kafka engine types only).
planDisk Integer
The description of the disk(s) on the managed database.
planReplicas Integer
The number of standby nodes available on the managed database (excluded for Kafka engine types).
publicHost String
The public hostname assigned to the managed database (VPC-attached only).
readReplicas List<DatabaseReadReplica>
A list of read replicas attached to the managed database.
saslPort String
The SASL connection port for the managed database (Kafka engine types only).
tag String
The tag to assign to the managed database.
trustedIps List<String>
A list of allowed IP addresses for the managed database.
vpcId String
The ID of the VPC Network to attach to the Managed Database.
databaseEngine
This property is required.
Changes to this property will trigger replacement.
string
The database engine of the new managed database.
databaseEngineVersion This property is required. string
The database engine version of the new managed database.
label This property is required. string
A label for the managed database.
plan This property is required. string
The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
region This property is required. string
The ID of the region that the managed database is to be created in. See List Regions
accessCert string
The certificate to authenticate the default user (Kafka engine types only).
accessKey string
The private key to authenticate the default user (Kafka engine types only).
clusterTimeZone string
The configured time zone for the Managed Database in TZ database format (e.g. UTC, America/New_York, Europe/London).
evictionPolicy string
The configuration value for the data eviction policy on the managed database (Redis engine types only - noeviction, allkeys-lru, volatile-lru, allkeys-random, volatile-random, volatile-ttl, volatile-lfu, allkeys-lfu).
ferretdbCredentials {[key: string]: string}
An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
maintenanceDow string
The preferred maintenance day of week for the managed database.
maintenanceTime string
The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g. 01:00, 13:00, 23:00).
mysqlLongQueryTime number
The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
mysqlRequirePrimaryKey boolean
The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
mysqlSlowQueryLog boolean
The configuration value for slow query logging on the managed database (MySQL engine types only).
mysqlSqlModes string[]
A list of SQL modes to configure for the managed database (MySQL engine types only - ALLOW_INVALID_DATES, ANSI, ANSI_QUOTES, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_SPACE, NO_AUTO_VALUE_ON_ZERO, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, NO_UNSIGNED_SUBTRACTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, PIPES_AS_CONCAT, REAL_AS_FLOAT, STRICT_ALL_TABLES, STRICT_TRANS_TABLES, TIME_TRUNCATE_FRACTIONAL, TRADITIONAL).
password string
The password for the managed database's primary admin user.
planBrokers number
The number of brokers available on the managed database (Kafka engine types only).
planDisk number
The description of the disk(s) on the managed database.
planReplicas number
The number of standby nodes available on the managed database (excluded for Kafka engine types).
publicHost string
The public hostname assigned to the managed database (VPC-attached only).
readReplicas DatabaseReadReplica[]
A list of read replicas attached to the managed database.
saslPort string
The SASL connection port for the managed database (Kafka engine types only).
tag string
The tag to assign to the managed database.
trustedIps string[]
A list of allowed IP addresses for the managed database.
vpcId string
The ID of the VPC Network to attach to the Managed Database.
database_engine
This property is required.
Changes to this property will trigger replacement.
str
The database engine of the new managed database.
database_engine_version This property is required. str
The database engine version of the new managed database.
label This property is required. str
A label for the managed database.
plan This property is required. str
The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
region This property is required. str
The ID of the region that the managed database is to be created in. See List Regions
access_cert str
The certificate to authenticate the default user (Kafka engine types only).
access_key str
The private key to authenticate the default user (Kafka engine types only).
cluster_time_zone str
The configured time zone for the Managed Database in TZ database format (e.g. UTC, America/New_York, Europe/London).
eviction_policy str
The configuration value for the data eviction policy on the managed database (Redis engine types only - noeviction, allkeys-lru, volatile-lru, allkeys-random, volatile-random, volatile-ttl, volatile-lfu, allkeys-lfu).
ferretdb_credentials Mapping[str, str]
An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
maintenance_dow str
The preferred maintenance day of week for the managed database.
maintenance_time str
The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g. 01:00, 13:00, 23:00).
mysql_long_query_time int
The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
mysql_require_primary_key bool
The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
mysql_slow_query_log bool
The configuration value for slow query logging on the managed database (MySQL engine types only).
mysql_sql_modes Sequence[str]
A list of SQL modes to configure for the managed database (MySQL engine types only - ALLOW_INVALID_DATES, ANSI, ANSI_QUOTES, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_SPACE, NO_AUTO_VALUE_ON_ZERO, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, NO_UNSIGNED_SUBTRACTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, PIPES_AS_CONCAT, REAL_AS_FLOAT, STRICT_ALL_TABLES, STRICT_TRANS_TABLES, TIME_TRUNCATE_FRACTIONAL, TRADITIONAL).
password str
The password for the managed database's primary admin user.
plan_brokers int
The number of brokers available on the managed database (Kafka engine types only).
plan_disk int
The description of the disk(s) on the managed database.
plan_replicas int
The number of standby nodes available on the managed database (excluded for Kafka engine types).
public_host str
The public hostname assigned to the managed database (VPC-attached only).
read_replicas Sequence[DatabaseReadReplicaArgs]
A list of read replicas attached to the managed database.
sasl_port str
The SASL connection port for the managed database (Kafka engine types only).
tag str
The tag to assign to the managed database.
trusted_ips Sequence[str]
A list of allowed IP addresses for the managed database.
vpc_id str
The ID of the VPC Network to attach to the Managed Database.
databaseEngine
This property is required.
Changes to this property will trigger replacement.
String
The database engine of the new managed database.
databaseEngineVersion This property is required. String
The database engine version of the new managed database.
label This property is required. String
A label for the managed database.
plan This property is required. String
The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
region This property is required. String
The ID of the region that the managed database is to be created in. See List Regions
accessCert String
The certificate to authenticate the default user (Kafka engine types only).
accessKey String
The private key to authenticate the default user (Kafka engine types only).
clusterTimeZone String
The configured time zone for the Managed Database in TZ database format (e.g. UTC, America/New_York, Europe/London).
evictionPolicy String
The configuration value for the data eviction policy on the managed database (Redis engine types only - noeviction, allkeys-lru, volatile-lru, allkeys-random, volatile-random, volatile-ttl, volatile-lfu, allkeys-lfu).
ferretdbCredentials Map<String>
An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
maintenanceDow String
The preferred maintenance day of week for the managed database.
maintenanceTime String
The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g. 01:00, 13:00, 23:00).
mysqlLongQueryTime Number
The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
mysqlRequirePrimaryKey Boolean
The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
mysqlSlowQueryLog Boolean
The configuration value for slow query logging on the managed database (MySQL engine types only).
mysqlSqlModes List<String>
A list of SQL modes to configure for the managed database (MySQL engine types only - ALLOW_INVALID_DATES, ANSI, ANSI_QUOTES, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_SPACE, NO_AUTO_VALUE_ON_ZERO, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, NO_UNSIGNED_SUBTRACTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, PIPES_AS_CONCAT, REAL_AS_FLOAT, STRICT_ALL_TABLES, STRICT_TRANS_TABLES, TIME_TRUNCATE_FRACTIONAL, TRADITIONAL).
password String
The password for the managed database's primary admin user.
planBrokers Number
The number of brokers available on the managed database (Kafka engine types only).
planDisk Number
The description of the disk(s) on the managed database.
planReplicas Number
The number of standby nodes available on the managed database (excluded for Kafka engine types).
publicHost String
The public hostname assigned to the managed database (VPC-attached only).
readReplicas List<Property Map>
A list of read replicas attached to the managed database.
saslPort String
The SASL connection port for the managed database (Kafka engine types only).
tag String
The tag to assign to the managed database.
trustedIps List<String>
A list of allowed IP addresses for the managed database.
vpcId String
The ID of the VPC Network to attach to the Managed Database.

Outputs

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

DateCreated string
The date the managed database was added to your Vultr account.
Dbname string
The managed database's default logical database.
Host string
The hostname assigned to the managed database.
Id string
The provider-assigned unique ID for this managed resource.
LatestBackup string
The date of the latest backup available on the managed database.
PlanRam int
The amount of memory available on the managed database in MB.
PlanVcpus int
The number of virtual CPUs available on the managed database.
Port string
The connection port for the managed database.
Status string
The current status of the managed database (poweroff, rebuilding, rebalancing, configuring, running).
User string
The primary admin user for the managed database.
DateCreated string
The date the managed database was added to your Vultr account.
Dbname string
The managed database's default logical database.
Host string
The hostname assigned to the managed database.
Id string
The provider-assigned unique ID for this managed resource.
LatestBackup string
The date of the latest backup available on the managed database.
PlanRam int
The amount of memory available on the managed database in MB.
PlanVcpus int
The number of virtual CPUs available on the managed database.
Port string
The connection port for the managed database.
Status string
The current status of the managed database (poweroff, rebuilding, rebalancing, configuring, running).
User string
The primary admin user for the managed database.
dateCreated String
The date the managed database was added to your Vultr account.
dbname String
The managed database's default logical database.
host String
The hostname assigned to the managed database.
id String
The provider-assigned unique ID for this managed resource.
latestBackup String
The date of the latest backup available on the managed database.
planRam Integer
The amount of memory available on the managed database in MB.
planVcpus Integer
The number of virtual CPUs available on the managed database.
port String
The connection port for the managed database.
status String
The current status of the managed database (poweroff, rebuilding, rebalancing, configuring, running).
user String
The primary admin user for the managed database.
dateCreated string
The date the managed database was added to your Vultr account.
dbname string
The managed database's default logical database.
host string
The hostname assigned to the managed database.
id string
The provider-assigned unique ID for this managed resource.
latestBackup string
The date of the latest backup available on the managed database.
planRam number
The amount of memory available on the managed database in MB.
planVcpus number
The number of virtual CPUs available on the managed database.
port string
The connection port for the managed database.
status string
The current status of the managed database (poweroff, rebuilding, rebalancing, configuring, running).
user string
The primary admin user for the managed database.
date_created str
The date the managed database was added to your Vultr account.
dbname str
The managed database's default logical database.
host str
The hostname assigned to the managed database.
id str
The provider-assigned unique ID for this managed resource.
latest_backup str
The date of the latest backup available on the managed database.
plan_ram int
The amount of memory available on the managed database in MB.
plan_vcpus int
The number of virtual CPUs available on the managed database.
port str
The connection port for the managed database.
status str
The current status of the managed database (poweroff, rebuilding, rebalancing, configuring, running).
user str
The primary admin user for the managed database.
dateCreated String
The date the managed database was added to your Vultr account.
dbname String
The managed database's default logical database.
host String
The hostname assigned to the managed database.
id String
The provider-assigned unique ID for this managed resource.
latestBackup String
The date of the latest backup available on the managed database.
planRam Number
The amount of memory available on the managed database in MB.
planVcpus Number
The number of virtual CPUs available on the managed database.
port String
The connection port for the managed database.
status String
The current status of the managed database (poweroff, rebuilding, rebalancing, configuring, running).
user String
The primary admin user for the managed database.

Look up Existing Database Resource

Get an existing Database 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?: DatabaseState, opts?: CustomResourceOptions): Database
@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        access_cert: Optional[str] = None,
        access_key: Optional[str] = None,
        cluster_time_zone: Optional[str] = None,
        database_engine: Optional[str] = None,
        database_engine_version: Optional[str] = None,
        date_created: Optional[str] = None,
        dbname: Optional[str] = None,
        eviction_policy: Optional[str] = None,
        ferretdb_credentials: Optional[Mapping[str, str]] = None,
        host: Optional[str] = None,
        label: Optional[str] = None,
        latest_backup: Optional[str] = None,
        maintenance_dow: Optional[str] = None,
        maintenance_time: Optional[str] = None,
        mysql_long_query_time: Optional[int] = None,
        mysql_require_primary_key: Optional[bool] = None,
        mysql_slow_query_log: Optional[bool] = None,
        mysql_sql_modes: Optional[Sequence[str]] = None,
        password: Optional[str] = None,
        plan: Optional[str] = None,
        plan_brokers: Optional[int] = None,
        plan_disk: Optional[int] = None,
        plan_ram: Optional[int] = None,
        plan_replicas: Optional[int] = None,
        plan_vcpus: Optional[int] = None,
        port: Optional[str] = None,
        public_host: Optional[str] = None,
        read_replicas: Optional[Sequence[DatabaseReadReplicaArgs]] = None,
        region: Optional[str] = None,
        sasl_port: Optional[str] = None,
        status: Optional[str] = None,
        tag: Optional[str] = None,
        trusted_ips: Optional[Sequence[str]] = None,
        user: Optional[str] = None,
        vpc_id: Optional[str] = None) -> Database
func GetDatabase(ctx *Context, name string, id IDInput, state *DatabaseState, opts ...ResourceOption) (*Database, error)
public static Database Get(string name, Input<string> id, DatabaseState? state, CustomResourceOptions? opts = null)
public static Database get(String name, Output<String> id, DatabaseState state, CustomResourceOptions options)
resources:  _:    type: vultr:Database    get:      id: ${id}
name This property is required.
The unique name of the resulting resource.
id This property is required.
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 This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
name This property is required.
The unique name of the resulting resource.
id This property is required.
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 This property is required.
The unique name of the resulting resource.
id This property is required.
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 This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
The following state arguments are supported:
AccessCert string
The certificate to authenticate the default user (Kafka engine types only).
AccessKey string
The private key to authenticate the default user (Kafka engine types only).
ClusterTimeZone string
The configured time zone for the Managed Database in TZ database format (e.g. UTC, America/New_York, Europe/London).
DatabaseEngine Changes to this property will trigger replacement. string
The database engine of the new managed database.
DatabaseEngineVersion string
The database engine version of the new managed database.
DateCreated string
The date the managed database was added to your Vultr account.
Dbname string
The managed database's default logical database.
EvictionPolicy string
The configuration value for the data eviction policy on the managed database (Redis engine types only - noeviction, allkeys-lru, volatile-lru, allkeys-random, volatile-random, volatile-ttl, volatile-lfu, allkeys-lfu).
FerretdbCredentials Dictionary<string, string>
An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
Host string
The hostname assigned to the managed database.
Label string
A label for the managed database.
LatestBackup string
The date of the latest backup available on the managed database.
MaintenanceDow string
The preferred maintenance day of week for the managed database.
MaintenanceTime string
The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g. 01:00, 13:00, 23:00).
MysqlLongQueryTime int
The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
MysqlRequirePrimaryKey bool
The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
MysqlSlowQueryLog bool
The configuration value for slow query logging on the managed database (MySQL engine types only).
MysqlSqlModes List<string>
A list of SQL modes to configure for the managed database (MySQL engine types only - ALLOW_INVALID_DATES, ANSI, ANSI_QUOTES, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_SPACE, NO_AUTO_VALUE_ON_ZERO, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, NO_UNSIGNED_SUBTRACTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, PIPES_AS_CONCAT, REAL_AS_FLOAT, STRICT_ALL_TABLES, STRICT_TRANS_TABLES, TIME_TRUNCATE_FRACTIONAL, TRADITIONAL).
Password string
The password for the managed database's primary admin user.
Plan string
The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
PlanBrokers int
The number of brokers available on the managed database (Kafka engine types only).
PlanDisk int
The description of the disk(s) on the managed database.
PlanRam int
The amount of memory available on the managed database in MB.
PlanReplicas int
The number of standby nodes available on the managed database (excluded for Kafka engine types).
PlanVcpus int
The number of virtual CPUs available on the managed database.
Port string
The connection port for the managed database.
PublicHost string
The public hostname assigned to the managed database (VPC-attached only).
ReadReplicas List<ediri.Vultr.Inputs.DatabaseReadReplica>
A list of read replicas attached to the managed database.
Region string
The ID of the region that the managed database is to be created in. See List Regions
SaslPort string
The SASL connection port for the managed database (Kafka engine types only).
Status string
The current status of the managed database (poweroff, rebuilding, rebalancing, configuring, running).
Tag string
The tag to assign to the managed database.
TrustedIps List<string>
A list of allowed IP addresses for the managed database.
User string
The primary admin user for the managed database.
VpcId string
The ID of the VPC Network to attach to the Managed Database.
AccessCert string
The certificate to authenticate the default user (Kafka engine types only).
AccessKey string
The private key to authenticate the default user (Kafka engine types only).
ClusterTimeZone string
The configured time zone for the Managed Database in TZ database format (e.g. UTC, America/New_York, Europe/London).
DatabaseEngine Changes to this property will trigger replacement. string
The database engine of the new managed database.
DatabaseEngineVersion string
The database engine version of the new managed database.
DateCreated string
The date the managed database was added to your Vultr account.
Dbname string
The managed database's default logical database.
EvictionPolicy string
The configuration value for the data eviction policy on the managed database (Redis engine types only - noeviction, allkeys-lru, volatile-lru, allkeys-random, volatile-random, volatile-ttl, volatile-lfu, allkeys-lfu).
FerretdbCredentials map[string]string
An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
Host string
The hostname assigned to the managed database.
Label string
A label for the managed database.
LatestBackup string
The date of the latest backup available on the managed database.
MaintenanceDow string
The preferred maintenance day of week for the managed database.
MaintenanceTime string
The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g. 01:00, 13:00, 23:00).
MysqlLongQueryTime int
The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
MysqlRequirePrimaryKey bool
The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
MysqlSlowQueryLog bool
The configuration value for slow query logging on the managed database (MySQL engine types only).
MysqlSqlModes []string
A list of SQL modes to configure for the managed database (MySQL engine types only - ALLOW_INVALID_DATES, ANSI, ANSI_QUOTES, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_SPACE, NO_AUTO_VALUE_ON_ZERO, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, NO_UNSIGNED_SUBTRACTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, PIPES_AS_CONCAT, REAL_AS_FLOAT, STRICT_ALL_TABLES, STRICT_TRANS_TABLES, TIME_TRUNCATE_FRACTIONAL, TRADITIONAL).
Password string
The password for the managed database's primary admin user.
Plan string
The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
PlanBrokers int
The number of brokers available on the managed database (Kafka engine types only).
PlanDisk int
The description of the disk(s) on the managed database.
PlanRam int
The amount of memory available on the managed database in MB.
PlanReplicas int
The number of standby nodes available on the managed database (excluded for Kafka engine types).
PlanVcpus int
The number of virtual CPUs available on the managed database.
Port string
The connection port for the managed database.
PublicHost string
The public hostname assigned to the managed database (VPC-attached only).
ReadReplicas []DatabaseReadReplicaArgs
A list of read replicas attached to the managed database.
Region string
The ID of the region that the managed database is to be created in. See List Regions
SaslPort string
The SASL connection port for the managed database (Kafka engine types only).
Status string
The current status of the managed database (poweroff, rebuilding, rebalancing, configuring, running).
Tag string
The tag to assign to the managed database.
TrustedIps []string
A list of allowed IP addresses for the managed database.
User string
The primary admin user for the managed database.
VpcId string
The ID of the VPC Network to attach to the Managed Database.
accessCert String
The certificate to authenticate the default user (Kafka engine types only).
accessKey String
The private key to authenticate the default user (Kafka engine types only).
clusterTimeZone String
The configured time zone for the Managed Database in TZ database format (e.g. UTC, America/New_York, Europe/London).
databaseEngine Changes to this property will trigger replacement. String
The database engine of the new managed database.
databaseEngineVersion String
The database engine version of the new managed database.
dateCreated String
The date the managed database was added to your Vultr account.
dbname String
The managed database's default logical database.
evictionPolicy String
The configuration value for the data eviction policy on the managed database (Redis engine types only - noeviction, allkeys-lru, volatile-lru, allkeys-random, volatile-random, volatile-ttl, volatile-lfu, allkeys-lfu).
ferretdbCredentials Map<String,String>
An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
host String
The hostname assigned to the managed database.
label String
A label for the managed database.
latestBackup String
The date of the latest backup available on the managed database.
maintenanceDow String
The preferred maintenance day of week for the managed database.
maintenanceTime String
The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g. 01:00, 13:00, 23:00).
mysqlLongQueryTime Integer
The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
mysqlRequirePrimaryKey Boolean
The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
mysqlSlowQueryLog Boolean
The configuration value for slow query logging on the managed database (MySQL engine types only).
mysqlSqlModes List<String>
A list of SQL modes to configure for the managed database (MySQL engine types only - ALLOW_INVALID_DATES, ANSI, ANSI_QUOTES, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_SPACE, NO_AUTO_VALUE_ON_ZERO, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, NO_UNSIGNED_SUBTRACTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, PIPES_AS_CONCAT, REAL_AS_FLOAT, STRICT_ALL_TABLES, STRICT_TRANS_TABLES, TIME_TRUNCATE_FRACTIONAL, TRADITIONAL).
password String
The password for the managed database's primary admin user.
plan String
The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
planBrokers Integer
The number of brokers available on the managed database (Kafka engine types only).
planDisk Integer
The description of the disk(s) on the managed database.
planRam Integer
The amount of memory available on the managed database in MB.
planReplicas Integer
The number of standby nodes available on the managed database (excluded for Kafka engine types).
planVcpus Integer
The number of virtual CPUs available on the managed database.
port String
The connection port for the managed database.
publicHost String
The public hostname assigned to the managed database (VPC-attached only).
readReplicas List<DatabaseReadReplica>
A list of read replicas attached to the managed database.
region String
The ID of the region that the managed database is to be created in. See List Regions
saslPort String
The SASL connection port for the managed database (Kafka engine types only).
status String
The current status of the managed database (poweroff, rebuilding, rebalancing, configuring, running).
tag String
The tag to assign to the managed database.
trustedIps List<String>
A list of allowed IP addresses for the managed database.
user String
The primary admin user for the managed database.
vpcId String
The ID of the VPC Network to attach to the Managed Database.
accessCert string
The certificate to authenticate the default user (Kafka engine types only).
accessKey string
The private key to authenticate the default user (Kafka engine types only).
clusterTimeZone string
The configured time zone for the Managed Database in TZ database format (e.g. UTC, America/New_York, Europe/London).
databaseEngine Changes to this property will trigger replacement. string
The database engine of the new managed database.
databaseEngineVersion string
The database engine version of the new managed database.
dateCreated string
The date the managed database was added to your Vultr account.
dbname string
The managed database's default logical database.
evictionPolicy string
The configuration value for the data eviction policy on the managed database (Redis engine types only - noeviction, allkeys-lru, volatile-lru, allkeys-random, volatile-random, volatile-ttl, volatile-lfu, allkeys-lfu).
ferretdbCredentials {[key: string]: string}
An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
host string
The hostname assigned to the managed database.
label string
A label for the managed database.
latestBackup string
The date of the latest backup available on the managed database.
maintenanceDow string
The preferred maintenance day of week for the managed database.
maintenanceTime string
The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g. 01:00, 13:00, 23:00).
mysqlLongQueryTime number
The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
mysqlRequirePrimaryKey boolean
The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
mysqlSlowQueryLog boolean
The configuration value for slow query logging on the managed database (MySQL engine types only).
mysqlSqlModes string[]
A list of SQL modes to configure for the managed database (MySQL engine types only - ALLOW_INVALID_DATES, ANSI, ANSI_QUOTES, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_SPACE, NO_AUTO_VALUE_ON_ZERO, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, NO_UNSIGNED_SUBTRACTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, PIPES_AS_CONCAT, REAL_AS_FLOAT, STRICT_ALL_TABLES, STRICT_TRANS_TABLES, TIME_TRUNCATE_FRACTIONAL, TRADITIONAL).
password string
The password for the managed database's primary admin user.
plan string
The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
planBrokers number
The number of brokers available on the managed database (Kafka engine types only).
planDisk number
The description of the disk(s) on the managed database.
planRam number
The amount of memory available on the managed database in MB.
planReplicas number
The number of standby nodes available on the managed database (excluded for Kafka engine types).
planVcpus number
The number of virtual CPUs available on the managed database.
port string
The connection port for the managed database.
publicHost string
The public hostname assigned to the managed database (VPC-attached only).
readReplicas DatabaseReadReplica[]
A list of read replicas attached to the managed database.
region string
The ID of the region that the managed database is to be created in. See List Regions
saslPort string
The SASL connection port for the managed database (Kafka engine types only).
status string
The current status of the managed database (poweroff, rebuilding, rebalancing, configuring, running).
tag string
The tag to assign to the managed database.
trustedIps string[]
A list of allowed IP addresses for the managed database.
user string
The primary admin user for the managed database.
vpcId string
The ID of the VPC Network to attach to the Managed Database.
access_cert str
The certificate to authenticate the default user (Kafka engine types only).
access_key str
The private key to authenticate the default user (Kafka engine types only).
cluster_time_zone str
The configured time zone for the Managed Database in TZ database format (e.g. UTC, America/New_York, Europe/London).
database_engine Changes to this property will trigger replacement. str
The database engine of the new managed database.
database_engine_version str
The database engine version of the new managed database.
date_created str
The date the managed database was added to your Vultr account.
dbname str
The managed database's default logical database.
eviction_policy str
The configuration value for the data eviction policy on the managed database (Redis engine types only - noeviction, allkeys-lru, volatile-lru, allkeys-random, volatile-random, volatile-ttl, volatile-lfu, allkeys-lfu).
ferretdb_credentials Mapping[str, str]
An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
host str
The hostname assigned to the managed database.
label str
A label for the managed database.
latest_backup str
The date of the latest backup available on the managed database.
maintenance_dow str
The preferred maintenance day of week for the managed database.
maintenance_time str
The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g. 01:00, 13:00, 23:00).
mysql_long_query_time int
The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
mysql_require_primary_key bool
The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
mysql_slow_query_log bool
The configuration value for slow query logging on the managed database (MySQL engine types only).
mysql_sql_modes Sequence[str]
A list of SQL modes to configure for the managed database (MySQL engine types only - ALLOW_INVALID_DATES, ANSI, ANSI_QUOTES, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_SPACE, NO_AUTO_VALUE_ON_ZERO, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, NO_UNSIGNED_SUBTRACTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, PIPES_AS_CONCAT, REAL_AS_FLOAT, STRICT_ALL_TABLES, STRICT_TRANS_TABLES, TIME_TRUNCATE_FRACTIONAL, TRADITIONAL).
password str
The password for the managed database's primary admin user.
plan str
The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
plan_brokers int
The number of brokers available on the managed database (Kafka engine types only).
plan_disk int
The description of the disk(s) on the managed database.
plan_ram int
The amount of memory available on the managed database in MB.
plan_replicas int
The number of standby nodes available on the managed database (excluded for Kafka engine types).
plan_vcpus int
The number of virtual CPUs available on the managed database.
port str
The connection port for the managed database.
public_host str
The public hostname assigned to the managed database (VPC-attached only).
read_replicas Sequence[DatabaseReadReplicaArgs]
A list of read replicas attached to the managed database.
region str
The ID of the region that the managed database is to be created in. See List Regions
sasl_port str
The SASL connection port for the managed database (Kafka engine types only).
status str
The current status of the managed database (poweroff, rebuilding, rebalancing, configuring, running).
tag str
The tag to assign to the managed database.
trusted_ips Sequence[str]
A list of allowed IP addresses for the managed database.
user str
The primary admin user for the managed database.
vpc_id str
The ID of the VPC Network to attach to the Managed Database.
accessCert String
The certificate to authenticate the default user (Kafka engine types only).
accessKey String
The private key to authenticate the default user (Kafka engine types only).
clusterTimeZone String
The configured time zone for the Managed Database in TZ database format (e.g. UTC, America/New_York, Europe/London).
databaseEngine Changes to this property will trigger replacement. String
The database engine of the new managed database.
databaseEngineVersion String
The database engine version of the new managed database.
dateCreated String
The date the managed database was added to your Vultr account.
dbname String
The managed database's default logical database.
evictionPolicy String
The configuration value for the data eviction policy on the managed database (Redis engine types only - noeviction, allkeys-lru, volatile-lru, allkeys-random, volatile-random, volatile-ttl, volatile-lfu, allkeys-lfu).
ferretdbCredentials Map<String>
An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
host String
The hostname assigned to the managed database.
label String
A label for the managed database.
latestBackup String
The date of the latest backup available on the managed database.
maintenanceDow String
The preferred maintenance day of week for the managed database.
maintenanceTime String
The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g. 01:00, 13:00, 23:00).
mysqlLongQueryTime Number
The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
mysqlRequirePrimaryKey Boolean
The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
mysqlSlowQueryLog Boolean
The configuration value for slow query logging on the managed database (MySQL engine types only).
mysqlSqlModes List<String>
A list of SQL modes to configure for the managed database (MySQL engine types only - ALLOW_INVALID_DATES, ANSI, ANSI_QUOTES, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_SPACE, NO_AUTO_VALUE_ON_ZERO, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, NO_UNSIGNED_SUBTRACTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, PIPES_AS_CONCAT, REAL_AS_FLOAT, STRICT_ALL_TABLES, STRICT_TRANS_TABLES, TIME_TRUNCATE_FRACTIONAL, TRADITIONAL).
password String
The password for the managed database's primary admin user.
plan String
The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
planBrokers Number
The number of brokers available on the managed database (Kafka engine types only).
planDisk Number
The description of the disk(s) on the managed database.
planRam Number
The amount of memory available on the managed database in MB.
planReplicas Number
The number of standby nodes available on the managed database (excluded for Kafka engine types).
planVcpus Number
The number of virtual CPUs available on the managed database.
port String
The connection port for the managed database.
publicHost String
The public hostname assigned to the managed database (VPC-attached only).
readReplicas List<Property Map>
A list of read replicas attached to the managed database.
region String
The ID of the region that the managed database is to be created in. See List Regions
saslPort String
The SASL connection port for the managed database (Kafka engine types only).
status String
The current status of the managed database (poweroff, rebuilding, rebalancing, configuring, running).
tag String
The tag to assign to the managed database.
trustedIps List<String>
A list of allowed IP addresses for the managed database.
user String
The primary admin user for the managed database.
vpcId String
The ID of the VPC Network to attach to the Managed Database.

Supporting Types

DatabaseReadReplica
, DatabaseReadReplicaArgs

Label This property is required. string
A label for the managed database.
Region This property is required. string
The ID of the region that the managed database is to be created in. See List Regions
ClusterTimeZone string
The configured time zone for the Managed Database in TZ database format (e.g. UTC, America/New_York, Europe/London).
DatabaseEngine string
The database engine of the new managed database.
DatabaseEngineVersion string
The database engine version of the new managed database.
DateCreated string
The date the managed database was added to your Vultr account.
Dbname string
The managed database's default logical database.
EvictionPolicy string
The configuration value for the data eviction policy on the managed database (Redis engine types only - noeviction, allkeys-lru, volatile-lru, allkeys-random, volatile-random, volatile-ttl, volatile-lfu, allkeys-lfu).
FerretdbCredentials Dictionary<string, string>
An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
Host string
The hostname assigned to the managed database.
Id string
The ID of the managed database.
LatestBackup string
The date of the latest backup available on the managed database.
MaintenanceDow string
The preferred maintenance day of week for the managed database.
MaintenanceTime string
The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g. 01:00, 13:00, 23:00).
MysqlLongQueryTime int
The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
MysqlRequirePrimaryKey bool
The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
MysqlSlowQueryLog bool
The configuration value for slow query logging on the managed database (MySQL engine types only).
MysqlSqlModes List<string>
A list of SQL modes to configure for the managed database (MySQL engine types only - ALLOW_INVALID_DATES, ANSI, ANSI_QUOTES, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_SPACE, NO_AUTO_VALUE_ON_ZERO, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, NO_UNSIGNED_SUBTRACTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, PIPES_AS_CONCAT, REAL_AS_FLOAT, STRICT_ALL_TABLES, STRICT_TRANS_TABLES, TIME_TRUNCATE_FRACTIONAL, TRADITIONAL).
Password string
The password for the managed database's primary admin user.
Plan string
The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
PlanDisk int
The description of the disk(s) on the managed database.
PlanRam int
The amount of memory available on the managed database in MB.
PlanReplicas int
The number of standby nodes available on the managed database (excluded for Kafka engine types).
PlanVcpus int
The number of virtual CPUs available on the managed database.
Port string
The connection port for the managed database.
PublicHost string
The public hostname assigned to the managed database (VPC-attached only).
Status string
The current status of the managed database (poweroff, rebuilding, rebalancing, configuring, running).
Tag string
The tag to assign to the managed database.
TrustedIps List<string>
A list of allowed IP addresses for the managed database.
User string
The primary admin user for the managed database.
VpcId string
The ID of the VPC Network to attach to the Managed Database.
Label This property is required. string
A label for the managed database.
Region This property is required. string
The ID of the region that the managed database is to be created in. See List Regions
ClusterTimeZone string
The configured time zone for the Managed Database in TZ database format (e.g. UTC, America/New_York, Europe/London).
DatabaseEngine string
The database engine of the new managed database.
DatabaseEngineVersion string
The database engine version of the new managed database.
DateCreated string
The date the managed database was added to your Vultr account.
Dbname string
The managed database's default logical database.
EvictionPolicy string
The configuration value for the data eviction policy on the managed database (Redis engine types only - noeviction, allkeys-lru, volatile-lru, allkeys-random, volatile-random, volatile-ttl, volatile-lfu, allkeys-lfu).
FerretdbCredentials map[string]string
An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
Host string
The hostname assigned to the managed database.
Id string
The ID of the managed database.
LatestBackup string
The date of the latest backup available on the managed database.
MaintenanceDow string
The preferred maintenance day of week for the managed database.
MaintenanceTime string
The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g. 01:00, 13:00, 23:00).
MysqlLongQueryTime int
The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
MysqlRequirePrimaryKey bool
The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
MysqlSlowQueryLog bool
The configuration value for slow query logging on the managed database (MySQL engine types only).
MysqlSqlModes []string
A list of SQL modes to configure for the managed database (MySQL engine types only - ALLOW_INVALID_DATES, ANSI, ANSI_QUOTES, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_SPACE, NO_AUTO_VALUE_ON_ZERO, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, NO_UNSIGNED_SUBTRACTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, PIPES_AS_CONCAT, REAL_AS_FLOAT, STRICT_ALL_TABLES, STRICT_TRANS_TABLES, TIME_TRUNCATE_FRACTIONAL, TRADITIONAL).
Password string
The password for the managed database's primary admin user.
Plan string
The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
PlanDisk int
The description of the disk(s) on the managed database.
PlanRam int
The amount of memory available on the managed database in MB.
PlanReplicas int
The number of standby nodes available on the managed database (excluded for Kafka engine types).
PlanVcpus int
The number of virtual CPUs available on the managed database.
Port string
The connection port for the managed database.
PublicHost string
The public hostname assigned to the managed database (VPC-attached only).
Status string
The current status of the managed database (poweroff, rebuilding, rebalancing, configuring, running).
Tag string
The tag to assign to the managed database.
TrustedIps []string
A list of allowed IP addresses for the managed database.
User string
The primary admin user for the managed database.
VpcId string
The ID of the VPC Network to attach to the Managed Database.
label This property is required. String
A label for the managed database.
region This property is required. String
The ID of the region that the managed database is to be created in. See List Regions
clusterTimeZone String
The configured time zone for the Managed Database in TZ database format (e.g. UTC, America/New_York, Europe/London).
databaseEngine String
The database engine of the new managed database.
databaseEngineVersion String
The database engine version of the new managed database.
dateCreated String
The date the managed database was added to your Vultr account.
dbname String
The managed database's default logical database.
evictionPolicy String
The configuration value for the data eviction policy on the managed database (Redis engine types only - noeviction, allkeys-lru, volatile-lru, allkeys-random, volatile-random, volatile-ttl, volatile-lfu, allkeys-lfu).
ferretdbCredentials Map<String,String>
An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
host String
The hostname assigned to the managed database.
id String
The ID of the managed database.
latestBackup String
The date of the latest backup available on the managed database.
maintenanceDow String
The preferred maintenance day of week for the managed database.
maintenanceTime String
The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g. 01:00, 13:00, 23:00).
mysqlLongQueryTime Integer
The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
mysqlRequirePrimaryKey Boolean
The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
mysqlSlowQueryLog Boolean
The configuration value for slow query logging on the managed database (MySQL engine types only).
mysqlSqlModes List<String>
A list of SQL modes to configure for the managed database (MySQL engine types only - ALLOW_INVALID_DATES, ANSI, ANSI_QUOTES, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_SPACE, NO_AUTO_VALUE_ON_ZERO, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, NO_UNSIGNED_SUBTRACTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, PIPES_AS_CONCAT, REAL_AS_FLOAT, STRICT_ALL_TABLES, STRICT_TRANS_TABLES, TIME_TRUNCATE_FRACTIONAL, TRADITIONAL).
password String
The password for the managed database's primary admin user.
plan String
The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
planDisk Integer
The description of the disk(s) on the managed database.
planRam Integer
The amount of memory available on the managed database in MB.
planReplicas Integer
The number of standby nodes available on the managed database (excluded for Kafka engine types).
planVcpus Integer
The number of virtual CPUs available on the managed database.
port String
The connection port for the managed database.
publicHost String
The public hostname assigned to the managed database (VPC-attached only).
status String
The current status of the managed database (poweroff, rebuilding, rebalancing, configuring, running).
tag String
The tag to assign to the managed database.
trustedIps List<String>
A list of allowed IP addresses for the managed database.
user String
The primary admin user for the managed database.
vpcId String
The ID of the VPC Network to attach to the Managed Database.
label This property is required. string
A label for the managed database.
region This property is required. string
The ID of the region that the managed database is to be created in. See List Regions
clusterTimeZone string
The configured time zone for the Managed Database in TZ database format (e.g. UTC, America/New_York, Europe/London).
databaseEngine string
The database engine of the new managed database.
databaseEngineVersion string
The database engine version of the new managed database.
dateCreated string
The date the managed database was added to your Vultr account.
dbname string
The managed database's default logical database.
evictionPolicy string
The configuration value for the data eviction policy on the managed database (Redis engine types only - noeviction, allkeys-lru, volatile-lru, allkeys-random, volatile-random, volatile-ttl, volatile-lfu, allkeys-lfu).
ferretdbCredentials {[key: string]: string}
An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
host string
The hostname assigned to the managed database.
id string
The ID of the managed database.
latestBackup string
The date of the latest backup available on the managed database.
maintenanceDow string
The preferred maintenance day of week for the managed database.
maintenanceTime string
The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g. 01:00, 13:00, 23:00).
mysqlLongQueryTime number
The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
mysqlRequirePrimaryKey boolean
The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
mysqlSlowQueryLog boolean
The configuration value for slow query logging on the managed database (MySQL engine types only).
mysqlSqlModes string[]
A list of SQL modes to configure for the managed database (MySQL engine types only - ALLOW_INVALID_DATES, ANSI, ANSI_QUOTES, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_SPACE, NO_AUTO_VALUE_ON_ZERO, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, NO_UNSIGNED_SUBTRACTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, PIPES_AS_CONCAT, REAL_AS_FLOAT, STRICT_ALL_TABLES, STRICT_TRANS_TABLES, TIME_TRUNCATE_FRACTIONAL, TRADITIONAL).
password string
The password for the managed database's primary admin user.
plan string
The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
planDisk number
The description of the disk(s) on the managed database.
planRam number
The amount of memory available on the managed database in MB.
planReplicas number
The number of standby nodes available on the managed database (excluded for Kafka engine types).
planVcpus number
The number of virtual CPUs available on the managed database.
port string
The connection port for the managed database.
publicHost string
The public hostname assigned to the managed database (VPC-attached only).
status string
The current status of the managed database (poweroff, rebuilding, rebalancing, configuring, running).
tag string
The tag to assign to the managed database.
trustedIps string[]
A list of allowed IP addresses for the managed database.
user string
The primary admin user for the managed database.
vpcId string
The ID of the VPC Network to attach to the Managed Database.
label This property is required. str
A label for the managed database.
region This property is required. str
The ID of the region that the managed database is to be created in. See List Regions
cluster_time_zone str
The configured time zone for the Managed Database in TZ database format (e.g. UTC, America/New_York, Europe/London).
database_engine str
The database engine of the new managed database.
database_engine_version str
The database engine version of the new managed database.
date_created str
The date the managed database was added to your Vultr account.
dbname str
The managed database's default logical database.
eviction_policy str
The configuration value for the data eviction policy on the managed database (Redis engine types only - noeviction, allkeys-lru, volatile-lru, allkeys-random, volatile-random, volatile-ttl, volatile-lfu, allkeys-lfu).
ferretdb_credentials Mapping[str, str]
An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
host str
The hostname assigned to the managed database.
id str
The ID of the managed database.
latest_backup str
The date of the latest backup available on the managed database.
maintenance_dow str
The preferred maintenance day of week for the managed database.
maintenance_time str
The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g. 01:00, 13:00, 23:00).
mysql_long_query_time int
The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
mysql_require_primary_key bool
The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
mysql_slow_query_log bool
The configuration value for slow query logging on the managed database (MySQL engine types only).
mysql_sql_modes Sequence[str]
A list of SQL modes to configure for the managed database (MySQL engine types only - ALLOW_INVALID_DATES, ANSI, ANSI_QUOTES, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_SPACE, NO_AUTO_VALUE_ON_ZERO, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, NO_UNSIGNED_SUBTRACTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, PIPES_AS_CONCAT, REAL_AS_FLOAT, STRICT_ALL_TABLES, STRICT_TRANS_TABLES, TIME_TRUNCATE_FRACTIONAL, TRADITIONAL).
password str
The password for the managed database's primary admin user.
plan str
The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
plan_disk int
The description of the disk(s) on the managed database.
plan_ram int
The amount of memory available on the managed database in MB.
plan_replicas int
The number of standby nodes available on the managed database (excluded for Kafka engine types).
plan_vcpus int
The number of virtual CPUs available on the managed database.
port str
The connection port for the managed database.
public_host str
The public hostname assigned to the managed database (VPC-attached only).
status str
The current status of the managed database (poweroff, rebuilding, rebalancing, configuring, running).
tag str
The tag to assign to the managed database.
trusted_ips Sequence[str]
A list of allowed IP addresses for the managed database.
user str
The primary admin user for the managed database.
vpc_id str
The ID of the VPC Network to attach to the Managed Database.
label This property is required. String
A label for the managed database.
region This property is required. String
The ID of the region that the managed database is to be created in. See List Regions
clusterTimeZone String
The configured time zone for the Managed Database in TZ database format (e.g. UTC, America/New_York, Europe/London).
databaseEngine String
The database engine of the new managed database.
databaseEngineVersion String
The database engine version of the new managed database.
dateCreated String
The date the managed database was added to your Vultr account.
dbname String
The managed database's default logical database.
evictionPolicy String
The configuration value for the data eviction policy on the managed database (Redis engine types only - noeviction, allkeys-lru, volatile-lru, allkeys-random, volatile-random, volatile-ttl, volatile-lfu, allkeys-lfu).
ferretdbCredentials Map<String>
An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
host String
The hostname assigned to the managed database.
id String
The ID of the managed database.
latestBackup String
The date of the latest backup available on the managed database.
maintenanceDow String
The preferred maintenance day of week for the managed database.
maintenanceTime String
The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g. 01:00, 13:00, 23:00).
mysqlLongQueryTime Number
The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
mysqlRequirePrimaryKey Boolean
The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
mysqlSlowQueryLog Boolean
The configuration value for slow query logging on the managed database (MySQL engine types only).
mysqlSqlModes List<String>
A list of SQL modes to configure for the managed database (MySQL engine types only - ALLOW_INVALID_DATES, ANSI, ANSI_QUOTES, ERROR_FOR_DIVISION_BY_ZERO, HIGH_NOT_PRECEDENCE, IGNORE_SPACE, NO_AUTO_VALUE_ON_ZERO, NO_DIR_IN_CREATE, NO_ENGINE_SUBSTITUTION, NO_UNSIGNED_SUBTRACTION, NO_ZERO_DATE, NO_ZERO_IN_DATE, ONLY_FULL_GROUP_BY, PIPES_AS_CONCAT, REAL_AS_FLOAT, STRICT_ALL_TABLES, STRICT_TRANS_TABLES, TIME_TRUNCATE_FRACTIONAL, TRADITIONAL).
password String
The password for the managed database's primary admin user.
plan String
The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
planDisk Number
The description of the disk(s) on the managed database.
planRam Number
The amount of memory available on the managed database in MB.
planReplicas Number
The number of standby nodes available on the managed database (excluded for Kafka engine types).
planVcpus Number
The number of virtual CPUs available on the managed database.
port String
The connection port for the managed database.
publicHost String
The public hostname assigned to the managed database (VPC-attached only).
status String
The current status of the managed database (poweroff, rebuilding, rebalancing, configuring, running).
tag String
The tag to assign to the managed database.
trustedIps List<String>
A list of allowed IP addresses for the managed database.
user String
The primary admin user for the managed database.
vpcId String
The ID of the VPC Network to attach to the Managed Database.

Import

Database can be imported using the database ID, e.g.

$ pulumi import vultr:index/database:Database my_database b6a859c5-b299-49dd-8888-b1abbc517d08
Copy

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

Package Details

Repository
vultr dirien/pulumi-vultr
License
Apache-2.0
Notes
This Pulumi package is based on the vultr Terraform Provider.
Vultr v2.23.1 published on Tuesday, Dec 10, 2024 by dirien
dirien/pulumi-vultr