Docs Packages
  1. Packages
  2. Aiven
  3. API Docs
  4. MySql
Aiven v6.18.0 published on Thursday, Jun 27, 2024 by Pulumi
pulumi/pulumi-aiven

aiven.MySql

Explore with Pulumi AI

aiven logo
Aiven v6.18.0 published on Thursday, Jun 27, 2024 by Pulumi
pulumi/pulumi-aiven

    The MySQL resource allows the creation and management of Aiven MySQL services.

    Example Usage

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

const mysql1 = new aiven.MySql("mysql1", {
    project: foo.project,
    cloudName: "google-europe-west1",
    plan: "business-4",
    serviceName: "my-mysql1",
    maintenanceWindowDow: "monday",
    maintenanceWindowTime: "10:00:00",
    mysqlUserConfig: {
        mysqlVersion: "8",
        mysql: {
            sqlMode: "ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE",
            sqlRequirePrimaryKey: true,
        },
        publicAccess: {
            mysql: true,
        },
    },
});

    import pulumi
import pulumi_aiven as aiven

mysql1 = aiven.MySql("mysql1",
    project=foo["project"],
    cloud_name="google-europe-west1",
    plan="business-4",
    service_name="my-mysql1",
    maintenance_window_dow="monday",
    maintenance_window_time="10:00:00",
    mysql_user_config=aiven.MySqlMysqlUserConfigArgs(
        mysql_version="8",
        mysql=aiven.MySqlMysqlUserConfigMysqlArgs(
            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=aiven.MySqlMysqlUserConfigPublicAccessArgs(
            mysql=True,
        ),
    ))

    package main

import (
	"github.com/pulumi/pulumi-aiven/sdk/v6/go/aiven"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := aiven.NewMySql(ctx, "mysql1", &aiven.MySqlArgs{
			Project:               pulumi.Any(foo.Project),
			CloudName:             pulumi.String("google-europe-west1"),
			Plan:                  pulumi.String("business-4"),
			ServiceName:           pulumi.String("my-mysql1"),
			MaintenanceWindowDow:  pulumi.String("monday"),
			MaintenanceWindowTime: pulumi.String("10:00:00"),
			MysqlUserConfig: &aiven.MySqlMysqlUserConfigArgs{
				MysqlVersion: pulumi.String("8"),
				Mysql: &aiven.MySqlMysqlUserConfigMysqlArgs{
					SqlMode:              pulumi.String("ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE"),
					SqlRequirePrimaryKey: pulumi.Bool(true),
				},
				PublicAccess: &aiven.MySqlMysqlUserConfigPublicAccessArgs{
					Mysql: pulumi.Bool(true),
				},
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Aiven = Pulumi.Aiven;

return await Deployment.RunAsync(() => 
{
    var mysql1 = new Aiven.MySql("mysql1", new()
    {
        Project = foo.Project,
        CloudName = "google-europe-west1",
        Plan = "business-4",
        ServiceName = "my-mysql1",
        MaintenanceWindowDow = "monday",
        MaintenanceWindowTime = "10:00:00",
        MysqlUserConfig = new Aiven.Inputs.MySqlMysqlUserConfigArgs
        {
            MysqlVersion = "8",
            Mysql = new Aiven.Inputs.MySqlMysqlUserConfigMysqlArgs
            {
                SqlMode = "ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE",
                SqlRequirePrimaryKey = true,
            },
            PublicAccess = new Aiven.Inputs.MySqlMysqlUserConfigPublicAccessArgs
            {
                Mysql = true,
            },
        },
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.aiven.MySql;
import com.pulumi.aiven.MySqlArgs;
import com.pulumi.aiven.inputs.MySqlMysqlUserConfigArgs;
import com.pulumi.aiven.inputs.MySqlMysqlUserConfigMysqlArgs;
import com.pulumi.aiven.inputs.MySqlMysqlUserConfigPublicAccessArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var mysql1 = new MySql("mysql1", MySqlArgs.builder()
            .project(foo.project())
            .cloudName("google-europe-west1")
            .plan("business-4")
            .serviceName("my-mysql1")
            .maintenanceWindowDow("monday")
            .maintenanceWindowTime("10:00:00")
            .mysqlUserConfig(MySqlMysqlUserConfigArgs.builder()
                .mysqlVersion(8)
                .mysql(MySqlMysqlUserConfigMysqlArgs.builder()
                    .sqlMode("ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE")
                    .sqlRequirePrimaryKey(true)
                    .build())
                .publicAccess(MySqlMysqlUserConfigPublicAccessArgs.builder()
                    .mysql(true)
                    .build())
                .build())
            .build());

    }
}

    resources:
  mysql1:
    type: aiven:MySql
    properties:
      project: ${foo.project}
      cloudName: google-europe-west1
      plan: business-4
      serviceName: my-mysql1
      maintenanceWindowDow: monday
      maintenanceWindowTime: 10:00:00
      mysqlUserConfig:
        mysqlVersion: 8
        mysql:
          sqlMode: ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE
          sqlRequirePrimaryKey: true
        publicAccess:
          mysql: true

    Create MySql Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new MySql(name: string, args: MySqlArgs, opts?: CustomResourceOptions);
    @overload
def MySql(resource_name: str,
          args: MySqlArgs,
          opts: Optional[ResourceOptions] = None)

@overload
def MySql(resource_name: str,
          opts: Optional[ResourceOptions] = None,
          plan: Optional[str] = None,
          service_name: Optional[str] = None,
          project: Optional[str] = None,
          maintenance_window_time: Optional[str] = None,
          additional_disk_space: Optional[str] = None,
          mysql: Optional[MySqlMysqlArgs] = None,
          mysql_user_config: Optional[MySqlMysqlUserConfigArgs] = None,
          maintenance_window_dow: Optional[str] = None,
          disk_space: Optional[str] = None,
          project_vpc_id: Optional[str] = None,
          service_integrations: Optional[Sequence[MySqlServiceIntegrationArgs]] = None,
          cloud_name: Optional[str] = None,
          static_ips: Optional[Sequence[str]] = None,
          tags: Optional[Sequence[MySqlTagArgs]] = None,
          tech_emails: Optional[Sequence[MySqlTechEmailArgs]] = None,
          termination_protection: Optional[bool] = None)
    func NewMySql(ctx *Context, name string, args MySqlArgs, opts ...ResourceOption) (*MySql, error)
    public MySql(string name, MySqlArgs args, CustomResourceOptions? opts = null)
    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 string
    The unique name of the resource.
    args MySqlArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args MySqlArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args MySqlArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args MySqlArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args MySqlArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var mySqlResource = new Aiven.MySql("mySqlResource", new()
{
    Plan = "string",
    ServiceName = "string",
    Project = "string",
    MaintenanceWindowTime = "string",
    AdditionalDiskSpace = "string",
    Mysql = new Aiven.Inputs.MySqlMysqlArgs
    {
        Params = new[]
        {
            new Aiven.Inputs.MySqlMysqlParamArgs
            {
                DatabaseName = "string",
                Host = "string",
                Password = "string",
                Port = 0,
                Sslmode = "string",
                User = "string",
            },
        },
        ReplicaUri = "string",
        StandbyUris = new[]
        {
            "string",
        },
        SyncingUris = new[]
        {
            "string",
        },
        Uris = new[]
        {
            "string",
        },
    },
    MysqlUserConfig = new Aiven.Inputs.MySqlMysqlUserConfigArgs
    {
        AdditionalBackupRegions = "string",
        AdminPassword = "string",
        AdminUsername = "string",
        BackupHour = 0,
        BackupMinute = 0,
        BinlogRetentionPeriod = 0,
        IpFilterObjects = new[]
        {
            new Aiven.Inputs.MySqlMysqlUserConfigIpFilterObjectArgs
            {
                Network = "string",
                Description = "string",
            },
        },
        IpFilterStrings = new[]
        {
            "string",
        },
        Migration = new Aiven.Inputs.MySqlMysqlUserConfigMigrationArgs
        {
            Host = "string",
            Port = 0,
            Dbname = "string",
            IgnoreDbs = "string",
            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",
            LongQueryTime = 0,
            MaxAllowedPacket = 0,
            MaxHeapTableSize = 0,
            NetBufferLength = 0,
            NetReadTimeout = 0,
            NetWriteTimeout = 0,
            SlowQueryLog = false,
            SortBufferSize = 0,
            SqlMode = "string",
            SqlRequirePrimaryKey = false,
            TmpTableSize = 0,
            WaitTimeout = 0,
        },
        MysqlVersion = "string",
        PrivateAccess = new Aiven.Inputs.MySqlMysqlUserConfigPrivateAccessArgs
        {
            Mysql = false,
            Mysqlx = false,
            Prometheus = false,
        },
        PrivatelinkAccess = new Aiven.Inputs.MySqlMysqlUserConfigPrivatelinkAccessArgs
        {
            Mysql = false,
            Mysqlx = false,
            Prometheus = false,
        },
        ProjectToForkFrom = "string",
        PublicAccess = new Aiven.Inputs.MySqlMysqlUserConfigPublicAccessArgs
        {
            Mysql = false,
            Mysqlx = false,
            Prometheus = false,
        },
        RecoveryTargetTime = "string",
        ServiceLog = false,
        ServiceToForkFrom = "string",
        StaticIps = false,
    },
    MaintenanceWindowDow = "string",
    ProjectVpcId = "string",
    ServiceIntegrations = new[]
    {
        new Aiven.Inputs.MySqlServiceIntegrationArgs
        {
            IntegrationType = "string",
            SourceServiceName = "string",
        },
    },
    CloudName = "string",
    StaticIps = new[]
    {
        "string",
    },
    Tags = new[]
    {
        new Aiven.Inputs.MySqlTagArgs
        {
            Key = "string",
            Value = "string",
        },
    },
    TechEmails = new[]
    {
        new Aiven.Inputs.MySqlTechEmailArgs
        {
            Email = "string",
        },
    },
    TerminationProtection = false,
});

    example, err := aiven.NewMySql(ctx, "mySqlResource", &aiven.MySqlArgs{
	Plan:                  pulumi.String("string"),
	ServiceName:           pulumi.String("string"),
	Project:               pulumi.String("string"),
	MaintenanceWindowTime: pulumi.String("string"),
	AdditionalDiskSpace:   pulumi.String("string"),
	Mysql: &aiven.MySqlMysqlArgs{
		Params: aiven.MySqlMysqlParamArray{
			&aiven.MySqlMysqlParamArgs{
				DatabaseName: pulumi.String("string"),
				Host:         pulumi.String("string"),
				Password:     pulumi.String("string"),
				Port:         pulumi.Int(0),
				Sslmode:      pulumi.String("string"),
				User:         pulumi.String("string"),
			},
		},
		ReplicaUri: pulumi.String("string"),
		StandbyUris: pulumi.StringArray{
			pulumi.String("string"),
		},
		SyncingUris: pulumi.StringArray{
			pulumi.String("string"),
		},
		Uris: pulumi.StringArray{
			pulumi.String("string"),
		},
	},
	MysqlUserConfig: &aiven.MySqlMysqlUserConfigArgs{
		AdditionalBackupRegions: pulumi.String("string"),
		AdminPassword:           pulumi.String("string"),
		AdminUsername:           pulumi.String("string"),
		BackupHour:              pulumi.Int(0),
		BackupMinute:            pulumi.Int(0),
		BinlogRetentionPeriod:   pulumi.Int(0),
		IpFilterObjects: aiven.MySqlMysqlUserConfigIpFilterObjectArray{
			&aiven.MySqlMysqlUserConfigIpFilterObjectArgs{
				Network:     pulumi.String("string"),
				Description: pulumi.String("string"),
			},
		},
		IpFilterStrings: pulumi.StringArray{
			pulumi.String("string"),
		},
		Migration: &aiven.MySqlMysqlUserConfigMigrationArgs{
			Host:      pulumi.String("string"),
			Port:      pulumi.Int(0),
			Dbname:    pulumi.String("string"),
			IgnoreDbs: pulumi.String("string"),
			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"),
			LongQueryTime:                pulumi.Float64(0),
			MaxAllowedPacket:             pulumi.Int(0),
			MaxHeapTableSize:             pulumi.Int(0),
			NetBufferLength:              pulumi.Int(0),
			NetReadTimeout:               pulumi.Int(0),
			NetWriteTimeout:              pulumi.Int(0),
			SlowQueryLog:                 pulumi.Bool(false),
			SortBufferSize:               pulumi.Int(0),
			SqlMode:                      pulumi.String("string"),
			SqlRequirePrimaryKey:         pulumi.Bool(false),
			TmpTableSize:                 pulumi.Int(0),
			WaitTimeout:                  pulumi.Int(0),
		},
		MysqlVersion: pulumi.String("string"),
		PrivateAccess: &aiven.MySqlMysqlUserConfigPrivateAccessArgs{
			Mysql:      pulumi.Bool(false),
			Mysqlx:     pulumi.Bool(false),
			Prometheus: pulumi.Bool(false),
		},
		PrivatelinkAccess: &aiven.MySqlMysqlUserConfigPrivatelinkAccessArgs{
			Mysql:      pulumi.Bool(false),
			Mysqlx:     pulumi.Bool(false),
			Prometheus: pulumi.Bool(false),
		},
		ProjectToForkFrom: pulumi.String("string"),
		PublicAccess: &aiven.MySqlMysqlUserConfigPublicAccessArgs{
			Mysql:      pulumi.Bool(false),
			Mysqlx:     pulumi.Bool(false),
			Prometheus: pulumi.Bool(false),
		},
		RecoveryTargetTime: pulumi.String("string"),
		ServiceLog:         pulumi.Bool(false),
		ServiceToForkFrom:  pulumi.String("string"),
		StaticIps:          pulumi.Bool(false),
	},
	MaintenanceWindowDow: pulumi.String("string"),
	ProjectVpcId:         pulumi.String("string"),
	ServiceIntegrations: aiven.MySqlServiceIntegrationArray{
		&aiven.MySqlServiceIntegrationArgs{
			IntegrationType:   pulumi.String("string"),
			SourceServiceName: pulumi.String("string"),
		},
	},
	CloudName: pulumi.String("string"),
	StaticIps: pulumi.StringArray{
		pulumi.String("string"),
	},
	Tags: aiven.MySqlTagArray{
		&aiven.MySqlTagArgs{
			Key:   pulumi.String("string"),
			Value: pulumi.String("string"),
		},
	},
	TechEmails: aiven.MySqlTechEmailArray{
		&aiven.MySqlTechEmailArgs{
			Email: pulumi.String("string"),
		},
	},
	TerminationProtection: pulumi.Bool(false),
})

    var mySqlResource = new MySql("mySqlResource", MySqlArgs.builder()
    .plan("string")
    .serviceName("string")
    .project("string")
    .maintenanceWindowTime("string")
    .additionalDiskSpace("string")
    .mysql(MySqlMysqlArgs.builder()
        .params(MySqlMysqlParamArgs.builder()
            .databaseName("string")
            .host("string")
            .password("string")
            .port(0)
            .sslmode("string")
            .user("string")
            .build())
        .replicaUri("string")
        .standbyUris("string")
        .syncingUris("string")
        .uris("string")
        .build())
    .mysqlUserConfig(MySqlMysqlUserConfigArgs.builder()
        .additionalBackupRegions("string")
        .adminPassword("string")
        .adminUsername("string")
        .backupHour(0)
        .backupMinute(0)
        .binlogRetentionPeriod(0)
        .ipFilterObjects(MySqlMysqlUserConfigIpFilterObjectArgs.builder()
            .network("string")
            .description("string")
            .build())
        .ipFilterStrings("string")
        .migration(MySqlMysqlUserConfigMigrationArgs.builder()
            .host("string")
            .port(0)
            .dbname("string")
            .ignoreDbs("string")
            .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")
            .longQueryTime(0)
            .maxAllowedPacket(0)
            .maxHeapTableSize(0)
            .netBufferLength(0)
            .netReadTimeout(0)
            .netWriteTimeout(0)
            .slowQueryLog(false)
            .sortBufferSize(0)
            .sqlMode("string")
            .sqlRequirePrimaryKey(false)
            .tmpTableSize(0)
            .waitTimeout(0)
            .build())
        .mysqlVersion("string")
        .privateAccess(MySqlMysqlUserConfigPrivateAccessArgs.builder()
            .mysql(false)
            .mysqlx(false)
            .prometheus(false)
            .build())
        .privatelinkAccess(MySqlMysqlUserConfigPrivatelinkAccessArgs.builder()
            .mysql(false)
            .mysqlx(false)
            .prometheus(false)
            .build())
        .projectToForkFrom("string")
        .publicAccess(MySqlMysqlUserConfigPublicAccessArgs.builder()
            .mysql(false)
            .mysqlx(false)
            .prometheus(false)
            .build())
        .recoveryTargetTime("string")
        .serviceLog(false)
        .serviceToForkFrom("string")
        .staticIps(false)
        .build())
    .maintenanceWindowDow("string")
    .projectVpcId("string")
    .serviceIntegrations(MySqlServiceIntegrationArgs.builder()
        .integrationType("string")
        .sourceServiceName("string")
        .build())
    .cloudName("string")
    .staticIps("string")
    .tags(MySqlTagArgs.builder()
        .key("string")
        .value("string")
        .build())
    .techEmails(MySqlTechEmailArgs.builder()
        .email("string")
        .build())
    .terminationProtection(false)
    .build());

    my_sql_resource = aiven.MySql("mySqlResource",
    plan="string",
    service_name="string",
    project="string",
    maintenance_window_time="string",
    additional_disk_space="string",
    mysql=aiven.MySqlMysqlArgs(
        params=[aiven.MySqlMysqlParamArgs(
            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=aiven.MySqlMysqlUserConfigArgs(
        additional_backup_regions="string",
        admin_password="string",
        admin_username="string",
        backup_hour=0,
        backup_minute=0,
        binlog_retention_period=0,
        ip_filter_objects=[aiven.MySqlMysqlUserConfigIpFilterObjectArgs(
            network="string",
            description="string",
        )],
        ip_filter_strings=["string"],
        migration=aiven.MySqlMysqlUserConfigMigrationArgs(
            host="string",
            port=0,
            dbname="string",
            ignore_dbs="string",
            method="string",
            password="string",
            ssl=False,
            username="string",
        ),
        mysql=aiven.MySqlMysqlUserConfigMysqlArgs(
            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",
            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=aiven.MySqlMysqlUserConfigPrivateAccessArgs(
            mysql=False,
            mysqlx=False,
            prometheus=False,
        ),
        privatelink_access=aiven.MySqlMysqlUserConfigPrivatelinkAccessArgs(
            mysql=False,
            mysqlx=False,
            prometheus=False,
        ),
        project_to_fork_from="string",
        public_access=aiven.MySqlMysqlUserConfigPublicAccessArgs(
            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=[aiven.MySqlServiceIntegrationArgs(
        integration_type="string",
        source_service_name="string",
    )],
    cloud_name="string",
    static_ips=["string"],
    tags=[aiven.MySqlTagArgs(
        key="string",
        value="string",
    )],
    tech_emails=[aiven.MySqlTechEmailArgs(
        email="string",
    )],
    termination_protection=False)

    const mySqlResource = new aiven.MySql("mySqlResource", {
    plan: "string",
    serviceName: "string",
    project: "string",
    maintenanceWindowTime: "string",
    additionalDiskSpace: "string",
    mysql: {
        params: [{
            databaseName: "string",
            host: "string",
            password: "string",
            port: 0,
            sslmode: "string",
            user: "string",
        }],
        replicaUri: "string",
        standbyUris: ["string"],
        syncingUris: ["string"],
        uris: ["string"],
    },
    mysqlUserConfig: {
        additionalBackupRegions: "string",
        adminPassword: "string",
        adminUsername: "string",
        backupHour: 0,
        backupMinute: 0,
        binlogRetentionPeriod: 0,
        ipFilterObjects: [{
            network: "string",
            description: "string",
        }],
        ipFilterStrings: ["string"],
        migration: {
            host: "string",
            port: 0,
            dbname: "string",
            ignoreDbs: "string",
            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",
            longQueryTime: 0,
            maxAllowedPacket: 0,
            maxHeapTableSize: 0,
            netBufferLength: 0,
            netReadTimeout: 0,
            netWriteTimeout: 0,
            slowQueryLog: false,
            sortBufferSize: 0,
            sqlMode: "string",
            sqlRequirePrimaryKey: false,
            tmpTableSize: 0,
            waitTimeout: 0,
        },
        mysqlVersion: "string",
        privateAccess: {
            mysql: false,
            mysqlx: false,
            prometheus: false,
        },
        privatelinkAccess: {
            mysql: false,
            mysqlx: false,
            prometheus: false,
        },
        projectToForkFrom: "string",
        publicAccess: {
            mysql: false,
            mysqlx: false,
            prometheus: false,
        },
        recoveryTargetTime: "string",
        serviceLog: false,
        serviceToForkFrom: "string",
        staticIps: false,
    },
    maintenanceWindowDow: "string",
    projectVpcId: "string",
    serviceIntegrations: [{
        integrationType: "string",
        sourceServiceName: "string",
    }],
    cloudName: "string",
    staticIps: ["string"],
    tags: [{
        key: "string",
        value: "string",
    }],
    techEmails: [{
        email: "string",
    }],
    terminationProtection: false,
});

    type: aiven:MySql
properties:
    additionalDiskSpace: string
    cloudName: string
    maintenanceWindowDow: string
    maintenanceWindowTime: string
    mysql:
        params:
            - databaseName: string
              host: string
              password: string
              port: 0
              sslmode: string
              user: string
        replicaUri: string
        standbyUris:
            - string
        syncingUris:
            - string
        uris:
            - string
    mysqlUserConfig:
        additionalBackupRegions: string
        adminPassword: string
        adminUsername: string
        backupHour: 0
        backupMinute: 0
        binlogRetentionPeriod: 0
        ipFilterObjects:
            - description: string
              network: string
        ipFilterStrings:
            - string
        migration:
            dbname: string
            host: string
            ignoreDbs: string
            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
            longQueryTime: 0
            maxAllowedPacket: 0
            maxHeapTableSize: 0
            netBufferLength: 0
            netReadTimeout: 0
            netWriteTimeout: 0
            slowQueryLog: false
            sortBufferSize: 0
            sqlMode: string
            sqlRequirePrimaryKey: false
            tmpTableSize: 0
            waitTimeout: 0
        mysqlVersion: string
        privateAccess:
            mysql: false
            mysqlx: false
            prometheus: false
        privatelinkAccess:
            mysql: false
            mysqlx: false
            prometheus: false
        projectToForkFrom: string
        publicAccess:
            mysql: false
            mysqlx: false
            prometheus: false
        recoveryTargetTime: string
        serviceLog: false
        serviceToForkFrom: string
        staticIps: false
    plan: string
    project: string
    projectVpcId: string
    serviceIntegrations:
        - integrationType: string
          sourceServiceName: string
    serviceName: string
    staticIps:
        - string
    tags:
        - key: string
          value: string
    techEmails:
        - email: string
    terminationProtection: false

    MySql Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    The MySql resource accepts the following input properties:

    Plan string
    Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are hobbyist, startup-x, business-x 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 seem from the Aiven pricing page.
    Project string
    The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    ServiceName 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
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    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 specific server provided values
    MysqlUserConfig MySqlMysqlUserConfig
    Mysql user configurable settings
    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 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 seem from the Aiven pricing page.
    Project string
    The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    ServiceName 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
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    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 specific server provided values
    MysqlUserConfig MySqlMysqlUserConfigArgs
    Mysql user configurable settings
    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 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 seem from the Aiven pricing page.
    project String
    The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    serviceName 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
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    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 specific server provided values
    mysqlUserConfig MySqlMysqlUserConfig
    Mysql user configurable settings
    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 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 seem from the Aiven pricing page.
    project string
    The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    serviceName 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
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    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 specific server provided values
    mysqlUserConfig MySqlMysqlUserConfig
    Mysql user configurable settings
    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 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 seem from the Aiven pricing page.
    project str
    The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    service_name str
    Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
    additional_disk_space str
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    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 specific server provided values
    mysql_user_config MySqlMysqlUserConfigArgs
    Mysql user configurable settings
    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 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 seem from the Aiven pricing page.
    project String
    The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    serviceName 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
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    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 specific server provided values
    mysqlUserConfig Property Map
    Mysql user configurable settings
    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
    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
    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
    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
    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
    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
    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)
    Resource lookup is not supported in YAML
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    AdditionalDiskSpace string
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    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
    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 specific server provided values
    MysqlUserConfig MySqlMysqlUserConfig
    Mysql user configurable settings
    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 seem from the Aiven pricing page.
    Project string
    The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    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 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
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    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
    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 specific server provided values
    MysqlUserConfig MySqlMysqlUserConfigArgs
    Mysql user configurable settings
    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 seem from the Aiven pricing page.
    Project string
    The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    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 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
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    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
    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 specific server provided values
    mysqlUserConfig MySqlMysqlUserConfig
    Mysql user configurable settings
    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 seem from the Aiven pricing page.
    project String
    The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    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 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
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    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
    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 specific server provided values
    mysqlUserConfig MySqlMysqlUserConfig
    Mysql user configurable settings
    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 seem from the Aiven pricing page.
    project string
    The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    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 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
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    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
    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 specific server provided values
    mysql_user_config MySqlMysqlUserConfigArgs
    Mysql user configurable settings
    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 seem from the Aiven pricing page.
    project str
    The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    project_vpc_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 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
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    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
    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 specific server provided values
    mysqlUserConfig Property Map
    Mysql user configurable settings
    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 seem from the Aiven pricing page.
    project String
    The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    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 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 master 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 master 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 master 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 master 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 master 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 master connection URIs

    MySqlMysqlParam, MySqlMysqlParamArgs

    DatabaseName string
    Primary MySQL database name
    Host string
    MySQL host IP or name
    Password string
    MySQL admin user password
    Port int
    MySQL port
    Sslmode string
    MySQL sslmode setting (currently always "require")
    User string
    MySQL admin user name
    DatabaseName string
    Primary MySQL database name
    Host string
    MySQL host IP or name
    Password string
    MySQL admin user password
    Port int
    MySQL port
    Sslmode string
    MySQL sslmode setting (currently always "require")
    User string
    MySQL admin user name
    databaseName String
    Primary MySQL database name
    host String
    MySQL host IP or name
    password String
    MySQL admin user password
    port Integer
    MySQL port
    sslmode String
    MySQL sslmode setting (currently always "require")
    user String
    MySQL admin user name
    databaseName string
    Primary MySQL database name
    host string
    MySQL host IP or name
    password string
    MySQL admin user password
    port number
    MySQL port
    sslmode string
    MySQL sslmode setting (currently always "require")
    user string
    MySQL admin user name
    database_name str
    Primary MySQL database name
    host str
    MySQL host IP or name
    password str
    MySQL admin user password
    port int
    MySQL port
    sslmode str
    MySQL sslmode setting (currently always "require")
    user str
    MySQL admin user name
    databaseName String
    Primary MySQL database name
    host String
    MySQL host IP or name
    password String
    MySQL admin user password
    port Number
    MySQL port
    sslmode String
    MySQL sslmode setting (currently always "require")
    user String
    MySQL admin user name

    MySqlMysqlUserConfig, MySqlMysqlUserConfigArgs

    AdditionalBackupRegions string
    Additional Cloud Regions for Backup Replication.
    AdminPassword string
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    AdminUsername 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 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 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 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 string
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    AdminUsername 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 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 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 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 String
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    adminUsername 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 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 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 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 string
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    adminUsername 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 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 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 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 str
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    admin_username str
    Custom username for admin user. This must be set only when a new service is being created. Example: avnadmin.
    backup_hour int
    The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed. Example: 3.
    backup_minute int
    The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed. Example: 30.
    binlog_retention_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 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 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 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 String
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    adminUsername 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 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 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 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 string
    CIDR address block. Example: 10.20.0.0/16.
    Description string
    Description for IP filter list entry. Example: Production service IP range.
    Network string
    CIDR address block. Example: 10.20.0.0/16.
    Description string
    Description for IP filter list entry. Example: Production service IP range.
    network String
    CIDR address block. Example: 10.20.0.0/16.
    description String
    Description for IP filter list entry. Example: Production service IP range.
    network string
    CIDR address block. Example: 10.20.0.0/16.
    description string
    Description for IP filter list entry. Example: Production service IP range.
    network str
    CIDR address block. Example: 10.20.0.0/16.
    description str
    Description for IP filter list entry. Example: Production service IP range.
    network String
    CIDR address block. Example: 10.20.0.0/16.
    description String
    Description for IP filter list entry. Example: Production service IP range.

    MySqlMysqlUserConfigMigration, MySqlMysqlUserConfigMigrationArgs

    Host string
    Hostname or IP address of the server where to migrate data from. Example: my.server.com.
    Port int
    Port number of the server where to migrate data from. Example: 1234.
    Dbname string
    Database name for bootstrapping the initial connection. Example: defaultdb.
    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.
    Method string
    Enum: dump, replication. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    Password string
    Password for authentication with the server where to migrate data from. Example: jjKk45Nnd.
    Ssl bool
    The server where to migrate data from is secured with SSL. Default: true.
    Username string
    User name for authentication with the server where to migrate data from. Example: myname.
    Host string
    Hostname or IP address of the server where to migrate data from. Example: my.server.com.
    Port int
    Port number of the server where to migrate data from. Example: 1234.
    Dbname string
    Database name for bootstrapping the initial connection. Example: defaultdb.
    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.
    Method string
    Enum: dump, replication. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    Password string
    Password for authentication with the server where to migrate data from. Example: jjKk45Nnd.
    Ssl bool
    The server where to migrate data from is secured with SSL. Default: true.
    Username string
    User name for authentication with the server where to migrate data from. Example: myname.
    host String
    Hostname or IP address of the server where to migrate data from. Example: my.server.com.
    port Integer
    Port number of the server where to migrate data from. Example: 1234.
    dbname String
    Database name for bootstrapping the initial connection. Example: defaultdb.
    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.
    method String
    Enum: dump, replication. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    password String
    Password for authentication with the server where to migrate data from. Example: jjKk45Nnd.
    ssl Boolean
    The server where to migrate data from is secured with SSL. Default: true.
    username String
    User name for authentication with the server where to migrate data from. Example: myname.
    host string
    Hostname or IP address of the server where to migrate data from. Example: my.server.com.
    port number
    Port number of the server where to migrate data from. Example: 1234.
    dbname string
    Database name for bootstrapping the initial connection. Example: defaultdb.
    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.
    method string
    Enum: dump, replication. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    password string
    Password for authentication with the server where to migrate data from. Example: jjKk45Nnd.
    ssl boolean
    The server where to migrate data from is secured with SSL. Default: true.
    username string
    User name for authentication with the server where to migrate data from. Example: myname.
    host str
    Hostname or IP address of the server where to migrate data from. Example: my.server.com.
    port int
    Port number of the server where to migrate data from. Example: 1234.
    dbname str
    Database name for bootstrapping the initial connection. Example: defaultdb.
    ignore_dbs str
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment). Example: db1,db2.
    method str
    Enum: dump, replication. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
    password str
    Password for authentication with the server where to migrate data from. Example: jjKk45Nnd.
    ssl bool
    The server where to migrate data from is secured with SSL. Default: true.
    username str
    User name for authentication with the server where to migrate data from. Example: myname.
    host String
    Hostname or IP address of the server where to migrate data from. Example: my.server.com.
    port Number
    Port number of the server where to migrate data from. Example: 1234.
    dbname String
    Database name for bootstrapping the initial connection. Example: defaultdb.
    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.
    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: TempTable, MEMORY. The storage engine for in-memory internal temporary tables.
    LongQueryTime double
    The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Default is 10s. Example: 10.
    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. Default is off.
    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: TempTable, MEMORY. The storage engine for in-memory internal temporary tables.
    LongQueryTime float64
    The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Default is 10s. Example: 10.
    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. Default is off.
    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: TempTable, MEMORY. The storage engine for in-memory internal temporary tables.
    longQueryTime Double
    The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Default is 10s. Example: 10.
    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. Default is off.
    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: TempTable, MEMORY. The storage engine for in-memory internal temporary tables.
    longQueryTime number
    The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Default is 10s. Example: 10.
    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. Default is off.
    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: TempTable, MEMORY. The storage engine for in-memory internal temporary tables.
    long_query_time float
    The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Default is 10s. Example: 10.
    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. Default is off.
    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: TempTable, MEMORY. The storage engine for in-memory internal temporary tables.
    longQueryTime Number
    The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Default is 10s. Example: 10.
    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. Default is off.
    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 string
    Type of the service integration. The only supported value at the moment is read_replica
    SourceServiceName string
    Name of the source service
    IntegrationType string
    Type of the service integration. The only supported value at the moment is read_replica
    SourceServiceName string
    Name of the source service
    integrationType String
    Type of the service integration. The only supported value at the moment is read_replica
    sourceServiceName String
    Name of the source service
    integrationType string
    Type of the service integration. The only supported value at the moment is read_replica
    sourceServiceName string
    Name of the source service
    integration_type str
    Type of the service integration. The only supported value at the moment is read_replica
    source_service_name str
    Name of the source service
    integrationType String
    Type of the service integration. The only supported value at the moment is read_replica
    sourceServiceName String
    Name of the source service

    MySqlTag, MySqlTagArgs

    Key string
    Service tag key
    Value string
    Service tag value
    Key string
    Service tag key
    Value string
    Service tag value
    key String
    Service tag key
    value String
    Service tag value
    key string
    Service tag key
    value string
    Service tag value
    key str
    Service tag key
    value str
    Service tag value
    key String
    Service tag key
    value String
    Service tag value

    MySqlTechEmail, MySqlTechEmailArgs

    Email string
    An email address to contact for technical issues
    Email string
    An email address to contact for technical issues
    email String
    An email address to contact for technical issues
    email string
    An email address to contact for technical issues
    email str
    An email address to contact for technical issues
    email String
    An email address to contact for technical issues

    Import

    $ pulumi import aiven:index/mySql:MySql mysql1 project/service_name

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    Aiven pulumi/pulumi-aiven
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the aiven Terraform Provider.
    aiven logo
    Aiven v6.18.0 published on Thursday, Jun 27, 2024 by Pulumi
    pulumi/pulumi-aiven