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:
import * as pulumi from "@pulumi/pulumi";
import * as vultr from "@ediri/vultr";
const myDatabase = new vultr.Database("myDatabase", {
databaseEngine: "pg",
databaseEngineVersion: "15",
label: "my_database_label",
plan: "vultr-dbaas-startup-cc-1-55-2",
region: "ewr",
});
import pulumi
import ediri_vultr as vultr
my_database = vultr.Database("myDatabase",
database_engine="pg",
database_engine_version="15",
label="my_database_label",
plan="vultr-dbaas-startup-cc-1-55-2",
region="ewr")
package main
import (
"github.com/dirien/pulumi-vultr/sdk/v2/go/vultr"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := vultr.NewDatabase(ctx, "myDatabase", &vultr.DatabaseArgs{
DatabaseEngine: pulumi.String("pg"),
DatabaseEngineVersion: pulumi.String("15"),
Label: pulumi.String("my_database_label"),
Plan: pulumi.String("vultr-dbaas-startup-cc-1-55-2"),
Region: pulumi.String("ewr"),
})
if err != nil {
return err
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Vultr = ediri.Vultr;
return await Deployment.RunAsync(() =>
{
var myDatabase = new Vultr.Database("myDatabase", new()
{
DatabaseEngine = "pg",
DatabaseEngineVersion = "15",
Label = "my_database_label",
Plan = "vultr-dbaas-startup-cc-1-55-2",
Region = "ewr",
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.vultr.Database;
import com.pulumi.vultr.DatabaseArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
var myDatabase = new Database("myDatabase", DatabaseArgs.builder()
.databaseEngine("pg")
.databaseEngineVersion("15")
.label("my_database_label")
.plan("vultr-dbaas-startup-cc-1-55-2")
.region("ewr")
.build());
}
}
resources:
myDatabase:
type: vultr:Database
properties:
databaseEngine: pg
databaseEngineVersion: '15'
label: my_database_label
plan: vultr-dbaas-startup-cc-1-55-2
region: ewr
Create a new database with options:
import * as pulumi from "@pulumi/pulumi";
import * as vultr from "@ediri/vultr";
const myDatabase = new vultr.Database("myDatabase", {
clusterTimeZone: "America/New_York",
databaseEngine: "pg",
databaseEngineVersion: "15",
label: "my_database_label",
maintenanceDow: "sunday",
maintenanceTime: "01:00",
plan: "vultr-dbaas-startup-cc-1-55-2",
region: "ewr",
tag: "some tag",
});
import pulumi
import ediri_vultr as vultr
my_database = vultr.Database("myDatabase",
cluster_time_zone="America/New_York",
database_engine="pg",
database_engine_version="15",
label="my_database_label",
maintenance_dow="sunday",
maintenance_time="01:00",
plan="vultr-dbaas-startup-cc-1-55-2",
region="ewr",
tag="some tag")
package main
import (
"github.com/dirien/pulumi-vultr/sdk/v2/go/vultr"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := vultr.NewDatabase(ctx, "myDatabase", &vultr.DatabaseArgs{
ClusterTimeZone: pulumi.String("America/New_York"),
DatabaseEngine: pulumi.String("pg"),
DatabaseEngineVersion: pulumi.String("15"),
Label: pulumi.String("my_database_label"),
MaintenanceDow: pulumi.String("sunday"),
MaintenanceTime: pulumi.String("01:00"),
Plan: pulumi.String("vultr-dbaas-startup-cc-1-55-2"),
Region: pulumi.String("ewr"),
Tag: pulumi.String("some tag"),
})
if err != nil {
return err
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Vultr = ediri.Vultr;
return await Deployment.RunAsync(() =>
{
var myDatabase = new Vultr.Database("myDatabase", new()
{
ClusterTimeZone = "America/New_York",
DatabaseEngine = "pg",
DatabaseEngineVersion = "15",
Label = "my_database_label",
MaintenanceDow = "sunday",
MaintenanceTime = "01:00",
Plan = "vultr-dbaas-startup-cc-1-55-2",
Region = "ewr",
Tag = "some tag",
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.vultr.Database;
import com.pulumi.vultr.DatabaseArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
var myDatabase = new Database("myDatabase", DatabaseArgs.builder()
.clusterTimeZone("America/New_York")
.databaseEngine("pg")
.databaseEngineVersion("15")
.label("my_database_label")
.maintenanceDow("sunday")
.maintenanceTime("01:00")
.plan("vultr-dbaas-startup-cc-1-55-2")
.region("ewr")
.tag("some tag")
.build());
}
}
resources:
myDatabase:
type: vultr:Database
properties:
clusterTimeZone: America/New_York
databaseEngine: pg
databaseEngineVersion: '15'
label: my_database_label
maintenanceDow: sunday
maintenanceTime: 01:00
plan: vultr-dbaas-startup-cc-1-55-2
region: ewr
tag: some tag
Create Database Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new Database(name: string, args: DatabaseArgs, opts?: CustomResourceOptions);
@overload
def Database(resource_name: str,
args: DatabaseArgs,
opts: Optional[ResourceOptions] = None)
@overload
def Database(resource_name: str,
opts: Optional[ResourceOptions] = None,
plan: Optional[str] = None,
database_engine: Optional[str] = None,
database_engine_version: Optional[str] = None,
region: Optional[str] = None,
label: Optional[str] = None,
mysql_sql_modes: Optional[Sequence[str]] = None,
maintenance_dow: Optional[str] = None,
mysql_long_query_time: Optional[int] = None,
mysql_require_primary_key: Optional[bool] = None,
mysql_slow_query_log: Optional[bool] = None,
cluster_time_zone: Optional[str] = None,
password: Optional[str] = None,
maintenance_time: Optional[str] = None,
plan_disk: Optional[int] = None,
public_host: Optional[str] = None,
read_replicas: Optional[Sequence[DatabaseReadReplicaArgs]] = None,
redis_eviction_policy: Optional[str] = None,
ferretdb_credentials: Optional[Mapping[str, Any]] = None,
tag: Optional[str] = None,
trusted_ips: Optional[Sequence[str]] = None,
vpc_id: Optional[str] = None)
func NewDatabase(ctx *Context, name string, args DatabaseArgs, opts ...ResourceOption) (*Database, error)
public Database(string name, DatabaseArgs args, CustomResourceOptions? opts = null)
public Database(String name, DatabaseArgs args)
public Database(String name, DatabaseArgs args, CustomResourceOptions options)
type: vultr:Database
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
Parameters
- name string
- The unique name of the resource.
- args DatabaseArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- resource_name str
- The unique name of the resource.
- args DatabaseArgs
- The arguments to resource properties.
- opts ResourceOptions
- Bag of options to control resource's behavior.
- ctx Context
- Context object for the current deployment.
- name string
- The unique name of the resource.
- args DatabaseArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args DatabaseArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args DatabaseArgs
- The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
Constructor example
The following reference example uses placeholder values for all input properties.
var databaseResource = new Vultr.Database("databaseResource", new()
{
Plan = "string",
DatabaseEngine = "string",
DatabaseEngineVersion = "string",
Region = "string",
Label = "string",
MysqlSqlModes = new[]
{
"string",
},
MaintenanceDow = "string",
MysqlLongQueryTime = 0,
MysqlRequirePrimaryKey = false,
MysqlSlowQueryLog = false,
ClusterTimeZone = "string",
Password = "string",
MaintenanceTime = "string",
PlanDisk = 0,
PublicHost = "string",
ReadReplicas = new[]
{
new Vultr.Inputs.DatabaseReadReplicaArgs
{
Label = "string",
Region = "string",
MysqlSlowQueryLog = false,
Host = "string",
Password = "string",
FerretdbCredentials =
{
{ "string", "any" },
},
Plan = "string",
Id = "string",
DatabaseEngineVersion = "string",
LatestBackup = "string",
MaintenanceDow = "string",
MaintenanceTime = "string",
MysqlLongQueryTime = 0,
PlanDisk = 0,
ClusterTimeZone = "string",
MysqlSqlModes = new[]
{
"string",
},
Dbname = "string",
DateCreated = "string",
MysqlRequirePrimaryKey = false,
PlanRam = 0,
PlanReplicas = 0,
PlanVcpus = 0,
Port = "string",
PublicHost = "string",
RedisEvictionPolicy = "string",
DatabaseEngine = "string",
Status = "string",
Tag = "string",
TrustedIps = new[]
{
"string",
},
User = "string",
VpcId = "string",
},
},
RedisEvictionPolicy = "string",
FerretdbCredentials =
{
{ "string", "any" },
},
Tag = "string",
TrustedIps = new[]
{
"string",
},
VpcId = "string",
});
example, err := vultr.NewDatabase(ctx, "databaseResource", &vultr.DatabaseArgs{
Plan: pulumi.String("string"),
DatabaseEngine: pulumi.String("string"),
DatabaseEngineVersion: pulumi.String("string"),
Region: pulumi.String("string"),
Label: pulumi.String("string"),
MysqlSqlModes: pulumi.StringArray{
pulumi.String("string"),
},
MaintenanceDow: pulumi.String("string"),
MysqlLongQueryTime: pulumi.Int(0),
MysqlRequirePrimaryKey: pulumi.Bool(false),
MysqlSlowQueryLog: pulumi.Bool(false),
ClusterTimeZone: pulumi.String("string"),
Password: pulumi.String("string"),
MaintenanceTime: pulumi.String("string"),
PlanDisk: pulumi.Int(0),
PublicHost: pulumi.String("string"),
ReadReplicas: vultr.DatabaseReadReplicaArray{
&vultr.DatabaseReadReplicaArgs{
Label: pulumi.String("string"),
Region: pulumi.String("string"),
MysqlSlowQueryLog: pulumi.Bool(false),
Host: pulumi.String("string"),
Password: pulumi.String("string"),
FerretdbCredentials: pulumi.Map{
"string": pulumi.Any("any"),
},
Plan: pulumi.String("string"),
Id: pulumi.String("string"),
DatabaseEngineVersion: pulumi.String("string"),
LatestBackup: pulumi.String("string"),
MaintenanceDow: pulumi.String("string"),
MaintenanceTime: pulumi.String("string"),
MysqlLongQueryTime: pulumi.Int(0),
PlanDisk: pulumi.Int(0),
ClusterTimeZone: pulumi.String("string"),
MysqlSqlModes: pulumi.StringArray{
pulumi.String("string"),
},
Dbname: pulumi.String("string"),
DateCreated: pulumi.String("string"),
MysqlRequirePrimaryKey: pulumi.Bool(false),
PlanRam: pulumi.Int(0),
PlanReplicas: pulumi.Int(0),
PlanVcpus: pulumi.Int(0),
Port: pulumi.String("string"),
PublicHost: pulumi.String("string"),
RedisEvictionPolicy: pulumi.String("string"),
DatabaseEngine: pulumi.String("string"),
Status: pulumi.String("string"),
Tag: pulumi.String("string"),
TrustedIps: pulumi.StringArray{
pulumi.String("string"),
},
User: pulumi.String("string"),
VpcId: pulumi.String("string"),
},
},
RedisEvictionPolicy: pulumi.String("string"),
FerretdbCredentials: pulumi.Map{
"string": pulumi.Any("any"),
},
Tag: pulumi.String("string"),
TrustedIps: pulumi.StringArray{
pulumi.String("string"),
},
VpcId: pulumi.String("string"),
})
var databaseResource = new Database("databaseResource", DatabaseArgs.builder()
.plan("string")
.databaseEngine("string")
.databaseEngineVersion("string")
.region("string")
.label("string")
.mysqlSqlModes("string")
.maintenanceDow("string")
.mysqlLongQueryTime(0)
.mysqlRequirePrimaryKey(false)
.mysqlSlowQueryLog(false)
.clusterTimeZone("string")
.password("string")
.maintenanceTime("string")
.planDisk(0)
.publicHost("string")
.readReplicas(DatabaseReadReplicaArgs.builder()
.label("string")
.region("string")
.mysqlSlowQueryLog(false)
.host("string")
.password("string")
.ferretdbCredentials(Map.of("string", "any"))
.plan("string")
.id("string")
.databaseEngineVersion("string")
.latestBackup("string")
.maintenanceDow("string")
.maintenanceTime("string")
.mysqlLongQueryTime(0)
.planDisk(0)
.clusterTimeZone("string")
.mysqlSqlModes("string")
.dbname("string")
.dateCreated("string")
.mysqlRequirePrimaryKey(false)
.planRam(0)
.planReplicas(0)
.planVcpus(0)
.port("string")
.publicHost("string")
.redisEvictionPolicy("string")
.databaseEngine("string")
.status("string")
.tag("string")
.trustedIps("string")
.user("string")
.vpcId("string")
.build())
.redisEvictionPolicy("string")
.ferretdbCredentials(Map.of("string", "any"))
.tag("string")
.trustedIps("string")
.vpcId("string")
.build());
database_resource = vultr.Database("databaseResource",
plan="string",
database_engine="string",
database_engine_version="string",
region="string",
label="string",
mysql_sql_modes=["string"],
maintenance_dow="string",
mysql_long_query_time=0,
mysql_require_primary_key=False,
mysql_slow_query_log=False,
cluster_time_zone="string",
password="string",
maintenance_time="string",
plan_disk=0,
public_host="string",
read_replicas=[vultr.DatabaseReadReplicaArgs(
label="string",
region="string",
mysql_slow_query_log=False,
host="string",
password="string",
ferretdb_credentials={
"string": "any",
},
plan="string",
id="string",
database_engine_version="string",
latest_backup="string",
maintenance_dow="string",
maintenance_time="string",
mysql_long_query_time=0,
plan_disk=0,
cluster_time_zone="string",
mysql_sql_modes=["string"],
dbname="string",
date_created="string",
mysql_require_primary_key=False,
plan_ram=0,
plan_replicas=0,
plan_vcpus=0,
port="string",
public_host="string",
redis_eviction_policy="string",
database_engine="string",
status="string",
tag="string",
trusted_ips=["string"],
user="string",
vpc_id="string",
)],
redis_eviction_policy="string",
ferretdb_credentials={
"string": "any",
},
tag="string",
trusted_ips=["string"],
vpc_id="string")
const databaseResource = new vultr.Database("databaseResource", {
plan: "string",
databaseEngine: "string",
databaseEngineVersion: "string",
region: "string",
label: "string",
mysqlSqlModes: ["string"],
maintenanceDow: "string",
mysqlLongQueryTime: 0,
mysqlRequirePrimaryKey: false,
mysqlSlowQueryLog: false,
clusterTimeZone: "string",
password: "string",
maintenanceTime: "string",
planDisk: 0,
publicHost: "string",
readReplicas: [{
label: "string",
region: "string",
mysqlSlowQueryLog: false,
host: "string",
password: "string",
ferretdbCredentials: {
string: "any",
},
plan: "string",
id: "string",
databaseEngineVersion: "string",
latestBackup: "string",
maintenanceDow: "string",
maintenanceTime: "string",
mysqlLongQueryTime: 0,
planDisk: 0,
clusterTimeZone: "string",
mysqlSqlModes: ["string"],
dbname: "string",
dateCreated: "string",
mysqlRequirePrimaryKey: false,
planRam: 0,
planReplicas: 0,
planVcpus: 0,
port: "string",
publicHost: "string",
redisEvictionPolicy: "string",
databaseEngine: "string",
status: "string",
tag: "string",
trustedIps: ["string"],
user: "string",
vpcId: "string",
}],
redisEvictionPolicy: "string",
ferretdbCredentials: {
string: "any",
},
tag: "string",
trustedIps: ["string"],
vpcId: "string",
});
type: vultr:Database
properties:
clusterTimeZone: string
databaseEngine: string
databaseEngineVersion: string
ferretdbCredentials:
string: any
label: string
maintenanceDow: string
maintenanceTime: string
mysqlLongQueryTime: 0
mysqlRequirePrimaryKey: false
mysqlSlowQueryLog: false
mysqlSqlModes:
- string
password: string
plan: string
planDisk: 0
publicHost: string
readReplicas:
- clusterTimeZone: string
databaseEngine: string
databaseEngineVersion: string
dateCreated: string
dbname: string
ferretdbCredentials:
string: any
host: string
id: string
label: string
latestBackup: string
maintenanceDow: string
maintenanceTime: string
mysqlLongQueryTime: 0
mysqlRequirePrimaryKey: false
mysqlSlowQueryLog: false
mysqlSqlModes:
- string
password: string
plan: string
planDisk: 0
planRam: 0
planReplicas: 0
planVcpus: 0
port: string
publicHost: string
redisEvictionPolicy: string
region: string
status: string
tag: string
trustedIps:
- string
user: string
vpcId: string
redisEvictionPolicy: string
region: string
tag: string
trustedIps:
- string
vpcId: string
Database Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
The Database resource accepts the following input properties:
- 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
To learn more about importing existing cloud resources, see Importing resources.
Package Details
- Repository
- vultr dirien/pulumi-vultr
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
vultr
Terraform Provider.