Docs Home Pulumi IaC Pulumi ESC Pulumi Cloud Packages Tutorials
  1. Packages
  2. Aiven Provider
  3. API Docs
  4. MySql
Aiven v6.35.0 published on Friday, Feb 21, 2025 by Pulumi
pulumi/pulumi-aiven

aiven.MySql

Explore with Pulumi AI

Aiven v6.35.0 published on Friday, Feb 21, 2025 by Pulumi
pulumi/pulumi-aiven

Creates and manages an Aiven for MySQL® service.

Example Usage

import * as pulumi from "@pulumi/pulumi";
import * as aiven from "@pulumi/aiven";

const exampleMysql = new aiven.MySql("example_mysql", {
    project: exampleProject.project,
    cloudName: "google-europe-west1",
    plan: "business-4",
    serviceName: "example-mysql",
    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,
        },
    },
});
Copy
import pulumi
import pulumi_aiven as aiven

example_mysql = aiven.MySql("example_mysql",
    project=example_project["project"],
    cloud_name="google-europe-west1",
    plan="business-4",
    service_name="example-mysql",
    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,
        },
    })
Copy
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, "example_mysql", &aiven.MySqlArgs{
			Project:               pulumi.Any(exampleProject.Project),
			CloudName:             pulumi.String("google-europe-west1"),
			Plan:                  pulumi.String("business-4"),
			ServiceName:           pulumi.String("example-mysql"),
			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
	})
}
Copy
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Aiven = Pulumi.Aiven;

return await Deployment.RunAsync(() => 
{
    var exampleMysql = new Aiven.MySql("example_mysql", new()
    {
        Project = exampleProject.Project,
        CloudName = "google-europe-west1",
        Plan = "business-4",
        ServiceName = "example-mysql",
        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,
            },
        },
    });

});
Copy
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 exampleMysql = new MySql("exampleMysql", MySqlArgs.builder()
            .project(exampleProject.project())
            .cloudName("google-europe-west1")
            .plan("business-4")
            .serviceName("example-mysql")
            .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());

    }
}
Copy
resources:
  exampleMysql:
    type: aiven:MySql
    name: example_mysql
    properties:
      project: ${exampleProject.project}
      cloudName: google-europe-west1
      plan: business-4
      serviceName: example-mysql
      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
Copy

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)
public MySql(String name, MySqlArgs args)
public MySql(String name, MySqlArgs args, CustomResourceOptions options)

type: aiven:MySql
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

Parameters

name This property is required. string
The unique name of the resource.
args This property is required. MySqlArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name This property is required. str
The unique name of the resource.
args This property is required. 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 This property is required. string
The unique name of the resource.
args This property is required. MySqlArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name This property is required. string
The unique name of the resource.
args This property is required. MySqlArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
name This property is required. String
The unique name of the resource.
args This property is required. 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,
});
Copy
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),
})
Copy
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());
Copy
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)
Copy
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,
});
Copy
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
Copy

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 This property is required. 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 and premium-x where x 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
This property is required.
Changes to this property will trigger replacement.
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.
ServiceName
This property is required.
Changes to this property will trigger replacement.
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.
AdditionalDiskSpace string
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.
CloudName 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.
DiskSpace 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.

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

MaintenanceWindowDow string
Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
MaintenanceWindowTime string
Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
Mysql MySqlMysql
MySQL server-provided values.
MysqlUserConfig MySqlMysqlUserConfig
Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
ProjectVpcId string
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.
ServiceIntegrations List<MySqlServiceIntegration>
Service integrations to specify when creating a service. Not applied after initial service creation
StaticIps 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
Tags List<MySqlTag>
Tags are key-value pairs that allow you to categorize services.
TechEmails List<MySqlTechEmail>
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.
TerminationProtection 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 This property is required. 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 and premium-x where x 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
This property is required.
Changes to this property will trigger replacement.
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.
ServiceName
This property is required.
Changes to this property will trigger replacement.
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.
AdditionalDiskSpace string
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.
CloudName 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.
DiskSpace 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.

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

MaintenanceWindowDow string
Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
MaintenanceWindowTime string
Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
Mysql MySqlMysqlArgs
MySQL server-provided values.
MysqlUserConfig MySqlMysqlUserConfigArgs
Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
ProjectVpcId string
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.
ServiceIntegrations []MySqlServiceIntegrationArgs
Service integrations to specify when creating a service. Not applied after initial service creation
StaticIps []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
Tags []MySqlTagArgs
Tags are key-value pairs that allow you to categorize services.
TechEmails []MySqlTechEmailArgs
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.
TerminationProtection 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 This property is required. 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 and premium-x where x 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
This property is required.
Changes to this property will trigger replacement.
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.
serviceName
This property is required.
Changes to this property will trigger replacement.
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.
additionalDiskSpace String
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.
cloudName 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.
diskSpace 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.

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

maintenanceWindowDow String
Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
maintenanceWindowTime String
Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
mysql MySqlMysql
MySQL server-provided values.
mysqlUserConfig MySqlMysqlUserConfig
Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
projectVpcId String
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.
serviceIntegrations List<MySqlServiceIntegration>
Service integrations to specify when creating a service. Not applied after initial service creation
staticIps 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
tags List<MySqlTag>
Tags are key-value pairs that allow you to categorize services.
techEmails List<MySqlTechEmail>
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.
terminationProtection 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 This property is required. 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 and premium-x where x 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
This property is required.
Changes to this property will trigger replacement.
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.
serviceName
This property is required.
Changes to this property will trigger replacement.
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.
additionalDiskSpace string
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.
cloudName 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.
diskSpace 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.

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

maintenanceWindowDow string
Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
maintenanceWindowTime string
Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
mysql MySqlMysql
MySQL server-provided values.
mysqlUserConfig MySqlMysqlUserConfig
Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
projectVpcId string
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.
serviceIntegrations MySqlServiceIntegration[]
Service integrations to specify when creating a service. Not applied after initial service creation
staticIps 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
tags MySqlTag[]
Tags are key-value pairs that allow you to categorize services.
techEmails MySqlTechEmail[]
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.
terminationProtection 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 This property is required. 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 and premium-x where x 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
This property is required.
Changes to this property will trigger replacement.
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
This property is required.
Changes to this property will trigger replacement.
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_space str
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.

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

maintenance_window_dow str
Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
maintenance_window_time str
Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
mysql MySqlMysqlArgs
MySQL server-provided values.
mysql_user_config MySqlMysqlUserConfigArgs
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_id str
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[MySqlServiceIntegrationArgs]
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
tags Sequence[MySqlTagArgs]
Tags are key-value pairs that allow you to categorize services.
tech_emails Sequence[MySqlTechEmailArgs]
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 This property is required. 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 and premium-x where x 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
This property is required.
Changes to this property will trigger replacement.
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.
serviceName
This property is required.
Changes to this property will trigger replacement.
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.
additionalDiskSpace String
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.
cloudName 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.
diskSpace 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.

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

maintenanceWindowDow String
Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
maintenanceWindowTime String
Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
mysql Property Map
MySQL server-provided values.
mysqlUserConfig Property Map
Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
projectVpcId String
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.
serviceIntegrations List<Property Map>
Service integrations to specify when creating a service. Not applied after initial service creation
staticIps 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
tags List<Property Map>
Tags are key-value pairs that allow you to categorize services.
techEmails 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.
terminationProtection 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<MySqlComponent>
Service component information objects
DiskSpaceCap string
The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
DiskSpaceDefault string
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
DiskSpaceStep string
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 from disk_space_default by increments of this size.
DiskSpaceUsed string
Disk space that service is currently using

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

Id string
The provider-assigned unique ID for this managed resource.
ServiceHost string
The hostname of the service.
ServicePassword string
Password used for connecting to the service, if applicable
ServicePort int
The port of the service
ServiceType string
Aiven internal service type code
ServiceUri string
URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
ServiceUsername string
Username used for connecting to the service, if applicable
State string
Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING
Components []MySqlComponent
Service component information objects
DiskSpaceCap string
The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
DiskSpaceDefault string
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
DiskSpaceStep string
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 from disk_space_default by increments of this size.
DiskSpaceUsed string
Disk space that service is currently using

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

Id string
The provider-assigned unique ID for this managed resource.
ServiceHost string
The hostname of the service.
ServicePassword string
Password used for connecting to the service, if applicable
ServicePort int
The port of the service
ServiceType string
Aiven internal service type code
ServiceUri string
URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
ServiceUsername string
Username used for connecting to the service, if applicable
State string
Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING
components List<MySqlComponent>
Service component information objects
diskSpaceCap String
The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
diskSpaceDefault String
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
diskSpaceStep String
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 from disk_space_default by increments of this size.
diskSpaceUsed String
Disk space that service is currently using

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

id String
The provider-assigned unique ID for this managed resource.
serviceHost String
The hostname of the service.
servicePassword String
Password used for connecting to the service, if applicable
servicePort Integer
The port of the service
serviceType String
Aiven internal service type code
serviceUri String
URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
serviceUsername String
Username used for connecting to the service, if applicable
state String
Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING
components MySqlComponent[]
Service component information objects
diskSpaceCap string
The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
diskSpaceDefault string
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
diskSpaceStep string
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 from disk_space_default by increments of this size.
diskSpaceUsed string
Disk space that service is currently using

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

id string
The provider-assigned unique ID for this managed resource.
serviceHost string
The hostname of the service.
servicePassword string
Password used for connecting to the service, if applicable
servicePort number
The port of the service
serviceType string
Aiven internal service type code
serviceUri string
URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
serviceUsername string
Username used for connecting to the service, if applicable
state string
Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING
components Sequence[MySqlComponent]
Service component information objects
disk_space_cap str
The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
disk_space_default str
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_step str
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 from disk_space_default by increments of this size.
disk_space_used str
Disk space that service is currently using

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

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 or RUNNING
components List<Property Map>
Service component information objects
diskSpaceCap String
The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
diskSpaceDefault String
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
diskSpaceStep String
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 from disk_space_default by increments of this size.
diskSpaceUsed String
Disk space that service is currently using

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

id String
The provider-assigned unique ID for this managed resource.
serviceHost String
The hostname of the service.
servicePassword String
Password used for connecting to the service, if applicable
servicePort Number
The port of the service
serviceType String
Aiven internal service type code
serviceUri String
URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
serviceUsername String
Username used for connecting to the service, if applicable
state String
Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING

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)
resources:  _:    type: aiven:MySql    get:      id: ${id}
name This property is required.
The unique name of the resulting resource.
id This property is required.
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 This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
name This property is required.
The unique name of the resulting resource.
id This property is required.
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 This property is required.
The unique name of the resulting resource.
id This property is required.
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 This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
state
Any extra arguments used during the lookup.
opts
A bag of options that control this resource's behavior.
The following state arguments are supported:
AdditionalDiskSpace string
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.
CloudName 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<MySqlComponent>
Service component information objects
DiskSpace 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.

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

DiskSpaceCap string
The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
DiskSpaceDefault string
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
DiskSpaceStep string
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 from disk_space_default by increments of this size.
DiskSpaceUsed string
Disk space that service is currently using

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

MaintenanceWindowDow string
Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
MaintenanceWindowTime string
Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
Mysql MySqlMysql
MySQL server-provided values.
MysqlUserConfig MySqlMysqlUserConfig
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 and premium-x where x 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 Changes to this property will trigger replacement. 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.
ProjectVpcId string
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.
ServiceHost string
The hostname of the service.
ServiceIntegrations List<MySqlServiceIntegration>
Service integrations to specify when creating a service. Not applied after initial service creation
ServiceName Changes to this property will trigger replacement. 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.
ServicePassword string
Password used for connecting to the service, if applicable
ServicePort int
The port of the service
ServiceType string
Aiven internal service type code
ServiceUri string
URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
ServiceUsername string
Username used for connecting to the service, if applicable
State string
Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING
StaticIps 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
Tags List<MySqlTag>
Tags are key-value pairs that allow you to categorize services.
TechEmails List<MySqlTechEmail>
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.
TerminationProtection 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.
AdditionalDiskSpace string
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.
CloudName 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 []MySqlComponentArgs
Service component information objects
DiskSpace 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.

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

DiskSpaceCap string
The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
DiskSpaceDefault string
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
DiskSpaceStep string
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 from disk_space_default by increments of this size.
DiskSpaceUsed string
Disk space that service is currently using

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

MaintenanceWindowDow string
Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
MaintenanceWindowTime string
Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
Mysql MySqlMysqlArgs
MySQL server-provided values.
MysqlUserConfig MySqlMysqlUserConfigArgs
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 and premium-x where x 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 Changes to this property will trigger replacement. 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.
ProjectVpcId string
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.
ServiceHost string
The hostname of the service.
ServiceIntegrations []MySqlServiceIntegrationArgs
Service integrations to specify when creating a service. Not applied after initial service creation
ServiceName Changes to this property will trigger replacement. 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.
ServicePassword string
Password used for connecting to the service, if applicable
ServicePort int
The port of the service
ServiceType string
Aiven internal service type code
ServiceUri string
URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
ServiceUsername string
Username used for connecting to the service, if applicable
State string
Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING
StaticIps []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
Tags []MySqlTagArgs
Tags are key-value pairs that allow you to categorize services.
TechEmails []MySqlTechEmailArgs
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.
TerminationProtection 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.
additionalDiskSpace String
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.
cloudName 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<MySqlComponent>
Service component information objects
diskSpace 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.

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

diskSpaceCap String
The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
diskSpaceDefault String
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
diskSpaceStep String
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 from disk_space_default by increments of this size.
diskSpaceUsed String
Disk space that service is currently using

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

maintenanceWindowDow String
Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
maintenanceWindowTime String
Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
mysql MySqlMysql
MySQL server-provided values.
mysqlUserConfig MySqlMysqlUserConfig
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 and premium-x where x 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 Changes to this property will trigger replacement. 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.
projectVpcId String
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.
serviceHost String
The hostname of the service.
serviceIntegrations List<MySqlServiceIntegration>
Service integrations to specify when creating a service. Not applied after initial service creation
serviceName Changes to this property will trigger replacement. 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.
servicePassword String
Password used for connecting to the service, if applicable
servicePort Integer
The port of the service
serviceType String
Aiven internal service type code
serviceUri String
URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
serviceUsername String
Username used for connecting to the service, if applicable
state String
Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING
staticIps 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
tags List<MySqlTag>
Tags are key-value pairs that allow you to categorize services.
techEmails List<MySqlTechEmail>
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.
terminationProtection 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.
additionalDiskSpace string
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.
cloudName 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 MySqlComponent[]
Service component information objects
diskSpace 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.

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

diskSpaceCap string
The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
diskSpaceDefault string
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
diskSpaceStep string
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 from disk_space_default by increments of this size.
diskSpaceUsed string
Disk space that service is currently using

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

maintenanceWindowDow string
Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
maintenanceWindowTime string
Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
mysql MySqlMysql
MySQL server-provided values.
mysqlUserConfig MySqlMysqlUserConfig
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 and premium-x where x 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 Changes to this property will trigger replacement. 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.
projectVpcId string
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.
serviceHost string
The hostname of the service.
serviceIntegrations MySqlServiceIntegration[]
Service integrations to specify when creating a service. Not applied after initial service creation
serviceName Changes to this property will trigger replacement. 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.
servicePassword string
Password used for connecting to the service, if applicable
servicePort number
The port of the service
serviceType string
Aiven internal service type code
serviceUri string
URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
serviceUsername string
Username used for connecting to the service, if applicable
state string
Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING
staticIps 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
tags MySqlTag[]
Tags are key-value pairs that allow you to categorize services.
techEmails MySqlTechEmail[]
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.
terminationProtection 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_space str
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[MySqlComponentArgs]
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.

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

disk_space_cap str
The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
disk_space_default str
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_step str
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 from disk_space_default by increments of this size.
disk_space_used str
Disk space that service is currently using

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

maintenance_window_dow str
Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
maintenance_window_time str
Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
mysql MySqlMysqlArgs
MySQL server-provided values.
mysql_user_config MySqlMysqlUserConfigArgs
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 and premium-x where x 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 Changes to this property will trigger replacement. 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_id str
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[MySqlServiceIntegrationArgs]
Service integrations to specify when creating a service. Not applied after initial service creation
service_name Changes to this property will trigger replacement. 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 or RUNNING
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
tags Sequence[MySqlTagArgs]
Tags are key-value pairs that allow you to categorize services.
tech_emails Sequence[MySqlTechEmailArgs]
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.
additionalDiskSpace String
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.
cloudName 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
diskSpace 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.

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

diskSpaceCap String
The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
diskSpaceDefault String
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
diskSpaceStep String
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 from disk_space_default by increments of this size.
diskSpaceUsed String
Disk space that service is currently using

Deprecated: This will be removed in v5.0.0. Please use additional_disk_space to specify the space to be added to the default disk_space defined by the plan.

maintenanceWindowDow String
Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
maintenanceWindowTime String
Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
mysql Property Map
MySQL server-provided values.
mysqlUserConfig Property Map
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 and premium-x where x 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 Changes to this property will trigger replacement. 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.
projectVpcId String
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.
serviceHost String
The hostname of the service.
serviceIntegrations List<Property Map>
Service integrations to specify when creating a service. Not applied after initial service creation
serviceName Changes to this property will trigger replacement. 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.
servicePassword String
Password used for connecting to the service, if applicable
servicePort Number
The port of the service
serviceType String
Aiven internal service type code
serviceUri String
URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
serviceUsername String
Username used for connecting to the service, if applicable
state String
Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING
staticIps 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
tags List<Property Map>
Tags are key-value pairs that allow you to categorize services.
techEmails 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.
terminationProtection 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
ConnectionUri 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
KafkaAuthenticationMethod string
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
ConnectionUri 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
KafkaAuthenticationMethod string
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
connectionUri 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
kafkaAuthenticationMethod String
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
connectionUri 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
kafkaAuthenticationMethod string
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_method str
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
connectionUri 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
kafkaAuthenticationMethod String
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<MySqlMysqlParam>
MySQL connection parameters.
ReplicaUri string
MySQL replica URI for services with a replica.
StandbyUris List<string>
MySQL standby connection URIs.
SyncingUris List<string>
MySQL syncing connection URIs.
Uris List<string>
MySQL connection URIs.
Params []MySqlMysqlParam
MySQL connection parameters.
ReplicaUri string
MySQL replica URI for services with a replica.
StandbyUris []string
MySQL standby connection URIs.
SyncingUris []string
MySQL syncing connection URIs.
Uris []string
MySQL connection URIs.
params List<MySqlMysqlParam>
MySQL connection parameters.
replicaUri String
MySQL replica URI for services with a replica.
standbyUris List<String>
MySQL standby connection URIs.
syncingUris List<String>
MySQL syncing connection URIs.
uris List<String>
MySQL connection URIs.
params MySqlMysqlParam[]
MySQL connection parameters.
replicaUri string
MySQL replica URI for services with a replica.
standbyUris string[]
MySQL standby connection URIs.
syncingUris string[]
MySQL syncing connection URIs.
uris string[]
MySQL connection URIs.
params Sequence[MySqlMysqlParam]
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 connection URIs.
params List<Property Map>
MySQL connection parameters.
replicaUri String
MySQL replica URI for services with a replica.
standbyUris List<String>
MySQL standby connection URIs.
syncingUris List<String>
MySQL syncing connection URIs.
uris List<String>
MySQL connection URIs.

MySqlMysqlParam
, MySqlMysqlParamArgs

DatabaseName string
Thr name of the primary MySQL database.
Host string
MySQL host IP or name.
Password string
The password for the admin service user.
Port int
MySQL port.
Sslmode string
MySQL SSL mode setting. Always set to "require".
User string
The username for the admin service user.
DatabaseName string
Thr name of the primary MySQL database.
Host string
MySQL host IP or name.
Password string
The password for the admin service user.
Port int
MySQL port.
Sslmode string
MySQL SSL mode setting. Always set to "require".
User string
The username for the admin service user.
databaseName String
Thr name of the primary MySQL database.
host String
MySQL host IP or name.
password String
The password for the admin service user.
port Integer
MySQL port.
sslmode String
MySQL SSL mode setting. Always set to "require".
user String
The username for the admin service user.
databaseName string
Thr name of the primary MySQL database.
host string
MySQL host IP or name.
password string
The password for the admin service user.
port number
MySQL port.
sslmode string
MySQL SSL mode setting. Always set to "require".
user string
The username for the admin service user.
database_name str
Thr name of the primary MySQL database.
host str
MySQL host IP or name.
password str
The password for the admin service user.
port int
MySQL port.
sslmode str
MySQL SSL mode setting. Always set to "require".
user str
The username for the admin service user.
databaseName String
Thr name of the primary MySQL database.
host String
MySQL host IP or name.
password String
The password for the admin service user.
port Number
MySQL port.
sslmode String
MySQL SSL mode setting. Always set to "require".
user String
The username for the admin service user.

MySqlMysqlUserConfig
, MySqlMysqlUserConfigArgs

AdditionalBackupRegions string
Additional Cloud Regions for Backup Replication.
AdminPassword Changes to this property will trigger replacement. string
Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
AdminUsername Changes to this property will trigger replacement. string
Custom username for admin user. This must be set only when a new service is being created. Example: avnadmin.
BackupHour 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.
BackupMinute 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.
BinlogRetentionPeriod int
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.
IpFilterObjects List<MySqlMysqlUserConfigIpFilterObject>
Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16
IpFilterStrings List<string>
Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16.
IpFilters List<string>
Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16.

Deprecated: Deprecated. Use ip_filter_string instead.

Migration MySqlMysqlUserConfigMigration
Migrate data from existing server
Mysql MySqlMysqlUserConfigMysql
mysql.conf configuration values
MysqlVersion string
Enum: 8, and newer. MySQL major version.
PrivateAccess MySqlMysqlUserConfigPrivateAccess
Allow access to selected service ports from private networks
PrivatelinkAccess MySqlMysqlUserConfigPrivatelinkAccess
Allow access to selected service components through Privatelink
ProjectToForkFrom Changes to this property will trigger replacement. string
Name of another project to fork a service from. This has effect only when a new service is being created. Example: anotherprojectname.
PublicAccess MySqlMysqlUserConfigPublicAccess
Allow access to selected service ports from the public Internet
RecoveryTargetTime Changes to this property will trigger replacement. string
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.
ServiceLog bool
Store logs for the service so that they are available in the HTTP API and console.
ServiceToForkFrom Changes to this property will trigger replacement. string
Name of another service to fork from. This has effect only when a new service is being created. Example: anotherservicename.
StaticIps bool
Use static public IP addresses.
AdditionalBackupRegions string
Additional Cloud Regions for Backup Replication.
AdminPassword Changes to this property will trigger replacement. string
Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
AdminUsername Changes to this property will trigger replacement. string
Custom username for admin user. This must be set only when a new service is being created. Example: avnadmin.
BackupHour 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.
BackupMinute 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.
BinlogRetentionPeriod int
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.
IpFilterObjects []MySqlMysqlUserConfigIpFilterObject
Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16
IpFilterStrings []string
Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16.
IpFilters []string
Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16.

Deprecated: Deprecated. Use ip_filter_string instead.

Migration MySqlMysqlUserConfigMigration
Migrate data from existing server
Mysql MySqlMysqlUserConfigMysql
mysql.conf configuration values
MysqlVersion string
Enum: 8, and newer. MySQL major version.
PrivateAccess MySqlMysqlUserConfigPrivateAccess
Allow access to selected service ports from private networks
PrivatelinkAccess MySqlMysqlUserConfigPrivatelinkAccess
Allow access to selected service components through Privatelink
ProjectToForkFrom Changes to this property will trigger replacement. string
Name of another project to fork a service from. This has effect only when a new service is being created. Example: anotherprojectname.
PublicAccess MySqlMysqlUserConfigPublicAccess
Allow access to selected service ports from the public Internet
RecoveryTargetTime Changes to this property will trigger replacement. string
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.
ServiceLog bool
Store logs for the service so that they are available in the HTTP API and console.
ServiceToForkFrom Changes to this property will trigger replacement. string
Name of another service to fork from. This has effect only when a new service is being created. Example: anotherservicename.
StaticIps bool
Use static public IP addresses.
additionalBackupRegions String
Additional Cloud Regions for Backup Replication.
adminPassword Changes to this property will trigger replacement. String
Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
adminUsername Changes to this property will trigger replacement. String
Custom username for admin user. This must be set only when a new service is being created. Example: avnadmin.
backupHour 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.
backupMinute 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.
binlogRetentionPeriod Integer
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.
ipFilterObjects List<MySqlMysqlUserConfigIpFilterObject>
Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16
ipFilterStrings List<String>
Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16.
ipFilters List<String>
Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16.

Deprecated: Deprecated. Use ip_filter_string instead.

migration MySqlMysqlUserConfigMigration
Migrate data from existing server
mysql MySqlMysqlUserConfigMysql
mysql.conf configuration values
mysqlVersion String
Enum: 8, and newer. MySQL major version.
privateAccess MySqlMysqlUserConfigPrivateAccess
Allow access to selected service ports from private networks
privatelinkAccess MySqlMysqlUserConfigPrivatelinkAccess
Allow access to selected service components through Privatelink
projectToForkFrom Changes to this property will trigger replacement. String
Name of another project to fork a service from. This has effect only when a new service is being created. Example: anotherprojectname.
publicAccess MySqlMysqlUserConfigPublicAccess
Allow access to selected service ports from the public Internet
recoveryTargetTime Changes to this property will trigger replacement. String
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.
serviceLog Boolean
Store logs for the service so that they are available in the HTTP API and console.
serviceToForkFrom Changes to this property will trigger replacement. String
Name of another service to fork from. This has effect only when a new service is being created. Example: anotherservicename.
staticIps Boolean
Use static public IP addresses.
additionalBackupRegions string
Additional Cloud Regions for Backup Replication.
adminPassword Changes to this property will trigger replacement. string
Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
adminUsername Changes to this property will trigger replacement. string
Custom username for admin user. This must be set only when a new service is being created. Example: avnadmin.
backupHour 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.
backupMinute 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.
binlogRetentionPeriod number
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.
ipFilterObjects MySqlMysqlUserConfigIpFilterObject[]
Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16
ipFilterStrings string[]
Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16.
ipFilters string[]
Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16.

Deprecated: Deprecated. Use ip_filter_string instead.

migration MySqlMysqlUserConfigMigration
Migrate data from existing server
mysql MySqlMysqlUserConfigMysql
mysql.conf configuration values
mysqlVersion string
Enum: 8, and newer. MySQL major version.
privateAccess MySqlMysqlUserConfigPrivateAccess
Allow access to selected service ports from private networks
privatelinkAccess MySqlMysqlUserConfigPrivatelinkAccess
Allow access to selected service components through Privatelink
projectToForkFrom Changes to this property will trigger replacement. string
Name of another project to fork a service from. This has effect only when a new service is being created. Example: anotherprojectname.
publicAccess MySqlMysqlUserConfigPublicAccess
Allow access to selected service ports from the public Internet
recoveryTargetTime Changes to this property will trigger replacement. string
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.
serviceLog boolean
Store logs for the service so that they are available in the HTTP API and console.
serviceToForkFrom Changes to this property will trigger replacement. string
Name of another service to fork from. This has effect only when a new service is being created. Example: anotherservicename.
staticIps boolean
Use static public IP addresses.
additional_backup_regions str
Additional Cloud Regions for Backup Replication.
admin_password Changes to this property will trigger replacement. str
Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
admin_username Changes to this property will trigger replacement. 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_period int
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_objects Sequence[MySqlMysqlUserConfigIpFilterObject]
Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16
ip_filter_strings Sequence[str]
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.

Deprecated: Deprecated. Use ip_filter_string instead.

migration MySqlMysqlUserConfigMigration
Migrate data from existing server
mysql MySqlMysqlUserConfigMysql
mysql.conf configuration values
mysql_version str
Enum: 8, and newer. MySQL major version.
private_access MySqlMysqlUserConfigPrivateAccess
Allow access to selected service ports from private networks
privatelink_access MySqlMysqlUserConfigPrivatelinkAccess
Allow access to selected service components through Privatelink
project_to_fork_from Changes to this property will trigger replacement. str
Name of another project to fork a service from. This has effect only when a new service is being created. Example: anotherprojectname.
public_access MySqlMysqlUserConfigPublicAccess
Allow access to selected service ports from the public Internet
recovery_target_time Changes to this property will trigger replacement. str
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_fork_from Changes to this property will trigger replacement. str
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.
additionalBackupRegions String
Additional Cloud Regions for Backup Replication.
adminPassword Changes to this property will trigger replacement. String
Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
adminUsername Changes to this property will trigger replacement. String
Custom username for admin user. This must be set only when a new service is being created. Example: avnadmin.
backupHour 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.
backupMinute 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.
binlogRetentionPeriod Number
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.
ipFilterObjects List<Property Map>
Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16
ipFilterStrings List<String>
Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16.
ipFilters List<String>
Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16.

Deprecated: Deprecated. Use ip_filter_string instead.

migration Property Map
Migrate data from existing server
mysql Property Map
mysql.conf configuration values
mysqlVersion String
Enum: 8, and newer. MySQL major version.
privateAccess Property Map
Allow access to selected service ports from private networks
privatelinkAccess Property Map
Allow access to selected service components through Privatelink
projectToForkFrom Changes to this property will trigger replacement. String
Name of another project to fork a service from. This has effect only when a new service is being created. Example: anotherprojectname.
publicAccess Property Map
Allow access to selected service ports from the public Internet
recoveryTargetTime Changes to this property will trigger replacement. String
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.
serviceLog Boolean
Store logs for the service so that they are available in the HTTP API and console.
serviceToForkFrom Changes to this property will trigger replacement. String
Name of another service to fork from. This has effect only when a new service is being created. Example: anotherservicename.
staticIps Boolean
Use static public IP addresses.

MySqlMysqlUserConfigIpFilterObject
, MySqlMysqlUserConfigIpFilterObjectArgs

Network This property is required. string
CIDR address block. Example: 10.20.0.0/16.
Description string
Description for IP filter list entry. Example: Production service IP range.
Network This property is required. string
CIDR address block. Example: 10.20.0.0/16.
Description string
Description for IP filter list entry. Example: Production service IP range.
network This property is required. String
CIDR address block. Example: 10.20.0.0/16.
description String
Description for IP filter list entry. Example: Production service IP range.
network This property is required. string
CIDR address block. Example: 10.20.0.0/16.
description string
Description for IP filter list entry. Example: Production service IP range.
network This property is required. str
CIDR address block. Example: 10.20.0.0/16.
description str
Description for IP filter list entry. Example: Production service IP range.
network This property is required. 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 This property is required. string
Hostname or IP address of the server where to migrate data from. Example: my.server.com.
Port This property is required. int
Port number of the server where to migrate data from. Example: 1234.
Dbname string
Database name for bootstrapping the initial connection. Example: defaultdb.
IgnoreDbs string
Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment). Example: db1,db2.
IgnoreRoles 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 This property is required. string
Hostname or IP address of the server where to migrate data from. Example: my.server.com.
Port This property is required. int
Port number of the server where to migrate data from. Example: 1234.
Dbname string
Database name for bootstrapping the initial connection. Example: defaultdb.
IgnoreDbs string
Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment). Example: db1,db2.
IgnoreRoles 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 This property is required. String
Hostname or IP address of the server where to migrate data from. Example: my.server.com.
port This property is required. Integer
Port number of the server where to migrate data from. Example: 1234.
dbname String
Database name for bootstrapping the initial connection. Example: defaultdb.
ignoreDbs String
Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment). Example: db1,db2.
ignoreRoles 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 This property is required. string
Hostname or IP address of the server where to migrate data from. Example: my.server.com.
port This property is required. number
Port number of the server where to migrate data from. Example: 1234.
dbname string
Database name for bootstrapping the initial connection. Example: defaultdb.
ignoreDbs string
Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment). Example: db1,db2.
ignoreRoles 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 This property is required. str
Hostname or IP address of the server where to migrate data from. Example: my.server.com.
port This property is required. 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 This property is required. String
Hostname or IP address of the server where to migrate data from. Example: my.server.com.
port This property is required. Number
Port number of the server where to migrate data from. Example: 1234.
dbname String
Database name for bootstrapping the initial connection. Example: defaultdb.
ignoreDbs String
Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment). Example: db1,db2.
ignoreRoles 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

ConnectTimeout int
The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake. Example: 10.
DefaultTimeZone string
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.
GroupConcatMaxLen int
The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example: 1024.
InformationSchemaStatsExpiry int
The time, in seconds, before cached statistics expire. Example: 86400.
InnodbChangeBufferMaxSize int
Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example: 30.
InnodbFlushNeighbors int
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.
InnodbFtMinTokenSize int
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.
InnodbFtServerStopwordTable string
This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example: db_name/table_name.
InnodbLockWaitTimeout int
The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example: 50.
InnodbLogBufferSize int
The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example: 16777216.
InnodbOnlineAlterLogMaxSize int
The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example: 134217728.
InnodbPrintAllDeadlocks bool
When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
InnodbReadIoThreads int
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.
InnodbRollbackOnTimeout bool
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.
InnodbThreadConcurrency int
Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example: 10.
InnodbWriteIoThreads int
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.
InteractiveTimeout int
The number of seconds the server waits for activity on an interactive connection before closing it. Example: 3600.
InternalTmpMemStorageEngine string
Enum: MEMORY, TempTable. The storage engine for in-memory internal temporary tables.
LogOutput 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.
LongQueryTime double
The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Example: 10.0.
MaxAllowedPacket int
Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example: 67108864.
MaxHeapTableSize int
Limits the size of internal in-memory tables. Also set tmptablesize. Default is 16777216 (16M). Example: 16777216.
NetBufferLength int
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.
NetReadTimeout int
The number of seconds to wait for more data from a connection before aborting the read. Example: 30.
NetWriteTimeout int
The number of seconds to wait for a block to be written to a connection before aborting the write. Example: 30.
SlowQueryLog bool
Slow query log enables capturing of slow queries. Setting slowquerylog to false also truncates the mysql.slow_log table.
SortBufferSize int
Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K). Example: 262144.
SqlMode 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.
SqlRequirePrimaryKey bool
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.
TmpTableSize int
Limits the size of internal in-memory tables. Also set maxheaptable_size. Default is 16777216 (16M). Example: 16777216.
WaitTimeout int
The number of seconds the server waits for activity on a noninteractive connection before closing it. Example: 28800.
ConnectTimeout int
The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake. Example: 10.
DefaultTimeZone string
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.
GroupConcatMaxLen int
The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example: 1024.
InformationSchemaStatsExpiry int
The time, in seconds, before cached statistics expire. Example: 86400.
InnodbChangeBufferMaxSize int
Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example: 30.
InnodbFlushNeighbors int
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.
InnodbFtMinTokenSize int
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.
InnodbFtServerStopwordTable string
This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example: db_name/table_name.
InnodbLockWaitTimeout int
The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example: 50.
InnodbLogBufferSize int
The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example: 16777216.
InnodbOnlineAlterLogMaxSize int
The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example: 134217728.
InnodbPrintAllDeadlocks bool
When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
InnodbReadIoThreads int
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.
InnodbRollbackOnTimeout bool
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.
InnodbThreadConcurrency int
Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example: 10.
InnodbWriteIoThreads int
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.
InteractiveTimeout int
The number of seconds the server waits for activity on an interactive connection before closing it. Example: 3600.
InternalTmpMemStorageEngine string
Enum: MEMORY, TempTable. The storage engine for in-memory internal temporary tables.
LogOutput 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.
LongQueryTime float64
The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Example: 10.0.
MaxAllowedPacket int
Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example: 67108864.
MaxHeapTableSize int
Limits the size of internal in-memory tables. Also set tmptablesize. Default is 16777216 (16M). Example: 16777216.
NetBufferLength int
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.
NetReadTimeout int
The number of seconds to wait for more data from a connection before aborting the read. Example: 30.
NetWriteTimeout int
The number of seconds to wait for a block to be written to a connection before aborting the write. Example: 30.
SlowQueryLog bool
Slow query log enables capturing of slow queries. Setting slowquerylog to false also truncates the mysql.slow_log table.
SortBufferSize int
Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K). Example: 262144.
SqlMode 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.
SqlRequirePrimaryKey bool
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.
TmpTableSize int
Limits the size of internal in-memory tables. Also set maxheaptable_size. Default is 16777216 (16M). Example: 16777216.
WaitTimeout int
The number of seconds the server waits for activity on a noninteractive connection before closing it. Example: 28800.
connectTimeout Integer
The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake. Example: 10.
defaultTimeZone String
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.
groupConcatMaxLen Integer
The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example: 1024.
informationSchemaStatsExpiry Integer
The time, in seconds, before cached statistics expire. Example: 86400.
innodbChangeBufferMaxSize Integer
Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example: 30.
innodbFlushNeighbors Integer
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.
innodbFtMinTokenSize Integer
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.
innodbFtServerStopwordTable String
This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example: db_name/table_name.
innodbLockWaitTimeout Integer
The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example: 50.
innodbLogBufferSize Integer
The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example: 16777216.
innodbOnlineAlterLogMaxSize Integer
The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example: 134217728.
innodbPrintAllDeadlocks Boolean
When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
innodbReadIoThreads Integer
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.
innodbRollbackOnTimeout Boolean
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.
innodbThreadConcurrency Integer
Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example: 10.
innodbWriteIoThreads Integer
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.
interactiveTimeout Integer
The number of seconds the server waits for activity on an interactive connection before closing it. Example: 3600.
internalTmpMemStorageEngine String
Enum: MEMORY, TempTable. The storage engine for in-memory internal temporary tables.
logOutput 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.
longQueryTime Double
The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Example: 10.0.
maxAllowedPacket Integer
Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example: 67108864.
maxHeapTableSize Integer
Limits the size of internal in-memory tables. Also set tmptablesize. Default is 16777216 (16M). Example: 16777216.
netBufferLength Integer
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.
netReadTimeout Integer
The number of seconds to wait for more data from a connection before aborting the read. Example: 30.
netWriteTimeout Integer
The number of seconds to wait for a block to be written to a connection before aborting the write. Example: 30.
slowQueryLog Boolean
Slow query log enables capturing of slow queries. Setting slowquerylog to false also truncates the mysql.slow_log table.
sortBufferSize Integer
Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K). Example: 262144.
sqlMode 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.
sqlRequirePrimaryKey Boolean
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.
tmpTableSize Integer
Limits the size of internal in-memory tables. Also set maxheaptable_size. Default is 16777216 (16M). Example: 16777216.
waitTimeout Integer
The number of seconds the server waits for activity on a noninteractive connection before closing it. Example: 28800.
connectTimeout number
The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake. Example: 10.
defaultTimeZone string
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.
groupConcatMaxLen number
The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example: 1024.
informationSchemaStatsExpiry number
The time, in seconds, before cached statistics expire. Example: 86400.
innodbChangeBufferMaxSize number
Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example: 30.
innodbFlushNeighbors number
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.
innodbFtMinTokenSize number
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.
innodbFtServerStopwordTable string
This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example: db_name/table_name.
innodbLockWaitTimeout number
The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example: 50.
innodbLogBufferSize number
The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example: 16777216.
innodbOnlineAlterLogMaxSize number
The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example: 134217728.
innodbPrintAllDeadlocks boolean
When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
innodbReadIoThreads number
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.
innodbRollbackOnTimeout boolean
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.
innodbThreadConcurrency number
Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example: 10.
innodbWriteIoThreads number
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.
interactiveTimeout number
The number of seconds the server waits for activity on an interactive connection before closing it. Example: 3600.
internalTmpMemStorageEngine string
Enum: MEMORY, TempTable. The storage engine for in-memory internal temporary tables.
logOutput 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.
longQueryTime number
The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Example: 10.0.
maxAllowedPacket number
Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example: 67108864.
maxHeapTableSize number
Limits the size of internal in-memory tables. Also set tmptablesize. Default is 16777216 (16M). Example: 16777216.
netBufferLength number
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.
netReadTimeout number
The number of seconds to wait for more data from a connection before aborting the read. Example: 30.
netWriteTimeout number
The number of seconds to wait for a block to be written to a connection before aborting the write. Example: 30.
slowQueryLog boolean
Slow query log enables capturing of slow queries. Setting slowquerylog to false also truncates the mysql.slow_log table.
sortBufferSize number
Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K). Example: 262144.
sqlMode 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.
sqlRequirePrimaryKey boolean
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.
tmpTableSize number
Limits the size of internal in-memory tables. Also set maxheaptable_size. Default is 16777216 (16M). Example: 16777216.
waitTimeout 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_zone str
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_max_len int
The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example: 1024.
information_schema_stats_expiry int
The time, in seconds, before cached statistics expire. Example: 86400.
innodb_change_buffer_max_size int
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_neighbors int
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_min_token_size int
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_server_stopword_table str
This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example: db_name/table_name.
innodb_lock_wait_timeout int
The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example: 50.
innodb_log_buffer_size int
The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example: 16777216.
innodb_online_alter_log_max_size int
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_all_deadlocks bool
When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
innodb_read_io_threads int
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_on_timeout bool
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_concurrency int
Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example: 10.
innodb_write_io_threads int
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_mem_storage_engine str
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_time float
The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Example: 10.0.
max_allowed_packet int
Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example: 67108864.
max_heap_table_size int
Limits the size of internal in-memory tables. Also set tmptablesize. Default is 16777216 (16M). Example: 16777216.
net_buffer_length int
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_timeout int
The number of seconds to wait for more data from a connection before aborting the read. Example: 30.
net_write_timeout int
The number of seconds to wait for a block to be written to a connection before aborting the write. Example: 30.
slow_query_log bool
Slow query log enables capturing of slow queries. Setting slowquerylog to false also truncates the mysql.slow_log table.
sort_buffer_size int
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_primary_key bool
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_size int
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.
connectTimeout Number
The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake. Example: 10.
defaultTimeZone String
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.
groupConcatMaxLen Number
The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example: 1024.
informationSchemaStatsExpiry Number
The time, in seconds, before cached statistics expire. Example: 86400.
innodbChangeBufferMaxSize Number
Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example: 30.
innodbFlushNeighbors Number
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.
innodbFtMinTokenSize Number
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.
innodbFtServerStopwordTable String
This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example: db_name/table_name.
innodbLockWaitTimeout Number
The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example: 50.
innodbLogBufferSize Number
The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example: 16777216.
innodbOnlineAlterLogMaxSize Number
The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example: 134217728.
innodbPrintAllDeadlocks Boolean
When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
innodbReadIoThreads Number
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.
innodbRollbackOnTimeout Boolean
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.
innodbThreadConcurrency Number
Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example: 10.
innodbWriteIoThreads Number
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.
interactiveTimeout Number
The number of seconds the server waits for activity on an interactive connection before closing it. Example: 3600.
internalTmpMemStorageEngine String
Enum: MEMORY, TempTable. The storage engine for in-memory internal temporary tables.
logOutput 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.
longQueryTime Number
The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Example: 10.0.
maxAllowedPacket Number
Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example: 67108864.
maxHeapTableSize Number
Limits the size of internal in-memory tables. Also set tmptablesize. Default is 16777216 (16M). Example: 16777216.
netBufferLength Number
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.
netReadTimeout Number
The number of seconds to wait for more data from a connection before aborting the read. Example: 30.
netWriteTimeout Number
The number of seconds to wait for a block to be written to a connection before aborting the write. Example: 30.
slowQueryLog Boolean
Slow query log enables capturing of slow queries. Setting slowquerylog to false also truncates the mysql.slow_log table.
sortBufferSize Number
Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K). Example: 262144.
sqlMode 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.
sqlRequirePrimaryKey Boolean
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.
tmpTableSize Number
Limits the size of internal in-memory tables. Also set maxheaptable_size. Default is 16777216 (16M). Example: 16777216.
waitTimeout 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

IntegrationType This property is required. string
Type of the service integration. The possible value is read_replica.
SourceServiceName This property is required. string
Name of the source service
IntegrationType This property is required. string
Type of the service integration. The possible value is read_replica.
SourceServiceName This property is required. string
Name of the source service
integrationType This property is required. String
Type of the service integration. The possible value is read_replica.
sourceServiceName This property is required. String
Name of the source service
integrationType This property is required. string
Type of the service integration. The possible value is read_replica.
sourceServiceName This property is required. string
Name of the source service
integration_type This property is required. str
Type of the service integration. The possible value is read_replica.
source_service_name This property is required. str
Name of the source service
integrationType This property is required. String
Type of the service integration. The possible value is read_replica.
sourceServiceName This property is required. String
Name of the source service

MySqlTag
, MySqlTagArgs

Key This property is required. string
Service tag key
Value This property is required. string
Service tag value
Key This property is required. string
Service tag key
Value This property is required. string
Service tag value
key This property is required. String
Service tag key
value This property is required. String
Service tag value
key This property is required. string
Service tag key
value This property is required. string
Service tag value
key This property is required. str
Service tag key
value This property is required. str
Service tag value
key This property is required. String
Service tag key
value This property is required. String
Service tag value

MySqlTechEmail
, MySqlTechEmailArgs

Email This property is required. string
An email address to contact for technical issues
Email This property is required. string
An email address to contact for technical issues
email This property is required. String
An email address to contact for technical issues
email This property is required. string
An email address to contact for technical issues
email This property is required. str
An email address to contact for technical issues
email This property is required. String
An email address to contact for technical issues

Import

$ pulumi import aiven:index/mySql:MySql example_mysql PROJECT/SERVICE_NAME
Copy

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.
Aiven v6.35.0 published on Friday, Feb 21, 2025 by Pulumi
pulumi/pulumi-aiven