1. Packages
  2. Vultr
  3. API Docs
  4. Database
Vultr v2.17.1 published on Wednesday, Nov 15, 2023 by dirien

vultr.Database

Explore with Pulumi AI

vultr logo
Vultr v2.17.1 published on Wednesday, Nov 15, 2023 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

    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Vultr = ediri.Vultr;
    
    return await Deployment.RunAsync(() => 
    {
        var myDatabase = new Vultr.Database("myDatabase", new()
        {
            DatabaseEngine = "pg",
            DatabaseEngineVersion = "15",
            Label = "my_database_label",
            Plan = "vultr-dbaas-startup-cc-1-55-2",
            Region = "ewr",
        });
    
    });
    
    package main
    
    import (
    	"github.com/dirien/pulumi-vultr/sdk/v2/go/vultr"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := vultr.NewDatabase(ctx, "myDatabase", &vultr.DatabaseArgs{
    			DatabaseEngine:        pulumi.String("pg"),
    			DatabaseEngineVersion: pulumi.String("15"),
    			Label:                 pulumi.String("my_database_label"),
    			Plan:                  pulumi.String("vultr-dbaas-startup-cc-1-55-2"),
    			Region:                pulumi.String("ewr"),
    		})
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.vultr.Database;
    import com.pulumi.vultr.DatabaseArgs;
    import java.util.List;
    import java.util.ArrayList;
    import java.util.Map;
    import java.io.File;
    import java.nio.file.Files;
    import java.nio.file.Paths;
    
    public class App {
        public static void main(String[] args) {
            Pulumi.run(App::stack);
        }
    
        public static void stack(Context ctx) {
            var myDatabase = new Database("myDatabase", DatabaseArgs.builder()        
                .databaseEngine("pg")
                .databaseEngineVersion("15")
                .label("my_database_label")
                .plan("vultr-dbaas-startup-cc-1-55-2")
                .region("ewr")
                .build());
    
        }
    }
    
    import pulumi
    import ediri_vultr as vultr
    
    my_database = vultr.Database("myDatabase",
        database_engine="pg",
        database_engine_version="15",
        label="my_database_label",
        plan="vultr-dbaas-startup-cc-1-55-2",
        region="ewr")
    
    import * as pulumi from "@pulumi/pulumi";
    import * as vultr from "@ediri/vultr";
    
    const myDatabase = new vultr.Database("myDatabase", {
        databaseEngine: "pg",
        databaseEngineVersion: "15",
        label: "my_database_label",
        plan: "vultr-dbaas-startup-cc-1-55-2",
        region: "ewr",
    });
    
    resources:
      myDatabase:
        type: vultr:Database
        properties:
          databaseEngine: pg
          databaseEngineVersion: '15'
          label: my_database_label
          plan: vultr-dbaas-startup-cc-1-55-2
          region: ewr
    

    Create a new database with options

    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Vultr = ediri.Vultr;
    
    return await Deployment.RunAsync(() => 
    {
        var myDatabase = new Vultr.Database("myDatabase", new()
        {
            ClusterTimeZone = "America/New_York",
            DatabaseEngine = "pg",
            DatabaseEngineVersion = "15",
            Label = "my_database_label",
            MaintenanceDow = "sunday",
            MaintenanceTime = "01:00",
            Plan = "vultr-dbaas-startup-cc-1-55-2",
            Region = "ewr",
            Tag = "some tag",
        });
    
    });
    
    package main
    
    import (
    	"github.com/dirien/pulumi-vultr/sdk/v2/go/vultr"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := vultr.NewDatabase(ctx, "myDatabase", &vultr.DatabaseArgs{
    			ClusterTimeZone:       pulumi.String("America/New_York"),
    			DatabaseEngine:        pulumi.String("pg"),
    			DatabaseEngineVersion: pulumi.String("15"),
    			Label:                 pulumi.String("my_database_label"),
    			MaintenanceDow:        pulumi.String("sunday"),
    			MaintenanceTime:       pulumi.String("01:00"),
    			Plan:                  pulumi.String("vultr-dbaas-startup-cc-1-55-2"),
    			Region:                pulumi.String("ewr"),
    			Tag:                   pulumi.String("some tag"),
    		})
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.vultr.Database;
    import com.pulumi.vultr.DatabaseArgs;
    import java.util.List;
    import java.util.ArrayList;
    import java.util.Map;
    import java.io.File;
    import java.nio.file.Files;
    import java.nio.file.Paths;
    
    public class App {
        public static void main(String[] args) {
            Pulumi.run(App::stack);
        }
    
        public static void stack(Context ctx) {
            var myDatabase = new Database("myDatabase", DatabaseArgs.builder()        
                .clusterTimeZone("America/New_York")
                .databaseEngine("pg")
                .databaseEngineVersion("15")
                .label("my_database_label")
                .maintenanceDow("sunday")
                .maintenanceTime("01:00")
                .plan("vultr-dbaas-startup-cc-1-55-2")
                .region("ewr")
                .tag("some tag")
                .build());
    
        }
    }
    
    import pulumi
    import ediri_vultr as vultr
    
    my_database = vultr.Database("myDatabase",
        cluster_time_zone="America/New_York",
        database_engine="pg",
        database_engine_version="15",
        label="my_database_label",
        maintenance_dow="sunday",
        maintenance_time="01:00",
        plan="vultr-dbaas-startup-cc-1-55-2",
        region="ewr",
        tag="some tag")
    
    import * as pulumi from "@pulumi/pulumi";
    import * as vultr from "@ediri/vultr";
    
    const myDatabase = new vultr.Database("myDatabase", {
        clusterTimeZone: "America/New_York",
        databaseEngine: "pg",
        databaseEngineVersion: "15",
        label: "my_database_label",
        maintenanceDow: "sunday",
        maintenanceTime: "01:00",
        plan: "vultr-dbaas-startup-cc-1-55-2",
        region: "ewr",
        tag: "some tag",
    });
    
    resources:
      myDatabase:
        type: vultr:Database
        properties:
          clusterTimeZone: America/New_York
          databaseEngine: pg
          databaseEngineVersion: '15'
          label: my_database_label
          maintenanceDow: sunday
          maintenanceTime: 01:00
          plan: vultr-dbaas-startup-cc-1-55-2
          region: ewr
          tag: some tag
    

    Create Database Resource

    new Database(name: string, args: DatabaseArgs, opts?: CustomResourceOptions);
    @overload
    def Database(resource_name: str,
                 opts: Optional[ResourceOptions] = None,
                 cluster_time_zone: Optional[str] = None,
                 database_engine: Optional[str] = None,
                 database_engine_version: Optional[str] = None,
                 ferretdb_credentials: Optional[Mapping[str, Any]] = None,
                 label: 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,
                 public_host: Optional[str] = None,
                 read_replicas: Optional[Sequence[DatabaseReadReplicaArgs]] = None,
                 redis_eviction_policy: Optional[str] = None,
                 region: Optional[str] = None,
                 tag: Optional[str] = None,
                 trusted_ips: Optional[Sequence[str]] = None,
                 vpc_id: Optional[str] = None)
    @overload
    def Database(resource_name: str,
                 args: DatabaseArgs,
                 opts: Optional[ResourceOptions] = 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.
    
    
    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.

    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
    

    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.17.1 published on Wednesday, Nov 15, 2023 by dirien