vultr.Database
Explore with Pulumi AI
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:
- Database
Engine string The database engine of the new managed database.
- Database
Engine stringVersion 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
- Cluster
Time stringZone The configured time zone for the Managed Database in TZ database format (e.g.
UTC
,America/New_York
,Europe/London
).- Ferretdb
Credentials Dictionary<string, object> An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
- Maintenance
Dow string The preferred maintenance day of week for the managed database.
- Maintenance
Time string The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g.
01:00
,13:00
,23:00
).- Mysql
Long intQuery Time The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
- Mysql
Require boolPrimary Key The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
- Mysql
Slow boolQuery Log The configuration value for slow query logging on the managed database (MySQL engine types only).
- Mysql
Sql List<string>Modes 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
Disk int The description of the disk(s) on the managed database.
- Public
Host string The public hostname assigned to the managed database (VPC-attached only).
- Read
Replicas List<ediri.Vultr. Inputs. Database Read Replica> A list of read replicas attached to the managed database.
- Redis
Eviction stringPolicy 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.
- Trusted
Ips List<string> A list of allowed IP addresses for the managed database.
- Vpc
Id string The ID of the VPC Network to attach to the Managed Database.
- Database
Engine string The database engine of the new managed database.
- Database
Engine stringVersion 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
- Cluster
Time stringZone The configured time zone for the Managed Database in TZ database format (e.g.
UTC
,America/New_York
,Europe/London
).- Ferretdb
Credentials map[string]interface{} An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
- Maintenance
Dow string The preferred maintenance day of week for the managed database.
- Maintenance
Time string The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g.
01:00
,13:00
,23:00
).- Mysql
Long intQuery Time The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
- Mysql
Require boolPrimary Key The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
- Mysql
Slow boolQuery Log The configuration value for slow query logging on the managed database (MySQL engine types only).
- Mysql
Sql []stringModes 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
Disk int The description of the disk(s) on the managed database.
- Public
Host string The public hostname assigned to the managed database (VPC-attached only).
- Read
Replicas []DatabaseRead Replica Args A list of read replicas attached to the managed database.
- Redis
Eviction stringPolicy 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.
- Trusted
Ips []string A list of allowed IP addresses for the managed database.
- Vpc
Id string The ID of the VPC Network to attach to the Managed Database.
- database
Engine String The database engine of the new managed database.
- database
Engine StringVersion 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
- cluster
Time StringZone The configured time zone for the Managed Database in TZ database format (e.g.
UTC
,America/New_York
,Europe/London
).- ferretdb
Credentials Map<String,Object> An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
- maintenance
Dow String The preferred maintenance day of week for the managed database.
- maintenance
Time String The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g.
01:00
,13:00
,23:00
).- mysql
Long IntegerQuery Time The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
- mysql
Require BooleanPrimary Key The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
- mysql
Slow BooleanQuery Log The configuration value for slow query logging on the managed database (MySQL engine types only).
- mysql
Sql List<String>Modes 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
Disk Integer The description of the disk(s) on the managed database.
- public
Host String The public hostname assigned to the managed database (VPC-attached only).
- read
Replicas List<DatabaseRead Replica> A list of read replicas attached to the managed database.
- redis
Eviction StringPolicy 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.
- trusted
Ips List<String> A list of allowed IP addresses for the managed database.
- vpc
Id String The ID of the VPC Network to attach to the Managed Database.
- database
Engine string The database engine of the new managed database.
- database
Engine stringVersion 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
- cluster
Time stringZone The configured time zone for the Managed Database in TZ database format (e.g.
UTC
,America/New_York
,Europe/London
).- ferretdb
Credentials {[key: string]: any} An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
- maintenance
Dow string The preferred maintenance day of week for the managed database.
- maintenance
Time string The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g.
01:00
,13:00
,23:00
).- mysql
Long numberQuery Time The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
- mysql
Require booleanPrimary Key The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
- mysql
Slow booleanQuery Log The configuration value for slow query logging on the managed database (MySQL engine types only).
- mysql
Sql string[]Modes 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
Disk number The description of the disk(s) on the managed database.
- public
Host string The public hostname assigned to the managed database (VPC-attached only).
- read
Replicas DatabaseRead Replica[] A list of read replicas attached to the managed database.
- redis
Eviction stringPolicy 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.
- trusted
Ips string[] A list of allowed IP addresses for the managed database.
- vpc
Id 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_ strversion 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_ strzone 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_ intquery_ time The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
- mysql_
require_ boolprimary_ key The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
- mysql_
slow_ boolquery_ log The configuration value for slow query logging on the managed database (MySQL engine types only).
- mysql_
sql_ Sequence[str]modes 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[DatabaseRead Replica Args] A list of read replicas attached to the managed database.
- redis_
eviction_ strpolicy 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.
- database
Engine String The database engine of the new managed database.
- database
Engine StringVersion 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
- cluster
Time StringZone The configured time zone for the Managed Database in TZ database format (e.g.
UTC
,America/New_York
,Europe/London
).- ferretdb
Credentials Map<Any> An associated list of FerretDB connection credentials (FerretDB + PostgreSQL engine types only).
- maintenance
Dow String The preferred maintenance day of week for the managed database.
- maintenance
Time String The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g.
01:00
,13:00
,23:00
).- mysql
Long NumberQuery Time The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
- mysql
Require BooleanPrimary Key The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
- mysql
Slow BooleanQuery Log The configuration value for slow query logging on the managed database (MySQL engine types only).
- mysql
Sql List<String>Modes 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
Disk Number The description of the disk(s) on the managed database.
- public
Host String The public hostname assigned to the managed database (VPC-attached only).
- read
Replicas List<Property Map> A list of read replicas attached to the managed database.
- redis
Eviction StringPolicy 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.
- trusted
Ips List<String> A list of allowed IP addresses for the managed database.
- vpc
Id 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:
- Date
Created 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.
- Latest
Backup string 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 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 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.
- Latest
Backup string 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 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 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.
- latest
Backup String The date of the latest backup available on the managed database.
- plan
Ram Integer The amount of memory available on the managed database in MB.
- plan
Replicas Integer The number of standby nodes available on the managed database.
- plan
Vcpus 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.
- date
Created 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.
- latest
Backup string The date of the latest backup available on the managed database.
- plan
Ram number The amount of memory available on the managed database in MB.
- plan
Replicas number The number of standby nodes available on the managed database.
- plan
Vcpus 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.
- date
Created 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.
- latest
Backup String The date of the latest backup available on the managed database.
- plan
Ram Number The amount of memory available on the managed database in MB.
- plan
Replicas Number The number of standby nodes available on the managed database.
- plan
Vcpus 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.
- Cluster
Time stringZone The configured time zone for the Managed Database in TZ database format (e.g.
UTC
,America/New_York
,Europe/London
).- Database
Engine string The database engine of the new managed database.
- Database
Engine stringVersion The database engine version of the new managed database.
- Date
Created string The date the managed database was added to your Vultr account.
- Dbname string
The managed database's default logical database.
- Ferretdb
Credentials 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.
- Latest
Backup string The date of the latest backup available on the managed database.
- Maintenance
Dow string The preferred maintenance day of week for the managed database.
- Maintenance
Time string The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g.
01:00
,13:00
,23:00
).- Mysql
Long intQuery Time The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
- Mysql
Require boolPrimary Key The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
- Mysql
Slow boolQuery Log The configuration value for slow query logging on the managed database (MySQL engine types only).
- Mysql
Sql List<string>Modes 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
- 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 string
The connection port for the managed database.
- Public
Host string The public hostname assigned to the managed database (VPC-attached only).
- Read
Replicas List<ediri.Vultr. Inputs. Database Read Replica> A list of read replicas attached to the managed database.
- Redis
Eviction stringPolicy 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.
- Trusted
Ips List<string> A list of allowed IP addresses for the managed database.
- User string
The primary admin user for the managed database.
- Vpc
Id string The ID of the VPC Network to attach to the Managed Database.
- Cluster
Time stringZone The configured time zone for the Managed Database in TZ database format (e.g.
UTC
,America/New_York
,Europe/London
).- Database
Engine string The database engine of the new managed database.
- Database
Engine stringVersion The database engine version of the new managed database.
- Date
Created string The date the managed database was added to your Vultr account.
- Dbname string
The managed database's default logical database.
- Ferretdb
Credentials 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.
- Latest
Backup string The date of the latest backup available on the managed database.
- Maintenance
Dow string The preferred maintenance day of week for the managed database.
- Maintenance
Time string The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g.
01:00
,13:00
,23:00
).- Mysql
Long intQuery Time The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
- Mysql
Require boolPrimary Key The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
- Mysql
Slow boolQuery Log The configuration value for slow query logging on the managed database (MySQL engine types only).
- Mysql
Sql []stringModes 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
- 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 string
The connection port for the managed database.
- Public
Host string The public hostname assigned to the managed database (VPC-attached only).
- Read
Replicas []DatabaseRead Replica Args A list of read replicas attached to the managed database.
- Redis
Eviction stringPolicy 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.
- Trusted
Ips []string A list of allowed IP addresses for the managed database.
- User string
The primary admin user for the managed database.
- Vpc
Id string The ID of the VPC Network to attach to the Managed Database.
- cluster
Time StringZone The configured time zone for the Managed Database in TZ database format (e.g.
UTC
,America/New_York
,Europe/London
).- database
Engine String The database engine of the new managed database.
- database
Engine StringVersion The database engine version of the new managed database.
- date
Created String The date the managed database was added to your Vultr account.
- dbname String
The managed database's default logical database.
- ferretdb
Credentials 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.
- latest
Backup String The date of the latest backup available on the managed database.
- maintenance
Dow String The preferred maintenance day of week for the managed database.
- maintenance
Time String The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g.
01:00
,13:00
,23:00
).- mysql
Long IntegerQuery Time The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
- mysql
Require BooleanPrimary Key The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
- mysql
Slow BooleanQuery Log The configuration value for slow query logging on the managed database (MySQL engine types only).
- mysql
Sql List<String>Modes 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
- plan
Disk Integer The description of the disk(s) on the managed database.
- plan
Ram Integer The amount of memory available on the managed database in MB.
- plan
Replicas Integer The number of standby nodes available on the managed database.
- plan
Vcpus Integer The number of virtual CPUs available on the managed database.
- port String
The connection port for the managed database.
- public
Host String The public hostname assigned to the managed database (VPC-attached only).
- read
Replicas List<DatabaseRead Replica> A list of read replicas attached to the managed database.
- redis
Eviction StringPolicy 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.
- trusted
Ips List<String> A list of allowed IP addresses for the managed database.
- user String
The primary admin user for the managed database.
- vpc
Id String The ID of the VPC Network to attach to the Managed Database.
- cluster
Time stringZone The configured time zone for the Managed Database in TZ database format (e.g.
UTC
,America/New_York
,Europe/London
).- database
Engine string The database engine of the new managed database.
- database
Engine stringVersion The database engine version of the new managed database.
- date
Created string The date the managed database was added to your Vultr account.
- dbname string
The managed database's default logical database.
- ferretdb
Credentials {[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.
- latest
Backup string The date of the latest backup available on the managed database.
- maintenance
Dow string The preferred maintenance day of week for the managed database.
- maintenance
Time string The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g.
01:00
,13:00
,23:00
).- mysql
Long numberQuery Time The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
- mysql
Require booleanPrimary Key The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
- mysql
Slow booleanQuery Log The configuration value for slow query logging on the managed database (MySQL engine types only).
- mysql
Sql string[]Modes 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
- plan
Disk number The description of the disk(s) on the managed database.
- plan
Ram number The amount of memory available on the managed database in MB.
- plan
Replicas number The number of standby nodes available on the managed database.
- plan
Vcpus number The number of virtual CPUs available on the managed database.
- port string
The connection port for the managed database.
- public
Host string The public hostname assigned to the managed database (VPC-attached only).
- read
Replicas DatabaseRead Replica[] A list of read replicas attached to the managed database.
- redis
Eviction stringPolicy 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.
- trusted
Ips string[] A list of allowed IP addresses for the managed database.
- user string
The primary admin user for the managed database.
- vpc
Id string The ID of the VPC Network to attach to the Managed Database.
- cluster_
time_ strzone 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_ strversion 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_ intquery_ time The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
- mysql_
require_ boolprimary_ key The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
- mysql_
slow_ boolquery_ log The configuration value for slow query logging on the managed database (MySQL engine types only).
- mysql_
sql_ Sequence[str]modes 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[DatabaseRead Replica Args] A list of read replicas attached to the managed database.
- redis_
eviction_ strpolicy 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.
- cluster
Time StringZone The configured time zone for the Managed Database in TZ database format (e.g.
UTC
,America/New_York
,Europe/London
).- database
Engine String The database engine of the new managed database.
- database
Engine StringVersion The database engine version of the new managed database.
- date
Created String The date the managed database was added to your Vultr account.
- dbname String
The managed database's default logical database.
- ferretdb
Credentials 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.
- latest
Backup String The date of the latest backup available on the managed database.
- maintenance
Dow String The preferred maintenance day of week for the managed database.
- maintenance
Time String The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g.
01:00
,13:00
,23:00
).- mysql
Long NumberQuery Time The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
- mysql
Require BooleanPrimary Key The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
- mysql
Slow BooleanQuery Log The configuration value for slow query logging on the managed database (MySQL engine types only).
- mysql
Sql List<String>Modes 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
- plan
Disk Number The description of the disk(s) on the managed database.
- plan
Ram Number The amount of memory available on the managed database in MB.
- plan
Replicas Number The number of standby nodes available on the managed database.
- plan
Vcpus Number The number of virtual CPUs available on the managed database.
- port String
The connection port for the managed database.
- public
Host String The public hostname assigned to the managed database (VPC-attached only).
- read
Replicas List<Property Map> A list of read replicas attached to the managed database.
- redis
Eviction StringPolicy 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.
- trusted
Ips List<String> A list of allowed IP addresses for the managed database.
- user String
The primary admin user for the managed database.
- vpc
Id 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
- Cluster
Time stringZone The configured time zone for the Managed Database in TZ database format (e.g.
UTC
,America/New_York
,Europe/London
).- Database
Engine string The database engine of the new managed database.
- Database
Engine stringVersion The database engine version of the new managed database.
- Date
Created string The date the managed database was added to your Vultr account.
- Dbname string
The managed database's default logical database.
- Ferretdb
Credentials 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.
- Latest
Backup string The date of the latest backup available on the managed database.
- Maintenance
Dow string The preferred maintenance day of week for the managed database.
- Maintenance
Time string The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g.
01:00
,13:00
,23:00
).- Mysql
Long intQuery Time The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
- Mysql
Require boolPrimary Key The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
- Mysql
Slow boolQuery Log The configuration value for slow query logging on the managed database (MySQL engine types only).
- Mysql
Sql List<string>Modes 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
- 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 string
The connection port for the managed database.
- Public
Host string The public hostname assigned to the managed database (VPC-attached only).
- Redis
Eviction stringPolicy 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.
- Trusted
Ips List<string> A list of allowed IP addresses for the managed database.
- User string
The primary admin user for the managed database.
- Vpc
Id 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
- Cluster
Time stringZone The configured time zone for the Managed Database in TZ database format (e.g.
UTC
,America/New_York
,Europe/London
).- Database
Engine string The database engine of the new managed database.
- Database
Engine stringVersion The database engine version of the new managed database.
- Date
Created string The date the managed database was added to your Vultr account.
- Dbname string
The managed database's default logical database.
- Ferretdb
Credentials 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.
- Latest
Backup string The date of the latest backup available on the managed database.
- Maintenance
Dow string The preferred maintenance day of week for the managed database.
- Maintenance
Time string The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g.
01:00
,13:00
,23:00
).- Mysql
Long intQuery Time The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
- Mysql
Require boolPrimary Key The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
- Mysql
Slow boolQuery Log The configuration value for slow query logging on the managed database (MySQL engine types only).
- Mysql
Sql []stringModes 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
- 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 string
The connection port for the managed database.
- Public
Host string The public hostname assigned to the managed database (VPC-attached only).
- Redis
Eviction stringPolicy 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.
- Trusted
Ips []string A list of allowed IP addresses for the managed database.
- User string
The primary admin user for the managed database.
- Vpc
Id 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
- cluster
Time StringZone The configured time zone for the Managed Database in TZ database format (e.g.
UTC
,America/New_York
,Europe/London
).- database
Engine String The database engine of the new managed database.
- database
Engine StringVersion The database engine version of the new managed database.
- date
Created String The date the managed database was added to your Vultr account.
- dbname String
The managed database's default logical database.
- ferretdb
Credentials 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.
- latest
Backup String The date of the latest backup available on the managed database.
- maintenance
Dow String The preferred maintenance day of week for the managed database.
- maintenance
Time String The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g.
01:00
,13:00
,23:00
).- mysql
Long IntegerQuery Time The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
- mysql
Require BooleanPrimary Key The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
- mysql
Slow BooleanQuery Log The configuration value for slow query logging on the managed database (MySQL engine types only).
- mysql
Sql List<String>Modes 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
- plan
Disk Integer The description of the disk(s) on the managed database.
- plan
Ram Integer The amount of memory available on the managed database in MB.
- plan
Replicas Integer The number of standby nodes available on the managed database.
- plan
Vcpus Integer The number of virtual CPUs available on the managed database.
- port String
The connection port for the managed database.
- public
Host String The public hostname assigned to the managed database (VPC-attached only).
- redis
Eviction StringPolicy 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.
- trusted
Ips List<String> A list of allowed IP addresses for the managed database.
- user String
The primary admin user for the managed database.
- vpc
Id 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
- cluster
Time stringZone The configured time zone for the Managed Database in TZ database format (e.g.
UTC
,America/New_York
,Europe/London
).- database
Engine string The database engine of the new managed database.
- database
Engine stringVersion The database engine version of the new managed database.
- date
Created string The date the managed database was added to your Vultr account.
- dbname string
The managed database's default logical database.
- ferretdb
Credentials {[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.
- latest
Backup string The date of the latest backup available on the managed database.
- maintenance
Dow string The preferred maintenance day of week for the managed database.
- maintenance
Time string The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g.
01:00
,13:00
,23:00
).- mysql
Long numberQuery Time The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
- mysql
Require booleanPrimary Key The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
- mysql
Slow booleanQuery Log The configuration value for slow query logging on the managed database (MySQL engine types only).
- mysql
Sql string[]Modes 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
- plan
Disk number The description of the disk(s) on the managed database.
- plan
Ram number The amount of memory available on the managed database in MB.
- plan
Replicas number The number of standby nodes available on the managed database.
- plan
Vcpus number The number of virtual CPUs available on the managed database.
- port string
The connection port for the managed database.
- public
Host string The public hostname assigned to the managed database (VPC-attached only).
- redis
Eviction stringPolicy 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.
- trusted
Ips string[] A list of allowed IP addresses for the managed database.
- user string
The primary admin user for the managed database.
- vpc
Id 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_ strzone 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_ strversion 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_ intquery_ time The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
- mysql_
require_ boolprimary_ key The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
- mysql_
slow_ boolquery_ log The configuration value for slow query logging on the managed database (MySQL engine types only).
- mysql_
sql_ Sequence[str]modes 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_ strpolicy 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
- cluster
Time StringZone The configured time zone for the Managed Database in TZ database format (e.g.
UTC
,America/New_York
,Europe/London
).- database
Engine String The database engine of the new managed database.
- database
Engine StringVersion The database engine version of the new managed database.
- date
Created String The date the managed database was added to your Vultr account.
- dbname String
The managed database's default logical database.
- ferretdb
Credentials 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.
- latest
Backup String The date of the latest backup available on the managed database.
- maintenance
Dow String The preferred maintenance day of week for the managed database.
- maintenance
Time String The preferred maintenance time for the managed database in 24-hour HH:00 format (e.g.
01:00
,13:00
,23:00
).- mysql
Long NumberQuery Time The configuration value for the long query time (in seconds) on the managed database (MySQL engine types only).
- mysql
Require BooleanPrimary Key The configuration value for whether primary keys are required on the managed database (MySQL engine types only).
- mysql
Slow BooleanQuery Log The configuration value for slow query logging on the managed database (MySQL engine types only).
- mysql
Sql List<String>Modes 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
- plan
Disk Number The description of the disk(s) on the managed database.
- plan
Ram Number The amount of memory available on the managed database in MB.
- plan
Replicas Number The number of standby nodes available on the managed database.
- plan
Vcpus Number The number of virtual CPUs available on the managed database.
- port String
The connection port for the managed database.
- public
Host String The public hostname assigned to the managed database (VPC-attached only).
- redis
Eviction StringPolicy 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.
- trusted
Ips List<String> A list of allowed IP addresses for the managed database.
- user String
The primary admin user for the managed database.
- vpc
Id 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.