1. Packages
  2. Vultr
  3. API Docs
  4. Database
Vultr v2.21.1 published on Monday, Jul 22, 2024 by dirien

vultr.Database

Explore with Pulumi AI

vultr logo
Vultr v2.21.1 published on Monday, Jul 22, 2024 by dirien

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

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

    Constructor 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.21.1 published on Monday, Jul 22, 2024 by dirien