Docs Packages
  1. Packages
  2. Vultr
  3. API Docs
  4. Database
Vultr v2.19.0 published on Friday, Jan 5, 2024 by dirien
dirien/pulumi-vultr

vultr.Database

Explore with Pulumi AI

vultr logo
Vultr v2.19.0 published on Friday, Jan 5, 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

    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",
    });

});

    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
	})
}

    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());

    }
}

    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")

    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",
});

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

    Create a new database with options

    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",
    });

});

    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
	})
}

    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());

    }
}

    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")

    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",
});

    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

    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,
             plan: Optional[str] = None,
             database_engine: Optional[str] = None,
             database_engine_version: Optional[str] = None,
             region: Optional[str] = None,
             label: Optional[str] = None,
             mysql_sql_modes: Optional[Sequence[str]] = None,
             maintenance_dow: Optional[str] = None,
             mysql_long_query_time: Optional[int] = None,
             mysql_require_primary_key: Optional[bool] = None,
             mysql_slow_query_log: Optional[bool] = None,
             cluster_time_zone: Optional[str] = None,
             password: Optional[str] = None,
             maintenance_time: Optional[str] = None,
             plan_disk: Optional[int] = None,
             public_host: Optional[str] = None,
             read_replicas: Optional[Sequence[DatabaseReadReplicaArgs]] = None,
             redis_eviction_policy: Optional[str] = None,
             ferretdb_credentials: Optional[Mapping[str, Any]] = 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 string
    The unique name of the resource.
    args DatabaseArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args 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 string
    The unique name of the resource.
    args DatabaseArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args DatabaseArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args DatabaseArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Example

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

    var databaseResource = new Vultr.Database("databaseResource", new()
{
    Plan = "string",
    DatabaseEngine = "string",
    DatabaseEngineVersion = "string",
    Region = "string",
    Label = "string",
    MysqlSqlModes = new[]
    {
        "string",
    },
    MaintenanceDow = "string",
    MysqlLongQueryTime = 0,
    MysqlRequirePrimaryKey = false,
    MysqlSlowQueryLog = false,
    ClusterTimeZone = "string",
    Password = "string",
    MaintenanceTime = "string",
    PlanDisk = 0,
    PublicHost = "string",
    ReadReplicas = new[]
    {
        new Vultr.Inputs.DatabaseReadReplicaArgs
        {
            Label = "string",
            Region = "string",
            MysqlSlowQueryLog = false,
            Host = "string",
            Password = "string",
            FerretdbCredentials = 
            {
                { "string", "any" },
            },
            Plan = "string",
            Id = "string",
            DatabaseEngineVersion = "string",
            LatestBackup = "string",
            MaintenanceDow = "string",
            MaintenanceTime = "string",
            MysqlLongQueryTime = 0,
            PlanDisk = 0,
            ClusterTimeZone = "string",
            MysqlSqlModes = new[]
            {
                "string",
            },
            Dbname = "string",
            DateCreated = "string",
            MysqlRequirePrimaryKey = false,
            PlanRam = 0,
            PlanReplicas = 0,
            PlanVcpus = 0,
            Port = "string",
            PublicHost = "string",
            RedisEvictionPolicy = "string",
            DatabaseEngine = "string",
            Status = "string",
            Tag = "string",
            TrustedIps = new[]
            {
                "string",
            },
            User = "string",
            VpcId = "string",
        },
    },
    RedisEvictionPolicy = "string",
    FerretdbCredentials = 
    {
        { "string", "any" },
    },
    Tag = "string",
    TrustedIps = new[]
    {
        "string",
    },
    VpcId = "string",
});

    example, err := vultr.NewDatabase(ctx, "databaseResource", &vultr.DatabaseArgs{
	Plan:                  pulumi.String("string"),
	DatabaseEngine:        pulumi.String("string"),
	DatabaseEngineVersion: pulumi.String("string"),
	Region:                pulumi.String("string"),
	Label:                 pulumi.String("string"),
	MysqlSqlModes: pulumi.StringArray{
		pulumi.String("string"),
	},
	MaintenanceDow:         pulumi.String("string"),
	MysqlLongQueryTime:     pulumi.Int(0),
	MysqlRequirePrimaryKey: pulumi.Bool(false),
	MysqlSlowQueryLog:      pulumi.Bool(false),
	ClusterTimeZone:        pulumi.String("string"),
	Password:               pulumi.String("string"),
	MaintenanceTime:        pulumi.String("string"),
	PlanDisk:               pulumi.Int(0),
	PublicHost:             pulumi.String("string"),
	ReadReplicas: vultr.DatabaseReadReplicaArray{
		&vultr.DatabaseReadReplicaArgs{
			Label:             pulumi.String("string"),
			Region:            pulumi.String("string"),
			MysqlSlowQueryLog: pulumi.Bool(false),
			Host:              pulumi.String("string"),
			Password:          pulumi.String("string"),
			FerretdbCredentials: pulumi.Map{
				"string": pulumi.Any("any"),
			},
			Plan:                  pulumi.String("string"),
			Id:                    pulumi.String("string"),
			DatabaseEngineVersion: pulumi.String("string"),
			LatestBackup:          pulumi.String("string"),
			MaintenanceDow:        pulumi.String("string"),
			MaintenanceTime:       pulumi.String("string"),
			MysqlLongQueryTime:    pulumi.Int(0),
			PlanDisk:              pulumi.Int(0),
			ClusterTimeZone:       pulumi.String("string"),
			MysqlSqlModes: pulumi.StringArray{
				pulumi.String("string"),
			},
			Dbname:                 pulumi.String("string"),
			DateCreated:            pulumi.String("string"),
			MysqlRequirePrimaryKey: pulumi.Bool(false),
			PlanRam:                pulumi.Int(0),
			PlanReplicas:           pulumi.Int(0),
			PlanVcpus:              pulumi.Int(0),
			Port:                   pulumi.String("string"),
			PublicHost:             pulumi.String("string"),
			RedisEvictionPolicy:    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"),
		},
	},
	RedisEvictionPolicy: pulumi.String("string"),
	FerretdbCredentials: pulumi.Map{
		"string": pulumi.Any("any"),
	},
	Tag: pulumi.String("string"),
	TrustedIps: pulumi.StringArray{
		pulumi.String("string"),
	},
	VpcId: pulumi.String("string"),
})

    var databaseResource = new Database("databaseResource", DatabaseArgs.builder()        
    .plan("string")
    .databaseEngine("string")
    .databaseEngineVersion("string")
    .region("string")
    .label("string")
    .mysqlSqlModes("string")
    .maintenanceDow("string")
    .mysqlLongQueryTime(0)
    .mysqlRequirePrimaryKey(false)
    .mysqlSlowQueryLog(false)
    .clusterTimeZone("string")
    .password("string")
    .maintenanceTime("string")
    .planDisk(0)
    .publicHost("string")
    .readReplicas(DatabaseReadReplicaArgs.builder()
        .label("string")
        .region("string")
        .mysqlSlowQueryLog(false)
        .host("string")
        .password("string")
        .ferretdbCredentials(Map.of("string", "any"))
        .plan("string")
        .id("string")
        .databaseEngineVersion("string")
        .latestBackup("string")
        .maintenanceDow("string")
        .maintenanceTime("string")
        .mysqlLongQueryTime(0)
        .planDisk(0)
        .clusterTimeZone("string")
        .mysqlSqlModes("string")
        .dbname("string")
        .dateCreated("string")
        .mysqlRequirePrimaryKey(false)
        .planRam(0)
        .planReplicas(0)
        .planVcpus(0)
        .port("string")
        .publicHost("string")
        .redisEvictionPolicy("string")
        .databaseEngine("string")
        .status("string")
        .tag("string")
        .trustedIps("string")
        .user("string")
        .vpcId("string")
        .build())
    .redisEvictionPolicy("string")
    .ferretdbCredentials(Map.of("string", "any"))
    .tag("string")
    .trustedIps("string")
    .vpcId("string")
    .build());

    database_resource = vultr.Database("databaseResource",
    plan="string",
    database_engine="string",
    database_engine_version="string",
    region="string",
    label="string",
    mysql_sql_modes=["string"],
    maintenance_dow="string",
    mysql_long_query_time=0,
    mysql_require_primary_key=False,
    mysql_slow_query_log=False,
    cluster_time_zone="string",
    password="string",
    maintenance_time="string",
    plan_disk=0,
    public_host="string",
    read_replicas=[vultr.DatabaseReadReplicaArgs(
        label="string",
        region="string",
        mysql_slow_query_log=False,
        host="string",
        password="string",
        ferretdb_credentials={
            "string": "any",
        },
        plan="string",
        id="string",
        database_engine_version="string",
        latest_backup="string",
        maintenance_dow="string",
        maintenance_time="string",
        mysql_long_query_time=0,
        plan_disk=0,
        cluster_time_zone="string",
        mysql_sql_modes=["string"],
        dbname="string",
        date_created="string",
        mysql_require_primary_key=False,
        plan_ram=0,
        plan_replicas=0,
        plan_vcpus=0,
        port="string",
        public_host="string",
        redis_eviction_policy="string",
        database_engine="string",
        status="string",
        tag="string",
        trusted_ips=["string"],
        user="string",
        vpc_id="string",
    )],
    redis_eviction_policy="string",
    ferretdb_credentials={
        "string": "any",
    },
    tag="string",
    trusted_ips=["string"],
    vpc_id="string")

    const databaseResource = new vultr.Database("databaseResource", {
    plan: "string",
    databaseEngine: "string",
    databaseEngineVersion: "string",
    region: "string",
    label: "string",
    mysqlSqlModes: ["string"],
    maintenanceDow: "string",
    mysqlLongQueryTime: 0,
    mysqlRequirePrimaryKey: false,
    mysqlSlowQueryLog: false,
    clusterTimeZone: "string",
    password: "string",
    maintenanceTime: "string",
    planDisk: 0,
    publicHost: "string",
    readReplicas: [{
        label: "string",
        region: "string",
        mysqlSlowQueryLog: false,
        host: "string",
        password: "string",
        ferretdbCredentials: {
            string: "any",
        },
        plan: "string",
        id: "string",
        databaseEngineVersion: "string",
        latestBackup: "string",
        maintenanceDow: "string",
        maintenanceTime: "string",
        mysqlLongQueryTime: 0,
        planDisk: 0,
        clusterTimeZone: "string",
        mysqlSqlModes: ["string"],
        dbname: "string",
        dateCreated: "string",
        mysqlRequirePrimaryKey: false,
        planRam: 0,
        planReplicas: 0,
        planVcpus: 0,
        port: "string",
        publicHost: "string",
        redisEvictionPolicy: "string",
        databaseEngine: "string",
        status: "string",
        tag: "string",
        trustedIps: ["string"],
        user: "string",
        vpcId: "string",
    }],
    redisEvictionPolicy: "string",
    ferretdbCredentials: {
        string: "any",
    },
    tag: "string",
    trustedIps: ["string"],
    vpcId: "string",
});

    type: vultr:Database
properties:
    clusterTimeZone: string
    databaseEngine: string
    databaseEngineVersion: string
    ferretdbCredentials:
        string: any
    label: string
    maintenanceDow: string
    maintenanceTime: string
    mysqlLongQueryTime: 0
    mysqlRequirePrimaryKey: false
    mysqlSlowQueryLog: false
    mysqlSqlModes:
        - string
    password: string
    plan: string
    planDisk: 0
    publicHost: string
    readReplicas:
        - clusterTimeZone: string
          databaseEngine: string
          databaseEngineVersion: string
          dateCreated: string
          dbname: string
          ferretdbCredentials:
            string: any
          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
          redisEvictionPolicy: string
          region: string
          status: string
          tag: string
          trustedIps:
            - string
          user: string
          vpcId: string
    redisEvictionPolicy: string
    region: string
    tag: string
    trustedIps:
        - string
    vpcId: string

    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

    The Database resource accepts the following input properties:

    DatabaseEngine string
    The database engine of the new managed database.
    DatabaseEngineVersion string
    The database engine version of the new managed database.
    Label string
    A label for the managed database.
    Plan string
    The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
    Region 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).
    FerretdbCredentials Dictionary<string, object>
    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.
    PlanDisk int
    The description of the disk(s) on 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.
    RedisEvictionPolicy 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).
    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 string
    The database engine of the new managed database.
    DatabaseEngineVersion string
    The database engine version of the new managed database.
    Label string
    A label for the managed database.
    Plan string
    The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
    Region 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).
    FerretdbCredentials map[string]interface{}
    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.
    PlanDisk int
    The description of the disk(s) on 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.
    RedisEvictionPolicy 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).
    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 String
    The database engine of the new managed database.
    databaseEngineVersion String
    The database engine version of the new managed database.
    label String
    A label for the managed database.
    plan String
    The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
    region 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).
    ferretdbCredentials Map<String,Object>
    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.
    planDisk Integer
    The description of the disk(s) on 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.
    redisEvictionPolicy 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).
    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 string
    The database engine of the new managed database.
    databaseEngineVersion string
    The database engine version of the new managed database.
    label string
    A label for the managed database.
    plan string
    The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
    region 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).
    ferretdbCredentials {[key: string]: any}
    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.
    planDisk number
    The description of the disk(s) on 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.
    redisEvictionPolicy 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).
    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 str
    The database engine of the new managed database.
    database_engine_version str
    The database engine version of the new managed database.
    label str
    A label for the managed database.
    plan str
    The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
    region 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).
    ferretdb_credentials Mapping[str, Any]
    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_disk int
    The description of the disk(s) on 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.
    redis_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).
    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 String
    The database engine of the new managed database.
    databaseEngineVersion String
    The database engine version of the new managed database.
    label String
    A label for the managed database.
    plan String
    The ID of the plan that you want the managed database to subscribe to. See List Managed Database Plans
    region 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).
    ferretdbCredentials Map<Any>
    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.
    planDisk Number
    The description of the disk(s) on 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.
    redisEvictionPolicy 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).
    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.
    PlanReplicas int
    The number of standby nodes available on the managed database.
    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.
    PlanReplicas int
    The number of standby nodes available on the managed database.
    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.
    planReplicas Integer
    The number of standby nodes available on the managed database.
    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.
    planReplicas number
    The number of standby nodes available on the managed database.
    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_replicas int
    The number of standby nodes available on the managed database.
    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.
    planReplicas Number
    The number of standby nodes available on the managed database.
    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,
        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,
        ferretdb_credentials: Optional[Mapping[str, Any]] = 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_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,
        redis_eviction_policy: Optional[str] = None,
        region: 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)
    Resource lookup is not supported in YAML
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    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.
    FerretdbCredentials Dictionary<string, object>
    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
    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.
    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.
    RedisEvictionPolicy 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).
    Region string
    The ID of the region that the managed database is to be created in. See List Regions
    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.
    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.
    FerretdbCredentials map[string]interface{}
    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
    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.
    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.
    RedisEvictionPolicy 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).
    Region string
    The ID of the region that the managed database is to be created in. See List Regions
    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.
    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.
    ferretdbCredentials Map<String,Object>
    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
    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.
    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.
    redisEvictionPolicy 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).
    region String
    The ID of the region that the managed database is to be created in. See List Regions
    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.
    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.
    ferretdbCredentials {[key: string]: any}
    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
    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.
    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.
    redisEvictionPolicy 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).
    region string
    The ID of the region that the managed database is to be created in. See List Regions
    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.
    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.
    ferretdb_credentials Mapping[str, Any]
    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_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.
    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.
    redis_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).
    region str
    The ID of the region that the managed database is to be created in. See List Regions
    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.
    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.
    ferretdbCredentials Map<Any>
    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
    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.
    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.
    redisEvictionPolicy 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).
    region String
    The ID of the region that the managed database is to be created in. See List Regions
    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 string
    A label for the managed database.
    Region 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.
    FerretdbCredentials Dictionary<string, object>
    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.
    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).
    RedisEvictionPolicy 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).
    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 string
    A label for the managed database.
    Region 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.
    FerretdbCredentials map[string]interface{}
    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.
    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).
    RedisEvictionPolicy 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).
    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 String
    A label for the managed database.
    region 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.
    ferretdbCredentials Map<String,Object>
    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.
    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).
    redisEvictionPolicy 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).
    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 string
    A label for the managed database.
    region 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.
    ferretdbCredentials {[key: string]: any}
    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.
    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).
    redisEvictionPolicy 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).
    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 str
    A label for the managed database.
    region 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.
    ferretdb_credentials Mapping[str, Any]
    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.
    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).
    redis_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).
    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 String
    A label for the managed database.
    region 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.
    ferretdbCredentials Map<Any>
    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.
    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).
    redisEvictionPolicy 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).
    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

    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 logo
    Vultr v2.19.0 published on Friday, Jan 5, 2024 by dirien
    dirien/pulumi-vultr