Vultr v2.17.1, Nov 15 23

Vultr v2.17.1 published on Wednesday, Nov 15, 2023 by dirien

vultr.Database

Explore with Pulumi AI

Vultr v2.17.1 published on Wednesday, Nov 15, 2023 by dirien

dirien/pulumi-vultr

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

dirien/pulumi-vultr

vultr.Database

On this page

On this page

Example Usage

Create Database Resource

Database Resource Properties

Inputs

Outputs

Look up Existing Database Resource

Supporting Types

DatabaseReadReplica, DatabaseReadReplicaArgs

Import

Package Details

On this page

On this page