aiven.MySql
Explore with Pulumi AI
The MySQL resource allows the creation and management of Aiven MySQL services.
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as aiven from "@pulumi/aiven";
const mysql1 = new aiven.MySql("mysql1", {
project: foo.project,
cloudName: "google-europe-west1",
plan: "business-4",
serviceName: "my-mysql1",
maintenanceWindowDow: "monday",
maintenanceWindowTime: "10:00:00",
mysqlUserConfig: {
mysqlVersion: "8",
mysql: {
sqlMode: "ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE",
sqlRequirePrimaryKey: true,
},
publicAccess: {
mysql: true,
},
},
});
import pulumi
import pulumi_aiven as aiven
mysql1 = aiven.MySql("mysql1",
project=foo["project"],
cloud_name="google-europe-west1",
plan="business-4",
service_name="my-mysql1",
maintenance_window_dow="monday",
maintenance_window_time="10:00:00",
mysql_user_config={
"mysql_version": "8",
"mysql": {
"sql_mode": "ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE",
"sql_require_primary_key": True,
},
"public_access": {
"mysql": True,
},
})
package main
import (
"github.com/pulumi/pulumi-aiven/sdk/v6/go/aiven"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := aiven.NewMySql(ctx, "mysql1", &aiven.MySqlArgs{
Project: pulumi.Any(foo.Project),
CloudName: pulumi.String("google-europe-west1"),
Plan: pulumi.String("business-4"),
ServiceName: pulumi.String("my-mysql1"),
MaintenanceWindowDow: pulumi.String("monday"),
MaintenanceWindowTime: pulumi.String("10:00:00"),
MysqlUserConfig: &aiven.MySqlMysqlUserConfigArgs{
MysqlVersion: pulumi.String("8"),
Mysql: &aiven.MySqlMysqlUserConfigMysqlArgs{
SqlMode: pulumi.String("ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE"),
SqlRequirePrimaryKey: pulumi.Bool(true),
},
PublicAccess: &aiven.MySqlMysqlUserConfigPublicAccessArgs{
Mysql: pulumi.Bool(true),
},
},
})
if err != nil {
return err
}
return nil
})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Aiven = Pulumi.Aiven;
return await Deployment.RunAsync(() =>
{
var mysql1 = new Aiven.MySql("mysql1", new()
{
Project = foo.Project,
CloudName = "google-europe-west1",
Plan = "business-4",
ServiceName = "my-mysql1",
MaintenanceWindowDow = "monday",
MaintenanceWindowTime = "10:00:00",
MysqlUserConfig = new Aiven.Inputs.MySqlMysqlUserConfigArgs
{
MysqlVersion = "8",
Mysql = new Aiven.Inputs.MySqlMysqlUserConfigMysqlArgs
{
SqlMode = "ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE",
SqlRequirePrimaryKey = true,
},
PublicAccess = new Aiven.Inputs.MySqlMysqlUserConfigPublicAccessArgs
{
Mysql = true,
},
},
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.aiven.MySql;
import com.pulumi.aiven.MySqlArgs;
import com.pulumi.aiven.inputs.MySqlMysqlUserConfigArgs;
import com.pulumi.aiven.inputs.MySqlMysqlUserConfigMysqlArgs;
import com.pulumi.aiven.inputs.MySqlMysqlUserConfigPublicAccessArgs;
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 mysql1 = new MySql("mysql1", MySqlArgs.builder()
.project(foo.project())
.cloudName("google-europe-west1")
.plan("business-4")
.serviceName("my-mysql1")
.maintenanceWindowDow("monday")
.maintenanceWindowTime("10:00:00")
.mysqlUserConfig(MySqlMysqlUserConfigArgs.builder()
.mysqlVersion(8)
.mysql(MySqlMysqlUserConfigMysqlArgs.builder()
.sqlMode("ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE")
.sqlRequirePrimaryKey(true)
.build())
.publicAccess(MySqlMysqlUserConfigPublicAccessArgs.builder()
.mysql(true)
.build())
.build())
.build());
}
}
resources:
mysql1:
type: aiven:MySql
properties:
project: ${foo.project}
cloudName: google-europe-west1
plan: business-4
serviceName: my-mysql1
maintenanceWindowDow: monday
maintenanceWindowTime: 10:00:00
mysqlUserConfig:
mysqlVersion: 8
mysql:
sqlMode: ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE
sqlRequirePrimaryKey: true
publicAccess:
mysql: true
Create MySql Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new MySql(name: string, args: MySqlArgs, opts?: CustomResourceOptions);
@overload
def MySql(resource_name: str,
args: MySqlArgs,
opts: Optional[ResourceOptions] = None)
@overload
def MySql(resource_name: str,
opts: Optional[ResourceOptions] = None,
plan: Optional[str] = None,
service_name: Optional[str] = None,
project: Optional[str] = None,
maintenance_window_time: Optional[str] = None,
additional_disk_space: Optional[str] = None,
mysql: Optional[MySqlMysqlArgs] = None,
mysql_user_config: Optional[MySqlMysqlUserConfigArgs] = None,
maintenance_window_dow: Optional[str] = None,
disk_space: Optional[str] = None,
project_vpc_id: Optional[str] = None,
service_integrations: Optional[Sequence[MySqlServiceIntegrationArgs]] = None,
cloud_name: Optional[str] = None,
static_ips: Optional[Sequence[str]] = None,
tags: Optional[Sequence[MySqlTagArgs]] = None,
tech_emails: Optional[Sequence[MySqlTechEmailArgs]] = None,
termination_protection: Optional[bool] = None)
func NewMySql(ctx *Context, name string, args MySqlArgs, opts ...ResourceOption) (*MySql, error)
public MySql(string name, MySqlArgs args, CustomResourceOptions? opts = null)
type: aiven:MySql
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 MySqlArgs
- 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 MySqlArgs
- 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 MySqlArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args MySqlArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args MySqlArgs
- 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 mySqlResource = new Aiven.MySql("mySqlResource", new()
{
Plan = "string",
ServiceName = "string",
Project = "string",
MaintenanceWindowTime = "string",
AdditionalDiskSpace = "string",
Mysql = new Aiven.Inputs.MySqlMysqlArgs
{
Params = new[]
{
new Aiven.Inputs.MySqlMysqlParamArgs
{
DatabaseName = "string",
Host = "string",
Password = "string",
Port = 0,
Sslmode = "string",
User = "string",
},
},
ReplicaUri = "string",
StandbyUris = new[]
{
"string",
},
SyncingUris = new[]
{
"string",
},
Uris = new[]
{
"string",
},
},
MysqlUserConfig = new Aiven.Inputs.MySqlMysqlUserConfigArgs
{
AdditionalBackupRegions = "string",
AdminPassword = "string",
AdminUsername = "string",
BackupHour = 0,
BackupMinute = 0,
BinlogRetentionPeriod = 0,
IpFilterObjects = new[]
{
new Aiven.Inputs.MySqlMysqlUserConfigIpFilterObjectArgs
{
Network = "string",
Description = "string",
},
},
IpFilterStrings = new[]
{
"string",
},
Migration = new Aiven.Inputs.MySqlMysqlUserConfigMigrationArgs
{
Host = "string",
Port = 0,
Dbname = "string",
IgnoreDbs = "string",
IgnoreRoles = "string",
Method = "string",
Password = "string",
Ssl = false,
Username = "string",
},
Mysql = new Aiven.Inputs.MySqlMysqlUserConfigMysqlArgs
{
ConnectTimeout = 0,
DefaultTimeZone = "string",
GroupConcatMaxLen = 0,
InformationSchemaStatsExpiry = 0,
InnodbChangeBufferMaxSize = 0,
InnodbFlushNeighbors = 0,
InnodbFtMinTokenSize = 0,
InnodbFtServerStopwordTable = "string",
InnodbLockWaitTimeout = 0,
InnodbLogBufferSize = 0,
InnodbOnlineAlterLogMaxSize = 0,
InnodbPrintAllDeadlocks = false,
InnodbReadIoThreads = 0,
InnodbRollbackOnTimeout = false,
InnodbThreadConcurrency = 0,
InnodbWriteIoThreads = 0,
InteractiveTimeout = 0,
InternalTmpMemStorageEngine = "string",
LogOutput = "string",
LongQueryTime = 0,
MaxAllowedPacket = 0,
MaxHeapTableSize = 0,
NetBufferLength = 0,
NetReadTimeout = 0,
NetWriteTimeout = 0,
SlowQueryLog = false,
SortBufferSize = 0,
SqlMode = "string",
SqlRequirePrimaryKey = false,
TmpTableSize = 0,
WaitTimeout = 0,
},
MysqlVersion = "string",
PrivateAccess = new Aiven.Inputs.MySqlMysqlUserConfigPrivateAccessArgs
{
Mysql = false,
Mysqlx = false,
Prometheus = false,
},
PrivatelinkAccess = new Aiven.Inputs.MySqlMysqlUserConfigPrivatelinkAccessArgs
{
Mysql = false,
Mysqlx = false,
Prometheus = false,
},
ProjectToForkFrom = "string",
PublicAccess = new Aiven.Inputs.MySqlMysqlUserConfigPublicAccessArgs
{
Mysql = false,
Mysqlx = false,
Prometheus = false,
},
RecoveryTargetTime = "string",
ServiceLog = false,
ServiceToForkFrom = "string",
StaticIps = false,
},
MaintenanceWindowDow = "string",
ProjectVpcId = "string",
ServiceIntegrations = new[]
{
new Aiven.Inputs.MySqlServiceIntegrationArgs
{
IntegrationType = "string",
SourceServiceName = "string",
},
},
CloudName = "string",
StaticIps = new[]
{
"string",
},
Tags = new[]
{
new Aiven.Inputs.MySqlTagArgs
{
Key = "string",
Value = "string",
},
},
TechEmails = new[]
{
new Aiven.Inputs.MySqlTechEmailArgs
{
Email = "string",
},
},
TerminationProtection = false,
});
example, err := aiven.NewMySql(ctx, "mySqlResource", &aiven.MySqlArgs{
Plan: pulumi.String("string"),
ServiceName: pulumi.String("string"),
Project: pulumi.String("string"),
MaintenanceWindowTime: pulumi.String("string"),
AdditionalDiskSpace: pulumi.String("string"),
Mysql: &aiven.MySqlMysqlArgs{
Params: aiven.MySqlMysqlParamArray{
&aiven.MySqlMysqlParamArgs{
DatabaseName: pulumi.String("string"),
Host: pulumi.String("string"),
Password: pulumi.String("string"),
Port: pulumi.Int(0),
Sslmode: pulumi.String("string"),
User: pulumi.String("string"),
},
},
ReplicaUri: pulumi.String("string"),
StandbyUris: pulumi.StringArray{
pulumi.String("string"),
},
SyncingUris: pulumi.StringArray{
pulumi.String("string"),
},
Uris: pulumi.StringArray{
pulumi.String("string"),
},
},
MysqlUserConfig: &aiven.MySqlMysqlUserConfigArgs{
AdditionalBackupRegions: pulumi.String("string"),
AdminPassword: pulumi.String("string"),
AdminUsername: pulumi.String("string"),
BackupHour: pulumi.Int(0),
BackupMinute: pulumi.Int(0),
BinlogRetentionPeriod: pulumi.Int(0),
IpFilterObjects: aiven.MySqlMysqlUserConfigIpFilterObjectArray{
&aiven.MySqlMysqlUserConfigIpFilterObjectArgs{
Network: pulumi.String("string"),
Description: pulumi.String("string"),
},
},
IpFilterStrings: pulumi.StringArray{
pulumi.String("string"),
},
Migration: &aiven.MySqlMysqlUserConfigMigrationArgs{
Host: pulumi.String("string"),
Port: pulumi.Int(0),
Dbname: pulumi.String("string"),
IgnoreDbs: pulumi.String("string"),
IgnoreRoles: pulumi.String("string"),
Method: pulumi.String("string"),
Password: pulumi.String("string"),
Ssl: pulumi.Bool(false),
Username: pulumi.String("string"),
},
Mysql: &aiven.MySqlMysqlUserConfigMysqlArgs{
ConnectTimeout: pulumi.Int(0),
DefaultTimeZone: pulumi.String("string"),
GroupConcatMaxLen: pulumi.Int(0),
InformationSchemaStatsExpiry: pulumi.Int(0),
InnodbChangeBufferMaxSize: pulumi.Int(0),
InnodbFlushNeighbors: pulumi.Int(0),
InnodbFtMinTokenSize: pulumi.Int(0),
InnodbFtServerStopwordTable: pulumi.String("string"),
InnodbLockWaitTimeout: pulumi.Int(0),
InnodbLogBufferSize: pulumi.Int(0),
InnodbOnlineAlterLogMaxSize: pulumi.Int(0),
InnodbPrintAllDeadlocks: pulumi.Bool(false),
InnodbReadIoThreads: pulumi.Int(0),
InnodbRollbackOnTimeout: pulumi.Bool(false),
InnodbThreadConcurrency: pulumi.Int(0),
InnodbWriteIoThreads: pulumi.Int(0),
InteractiveTimeout: pulumi.Int(0),
InternalTmpMemStorageEngine: pulumi.String("string"),
LogOutput: pulumi.String("string"),
LongQueryTime: pulumi.Float64(0),
MaxAllowedPacket: pulumi.Int(0),
MaxHeapTableSize: pulumi.Int(0),
NetBufferLength: pulumi.Int(0),
NetReadTimeout: pulumi.Int(0),
NetWriteTimeout: pulumi.Int(0),
SlowQueryLog: pulumi.Bool(false),
SortBufferSize: pulumi.Int(0),
SqlMode: pulumi.String("string"),
SqlRequirePrimaryKey: pulumi.Bool(false),
TmpTableSize: pulumi.Int(0),
WaitTimeout: pulumi.Int(0),
},
MysqlVersion: pulumi.String("string"),
PrivateAccess: &aiven.MySqlMysqlUserConfigPrivateAccessArgs{
Mysql: pulumi.Bool(false),
Mysqlx: pulumi.Bool(false),
Prometheus: pulumi.Bool(false),
},
PrivatelinkAccess: &aiven.MySqlMysqlUserConfigPrivatelinkAccessArgs{
Mysql: pulumi.Bool(false),
Mysqlx: pulumi.Bool(false),
Prometheus: pulumi.Bool(false),
},
ProjectToForkFrom: pulumi.String("string"),
PublicAccess: &aiven.MySqlMysqlUserConfigPublicAccessArgs{
Mysql: pulumi.Bool(false),
Mysqlx: pulumi.Bool(false),
Prometheus: pulumi.Bool(false),
},
RecoveryTargetTime: pulumi.String("string"),
ServiceLog: pulumi.Bool(false),
ServiceToForkFrom: pulumi.String("string"),
StaticIps: pulumi.Bool(false),
},
MaintenanceWindowDow: pulumi.String("string"),
ProjectVpcId: pulumi.String("string"),
ServiceIntegrations: aiven.MySqlServiceIntegrationArray{
&aiven.MySqlServiceIntegrationArgs{
IntegrationType: pulumi.String("string"),
SourceServiceName: pulumi.String("string"),
},
},
CloudName: pulumi.String("string"),
StaticIps: pulumi.StringArray{
pulumi.String("string"),
},
Tags: aiven.MySqlTagArray{
&aiven.MySqlTagArgs{
Key: pulumi.String("string"),
Value: pulumi.String("string"),
},
},
TechEmails: aiven.MySqlTechEmailArray{
&aiven.MySqlTechEmailArgs{
Email: pulumi.String("string"),
},
},
TerminationProtection: pulumi.Bool(false),
})
var mySqlResource = new MySql("mySqlResource", MySqlArgs.builder()
.plan("string")
.serviceName("string")
.project("string")
.maintenanceWindowTime("string")
.additionalDiskSpace("string")
.mysql(MySqlMysqlArgs.builder()
.params(MySqlMysqlParamArgs.builder()
.databaseName("string")
.host("string")
.password("string")
.port(0)
.sslmode("string")
.user("string")
.build())
.replicaUri("string")
.standbyUris("string")
.syncingUris("string")
.uris("string")
.build())
.mysqlUserConfig(MySqlMysqlUserConfigArgs.builder()
.additionalBackupRegions("string")
.adminPassword("string")
.adminUsername("string")
.backupHour(0)
.backupMinute(0)
.binlogRetentionPeriod(0)
.ipFilterObjects(MySqlMysqlUserConfigIpFilterObjectArgs.builder()
.network("string")
.description("string")
.build())
.ipFilterStrings("string")
.migration(MySqlMysqlUserConfigMigrationArgs.builder()
.host("string")
.port(0)
.dbname("string")
.ignoreDbs("string")
.ignoreRoles("string")
.method("string")
.password("string")
.ssl(false)
.username("string")
.build())
.mysql(MySqlMysqlUserConfigMysqlArgs.builder()
.connectTimeout(0)
.defaultTimeZone("string")
.groupConcatMaxLen(0)
.informationSchemaStatsExpiry(0)
.innodbChangeBufferMaxSize(0)
.innodbFlushNeighbors(0)
.innodbFtMinTokenSize(0)
.innodbFtServerStopwordTable("string")
.innodbLockWaitTimeout(0)
.innodbLogBufferSize(0)
.innodbOnlineAlterLogMaxSize(0)
.innodbPrintAllDeadlocks(false)
.innodbReadIoThreads(0)
.innodbRollbackOnTimeout(false)
.innodbThreadConcurrency(0)
.innodbWriteIoThreads(0)
.interactiveTimeout(0)
.internalTmpMemStorageEngine("string")
.logOutput("string")
.longQueryTime(0)
.maxAllowedPacket(0)
.maxHeapTableSize(0)
.netBufferLength(0)
.netReadTimeout(0)
.netWriteTimeout(0)
.slowQueryLog(false)
.sortBufferSize(0)
.sqlMode("string")
.sqlRequirePrimaryKey(false)
.tmpTableSize(0)
.waitTimeout(0)
.build())
.mysqlVersion("string")
.privateAccess(MySqlMysqlUserConfigPrivateAccessArgs.builder()
.mysql(false)
.mysqlx(false)
.prometheus(false)
.build())
.privatelinkAccess(MySqlMysqlUserConfigPrivatelinkAccessArgs.builder()
.mysql(false)
.mysqlx(false)
.prometheus(false)
.build())
.projectToForkFrom("string")
.publicAccess(MySqlMysqlUserConfigPublicAccessArgs.builder()
.mysql(false)
.mysqlx(false)
.prometheus(false)
.build())
.recoveryTargetTime("string")
.serviceLog(false)
.serviceToForkFrom("string")
.staticIps(false)
.build())
.maintenanceWindowDow("string")
.projectVpcId("string")
.serviceIntegrations(MySqlServiceIntegrationArgs.builder()
.integrationType("string")
.sourceServiceName("string")
.build())
.cloudName("string")
.staticIps("string")
.tags(MySqlTagArgs.builder()
.key("string")
.value("string")
.build())
.techEmails(MySqlTechEmailArgs.builder()
.email("string")
.build())
.terminationProtection(false)
.build());
my_sql_resource = aiven.MySql("mySqlResource",
plan="string",
service_name="string",
project="string",
maintenance_window_time="string",
additional_disk_space="string",
mysql={
"params": [{
"database_name": "string",
"host": "string",
"password": "string",
"port": 0,
"sslmode": "string",
"user": "string",
}],
"replica_uri": "string",
"standby_uris": ["string"],
"syncing_uris": ["string"],
"uris": ["string"],
},
mysql_user_config={
"additional_backup_regions": "string",
"admin_password": "string",
"admin_username": "string",
"backup_hour": 0,
"backup_minute": 0,
"binlog_retention_period": 0,
"ip_filter_objects": [{
"network": "string",
"description": "string",
}],
"ip_filter_strings": ["string"],
"migration": {
"host": "string",
"port": 0,
"dbname": "string",
"ignore_dbs": "string",
"ignore_roles": "string",
"method": "string",
"password": "string",
"ssl": False,
"username": "string",
},
"mysql": {
"connect_timeout": 0,
"default_time_zone": "string",
"group_concat_max_len": 0,
"information_schema_stats_expiry": 0,
"innodb_change_buffer_max_size": 0,
"innodb_flush_neighbors": 0,
"innodb_ft_min_token_size": 0,
"innodb_ft_server_stopword_table": "string",
"innodb_lock_wait_timeout": 0,
"innodb_log_buffer_size": 0,
"innodb_online_alter_log_max_size": 0,
"innodb_print_all_deadlocks": False,
"innodb_read_io_threads": 0,
"innodb_rollback_on_timeout": False,
"innodb_thread_concurrency": 0,
"innodb_write_io_threads": 0,
"interactive_timeout": 0,
"internal_tmp_mem_storage_engine": "string",
"log_output": "string",
"long_query_time": 0,
"max_allowed_packet": 0,
"max_heap_table_size": 0,
"net_buffer_length": 0,
"net_read_timeout": 0,
"net_write_timeout": 0,
"slow_query_log": False,
"sort_buffer_size": 0,
"sql_mode": "string",
"sql_require_primary_key": False,
"tmp_table_size": 0,
"wait_timeout": 0,
},
"mysql_version": "string",
"private_access": {
"mysql": False,
"mysqlx": False,
"prometheus": False,
},
"privatelink_access": {
"mysql": False,
"mysqlx": False,
"prometheus": False,
},
"project_to_fork_from": "string",
"public_access": {
"mysql": False,
"mysqlx": False,
"prometheus": False,
},
"recovery_target_time": "string",
"service_log": False,
"service_to_fork_from": "string",
"static_ips": False,
},
maintenance_window_dow="string",
project_vpc_id="string",
service_integrations=[{
"integration_type": "string",
"source_service_name": "string",
}],
cloud_name="string",
static_ips=["string"],
tags=[{
"key": "string",
"value": "string",
}],
tech_emails=[{
"email": "string",
}],
termination_protection=False)
const mySqlResource = new aiven.MySql("mySqlResource", {
plan: "string",
serviceName: "string",
project: "string",
maintenanceWindowTime: "string",
additionalDiskSpace: "string",
mysql: {
params: [{
databaseName: "string",
host: "string",
password: "string",
port: 0,
sslmode: "string",
user: "string",
}],
replicaUri: "string",
standbyUris: ["string"],
syncingUris: ["string"],
uris: ["string"],
},
mysqlUserConfig: {
additionalBackupRegions: "string",
adminPassword: "string",
adminUsername: "string",
backupHour: 0,
backupMinute: 0,
binlogRetentionPeriod: 0,
ipFilterObjects: [{
network: "string",
description: "string",
}],
ipFilterStrings: ["string"],
migration: {
host: "string",
port: 0,
dbname: "string",
ignoreDbs: "string",
ignoreRoles: "string",
method: "string",
password: "string",
ssl: false,
username: "string",
},
mysql: {
connectTimeout: 0,
defaultTimeZone: "string",
groupConcatMaxLen: 0,
informationSchemaStatsExpiry: 0,
innodbChangeBufferMaxSize: 0,
innodbFlushNeighbors: 0,
innodbFtMinTokenSize: 0,
innodbFtServerStopwordTable: "string",
innodbLockWaitTimeout: 0,
innodbLogBufferSize: 0,
innodbOnlineAlterLogMaxSize: 0,
innodbPrintAllDeadlocks: false,
innodbReadIoThreads: 0,
innodbRollbackOnTimeout: false,
innodbThreadConcurrency: 0,
innodbWriteIoThreads: 0,
interactiveTimeout: 0,
internalTmpMemStorageEngine: "string",
logOutput: "string",
longQueryTime: 0,
maxAllowedPacket: 0,
maxHeapTableSize: 0,
netBufferLength: 0,
netReadTimeout: 0,
netWriteTimeout: 0,
slowQueryLog: false,
sortBufferSize: 0,
sqlMode: "string",
sqlRequirePrimaryKey: false,
tmpTableSize: 0,
waitTimeout: 0,
},
mysqlVersion: "string",
privateAccess: {
mysql: false,
mysqlx: false,
prometheus: false,
},
privatelinkAccess: {
mysql: false,
mysqlx: false,
prometheus: false,
},
projectToForkFrom: "string",
publicAccess: {
mysql: false,
mysqlx: false,
prometheus: false,
},
recoveryTargetTime: "string",
serviceLog: false,
serviceToForkFrom: "string",
staticIps: false,
},
maintenanceWindowDow: "string",
projectVpcId: "string",
serviceIntegrations: [{
integrationType: "string",
sourceServiceName: "string",
}],
cloudName: "string",
staticIps: ["string"],
tags: [{
key: "string",
value: "string",
}],
techEmails: [{
email: "string",
}],
terminationProtection: false,
});
type: aiven:MySql
properties:
additionalDiskSpace: string
cloudName: string
maintenanceWindowDow: string
maintenanceWindowTime: string
mysql:
params:
- databaseName: string
host: string
password: string
port: 0
sslmode: string
user: string
replicaUri: string
standbyUris:
- string
syncingUris:
- string
uris:
- string
mysqlUserConfig:
additionalBackupRegions: string
adminPassword: string
adminUsername: string
backupHour: 0
backupMinute: 0
binlogRetentionPeriod: 0
ipFilterObjects:
- description: string
network: string
ipFilterStrings:
- string
migration:
dbname: string
host: string
ignoreDbs: string
ignoreRoles: string
method: string
password: string
port: 0
ssl: false
username: string
mysql:
connectTimeout: 0
defaultTimeZone: string
groupConcatMaxLen: 0
informationSchemaStatsExpiry: 0
innodbChangeBufferMaxSize: 0
innodbFlushNeighbors: 0
innodbFtMinTokenSize: 0
innodbFtServerStopwordTable: string
innodbLockWaitTimeout: 0
innodbLogBufferSize: 0
innodbOnlineAlterLogMaxSize: 0
innodbPrintAllDeadlocks: false
innodbReadIoThreads: 0
innodbRollbackOnTimeout: false
innodbThreadConcurrency: 0
innodbWriteIoThreads: 0
interactiveTimeout: 0
internalTmpMemStorageEngine: string
logOutput: string
longQueryTime: 0
maxAllowedPacket: 0
maxHeapTableSize: 0
netBufferLength: 0
netReadTimeout: 0
netWriteTimeout: 0
slowQueryLog: false
sortBufferSize: 0
sqlMode: string
sqlRequirePrimaryKey: false
tmpTableSize: 0
waitTimeout: 0
mysqlVersion: string
privateAccess:
mysql: false
mysqlx: false
prometheus: false
privatelinkAccess:
mysql: false
mysqlx: false
prometheus: false
projectToForkFrom: string
publicAccess:
mysql: false
mysqlx: false
prometheus: false
recoveryTargetTime: string
serviceLog: false
serviceToForkFrom: string
staticIps: false
plan: string
project: string
projectVpcId: string
serviceIntegrations:
- integrationType: string
sourceServiceName: string
serviceName: string
staticIps:
- string
tags:
- key: string
value: string
techEmails:
- email: string
terminationProtection: false
MySql Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.
The MySql resource accepts the following input properties:
- Plan string
- Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are
hobbyist
,startup-x
,business-x
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page. - Project string
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- Service
Name string - Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
- Additional
Disk stringSpace - Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart and there might be a short downtime for services with no HA capabilities.
- Cloud
Name string - Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (
aws
,azure
,do
google
,upcloud
, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS. - Disk
Space string - Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- Maintenance
Window stringDow - Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- Maintenance
Window stringTime - Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- Mysql
My
Sql Mysql - MySQL specific server provided values
- Mysql
User MyConfig Sql Mysql User Config - Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- Project
Vpc stringId - Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- Service
Integrations List<MySql Service Integration> - Service integrations to specify when creating a service. Not applied after initial service creation
- Static
Ips List<string> - Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- List<My
Sql Tag> - Tags are key-value pairs that allow you to categorize services.
- Tech
Emails List<MySql Tech Email> - The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- Termination
Protection bool - Prevents the service from being deleted. It is recommended to set this to
true
for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
- Plan string
- Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are
hobbyist
,startup-x
,business-x
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page. - Project string
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- Service
Name string - Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
- Additional
Disk stringSpace - Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart and there might be a short downtime for services with no HA capabilities.
- Cloud
Name string - Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (
aws
,azure
,do
google
,upcloud
, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS. - Disk
Space string - Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- Maintenance
Window stringDow - Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- Maintenance
Window stringTime - Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- Mysql
My
Sql Mysql Args - MySQL specific server provided values
- Mysql
User MyConfig Sql Mysql User Config Args - Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- Project
Vpc stringId - Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- Service
Integrations []MySql Service Integration Args - Service integrations to specify when creating a service. Not applied after initial service creation
- Static
Ips []string - Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- []My
Sql Tag Args - Tags are key-value pairs that allow you to categorize services.
- Tech
Emails []MySql Tech Email Args - The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- Termination
Protection bool - Prevents the service from being deleted. It is recommended to set this to
true
for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
- plan String
- Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are
hobbyist
,startup-x
,business-x
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page. - project String
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- service
Name String - Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
- additional
Disk StringSpace - Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart and there might be a short downtime for services with no HA capabilities.
- cloud
Name String - Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (
aws
,azure
,do
google
,upcloud
, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS. - disk
Space String - Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- maintenance
Window StringDow - Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenance
Window StringTime - Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql
My
Sql Mysql - MySQL specific server provided values
- mysql
User MyConfig Sql Mysql User Config - Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- project
Vpc StringId - Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- service
Integrations List<MySql Service Integration> - Service integrations to specify when creating a service. Not applied after initial service creation
- static
Ips List<String> - Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- List<My
Sql Tag> - Tags are key-value pairs that allow you to categorize services.
- tech
Emails List<MySql Tech Email> - The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- termination
Protection Boolean - Prevents the service from being deleted. It is recommended to set this to
true
for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
- plan string
- Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are
hobbyist
,startup-x
,business-x
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page. - project string
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- service
Name string - Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
- additional
Disk stringSpace - Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart and there might be a short downtime for services with no HA capabilities.
- cloud
Name string - Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (
aws
,azure
,do
google
,upcloud
, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS. - disk
Space string - Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- maintenance
Window stringDow - Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenance
Window stringTime - Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql
My
Sql Mysql - MySQL specific server provided values
- mysql
User MyConfig Sql Mysql User Config - Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- project
Vpc stringId - Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- service
Integrations MySql Service Integration[] - Service integrations to specify when creating a service. Not applied after initial service creation
- static
Ips string[] - Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- My
Sql Tag[] - Tags are key-value pairs that allow you to categorize services.
- tech
Emails MySql Tech Email[] - The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- termination
Protection boolean - Prevents the service from being deleted. It is recommended to set this to
true
for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
- plan str
- Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are
hobbyist
,startup-x
,business-x
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page. - project str
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- service_
name str - Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
- additional_
disk_ strspace - Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart and there might be a short downtime for services with no HA capabilities.
- cloud_
name str - Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (
aws
,azure
,do
google
,upcloud
, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS. - disk_
space str - Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- maintenance_
window_ strdow - Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenance_
window_ strtime - Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql
My
Sql Mysql Args - MySQL specific server provided values
- mysql_
user_ Myconfig Sql Mysql User Config Args - Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- project_
vpc_ strid - Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- service_
integrations Sequence[MySql Service Integration Args] - Service integrations to specify when creating a service. Not applied after initial service creation
- static_
ips Sequence[str] - Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- Sequence[My
Sql Tag Args] - Tags are key-value pairs that allow you to categorize services.
- tech_
emails Sequence[MySql Tech Email Args] - The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- termination_
protection bool - Prevents the service from being deleted. It is recommended to set this to
true
for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
- plan String
- Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are
hobbyist
,startup-x
,business-x
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page. - project String
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- service
Name String - Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
- additional
Disk StringSpace - Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart and there might be a short downtime for services with no HA capabilities.
- cloud
Name String - Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (
aws
,azure
,do
google
,upcloud
, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS. - disk
Space String - Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- maintenance
Window StringDow - Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenance
Window StringTime - Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql Property Map
- MySQL specific server provided values
- mysql
User Property MapConfig - Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- project
Vpc StringId - Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- service
Integrations List<Property Map> - Service integrations to specify when creating a service. Not applied after initial service creation
- static
Ips List<String> - Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- List<Property Map>
- Tags are key-value pairs that allow you to categorize services.
- tech
Emails List<Property Map> - The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- termination
Protection Boolean - Prevents the service from being deleted. It is recommended to set this to
true
for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
Outputs
All input properties are implicitly available as output properties. Additionally, the MySql resource produces the following output properties:
- Components
List<My
Sql Component> - Service component information objects
- Disk
Space stringCap - The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- Disk
Space stringDefault - The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- Disk
Space stringStep - The default disk space step of the service, possible values depend on the service type, the cloud provider and the project.
disk_space
needs to increment fromdisk_space_default
by increments of this size. - Disk
Space stringUsed - Disk space that service is currently using
- Id string
- The provider-assigned unique ID for this managed resource.
- Service
Host string - The hostname of the service.
- Service
Password string - Password used for connecting to the service, if applicable
- Service
Port int - The port of the service
- Service
Type string - Aiven internal service type code
- Service
Uri string - URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- Service
Username string - Username used for connecting to the service, if applicable
- State string
- Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- Components
[]My
Sql Component - Service component information objects
- Disk
Space stringCap - The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- Disk
Space stringDefault - The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- Disk
Space stringStep - The default disk space step of the service, possible values depend on the service type, the cloud provider and the project.
disk_space
needs to increment fromdisk_space_default
by increments of this size. - Disk
Space stringUsed - Disk space that service is currently using
- Id string
- The provider-assigned unique ID for this managed resource.
- Service
Host string - The hostname of the service.
- Service
Password string - Password used for connecting to the service, if applicable
- Service
Port int - The port of the service
- Service
Type string - Aiven internal service type code
- Service
Uri string - URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- Service
Username string - Username used for connecting to the service, if applicable
- State string
- Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- components
List<My
Sql Component> - Service component information objects
- disk
Space StringCap - The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- disk
Space StringDefault - The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- disk
Space StringStep - The default disk space step of the service, possible values depend on the service type, the cloud provider and the project.
disk_space
needs to increment fromdisk_space_default
by increments of this size. - disk
Space StringUsed - Disk space that service is currently using
- id String
- The provider-assigned unique ID for this managed resource.
- service
Host String - The hostname of the service.
- service
Password String - Password used for connecting to the service, if applicable
- service
Port Integer - The port of the service
- service
Type String - Aiven internal service type code
- service
Uri String - URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- service
Username String - Username used for connecting to the service, if applicable
- state String
- Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- components
My
Sql Component[] - Service component information objects
- disk
Space stringCap - The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- disk
Space stringDefault - The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- disk
Space stringStep - The default disk space step of the service, possible values depend on the service type, the cloud provider and the project.
disk_space
needs to increment fromdisk_space_default
by increments of this size. - disk
Space stringUsed - Disk space that service is currently using
- id string
- The provider-assigned unique ID for this managed resource.
- service
Host string - The hostname of the service.
- service
Password string - Password used for connecting to the service, if applicable
- service
Port number - The port of the service
- service
Type string - Aiven internal service type code
- service
Uri string - URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- service
Username string - Username used for connecting to the service, if applicable
- state string
- Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- components
Sequence[My
Sql Component] - Service component information objects
- disk_
space_ strcap - The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- disk_
space_ strdefault - The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- disk_
space_ strstep - The default disk space step of the service, possible values depend on the service type, the cloud provider and the project.
disk_space
needs to increment fromdisk_space_default
by increments of this size. - disk_
space_ strused - Disk space that service is currently using
- id str
- The provider-assigned unique ID for this managed resource.
- service_
host str - The hostname of the service.
- service_
password str - Password used for connecting to the service, if applicable
- service_
port int - The port of the service
- service_
type str - Aiven internal service type code
- service_
uri str - URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- service_
username str - Username used for connecting to the service, if applicable
- state str
- Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- components List<Property Map>
- Service component information objects
- disk
Space StringCap - The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- disk
Space StringDefault - The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- disk
Space StringStep - The default disk space step of the service, possible values depend on the service type, the cloud provider and the project.
disk_space
needs to increment fromdisk_space_default
by increments of this size. - disk
Space StringUsed - Disk space that service is currently using
- id String
- The provider-assigned unique ID for this managed resource.
- service
Host String - The hostname of the service.
- service
Password String - Password used for connecting to the service, if applicable
- service
Port Number - The port of the service
- service
Type String - Aiven internal service type code
- service
Uri String - URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- service
Username String - Username used for connecting to the service, if applicable
- state String
- Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
Look up Existing MySql Resource
Get an existing MySql 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?: MySqlState, opts?: CustomResourceOptions): MySql
@staticmethod
def get(resource_name: str,
id: str,
opts: Optional[ResourceOptions] = None,
additional_disk_space: Optional[str] = None,
cloud_name: Optional[str] = None,
components: Optional[Sequence[MySqlComponentArgs]] = None,
disk_space: Optional[str] = None,
disk_space_cap: Optional[str] = None,
disk_space_default: Optional[str] = None,
disk_space_step: Optional[str] = None,
disk_space_used: Optional[str] = None,
maintenance_window_dow: Optional[str] = None,
maintenance_window_time: Optional[str] = None,
mysql: Optional[MySqlMysqlArgs] = None,
mysql_user_config: Optional[MySqlMysqlUserConfigArgs] = None,
plan: Optional[str] = None,
project: Optional[str] = None,
project_vpc_id: Optional[str] = None,
service_host: Optional[str] = None,
service_integrations: Optional[Sequence[MySqlServiceIntegrationArgs]] = None,
service_name: Optional[str] = None,
service_password: Optional[str] = None,
service_port: Optional[int] = None,
service_type: Optional[str] = None,
service_uri: Optional[str] = None,
service_username: Optional[str] = None,
state: Optional[str] = None,
static_ips: Optional[Sequence[str]] = None,
tags: Optional[Sequence[MySqlTagArgs]] = None,
tech_emails: Optional[Sequence[MySqlTechEmailArgs]] = None,
termination_protection: Optional[bool] = None) -> MySql
func GetMySql(ctx *Context, name string, id IDInput, state *MySqlState, opts ...ResourceOption) (*MySql, error)
public static MySql Get(string name, Input<string> id, MySqlState? state, CustomResourceOptions? opts = null)
public static MySql get(String name, Output<String> id, MySqlState 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.
- Additional
Disk stringSpace - Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart and there might be a short downtime for services with no HA capabilities.
- Cloud
Name string - Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (
aws
,azure
,do
google
,upcloud
, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS. - Components
List<My
Sql Component> - Service component information objects
- Disk
Space string - Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- Disk
Space stringCap - The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- Disk
Space stringDefault - The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- Disk
Space stringStep - The default disk space step of the service, possible values depend on the service type, the cloud provider and the project.
disk_space
needs to increment fromdisk_space_default
by increments of this size. - Disk
Space stringUsed - Disk space that service is currently using
- Maintenance
Window stringDow - Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- Maintenance
Window stringTime - Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- Mysql
My
Sql Mysql - MySQL specific server provided values
- Mysql
User MyConfig Sql Mysql User Config - Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- Plan string
- Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are
hobbyist
,startup-x
,business-x
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page. - Project string
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- Project
Vpc stringId - Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- Service
Host string - The hostname of the service.
- Service
Integrations List<MySql Service Integration> - Service integrations to specify when creating a service. Not applied after initial service creation
- Service
Name string - Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
- Service
Password string - Password used for connecting to the service, if applicable
- Service
Port int - The port of the service
- Service
Type string - Aiven internal service type code
- Service
Uri string - URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- Service
Username string - Username used for connecting to the service, if applicable
- State string
- Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- Static
Ips List<string> - Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- List<My
Sql Tag> - Tags are key-value pairs that allow you to categorize services.
- Tech
Emails List<MySql Tech Email> - The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- Termination
Protection bool - Prevents the service from being deleted. It is recommended to set this to
true
for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
- Additional
Disk stringSpace - Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart and there might be a short downtime for services with no HA capabilities.
- Cloud
Name string - Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (
aws
,azure
,do
google
,upcloud
, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS. - Components
[]My
Sql Component Args - Service component information objects
- Disk
Space string - Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- Disk
Space stringCap - The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- Disk
Space stringDefault - The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- Disk
Space stringStep - The default disk space step of the service, possible values depend on the service type, the cloud provider and the project.
disk_space
needs to increment fromdisk_space_default
by increments of this size. - Disk
Space stringUsed - Disk space that service is currently using
- Maintenance
Window stringDow - Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- Maintenance
Window stringTime - Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- Mysql
My
Sql Mysql Args - MySQL specific server provided values
- Mysql
User MyConfig Sql Mysql User Config Args - Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- Plan string
- Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are
hobbyist
,startup-x
,business-x
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page. - Project string
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- Project
Vpc stringId - Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- Service
Host string - The hostname of the service.
- Service
Integrations []MySql Service Integration Args - Service integrations to specify when creating a service. Not applied after initial service creation
- Service
Name string - Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
- Service
Password string - Password used for connecting to the service, if applicable
- Service
Port int - The port of the service
- Service
Type string - Aiven internal service type code
- Service
Uri string - URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- Service
Username string - Username used for connecting to the service, if applicable
- State string
- Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- Static
Ips []string - Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- []My
Sql Tag Args - Tags are key-value pairs that allow you to categorize services.
- Tech
Emails []MySql Tech Email Args - The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- Termination
Protection bool - Prevents the service from being deleted. It is recommended to set this to
true
for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
- additional
Disk StringSpace - Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart and there might be a short downtime for services with no HA capabilities.
- cloud
Name String - Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (
aws
,azure
,do
google
,upcloud
, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS. - components
List<My
Sql Component> - Service component information objects
- disk
Space String - Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- disk
Space StringCap - The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- disk
Space StringDefault - The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- disk
Space StringStep - The default disk space step of the service, possible values depend on the service type, the cloud provider and the project.
disk_space
needs to increment fromdisk_space_default
by increments of this size. - disk
Space StringUsed - Disk space that service is currently using
- maintenance
Window StringDow - Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenance
Window StringTime - Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql
My
Sql Mysql - MySQL specific server provided values
- mysql
User MyConfig Sql Mysql User Config - Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- plan String
- Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are
hobbyist
,startup-x
,business-x
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page. - project String
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- project
Vpc StringId - Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- service
Host String - The hostname of the service.
- service
Integrations List<MySql Service Integration> - Service integrations to specify when creating a service. Not applied after initial service creation
- service
Name String - Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
- service
Password String - Password used for connecting to the service, if applicable
- service
Port Integer - The port of the service
- service
Type String - Aiven internal service type code
- service
Uri String - URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- service
Username String - Username used for connecting to the service, if applicable
- state String
- Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- static
Ips List<String> - Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- List<My
Sql Tag> - Tags are key-value pairs that allow you to categorize services.
- tech
Emails List<MySql Tech Email> - The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- termination
Protection Boolean - Prevents the service from being deleted. It is recommended to set this to
true
for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
- additional
Disk stringSpace - Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart and there might be a short downtime for services with no HA capabilities.
- cloud
Name string - Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (
aws
,azure
,do
google
,upcloud
, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS. - components
My
Sql Component[] - Service component information objects
- disk
Space string - Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- disk
Space stringCap - The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- disk
Space stringDefault - The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- disk
Space stringStep - The default disk space step of the service, possible values depend on the service type, the cloud provider and the project.
disk_space
needs to increment fromdisk_space_default
by increments of this size. - disk
Space stringUsed - Disk space that service is currently using
- maintenance
Window stringDow - Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenance
Window stringTime - Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql
My
Sql Mysql - MySQL specific server provided values
- mysql
User MyConfig Sql Mysql User Config - Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- plan string
- Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are
hobbyist
,startup-x
,business-x
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page. - project string
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- project
Vpc stringId - Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- service
Host string - The hostname of the service.
- service
Integrations MySql Service Integration[] - Service integrations to specify when creating a service. Not applied after initial service creation
- service
Name string - Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
- service
Password string - Password used for connecting to the service, if applicable
- service
Port number - The port of the service
- service
Type string - Aiven internal service type code
- service
Uri string - URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- service
Username string - Username used for connecting to the service, if applicable
- state string
- Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- static
Ips string[] - Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- My
Sql Tag[] - Tags are key-value pairs that allow you to categorize services.
- tech
Emails MySql Tech Email[] - The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- termination
Protection boolean - Prevents the service from being deleted. It is recommended to set this to
true
for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
- additional_
disk_ strspace - Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart and there might be a short downtime for services with no HA capabilities.
- cloud_
name str - Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (
aws
,azure
,do
google
,upcloud
, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS. - components
Sequence[My
Sql Component Args] - Service component information objects
- disk_
space str - Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- disk_
space_ strcap - The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- disk_
space_ strdefault - The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- disk_
space_ strstep - The default disk space step of the service, possible values depend on the service type, the cloud provider and the project.
disk_space
needs to increment fromdisk_space_default
by increments of this size. - disk_
space_ strused - Disk space that service is currently using
- maintenance_
window_ strdow - Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenance_
window_ strtime - Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql
My
Sql Mysql Args - MySQL specific server provided values
- mysql_
user_ Myconfig Sql Mysql User Config Args - Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- plan str
- Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are
hobbyist
,startup-x
,business-x
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page. - project str
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- project_
vpc_ strid - Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- service_
host str - The hostname of the service.
- service_
integrations Sequence[MySql Service Integration Args] - Service integrations to specify when creating a service. Not applied after initial service creation
- service_
name str - Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
- service_
password str - Password used for connecting to the service, if applicable
- service_
port int - The port of the service
- service_
type str - Aiven internal service type code
- service_
uri str - URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- service_
username str - Username used for connecting to the service, if applicable
- state str
- Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- static_
ips Sequence[str] - Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- Sequence[My
Sql Tag Args] - Tags are key-value pairs that allow you to categorize services.
- tech_
emails Sequence[MySql Tech Email Args] - The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- termination_
protection bool - Prevents the service from being deleted. It is recommended to set this to
true
for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
- additional
Disk StringSpace - Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart and there might be a short downtime for services with no HA capabilities.
- cloud
Name String - Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (
aws
,azure
,do
google
,upcloud
, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS. - components List<Property Map>
- Service component information objects
- disk
Space String - Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- disk
Space StringCap - The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- disk
Space StringDefault - The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- disk
Space StringStep - The default disk space step of the service, possible values depend on the service type, the cloud provider and the project.
disk_space
needs to increment fromdisk_space_default
by increments of this size. - disk
Space StringUsed - Disk space that service is currently using
- maintenance
Window StringDow - Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenance
Window StringTime - Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql Property Map
- MySQL specific server provided values
- mysql
User Property MapConfig - Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- plan String
- Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are
hobbyist
,startup-x
,business-x
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page. - project String
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- project
Vpc StringId - Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- service
Host String - The hostname of the service.
- service
Integrations List<Property Map> - Service integrations to specify when creating a service. Not applied after initial service creation
- service
Name String - Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
- service
Password String - Password used for connecting to the service, if applicable
- service
Port Number - The port of the service
- service
Type String - Aiven internal service type code
- service
Uri String - URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- service
Username String - Username used for connecting to the service, if applicable
- state String
- Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- static
Ips List<String> - Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- List<Property Map>
- Tags are key-value pairs that allow you to categorize services.
- tech
Emails List<Property Map> - The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- termination
Protection Boolean - Prevents the service from being deleted. It is recommended to set this to
true
for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
Supporting Types
MySqlComponent, MySqlComponentArgs
- Component string
- Service component name
- Connection
Uri string - Connection info for connecting to the service component. This is a combination of host and port.
- Host string
- Host name for connecting to the service component
- Kafka
Authentication stringMethod - Kafka authentication method. This is a value specific to the 'kafka' service component
- Port int
- Port number for connecting to the service component
- Route string
- Network access route
- Ssl bool
- Whether the endpoint is encrypted or accepts plaintext. By default endpoints are always encrypted and this property is only included for service components they may disable encryption
- Usage string
- DNS usage name
- Component string
- Service component name
- Connection
Uri string - Connection info for connecting to the service component. This is a combination of host and port.
- Host string
- Host name for connecting to the service component
- Kafka
Authentication stringMethod - Kafka authentication method. This is a value specific to the 'kafka' service component
- Port int
- Port number for connecting to the service component
- Route string
- Network access route
- Ssl bool
- Whether the endpoint is encrypted or accepts plaintext. By default endpoints are always encrypted and this property is only included for service components they may disable encryption
- Usage string
- DNS usage name
- component String
- Service component name
- connection
Uri String - Connection info for connecting to the service component. This is a combination of host and port.
- host String
- Host name for connecting to the service component
- kafka
Authentication StringMethod - Kafka authentication method. This is a value specific to the 'kafka' service component
- port Integer
- Port number for connecting to the service component
- route String
- Network access route
- ssl Boolean
- Whether the endpoint is encrypted or accepts plaintext. By default endpoints are always encrypted and this property is only included for service components they may disable encryption
- usage String
- DNS usage name
- component string
- Service component name
- connection
Uri string - Connection info for connecting to the service component. This is a combination of host and port.
- host string
- Host name for connecting to the service component
- kafka
Authentication stringMethod - Kafka authentication method. This is a value specific to the 'kafka' service component
- port number
- Port number for connecting to the service component
- route string
- Network access route
- ssl boolean
- Whether the endpoint is encrypted or accepts plaintext. By default endpoints are always encrypted and this property is only included for service components they may disable encryption
- usage string
- DNS usage name
- component str
- Service component name
- connection_
uri str - Connection info for connecting to the service component. This is a combination of host and port.
- host str
- Host name for connecting to the service component
- kafka_
authentication_ strmethod - Kafka authentication method. This is a value specific to the 'kafka' service component
- port int
- Port number for connecting to the service component
- route str
- Network access route
- ssl bool
- Whether the endpoint is encrypted or accepts plaintext. By default endpoints are always encrypted and this property is only included for service components they may disable encryption
- usage str
- DNS usage name
- component String
- Service component name
- connection
Uri String - Connection info for connecting to the service component. This is a combination of host and port.
- host String
- Host name for connecting to the service component
- kafka
Authentication StringMethod - Kafka authentication method. This is a value specific to the 'kafka' service component
- port Number
- Port number for connecting to the service component
- route String
- Network access route
- ssl Boolean
- Whether the endpoint is encrypted or accepts plaintext. By default endpoints are always encrypted and this property is only included for service components they may disable encryption
- usage String
- DNS usage name
MySqlMysql, MySqlMysqlArgs
- Params
List<My
Sql Mysql Param> - MySQL connection parameters
- Replica
Uri string - MySQL replica URI for services with a replica
- Standby
Uris List<string> - MySQL standby connection URIs
- Syncing
Uris List<string> - MySQL syncing connection URIs
- Uris List<string>
- MySQL master connection URIs
- Params
[]My
Sql Mysql Param - MySQL connection parameters
- Replica
Uri string - MySQL replica URI for services with a replica
- Standby
Uris []string - MySQL standby connection URIs
- Syncing
Uris []string - MySQL syncing connection URIs
- Uris []string
- MySQL master connection URIs
- params
List<My
Sql Mysql Param> - MySQL connection parameters
- replica
Uri String - MySQL replica URI for services with a replica
- standby
Uris List<String> - MySQL standby connection URIs
- syncing
Uris List<String> - MySQL syncing connection URIs
- uris List<String>
- MySQL master connection URIs
- params
My
Sql Mysql Param[] - MySQL connection parameters
- replica
Uri string - MySQL replica URI for services with a replica
- standby
Uris string[] - MySQL standby connection URIs
- syncing
Uris string[] - MySQL syncing connection URIs
- uris string[]
- MySQL master connection URIs
- params
Sequence[My
Sql Mysql Param] - MySQL connection parameters
- replica_
uri str - MySQL replica URI for services with a replica
- standby_
uris Sequence[str] - MySQL standby connection URIs
- syncing_
uris Sequence[str] - MySQL syncing connection URIs
- uris Sequence[str]
- MySQL master connection URIs
- params List<Property Map>
- MySQL connection parameters
- replica
Uri String - MySQL replica URI for services with a replica
- standby
Uris List<String> - MySQL standby connection URIs
- syncing
Uris List<String> - MySQL syncing connection URIs
- uris List<String>
- MySQL master connection URIs
MySqlMysqlParam, MySqlMysqlParamArgs
MySqlMysqlUserConfig, MySqlMysqlUserConfigArgs
- Additional
Backup stringRegions - Additional Cloud Regions for Backup Replication.
- Admin
Password string - Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
- Admin
Username string - Custom username for admin user. This must be set only when a new service is being created. Example:
avnadmin
. - Backup
Hour int - The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed. Example:
3
. - Backup
Minute int - The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed. Example:
30
. - Binlog
Retention intPeriod - The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector. Example:
600
. - Ip
Filter List<MyObjects Sql Mysql User Config Ip Filter Object> - Allow incoming connections from CIDR address block, e.g.
10.20.0.0/16
- Ip
Filter List<string>Strings - Allow incoming connections from CIDR address block, e.g.
10.20.0.0/16
. - Ip
Filters List<string> - Allow incoming connections from CIDR address block, e.g.
10.20.0.0/16
. - Migration
My
Sql Mysql User Config Migration - Migrate data from existing server
- Mysql
My
Sql Mysql User Config Mysql - mysql.conf configuration values
- Mysql
Version string - Enum:
8
, and newer. MySQL major version. - Private
Access MySql Mysql User Config Private Access - Allow access to selected service ports from private networks
- Privatelink
Access MySql Mysql User Config Privatelink Access - Allow access to selected service components through Privatelink
- Project
To stringFork From - Name of another project to fork a service from. This has effect only when a new service is being created. Example:
anotherprojectname
. - Public
Access MySql Mysql User Config Public Access - Allow access to selected service ports from the public Internet
- Recovery
Target stringTime - Recovery target time when forking a service. This has effect only when a new service is being created. Example:
2019-01-01 23:34:45
. - Service
Log bool - Store logs for the service so that they are available in the HTTP API and console.
- Service
To stringFork From - Name of another service to fork from. This has effect only when a new service is being created. Example:
anotherservicename
. - Static
Ips bool - Use static public IP addresses.
- Additional
Backup stringRegions - Additional Cloud Regions for Backup Replication.
- Admin
Password string - Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
- Admin
Username string - Custom username for admin user. This must be set only when a new service is being created. Example:
avnadmin
. - Backup
Hour int - The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed. Example:
3
. - Backup
Minute int - The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed. Example:
30
. - Binlog
Retention intPeriod - The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector. Example:
600
. - Ip
Filter []MyObjects Sql Mysql User Config Ip Filter Object - Allow incoming connections from CIDR address block, e.g.
10.20.0.0/16
- Ip
Filter []stringStrings - Allow incoming connections from CIDR address block, e.g.
10.20.0.0/16
. - Ip
Filters []string - Allow incoming connections from CIDR address block, e.g.
10.20.0.0/16
. - Migration
My
Sql Mysql User Config Migration - Migrate data from existing server
- Mysql
My
Sql Mysql User Config Mysql - mysql.conf configuration values
- Mysql
Version string - Enum:
8
, and newer. MySQL major version. - Private
Access MySql Mysql User Config Private Access - Allow access to selected service ports from private networks
- Privatelink
Access MySql Mysql User Config Privatelink Access - Allow access to selected service components through Privatelink
- Project
To stringFork From - Name of another project to fork a service from. This has effect only when a new service is being created. Example:
anotherprojectname
. - Public
Access MySql Mysql User Config Public Access - Allow access to selected service ports from the public Internet
- Recovery
Target stringTime - Recovery target time when forking a service. This has effect only when a new service is being created. Example:
2019-01-01 23:34:45
. - Service
Log bool - Store logs for the service so that they are available in the HTTP API and console.
- Service
To stringFork From - Name of another service to fork from. This has effect only when a new service is being created. Example:
anotherservicename
. - Static
Ips bool - Use static public IP addresses.
- additional
Backup StringRegions - Additional Cloud Regions for Backup Replication.
- admin
Password String - Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
- admin
Username String - Custom username for admin user. This must be set only when a new service is being created. Example:
avnadmin
. - backup
Hour Integer - The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed. Example:
3
. - backup
Minute Integer - The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed. Example:
30
. - binlog
Retention IntegerPeriod - The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector. Example:
600
. - ip
Filter List<MyObjects Sql Mysql User Config Ip Filter Object> - Allow incoming connections from CIDR address block, e.g.
10.20.0.0/16
- ip
Filter List<String>Strings - Allow incoming connections from CIDR address block, e.g.
10.20.0.0/16
. - ip
Filters List<String> - Allow incoming connections from CIDR address block, e.g.
10.20.0.0/16
. - migration
My
Sql Mysql User Config Migration - Migrate data from existing server
- mysql
My
Sql Mysql User Config Mysql - mysql.conf configuration values
- mysql
Version String - Enum:
8
, and newer. MySQL major version. - private
Access MySql Mysql User Config Private Access - Allow access to selected service ports from private networks
- privatelink
Access MySql Mysql User Config Privatelink Access - Allow access to selected service components through Privatelink
- project
To StringFork From - Name of another project to fork a service from. This has effect only when a new service is being created. Example:
anotherprojectname
. - public
Access MySql Mysql User Config Public Access - Allow access to selected service ports from the public Internet
- recovery
Target StringTime - Recovery target time when forking a service. This has effect only when a new service is being created. Example:
2019-01-01 23:34:45
. - service
Log Boolean - Store logs for the service so that they are available in the HTTP API and console.
- service
To StringFork From - Name of another service to fork from. This has effect only when a new service is being created. Example:
anotherservicename
. - static
Ips Boolean - Use static public IP addresses.
- additional
Backup stringRegions - Additional Cloud Regions for Backup Replication.
- admin
Password string - Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
- admin
Username string - Custom username for admin user. This must be set only when a new service is being created. Example:
avnadmin
. - backup
Hour number - The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed. Example:
3
. - backup
Minute number - The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed. Example:
30
. - binlog
Retention numberPeriod - The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector. Example:
600
. - ip
Filter MyObjects Sql Mysql User Config Ip Filter Object[] - Allow incoming connections from CIDR address block, e.g.
10.20.0.0/16
- ip
Filter string[]Strings - Allow incoming connections from CIDR address block, e.g.
10.20.0.0/16
. - ip
Filters string[] - Allow incoming connections from CIDR address block, e.g.
10.20.0.0/16
. - migration
My
Sql Mysql User Config Migration - Migrate data from existing server
- mysql
My
Sql Mysql User Config Mysql - mysql.conf configuration values
- mysql
Version string - Enum:
8
, and newer. MySQL major version. - private
Access MySql Mysql User Config Private Access - Allow access to selected service ports from private networks
- privatelink
Access MySql Mysql User Config Privatelink Access - Allow access to selected service components through Privatelink
- project
To stringFork From - Name of another project to fork a service from. This has effect only when a new service is being created. Example:
anotherprojectname
. - public
Access MySql Mysql User Config Public Access - Allow access to selected service ports from the public Internet
- recovery
Target stringTime - Recovery target time when forking a service. This has effect only when a new service is being created. Example:
2019-01-01 23:34:45
. - service
Log boolean - Store logs for the service so that they are available in the HTTP API and console.
- service
To stringFork From - Name of another service to fork from. This has effect only when a new service is being created. Example:
anotherservicename
. - static
Ips boolean - Use static public IP addresses.
- additional_
backup_ strregions - Additional Cloud Regions for Backup Replication.
- admin_
password str - Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
- admin_
username str - Custom username for admin user. This must be set only when a new service is being created. Example:
avnadmin
. - backup_
hour int - The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed. Example:
3
. - backup_
minute int - The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed. Example:
30
. - binlog_
retention_ intperiod - The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector. Example:
600
. - ip_
filter_ Sequence[Myobjects Sql Mysql User Config Ip Filter Object] - Allow incoming connections from CIDR address block, e.g.
10.20.0.0/16
- ip_
filter_ Sequence[str]strings - Allow incoming connections from CIDR address block, e.g.
10.20.0.0/16
. - ip_
filters Sequence[str] - Allow incoming connections from CIDR address block, e.g.
10.20.0.0/16
. - migration
My
Sql Mysql User Config Migration - Migrate data from existing server
- mysql
My
Sql Mysql User Config Mysql - mysql.conf configuration values
- mysql_
version str - Enum:
8
, and newer. MySQL major version. - private_
access MySql Mysql User Config Private Access - Allow access to selected service ports from private networks
- privatelink_
access MySql Mysql User Config Privatelink Access - Allow access to selected service components through Privatelink
- project_
to_ strfork_ from - Name of another project to fork a service from. This has effect only when a new service is being created. Example:
anotherprojectname
. - public_
access MySql Mysql User Config Public Access - Allow access to selected service ports from the public Internet
- recovery_
target_ strtime - Recovery target time when forking a service. This has effect only when a new service is being created. Example:
2019-01-01 23:34:45
. - service_
log bool - Store logs for the service so that they are available in the HTTP API and console.
- service_
to_ strfork_ from - Name of another service to fork from. This has effect only when a new service is being created. Example:
anotherservicename
. - static_
ips bool - Use static public IP addresses.
- additional
Backup StringRegions - Additional Cloud Regions for Backup Replication.
- admin
Password String - Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
- admin
Username String - Custom username for admin user. This must be set only when a new service is being created. Example:
avnadmin
. - backup
Hour Number - The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed. Example:
3
. - backup
Minute Number - The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed. Example:
30
. - binlog
Retention NumberPeriod - The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector. Example:
600
. - ip
Filter List<Property Map>Objects - Allow incoming connections from CIDR address block, e.g.
10.20.0.0/16
- ip
Filter List<String>Strings - Allow incoming connections from CIDR address block, e.g.
10.20.0.0/16
. - ip
Filters List<String> - Allow incoming connections from CIDR address block, e.g.
10.20.0.0/16
. - migration Property Map
- Migrate data from existing server
- mysql Property Map
- mysql.conf configuration values
- mysql
Version String - Enum:
8
, and newer. MySQL major version. - private
Access Property Map - Allow access to selected service ports from private networks
- privatelink
Access Property Map - Allow access to selected service components through Privatelink
- project
To StringFork From - Name of another project to fork a service from. This has effect only when a new service is being created. Example:
anotherprojectname
. - public
Access Property Map - Allow access to selected service ports from the public Internet
- recovery
Target StringTime - Recovery target time when forking a service. This has effect only when a new service is being created. Example:
2019-01-01 23:34:45
. - service
Log Boolean - Store logs for the service so that they are available in the HTTP API and console.
- service
To StringFork From - Name of another service to fork from. This has effect only when a new service is being created. Example:
anotherservicename
. - static
Ips Boolean - Use static public IP addresses.
MySqlMysqlUserConfigIpFilterObject, MySqlMysqlUserConfigIpFilterObjectArgs
- Network string
- CIDR address block. Example:
10.20.0.0/16
. - Description string
- Description for IP filter list entry. Example:
Production service IP range
.
- Network string
- CIDR address block. Example:
10.20.0.0/16
. - Description string
- Description for IP filter list entry. Example:
Production service IP range
.
- network String
- CIDR address block. Example:
10.20.0.0/16
. - description String
- Description for IP filter list entry. Example:
Production service IP range
.
- network string
- CIDR address block. Example:
10.20.0.0/16
. - description string
- Description for IP filter list entry. Example:
Production service IP range
.
- network str
- CIDR address block. Example:
10.20.0.0/16
. - description str
- Description for IP filter list entry. Example:
Production service IP range
.
- network String
- CIDR address block. Example:
10.20.0.0/16
. - description String
- Description for IP filter list entry. Example:
Production service IP range
.
MySqlMysqlUserConfigMigration, MySqlMysqlUserConfigMigrationArgs
- Host string
- Hostname or IP address of the server where to migrate data from. Example:
my.server.com
. - Port int
- Port number of the server where to migrate data from. Example:
1234
. - Dbname string
- Database name for bootstrapping the initial connection. Example:
defaultdb
. - Ignore
Dbs string - Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment). Example:
db1,db2
. - Ignore
Roles string - Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment). Example:
role1,role2
. - Method string
- Enum:
dump
,replication
. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types). - Password string
- Password for authentication with the server where to migrate data from. Example:
jjKk45Nnd
. - Ssl bool
- The server where to migrate data from is secured with SSL. Default:
true
. - Username string
- User name for authentication with the server where to migrate data from. Example:
myname
.
- Host string
- Hostname or IP address of the server where to migrate data from. Example:
my.server.com
. - Port int
- Port number of the server where to migrate data from. Example:
1234
. - Dbname string
- Database name for bootstrapping the initial connection. Example:
defaultdb
. - Ignore
Dbs string - Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment). Example:
db1,db2
. - Ignore
Roles string - Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment). Example:
role1,role2
. - Method string
- Enum:
dump
,replication
. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types). - Password string
- Password for authentication with the server where to migrate data from. Example:
jjKk45Nnd
. - Ssl bool
- The server where to migrate data from is secured with SSL. Default:
true
. - Username string
- User name for authentication with the server where to migrate data from. Example:
myname
.
- host String
- Hostname or IP address of the server where to migrate data from. Example:
my.server.com
. - port Integer
- Port number of the server where to migrate data from. Example:
1234
. - dbname String
- Database name for bootstrapping the initial connection. Example:
defaultdb
. - ignore
Dbs String - Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment). Example:
db1,db2
. - ignore
Roles String - Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment). Example:
role1,role2
. - method String
- Enum:
dump
,replication
. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types). - password String
- Password for authentication with the server where to migrate data from. Example:
jjKk45Nnd
. - ssl Boolean
- The server where to migrate data from is secured with SSL. Default:
true
. - username String
- User name for authentication with the server where to migrate data from. Example:
myname
.
- host string
- Hostname or IP address of the server where to migrate data from. Example:
my.server.com
. - port number
- Port number of the server where to migrate data from. Example:
1234
. - dbname string
- Database name for bootstrapping the initial connection. Example:
defaultdb
. - ignore
Dbs string - Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment). Example:
db1,db2
. - ignore
Roles string - Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment). Example:
role1,role2
. - method string
- Enum:
dump
,replication
. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types). - password string
- Password for authentication with the server where to migrate data from. Example:
jjKk45Nnd
. - ssl boolean
- The server where to migrate data from is secured with SSL. Default:
true
. - username string
- User name for authentication with the server where to migrate data from. Example:
myname
.
- host str
- Hostname or IP address of the server where to migrate data from. Example:
my.server.com
. - port int
- Port number of the server where to migrate data from. Example:
1234
. - dbname str
- Database name for bootstrapping the initial connection. Example:
defaultdb
. - ignore_
dbs str - Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment). Example:
db1,db2
. - ignore_
roles str - Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment). Example:
role1,role2
. - method str
- Enum:
dump
,replication
. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types). - password str
- Password for authentication with the server where to migrate data from. Example:
jjKk45Nnd
. - ssl bool
- The server where to migrate data from is secured with SSL. Default:
true
. - username str
- User name for authentication with the server where to migrate data from. Example:
myname
.
- host String
- Hostname or IP address of the server where to migrate data from. Example:
my.server.com
. - port Number
- Port number of the server where to migrate data from. Example:
1234
. - dbname String
- Database name for bootstrapping the initial connection. Example:
defaultdb
. - ignore
Dbs String - Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment). Example:
db1,db2
. - ignore
Roles String - Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment). Example:
role1,role2
. - method String
- Enum:
dump
,replication
. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types). - password String
- Password for authentication with the server where to migrate data from. Example:
jjKk45Nnd
. - ssl Boolean
- The server where to migrate data from is secured with SSL. Default:
true
. - username String
- User name for authentication with the server where to migrate data from. Example:
myname
.
MySqlMysqlUserConfigMysql, MySqlMysqlUserConfigMysqlArgs
- Connect
Timeout int - The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake. Example:
10
. - Default
Time stringZone - Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or
SYSTEM
to use the MySQL server default. Example:+03:00
. - Group
Concat intMax Len - The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example:
1024
. - Information
Schema intStats Expiry - The time, in seconds, before cached statistics expire. Example:
86400
. - Innodb
Change intBuffer Max Size - Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example:
30
. - Innodb
Flush intNeighbors - Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent. Example:
0
. - Innodb
Ft intMin Token Size - Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service. Example:
3
. - Innodb
Ft stringServer Stopword Table - This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example:
db_name/table_name
. - Innodb
Lock intWait Timeout - The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example:
50
. - Innodb
Log intBuffer Size - The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example:
16777216
. - Innodb
Online intAlter Log Max Size - The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example:
134217728
. - Innodb
Print boolAll Deadlocks - When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
- Innodb
Read intIo Threads - The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example:
10
. - Innodb
Rollback boolOn Timeout - When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
- Innodb
Thread intConcurrency - Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example:
10
. - Innodb
Write intIo Threads - The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example:
10
. - Interactive
Timeout int - The number of seconds the server waits for activity on an interactive connection before closing it. Example:
3600
. - Internal
Tmp stringMem Storage Engine - Enum:
MEMORY
,TempTable
. The storage engine for in-memory internal temporary tables. - Log
Output string - Enum:
INSIGHTS
,INSIGHTS,TABLE
,NONE
,TABLE
. The slow log output destination when slowquerylog is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slowlog table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slowlog table, choose TABLE. To silence slow logs, choose NONE. - Long
Query doubleTime - The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Example:
10.0
. - Max
Allowed intPacket - Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example:
67108864
. - Max
Heap intTable Size - Limits the size of internal in-memory tables. Also set tmptablesize. Default is 16777216 (16M). Example:
16777216
. - Net
Buffer intLength - Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service. Example:
16384
. - Net
Read intTimeout - The number of seconds to wait for more data from a connection before aborting the read. Example:
30
. - Net
Write intTimeout - The number of seconds to wait for a block to be written to a connection before aborting the write. Example:
30
. - Slow
Query boolLog - Slow query log enables capturing of slow queries. Setting slowquerylog to false also truncates the mysql.slow_log table.
- Sort
Buffer intSize - Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K). Example:
262144
. - Sql
Mode string - Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned. Example:
ANSI,TRADITIONAL
. - Sql
Require boolPrimary Key - Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
- Tmp
Table intSize - Limits the size of internal in-memory tables. Also set maxheaptable_size. Default is 16777216 (16M). Example:
16777216
. - Wait
Timeout int - The number of seconds the server waits for activity on a noninteractive connection before closing it. Example:
28800
.
- Connect
Timeout int - The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake. Example:
10
. - Default
Time stringZone - Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or
SYSTEM
to use the MySQL server default. Example:+03:00
. - Group
Concat intMax Len - The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example:
1024
. - Information
Schema intStats Expiry - The time, in seconds, before cached statistics expire. Example:
86400
. - Innodb
Change intBuffer Max Size - Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example:
30
. - Innodb
Flush intNeighbors - Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent. Example:
0
. - Innodb
Ft intMin Token Size - Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service. Example:
3
. - Innodb
Ft stringServer Stopword Table - This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example:
db_name/table_name
. - Innodb
Lock intWait Timeout - The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example:
50
. - Innodb
Log intBuffer Size - The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example:
16777216
. - Innodb
Online intAlter Log Max Size - The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example:
134217728
. - Innodb
Print boolAll Deadlocks - When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
- Innodb
Read intIo Threads - The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example:
10
. - Innodb
Rollback boolOn Timeout - When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
- Innodb
Thread intConcurrency - Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example:
10
. - Innodb
Write intIo Threads - The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example:
10
. - Interactive
Timeout int - The number of seconds the server waits for activity on an interactive connection before closing it. Example:
3600
. - Internal
Tmp stringMem Storage Engine - Enum:
MEMORY
,TempTable
. The storage engine for in-memory internal temporary tables. - Log
Output string - Enum:
INSIGHTS
,INSIGHTS,TABLE
,NONE
,TABLE
. The slow log output destination when slowquerylog is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slowlog table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slowlog table, choose TABLE. To silence slow logs, choose NONE. - Long
Query float64Time - The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Example:
10.0
. - Max
Allowed intPacket - Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example:
67108864
. - Max
Heap intTable Size - Limits the size of internal in-memory tables. Also set tmptablesize. Default is 16777216 (16M). Example:
16777216
. - Net
Buffer intLength - Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service. Example:
16384
. - Net
Read intTimeout - The number of seconds to wait for more data from a connection before aborting the read. Example:
30
. - Net
Write intTimeout - The number of seconds to wait for a block to be written to a connection before aborting the write. Example:
30
. - Slow
Query boolLog - Slow query log enables capturing of slow queries. Setting slowquerylog to false also truncates the mysql.slow_log table.
- Sort
Buffer intSize - Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K). Example:
262144
. - Sql
Mode string - Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned. Example:
ANSI,TRADITIONAL
. - Sql
Require boolPrimary Key - Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
- Tmp
Table intSize - Limits the size of internal in-memory tables. Also set maxheaptable_size. Default is 16777216 (16M). Example:
16777216
. - Wait
Timeout int - The number of seconds the server waits for activity on a noninteractive connection before closing it. Example:
28800
.
- connect
Timeout Integer - The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake. Example:
10
. - default
Time StringZone - Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or
SYSTEM
to use the MySQL server default. Example:+03:00
. - group
Concat IntegerMax Len - The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example:
1024
. - information
Schema IntegerStats Expiry - The time, in seconds, before cached statistics expire. Example:
86400
. - innodb
Change IntegerBuffer Max Size - Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example:
30
. - innodb
Flush IntegerNeighbors - Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent. Example:
0
. - innodb
Ft IntegerMin Token Size - Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service. Example:
3
. - innodb
Ft StringServer Stopword Table - This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example:
db_name/table_name
. - innodb
Lock IntegerWait Timeout - The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example:
50
. - innodb
Log IntegerBuffer Size - The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example:
16777216
. - innodb
Online IntegerAlter Log Max Size - The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example:
134217728
. - innodb
Print BooleanAll Deadlocks - When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
- innodb
Read IntegerIo Threads - The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example:
10
. - innodb
Rollback BooleanOn Timeout - When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
- innodb
Thread IntegerConcurrency - Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example:
10
. - innodb
Write IntegerIo Threads - The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example:
10
. - interactive
Timeout Integer - The number of seconds the server waits for activity on an interactive connection before closing it. Example:
3600
. - internal
Tmp StringMem Storage Engine - Enum:
MEMORY
,TempTable
. The storage engine for in-memory internal temporary tables. - log
Output String - Enum:
INSIGHTS
,INSIGHTS,TABLE
,NONE
,TABLE
. The slow log output destination when slowquerylog is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slowlog table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slowlog table, choose TABLE. To silence slow logs, choose NONE. - long
Query DoubleTime - The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Example:
10.0
. - max
Allowed IntegerPacket - Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example:
67108864
. - max
Heap IntegerTable Size - Limits the size of internal in-memory tables. Also set tmptablesize. Default is 16777216 (16M). Example:
16777216
. - net
Buffer IntegerLength - Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service. Example:
16384
. - net
Read IntegerTimeout - The number of seconds to wait for more data from a connection before aborting the read. Example:
30
. - net
Write IntegerTimeout - The number of seconds to wait for a block to be written to a connection before aborting the write. Example:
30
. - slow
Query BooleanLog - Slow query log enables capturing of slow queries. Setting slowquerylog to false also truncates the mysql.slow_log table.
- sort
Buffer IntegerSize - Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K). Example:
262144
. - sql
Mode String - Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned. Example:
ANSI,TRADITIONAL
. - sql
Require BooleanPrimary Key - Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
- tmp
Table IntegerSize - Limits the size of internal in-memory tables. Also set maxheaptable_size. Default is 16777216 (16M). Example:
16777216
. - wait
Timeout Integer - The number of seconds the server waits for activity on a noninteractive connection before closing it. Example:
28800
.
- connect
Timeout number - The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake. Example:
10
. - default
Time stringZone - Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or
SYSTEM
to use the MySQL server default. Example:+03:00
. - group
Concat numberMax Len - The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example:
1024
. - information
Schema numberStats Expiry - The time, in seconds, before cached statistics expire. Example:
86400
. - innodb
Change numberBuffer Max Size - Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example:
30
. - innodb
Flush numberNeighbors - Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent. Example:
0
. - innodb
Ft numberMin Token Size - Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service. Example:
3
. - innodb
Ft stringServer Stopword Table - This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example:
db_name/table_name
. - innodb
Lock numberWait Timeout - The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example:
50
. - innodb
Log numberBuffer Size - The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example:
16777216
. - innodb
Online numberAlter Log Max Size - The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example:
134217728
. - innodb
Print booleanAll Deadlocks - When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
- innodb
Read numberIo Threads - The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example:
10
. - innodb
Rollback booleanOn Timeout - When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
- innodb
Thread numberConcurrency - Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example:
10
. - innodb
Write numberIo Threads - The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example:
10
. - interactive
Timeout number - The number of seconds the server waits for activity on an interactive connection before closing it. Example:
3600
. - internal
Tmp stringMem Storage Engine - Enum:
MEMORY
,TempTable
. The storage engine for in-memory internal temporary tables. - log
Output string - Enum:
INSIGHTS
,INSIGHTS,TABLE
,NONE
,TABLE
. The slow log output destination when slowquerylog is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slowlog table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slowlog table, choose TABLE. To silence slow logs, choose NONE. - long
Query numberTime - The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Example:
10.0
. - max
Allowed numberPacket - Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example:
67108864
. - max
Heap numberTable Size - Limits the size of internal in-memory tables. Also set tmptablesize. Default is 16777216 (16M). Example:
16777216
. - net
Buffer numberLength - Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service. Example:
16384
. - net
Read numberTimeout - The number of seconds to wait for more data from a connection before aborting the read. Example:
30
. - net
Write numberTimeout - The number of seconds to wait for a block to be written to a connection before aborting the write. Example:
30
. - slow
Query booleanLog - Slow query log enables capturing of slow queries. Setting slowquerylog to false also truncates the mysql.slow_log table.
- sort
Buffer numberSize - Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K). Example:
262144
. - sql
Mode string - Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned. Example:
ANSI,TRADITIONAL
. - sql
Require booleanPrimary Key - Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
- tmp
Table numberSize - Limits the size of internal in-memory tables. Also set maxheaptable_size. Default is 16777216 (16M). Example:
16777216
. - wait
Timeout number - The number of seconds the server waits for activity on a noninteractive connection before closing it. Example:
28800
.
- connect_
timeout int - The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake. Example:
10
. - default_
time_ strzone - Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or
SYSTEM
to use the MySQL server default. Example:+03:00
. - group_
concat_ intmax_ len - The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example:
1024
. - information_
schema_ intstats_ expiry - The time, in seconds, before cached statistics expire. Example:
86400
. - innodb_
change_ intbuffer_ max_ size - Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example:
30
. - innodb_
flush_ intneighbors - Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent. Example:
0
. - innodb_
ft_ intmin_ token_ size - Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service. Example:
3
. - innodb_
ft_ strserver_ stopword_ table - This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example:
db_name/table_name
. - innodb_
lock_ intwait_ timeout - The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example:
50
. - innodb_
log_ intbuffer_ size - The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example:
16777216
. - innodb_
online_ intalter_ log_ max_ size - The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example:
134217728
. - innodb_
print_ boolall_ deadlocks - When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
- innodb_
read_ intio_ threads - The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example:
10
. - innodb_
rollback_ boolon_ timeout - When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
- innodb_
thread_ intconcurrency - Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example:
10
. - innodb_
write_ intio_ threads - The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example:
10
. - interactive_
timeout int - The number of seconds the server waits for activity on an interactive connection before closing it. Example:
3600
. - internal_
tmp_ strmem_ storage_ engine - Enum:
MEMORY
,TempTable
. The storage engine for in-memory internal temporary tables. - log_
output str - Enum:
INSIGHTS
,INSIGHTS,TABLE
,NONE
,TABLE
. The slow log output destination when slowquerylog is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slowlog table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slowlog table, choose TABLE. To silence slow logs, choose NONE. - long_
query_ floattime - The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Example:
10.0
. - max_
allowed_ intpacket - Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example:
67108864
. - max_
heap_ inttable_ size - Limits the size of internal in-memory tables. Also set tmptablesize. Default is 16777216 (16M). Example:
16777216
. - net_
buffer_ intlength - Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service. Example:
16384
. - net_
read_ inttimeout - The number of seconds to wait for more data from a connection before aborting the read. Example:
30
. - net_
write_ inttimeout - The number of seconds to wait for a block to be written to a connection before aborting the write. Example:
30
. - slow_
query_ boollog - Slow query log enables capturing of slow queries. Setting slowquerylog to false also truncates the mysql.slow_log table.
- sort_
buffer_ intsize - Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K). Example:
262144
. - sql_
mode str - Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned. Example:
ANSI,TRADITIONAL
. - sql_
require_ boolprimary_ key - Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
- tmp_
table_ intsize - Limits the size of internal in-memory tables. Also set maxheaptable_size. Default is 16777216 (16M). Example:
16777216
. - wait_
timeout int - The number of seconds the server waits for activity on a noninteractive connection before closing it. Example:
28800
.
- connect
Timeout Number - The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake. Example:
10
. - default
Time StringZone - Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or
SYSTEM
to use the MySQL server default. Example:+03:00
. - group
Concat NumberMax Len - The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example:
1024
. - information
Schema NumberStats Expiry - The time, in seconds, before cached statistics expire. Example:
86400
. - innodb
Change NumberBuffer Max Size - Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example:
30
. - innodb
Flush NumberNeighbors - Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent. Example:
0
. - innodb
Ft NumberMin Token Size - Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service. Example:
3
. - innodb
Ft StringServer Stopword Table - This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example:
db_name/table_name
. - innodb
Lock NumberWait Timeout - The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example:
50
. - innodb
Log NumberBuffer Size - The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example:
16777216
. - innodb
Online NumberAlter Log Max Size - The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example:
134217728
. - innodb
Print BooleanAll Deadlocks - When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
- innodb
Read NumberIo Threads - The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example:
10
. - innodb
Rollback BooleanOn Timeout - When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
- innodb
Thread NumberConcurrency - Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example:
10
. - innodb
Write NumberIo Threads - The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example:
10
. - interactive
Timeout Number - The number of seconds the server waits for activity on an interactive connection before closing it. Example:
3600
. - internal
Tmp StringMem Storage Engine - Enum:
MEMORY
,TempTable
. The storage engine for in-memory internal temporary tables. - log
Output String - Enum:
INSIGHTS
,INSIGHTS,TABLE
,NONE
,TABLE
. The slow log output destination when slowquerylog is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slowlog table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slowlog table, choose TABLE. To silence slow logs, choose NONE. - long
Query NumberTime - The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Example:
10.0
. - max
Allowed NumberPacket - Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example:
67108864
. - max
Heap NumberTable Size - Limits the size of internal in-memory tables. Also set tmptablesize. Default is 16777216 (16M). Example:
16777216
. - net
Buffer NumberLength - Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service. Example:
16384
. - net
Read NumberTimeout - The number of seconds to wait for more data from a connection before aborting the read. Example:
30
. - net
Write NumberTimeout - The number of seconds to wait for a block to be written to a connection before aborting the write. Example:
30
. - slow
Query BooleanLog - Slow query log enables capturing of slow queries. Setting slowquerylog to false also truncates the mysql.slow_log table.
- sort
Buffer NumberSize - Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K). Example:
262144
. - sql
Mode String - Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned. Example:
ANSI,TRADITIONAL
. - sql
Require BooleanPrimary Key - Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
- tmp
Table NumberSize - Limits the size of internal in-memory tables. Also set maxheaptable_size. Default is 16777216 (16M). Example:
16777216
. - wait
Timeout Number - The number of seconds the server waits for activity on a noninteractive connection before closing it. Example:
28800
.
MySqlMysqlUserConfigPrivateAccess, MySqlMysqlUserConfigPrivateAccessArgs
- Mysql bool
- Allow clients to connect to mysql with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
- Mysqlx bool
- Allow clients to connect to mysqlx with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
- Prometheus bool
- Allow clients to connect to prometheus with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
- Mysql bool
- Allow clients to connect to mysql with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
- Mysqlx bool
- Allow clients to connect to mysqlx with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
- Prometheus bool
- Allow clients to connect to prometheus with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
- mysql Boolean
- Allow clients to connect to mysql with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
- mysqlx Boolean
- Allow clients to connect to mysqlx with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
- prometheus Boolean
- Allow clients to connect to prometheus with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
- mysql boolean
- Allow clients to connect to mysql with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
- mysqlx boolean
- Allow clients to connect to mysqlx with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
- prometheus boolean
- Allow clients to connect to prometheus with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
- mysql bool
- Allow clients to connect to mysql with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
- mysqlx bool
- Allow clients to connect to mysqlx with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
- prometheus bool
- Allow clients to connect to prometheus with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
- mysql Boolean
- Allow clients to connect to mysql with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
- mysqlx Boolean
- Allow clients to connect to mysqlx with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
- prometheus Boolean
- Allow clients to connect to prometheus with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
MySqlMysqlUserConfigPrivatelinkAccess, MySqlMysqlUserConfigPrivatelinkAccessArgs
- Mysql bool
- Enable mysql.
- Mysqlx bool
- Enable mysqlx.
- Prometheus bool
- Enable prometheus.
- Mysql bool
- Enable mysql.
- Mysqlx bool
- Enable mysqlx.
- Prometheus bool
- Enable prometheus.
- mysql Boolean
- Enable mysql.
- mysqlx Boolean
- Enable mysqlx.
- prometheus Boolean
- Enable prometheus.
- mysql boolean
- Enable mysql.
- mysqlx boolean
- Enable mysqlx.
- prometheus boolean
- Enable prometheus.
- mysql bool
- Enable mysql.
- mysqlx bool
- Enable mysqlx.
- prometheus bool
- Enable prometheus.
- mysql Boolean
- Enable mysql.
- mysqlx Boolean
- Enable mysqlx.
- prometheus Boolean
- Enable prometheus.
MySqlMysqlUserConfigPublicAccess, MySqlMysqlUserConfigPublicAccessArgs
- Mysql bool
- Allow clients to connect to mysql from the public internet for service nodes that are in a project VPC or another type of private network.
- Mysqlx bool
- Allow clients to connect to mysqlx from the public internet for service nodes that are in a project VPC or another type of private network.
- Prometheus bool
- Allow clients to connect to prometheus from the public internet for service nodes that are in a project VPC or another type of private network.
- Mysql bool
- Allow clients to connect to mysql from the public internet for service nodes that are in a project VPC or another type of private network.
- Mysqlx bool
- Allow clients to connect to mysqlx from the public internet for service nodes that are in a project VPC or another type of private network.
- Prometheus bool
- Allow clients to connect to prometheus from the public internet for service nodes that are in a project VPC or another type of private network.
- mysql Boolean
- Allow clients to connect to mysql from the public internet for service nodes that are in a project VPC or another type of private network.
- mysqlx Boolean
- Allow clients to connect to mysqlx from the public internet for service nodes that are in a project VPC or another type of private network.
- prometheus Boolean
- Allow clients to connect to prometheus from the public internet for service nodes that are in a project VPC or another type of private network.
- mysql boolean
- Allow clients to connect to mysql from the public internet for service nodes that are in a project VPC or another type of private network.
- mysqlx boolean
- Allow clients to connect to mysqlx from the public internet for service nodes that are in a project VPC or another type of private network.
- prometheus boolean
- Allow clients to connect to prometheus from the public internet for service nodes that are in a project VPC or another type of private network.
- mysql bool
- Allow clients to connect to mysql from the public internet for service nodes that are in a project VPC or another type of private network.
- mysqlx bool
- Allow clients to connect to mysqlx from the public internet for service nodes that are in a project VPC or another type of private network.
- prometheus bool
- Allow clients to connect to prometheus from the public internet for service nodes that are in a project VPC or another type of private network.
- mysql Boolean
- Allow clients to connect to mysql from the public internet for service nodes that are in a project VPC or another type of private network.
- mysqlx Boolean
- Allow clients to connect to mysqlx from the public internet for service nodes that are in a project VPC or another type of private network.
- prometheus Boolean
- Allow clients to connect to prometheus from the public internet for service nodes that are in a project VPC or another type of private network.
MySqlServiceIntegration, MySqlServiceIntegrationArgs
- Integration
Type string - Type of the service integration. The only supported value at the moment is
read_replica
- Source
Service stringName - Name of the source service
- Integration
Type string - Type of the service integration. The only supported value at the moment is
read_replica
- Source
Service stringName - Name of the source service
- integration
Type String - Type of the service integration. The only supported value at the moment is
read_replica
- source
Service StringName - Name of the source service
- integration
Type string - Type of the service integration. The only supported value at the moment is
read_replica
- source
Service stringName - Name of the source service
- integration_
type str - Type of the service integration. The only supported value at the moment is
read_replica
- source_
service_ strname - Name of the source service
- integration
Type String - Type of the service integration. The only supported value at the moment is
read_replica
- source
Service StringName - Name of the source service
MySqlTag, MySqlTagArgs
MySqlTechEmail, MySqlTechEmailArgs
- Email string
- An email address to contact for technical issues
- Email string
- An email address to contact for technical issues
- email String
- An email address to contact for technical issues
- email string
- An email address to contact for technical issues
- email str
- An email address to contact for technical issues
- email String
- An email address to contact for technical issues
Import
$ pulumi import aiven:index/mySql:MySql mysql1 project/service_name
To learn more about importing existing cloud resources, see Importing resources.
Package Details
- Repository
- Aiven pulumi/pulumi-aiven
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the
aiven
Terraform Provider.