aiven.MySql
Explore with Pulumi AI
Creates and manages an Aiven for MySQL® service.
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as aiven from "@pulumi/aiven";
const exampleMysql = new aiven.MySql("example_mysql", {
    project: exampleProject.project,
    cloudName: "google-europe-west1",
    plan: "business-4",
    serviceName: "example-mysql",
    maintenanceWindowDow: "monday",
    maintenanceWindowTime: "10:00:00",
    mysqlUserConfig: {
        mysqlVersion: "8",
        mysql: {
            sqlMode: "ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE",
            sqlRequirePrimaryKey: true,
        },
        publicAccess: {
            mysql: true,
        },
    },
});
import pulumi
import pulumi_aiven as aiven
example_mysql = aiven.MySql("example_mysql",
    project=example_project["project"],
    cloud_name="google-europe-west1",
    plan="business-4",
    service_name="example-mysql",
    maintenance_window_dow="monday",
    maintenance_window_time="10:00:00",
    mysql_user_config={
        "mysql_version": "8",
        "mysql": {
            "sql_mode": "ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE",
            "sql_require_primary_key": True,
        },
        "public_access": {
            "mysql": True,
        },
    })
package main
import (
	"github.com/pulumi/pulumi-aiven/sdk/v6/go/aiven"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := aiven.NewMySql(ctx, "example_mysql", &aiven.MySqlArgs{
			Project:               pulumi.Any(exampleProject.Project),
			CloudName:             pulumi.String("google-europe-west1"),
			Plan:                  pulumi.String("business-4"),
			ServiceName:           pulumi.String("example-mysql"),
			MaintenanceWindowDow:  pulumi.String("monday"),
			MaintenanceWindowTime: pulumi.String("10:00:00"),
			MysqlUserConfig: &aiven.MySqlMysqlUserConfigArgs{
				MysqlVersion: pulumi.String("8"),
				Mysql: &aiven.MySqlMysqlUserConfigMysqlArgs{
					SqlMode:              pulumi.String("ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE"),
					SqlRequirePrimaryKey: pulumi.Bool(true),
				},
				PublicAccess: &aiven.MySqlMysqlUserConfigPublicAccessArgs{
					Mysql: pulumi.Bool(true),
				},
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Aiven = Pulumi.Aiven;
return await Deployment.RunAsync(() => 
{
    var exampleMysql = new Aiven.MySql("example_mysql", new()
    {
        Project = exampleProject.Project,
        CloudName = "google-europe-west1",
        Plan = "business-4",
        ServiceName = "example-mysql",
        MaintenanceWindowDow = "monday",
        MaintenanceWindowTime = "10:00:00",
        MysqlUserConfig = new Aiven.Inputs.MySqlMysqlUserConfigArgs
        {
            MysqlVersion = "8",
            Mysql = new Aiven.Inputs.MySqlMysqlUserConfigMysqlArgs
            {
                SqlMode = "ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE",
                SqlRequirePrimaryKey = true,
            },
            PublicAccess = new Aiven.Inputs.MySqlMysqlUserConfigPublicAccessArgs
            {
                Mysql = true,
            },
        },
    });
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.aiven.MySql;
import com.pulumi.aiven.MySqlArgs;
import com.pulumi.aiven.inputs.MySqlMysqlUserConfigArgs;
import com.pulumi.aiven.inputs.MySqlMysqlUserConfigMysqlArgs;
import com.pulumi.aiven.inputs.MySqlMysqlUserConfigPublicAccessArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }
    public static void stack(Context ctx) {
        var exampleMysql = new MySql("exampleMysql", MySqlArgs.builder()
            .project(exampleProject.project())
            .cloudName("google-europe-west1")
            .plan("business-4")
            .serviceName("example-mysql")
            .maintenanceWindowDow("monday")
            .maintenanceWindowTime("10:00:00")
            .mysqlUserConfig(MySqlMysqlUserConfigArgs.builder()
                .mysqlVersion("8")
                .mysql(MySqlMysqlUserConfigMysqlArgs.builder()
                    .sqlMode("ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE")
                    .sqlRequirePrimaryKey(true)
                    .build())
                .publicAccess(MySqlMysqlUserConfigPublicAccessArgs.builder()
                    .mysql(true)
                    .build())
                .build())
            .build());
    }
}
resources:
  exampleMysql:
    type: aiven:MySql
    name: example_mysql
    properties:
      project: ${exampleProject.project}
      cloudName: google-europe-west1
      plan: business-4
      serviceName: example-mysql
      maintenanceWindowDow: monday
      maintenanceWindowTime: 10:00:00
      mysqlUserConfig:
        mysqlVersion: 8
        mysql:
          sqlMode: ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE
          sqlRequirePrimaryKey: true
        publicAccess:
          mysql: true
Create MySql Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new MySql(name: string, args: MySqlArgs, opts?: CustomResourceOptions);@overload
def MySql(resource_name: str,
          args: MySqlArgs,
          opts: Optional[ResourceOptions] = None)
@overload
def MySql(resource_name: str,
          opts: Optional[ResourceOptions] = None,
          plan: Optional[str] = None,
          service_name: Optional[str] = None,
          project: Optional[str] = None,
          maintenance_window_time: Optional[str] = None,
          additional_disk_space: Optional[str] = None,
          mysql: Optional[MySqlMysqlArgs] = None,
          mysql_user_config: Optional[MySqlMysqlUserConfigArgs] = None,
          maintenance_window_dow: Optional[str] = None,
          disk_space: Optional[str] = None,
          project_vpc_id: Optional[str] = None,
          service_integrations: Optional[Sequence[MySqlServiceIntegrationArgs]] = None,
          cloud_name: Optional[str] = None,
          static_ips: Optional[Sequence[str]] = None,
          tags: Optional[Sequence[MySqlTagArgs]] = None,
          tech_emails: Optional[Sequence[MySqlTechEmailArgs]] = None,
          termination_protection: Optional[bool] = None)func NewMySql(ctx *Context, name string, args MySqlArgs, opts ...ResourceOption) (*MySql, error)public MySql(string name, MySqlArgs args, CustomResourceOptions? opts = null)type: aiven:MySql
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
Parameters
- name string
- The unique name of the resource.
- args MySqlArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- resource_name str
- The unique name of the resource.
- args MySqlArgs
- The arguments to resource properties.
- opts ResourceOptions
- Bag of options to control resource's behavior.
- ctx Context
- Context object for the current deployment.
- name string
- The unique name of the resource.
- args MySqlArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args MySqlArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args MySqlArgs
- The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
Constructor example
The following reference example uses placeholder values for all input properties.
var mySqlResource = new Aiven.MySql("mySqlResource", new()
{
    Plan = "string",
    ServiceName = "string",
    Project = "string",
    MaintenanceWindowTime = "string",
    AdditionalDiskSpace = "string",
    Mysql = new Aiven.Inputs.MySqlMysqlArgs
    {
        Params = new[]
        {
            new Aiven.Inputs.MySqlMysqlParamArgs
            {
                DatabaseName = "string",
                Host = "string",
                Password = "string",
                Port = 0,
                Sslmode = "string",
                User = "string",
            },
        },
        ReplicaUri = "string",
        StandbyUris = new[]
        {
            "string",
        },
        SyncingUris = new[]
        {
            "string",
        },
        Uris = new[]
        {
            "string",
        },
    },
    MysqlUserConfig = new Aiven.Inputs.MySqlMysqlUserConfigArgs
    {
        AdditionalBackupRegions = "string",
        AdminPassword = "string",
        AdminUsername = "string",
        BackupHour = 0,
        BackupMinute = 0,
        BinlogRetentionPeriod = 0,
        IpFilterObjects = new[]
        {
            new Aiven.Inputs.MySqlMysqlUserConfigIpFilterObjectArgs
            {
                Network = "string",
                Description = "string",
            },
        },
        IpFilterStrings = new[]
        {
            "string",
        },
        Migration = new Aiven.Inputs.MySqlMysqlUserConfigMigrationArgs
        {
            Host = "string",
            Port = 0,
            Dbname = "string",
            IgnoreDbs = "string",
            IgnoreRoles = "string",
            Method = "string",
            Password = "string",
            Ssl = false,
            Username = "string",
        },
        Mysql = new Aiven.Inputs.MySqlMysqlUserConfigMysqlArgs
        {
            ConnectTimeout = 0,
            DefaultTimeZone = "string",
            GroupConcatMaxLen = 0,
            InformationSchemaStatsExpiry = 0,
            InnodbChangeBufferMaxSize = 0,
            InnodbFlushNeighbors = 0,
            InnodbFtMinTokenSize = 0,
            InnodbFtServerStopwordTable = "string",
            InnodbLockWaitTimeout = 0,
            InnodbLogBufferSize = 0,
            InnodbOnlineAlterLogMaxSize = 0,
            InnodbPrintAllDeadlocks = false,
            InnodbReadIoThreads = 0,
            InnodbRollbackOnTimeout = false,
            InnodbThreadConcurrency = 0,
            InnodbWriteIoThreads = 0,
            InteractiveTimeout = 0,
            InternalTmpMemStorageEngine = "string",
            LogOutput = "string",
            LongQueryTime = 0,
            MaxAllowedPacket = 0,
            MaxHeapTableSize = 0,
            NetBufferLength = 0,
            NetReadTimeout = 0,
            NetWriteTimeout = 0,
            SlowQueryLog = false,
            SortBufferSize = 0,
            SqlMode = "string",
            SqlRequirePrimaryKey = false,
            TmpTableSize = 0,
            WaitTimeout = 0,
        },
        MysqlVersion = "string",
        PrivateAccess = new Aiven.Inputs.MySqlMysqlUserConfigPrivateAccessArgs
        {
            Mysql = false,
            Mysqlx = false,
            Prometheus = false,
        },
        PrivatelinkAccess = new Aiven.Inputs.MySqlMysqlUserConfigPrivatelinkAccessArgs
        {
            Mysql = false,
            Mysqlx = false,
            Prometheus = false,
        },
        ProjectToForkFrom = "string",
        PublicAccess = new Aiven.Inputs.MySqlMysqlUserConfigPublicAccessArgs
        {
            Mysql = false,
            Mysqlx = false,
            Prometheus = false,
        },
        RecoveryTargetTime = "string",
        ServiceLog = false,
        ServiceToForkFrom = "string",
        StaticIps = false,
    },
    MaintenanceWindowDow = "string",
    ProjectVpcId = "string",
    ServiceIntegrations = new[]
    {
        new Aiven.Inputs.MySqlServiceIntegrationArgs
        {
            IntegrationType = "string",
            SourceServiceName = "string",
        },
    },
    CloudName = "string",
    StaticIps = new[]
    {
        "string",
    },
    Tags = new[]
    {
        new Aiven.Inputs.MySqlTagArgs
        {
            Key = "string",
            Value = "string",
        },
    },
    TechEmails = new[]
    {
        new Aiven.Inputs.MySqlTechEmailArgs
        {
            Email = "string",
        },
    },
    TerminationProtection = false,
});
example, err := aiven.NewMySql(ctx, "mySqlResource", &aiven.MySqlArgs{
	Plan:                  pulumi.String("string"),
	ServiceName:           pulumi.String("string"),
	Project:               pulumi.String("string"),
	MaintenanceWindowTime: pulumi.String("string"),
	AdditionalDiskSpace:   pulumi.String("string"),
	Mysql: &aiven.MySqlMysqlArgs{
		Params: aiven.MySqlMysqlParamArray{
			&aiven.MySqlMysqlParamArgs{
				DatabaseName: pulumi.String("string"),
				Host:         pulumi.String("string"),
				Password:     pulumi.String("string"),
				Port:         pulumi.Int(0),
				Sslmode:      pulumi.String("string"),
				User:         pulumi.String("string"),
			},
		},
		ReplicaUri: pulumi.String("string"),
		StandbyUris: pulumi.StringArray{
			pulumi.String("string"),
		},
		SyncingUris: pulumi.StringArray{
			pulumi.String("string"),
		},
		Uris: pulumi.StringArray{
			pulumi.String("string"),
		},
	},
	MysqlUserConfig: &aiven.MySqlMysqlUserConfigArgs{
		AdditionalBackupRegions: pulumi.String("string"),
		AdminPassword:           pulumi.String("string"),
		AdminUsername:           pulumi.String("string"),
		BackupHour:              pulumi.Int(0),
		BackupMinute:            pulumi.Int(0),
		BinlogRetentionPeriod:   pulumi.Int(0),
		IpFilterObjects: aiven.MySqlMysqlUserConfigIpFilterObjectArray{
			&aiven.MySqlMysqlUserConfigIpFilterObjectArgs{
				Network:     pulumi.String("string"),
				Description: pulumi.String("string"),
			},
		},
		IpFilterStrings: pulumi.StringArray{
			pulumi.String("string"),
		},
		Migration: &aiven.MySqlMysqlUserConfigMigrationArgs{
			Host:        pulumi.String("string"),
			Port:        pulumi.Int(0),
			Dbname:      pulumi.String("string"),
			IgnoreDbs:   pulumi.String("string"),
			IgnoreRoles: pulumi.String("string"),
			Method:      pulumi.String("string"),
			Password:    pulumi.String("string"),
			Ssl:         pulumi.Bool(false),
			Username:    pulumi.String("string"),
		},
		Mysql: &aiven.MySqlMysqlUserConfigMysqlArgs{
			ConnectTimeout:               pulumi.Int(0),
			DefaultTimeZone:              pulumi.String("string"),
			GroupConcatMaxLen:            pulumi.Int(0),
			InformationSchemaStatsExpiry: pulumi.Int(0),
			InnodbChangeBufferMaxSize:    pulumi.Int(0),
			InnodbFlushNeighbors:         pulumi.Int(0),
			InnodbFtMinTokenSize:         pulumi.Int(0),
			InnodbFtServerStopwordTable:  pulumi.String("string"),
			InnodbLockWaitTimeout:        pulumi.Int(0),
			InnodbLogBufferSize:          pulumi.Int(0),
			InnodbOnlineAlterLogMaxSize:  pulumi.Int(0),
			InnodbPrintAllDeadlocks:      pulumi.Bool(false),
			InnodbReadIoThreads:          pulumi.Int(0),
			InnodbRollbackOnTimeout:      pulumi.Bool(false),
			InnodbThreadConcurrency:      pulumi.Int(0),
			InnodbWriteIoThreads:         pulumi.Int(0),
			InteractiveTimeout:           pulumi.Int(0),
			InternalTmpMemStorageEngine:  pulumi.String("string"),
			LogOutput:                    pulumi.String("string"),
			LongQueryTime:                pulumi.Float64(0),
			MaxAllowedPacket:             pulumi.Int(0),
			MaxHeapTableSize:             pulumi.Int(0),
			NetBufferLength:              pulumi.Int(0),
			NetReadTimeout:               pulumi.Int(0),
			NetWriteTimeout:              pulumi.Int(0),
			SlowQueryLog:                 pulumi.Bool(false),
			SortBufferSize:               pulumi.Int(0),
			SqlMode:                      pulumi.String("string"),
			SqlRequirePrimaryKey:         pulumi.Bool(false),
			TmpTableSize:                 pulumi.Int(0),
			WaitTimeout:                  pulumi.Int(0),
		},
		MysqlVersion: pulumi.String("string"),
		PrivateAccess: &aiven.MySqlMysqlUserConfigPrivateAccessArgs{
			Mysql:      pulumi.Bool(false),
			Mysqlx:     pulumi.Bool(false),
			Prometheus: pulumi.Bool(false),
		},
		PrivatelinkAccess: &aiven.MySqlMysqlUserConfigPrivatelinkAccessArgs{
			Mysql:      pulumi.Bool(false),
			Mysqlx:     pulumi.Bool(false),
			Prometheus: pulumi.Bool(false),
		},
		ProjectToForkFrom: pulumi.String("string"),
		PublicAccess: &aiven.MySqlMysqlUserConfigPublicAccessArgs{
			Mysql:      pulumi.Bool(false),
			Mysqlx:     pulumi.Bool(false),
			Prometheus: pulumi.Bool(false),
		},
		RecoveryTargetTime: pulumi.String("string"),
		ServiceLog:         pulumi.Bool(false),
		ServiceToForkFrom:  pulumi.String("string"),
		StaticIps:          pulumi.Bool(false),
	},
	MaintenanceWindowDow: pulumi.String("string"),
	ProjectVpcId:         pulumi.String("string"),
	ServiceIntegrations: aiven.MySqlServiceIntegrationArray{
		&aiven.MySqlServiceIntegrationArgs{
			IntegrationType:   pulumi.String("string"),
			SourceServiceName: pulumi.String("string"),
		},
	},
	CloudName: pulumi.String("string"),
	StaticIps: pulumi.StringArray{
		pulumi.String("string"),
	},
	Tags: aiven.MySqlTagArray{
		&aiven.MySqlTagArgs{
			Key:   pulumi.String("string"),
			Value: pulumi.String("string"),
		},
	},
	TechEmails: aiven.MySqlTechEmailArray{
		&aiven.MySqlTechEmailArgs{
			Email: pulumi.String("string"),
		},
	},
	TerminationProtection: pulumi.Bool(false),
})
var mySqlResource = new MySql("mySqlResource", MySqlArgs.builder()
    .plan("string")
    .serviceName("string")
    .project("string")
    .maintenanceWindowTime("string")
    .additionalDiskSpace("string")
    .mysql(MySqlMysqlArgs.builder()
        .params(MySqlMysqlParamArgs.builder()
            .databaseName("string")
            .host("string")
            .password("string")
            .port(0)
            .sslmode("string")
            .user("string")
            .build())
        .replicaUri("string")
        .standbyUris("string")
        .syncingUris("string")
        .uris("string")
        .build())
    .mysqlUserConfig(MySqlMysqlUserConfigArgs.builder()
        .additionalBackupRegions("string")
        .adminPassword("string")
        .adminUsername("string")
        .backupHour(0)
        .backupMinute(0)
        .binlogRetentionPeriod(0)
        .ipFilterObjects(MySqlMysqlUserConfigIpFilterObjectArgs.builder()
            .network("string")
            .description("string")
            .build())
        .ipFilterStrings("string")
        .migration(MySqlMysqlUserConfigMigrationArgs.builder()
            .host("string")
            .port(0)
            .dbname("string")
            .ignoreDbs("string")
            .ignoreRoles("string")
            .method("string")
            .password("string")
            .ssl(false)
            .username("string")
            .build())
        .mysql(MySqlMysqlUserConfigMysqlArgs.builder()
            .connectTimeout(0)
            .defaultTimeZone("string")
            .groupConcatMaxLen(0)
            .informationSchemaStatsExpiry(0)
            .innodbChangeBufferMaxSize(0)
            .innodbFlushNeighbors(0)
            .innodbFtMinTokenSize(0)
            .innodbFtServerStopwordTable("string")
            .innodbLockWaitTimeout(0)
            .innodbLogBufferSize(0)
            .innodbOnlineAlterLogMaxSize(0)
            .innodbPrintAllDeadlocks(false)
            .innodbReadIoThreads(0)
            .innodbRollbackOnTimeout(false)
            .innodbThreadConcurrency(0)
            .innodbWriteIoThreads(0)
            .interactiveTimeout(0)
            .internalTmpMemStorageEngine("string")
            .logOutput("string")
            .longQueryTime(0.0)
            .maxAllowedPacket(0)
            .maxHeapTableSize(0)
            .netBufferLength(0)
            .netReadTimeout(0)
            .netWriteTimeout(0)
            .slowQueryLog(false)
            .sortBufferSize(0)
            .sqlMode("string")
            .sqlRequirePrimaryKey(false)
            .tmpTableSize(0)
            .waitTimeout(0)
            .build())
        .mysqlVersion("string")
        .privateAccess(MySqlMysqlUserConfigPrivateAccessArgs.builder()
            .mysql(false)
            .mysqlx(false)
            .prometheus(false)
            .build())
        .privatelinkAccess(MySqlMysqlUserConfigPrivatelinkAccessArgs.builder()
            .mysql(false)
            .mysqlx(false)
            .prometheus(false)
            .build())
        .projectToForkFrom("string")
        .publicAccess(MySqlMysqlUserConfigPublicAccessArgs.builder()
            .mysql(false)
            .mysqlx(false)
            .prometheus(false)
            .build())
        .recoveryTargetTime("string")
        .serviceLog(false)
        .serviceToForkFrom("string")
        .staticIps(false)
        .build())
    .maintenanceWindowDow("string")
    .projectVpcId("string")
    .serviceIntegrations(MySqlServiceIntegrationArgs.builder()
        .integrationType("string")
        .sourceServiceName("string")
        .build())
    .cloudName("string")
    .staticIps("string")
    .tags(MySqlTagArgs.builder()
        .key("string")
        .value("string")
        .build())
    .techEmails(MySqlTechEmailArgs.builder()
        .email("string")
        .build())
    .terminationProtection(false)
    .build());
my_sql_resource = aiven.MySql("mySqlResource",
    plan="string",
    service_name="string",
    project="string",
    maintenance_window_time="string",
    additional_disk_space="string",
    mysql={
        "params": [{
            "database_name": "string",
            "host": "string",
            "password": "string",
            "port": 0,
            "sslmode": "string",
            "user": "string",
        }],
        "replica_uri": "string",
        "standby_uris": ["string"],
        "syncing_uris": ["string"],
        "uris": ["string"],
    },
    mysql_user_config={
        "additional_backup_regions": "string",
        "admin_password": "string",
        "admin_username": "string",
        "backup_hour": 0,
        "backup_minute": 0,
        "binlog_retention_period": 0,
        "ip_filter_objects": [{
            "network": "string",
            "description": "string",
        }],
        "ip_filter_strings": ["string"],
        "migration": {
            "host": "string",
            "port": 0,
            "dbname": "string",
            "ignore_dbs": "string",
            "ignore_roles": "string",
            "method": "string",
            "password": "string",
            "ssl": False,
            "username": "string",
        },
        "mysql": {
            "connect_timeout": 0,
            "default_time_zone": "string",
            "group_concat_max_len": 0,
            "information_schema_stats_expiry": 0,
            "innodb_change_buffer_max_size": 0,
            "innodb_flush_neighbors": 0,
            "innodb_ft_min_token_size": 0,
            "innodb_ft_server_stopword_table": "string",
            "innodb_lock_wait_timeout": 0,
            "innodb_log_buffer_size": 0,
            "innodb_online_alter_log_max_size": 0,
            "innodb_print_all_deadlocks": False,
            "innodb_read_io_threads": 0,
            "innodb_rollback_on_timeout": False,
            "innodb_thread_concurrency": 0,
            "innodb_write_io_threads": 0,
            "interactive_timeout": 0,
            "internal_tmp_mem_storage_engine": "string",
            "log_output": "string",
            "long_query_time": 0,
            "max_allowed_packet": 0,
            "max_heap_table_size": 0,
            "net_buffer_length": 0,
            "net_read_timeout": 0,
            "net_write_timeout": 0,
            "slow_query_log": False,
            "sort_buffer_size": 0,
            "sql_mode": "string",
            "sql_require_primary_key": False,
            "tmp_table_size": 0,
            "wait_timeout": 0,
        },
        "mysql_version": "string",
        "private_access": {
            "mysql": False,
            "mysqlx": False,
            "prometheus": False,
        },
        "privatelink_access": {
            "mysql": False,
            "mysqlx": False,
            "prometheus": False,
        },
        "project_to_fork_from": "string",
        "public_access": {
            "mysql": False,
            "mysqlx": False,
            "prometheus": False,
        },
        "recovery_target_time": "string",
        "service_log": False,
        "service_to_fork_from": "string",
        "static_ips": False,
    },
    maintenance_window_dow="string",
    project_vpc_id="string",
    service_integrations=[{
        "integration_type": "string",
        "source_service_name": "string",
    }],
    cloud_name="string",
    static_ips=["string"],
    tags=[{
        "key": "string",
        "value": "string",
    }],
    tech_emails=[{
        "email": "string",
    }],
    termination_protection=False)
const mySqlResource = new aiven.MySql("mySqlResource", {
    plan: "string",
    serviceName: "string",
    project: "string",
    maintenanceWindowTime: "string",
    additionalDiskSpace: "string",
    mysql: {
        params: [{
            databaseName: "string",
            host: "string",
            password: "string",
            port: 0,
            sslmode: "string",
            user: "string",
        }],
        replicaUri: "string",
        standbyUris: ["string"],
        syncingUris: ["string"],
        uris: ["string"],
    },
    mysqlUserConfig: {
        additionalBackupRegions: "string",
        adminPassword: "string",
        adminUsername: "string",
        backupHour: 0,
        backupMinute: 0,
        binlogRetentionPeriod: 0,
        ipFilterObjects: [{
            network: "string",
            description: "string",
        }],
        ipFilterStrings: ["string"],
        migration: {
            host: "string",
            port: 0,
            dbname: "string",
            ignoreDbs: "string",
            ignoreRoles: "string",
            method: "string",
            password: "string",
            ssl: false,
            username: "string",
        },
        mysql: {
            connectTimeout: 0,
            defaultTimeZone: "string",
            groupConcatMaxLen: 0,
            informationSchemaStatsExpiry: 0,
            innodbChangeBufferMaxSize: 0,
            innodbFlushNeighbors: 0,
            innodbFtMinTokenSize: 0,
            innodbFtServerStopwordTable: "string",
            innodbLockWaitTimeout: 0,
            innodbLogBufferSize: 0,
            innodbOnlineAlterLogMaxSize: 0,
            innodbPrintAllDeadlocks: false,
            innodbReadIoThreads: 0,
            innodbRollbackOnTimeout: false,
            innodbThreadConcurrency: 0,
            innodbWriteIoThreads: 0,
            interactiveTimeout: 0,
            internalTmpMemStorageEngine: "string",
            logOutput: "string",
            longQueryTime: 0,
            maxAllowedPacket: 0,
            maxHeapTableSize: 0,
            netBufferLength: 0,
            netReadTimeout: 0,
            netWriteTimeout: 0,
            slowQueryLog: false,
            sortBufferSize: 0,
            sqlMode: "string",
            sqlRequirePrimaryKey: false,
            tmpTableSize: 0,
            waitTimeout: 0,
        },
        mysqlVersion: "string",
        privateAccess: {
            mysql: false,
            mysqlx: false,
            prometheus: false,
        },
        privatelinkAccess: {
            mysql: false,
            mysqlx: false,
            prometheus: false,
        },
        projectToForkFrom: "string",
        publicAccess: {
            mysql: false,
            mysqlx: false,
            prometheus: false,
        },
        recoveryTargetTime: "string",
        serviceLog: false,
        serviceToForkFrom: "string",
        staticIps: false,
    },
    maintenanceWindowDow: "string",
    projectVpcId: "string",
    serviceIntegrations: [{
        integrationType: "string",
        sourceServiceName: "string",
    }],
    cloudName: "string",
    staticIps: ["string"],
    tags: [{
        key: "string",
        value: "string",
    }],
    techEmails: [{
        email: "string",
    }],
    terminationProtection: false,
});
type: aiven:MySql
properties:
    additionalDiskSpace: string
    cloudName: string
    maintenanceWindowDow: string
    maintenanceWindowTime: string
    mysql:
        params:
            - databaseName: string
              host: string
              password: string
              port: 0
              sslmode: string
              user: string
        replicaUri: string
        standbyUris:
            - string
        syncingUris:
            - string
        uris:
            - string
    mysqlUserConfig:
        additionalBackupRegions: string
        adminPassword: string
        adminUsername: string
        backupHour: 0
        backupMinute: 0
        binlogRetentionPeriod: 0
        ipFilterObjects:
            - description: string
              network: string
        ipFilterStrings:
            - string
        migration:
            dbname: string
            host: string
            ignoreDbs: string
            ignoreRoles: string
            method: string
            password: string
            port: 0
            ssl: false
            username: string
        mysql:
            connectTimeout: 0
            defaultTimeZone: string
            groupConcatMaxLen: 0
            informationSchemaStatsExpiry: 0
            innodbChangeBufferMaxSize: 0
            innodbFlushNeighbors: 0
            innodbFtMinTokenSize: 0
            innodbFtServerStopwordTable: string
            innodbLockWaitTimeout: 0
            innodbLogBufferSize: 0
            innodbOnlineAlterLogMaxSize: 0
            innodbPrintAllDeadlocks: false
            innodbReadIoThreads: 0
            innodbRollbackOnTimeout: false
            innodbThreadConcurrency: 0
            innodbWriteIoThreads: 0
            interactiveTimeout: 0
            internalTmpMemStorageEngine: string
            logOutput: string
            longQueryTime: 0
            maxAllowedPacket: 0
            maxHeapTableSize: 0
            netBufferLength: 0
            netReadTimeout: 0
            netWriteTimeout: 0
            slowQueryLog: false
            sortBufferSize: 0
            sqlMode: string
            sqlRequirePrimaryKey: false
            tmpTableSize: 0
            waitTimeout: 0
        mysqlVersion: string
        privateAccess:
            mysql: false
            mysqlx: false
            prometheus: false
        privatelinkAccess:
            mysql: false
            mysqlx: false
            prometheus: false
        projectToForkFrom: string
        publicAccess:
            mysql: false
            mysqlx: false
            prometheus: false
        recoveryTargetTime: string
        serviceLog: false
        serviceToForkFrom: string
        staticIps: false
    plan: string
    project: string
    projectVpcId: string
    serviceIntegrations:
        - integrationType: string
          sourceServiceName: string
    serviceName: string
    staticIps:
        - string
    tags:
        - key: string
          value: string
    techEmails:
        - email: string
    terminationProtection: false
MySql Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.
The MySql resource accepts the following input properties:
- Plan string
- Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are hobbyist,startup-x,business-xandpremium-xwherexis (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page.
- Project string
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- 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.
- AdditionalDisk stringSpace 
- Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart, and there might be a short downtime for services without an autoscaler integration or high availability capabilities. The field can be safely removed when autoscaler is enabled without causing any changes.
- CloudName string
- The cloud provider and region the service is hosted in. The format is provider-region, for example:google-europe-west1. The available cloud regions can differ per project and service. Changing this value migrates the service to another cloud provider or region. The migration runs in the background and includes a DNS update to redirect traffic to the new region. Most services experience no downtime, but some databases may have a brief interruption during DNS propagation.
- 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.
- MaintenanceWindow stringDow 
- Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- MaintenanceWindow stringTime 
- Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- Mysql
MySql Mysql 
- MySQL server-provided values.
- MysqlUser MyConfig Sql Mysql User Config 
- Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- ProjectVpc stringId 
- Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- ServiceIntegrations List<MySql Service Integration> 
- 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
- 
List<MySql Tag> 
- Tags are key-value pairs that allow you to categorize services.
- TechEmails List<MySql Tech Email> 
- The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- TerminationProtection bool
- Prevents the service from being deleted. It is recommended to set this to truefor 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-xandpremium-xwherexis (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page.
- Project string
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- 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.
- AdditionalDisk stringSpace 
- Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart, and there might be a short downtime for services without an autoscaler integration or high availability capabilities. The field can be safely removed when autoscaler is enabled without causing any changes.
- CloudName string
- The cloud provider and region the service is hosted in. The format is provider-region, for example:google-europe-west1. The available cloud regions can differ per project and service. Changing this value migrates the service to another cloud provider or region. The migration runs in the background and includes a DNS update to redirect traffic to the new region. Most services experience no downtime, but some databases may have a brief interruption during DNS propagation.
- 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.
- MaintenanceWindow stringDow 
- Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- MaintenanceWindow stringTime 
- Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- Mysql
MySql Mysql Args 
- MySQL server-provided values.
- MysqlUser MyConfig Sql Mysql User Config Args 
- Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- ProjectVpc stringId 
- Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- ServiceIntegrations []MySql Service Integration Args 
- 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
- 
[]MySql Tag Args 
- Tags are key-value pairs that allow you to categorize services.
- TechEmails []MySql Tech Email Args 
- The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- TerminationProtection bool
- Prevents the service from being deleted. It is recommended to set this to truefor 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-xandpremium-xwherexis (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page.
- project String
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- 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.
- additionalDisk StringSpace 
- Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart, and there might be a short downtime for services without an autoscaler integration or high availability capabilities. The field can be safely removed when autoscaler is enabled without causing any changes.
- cloudName String
- The cloud provider and region the service is hosted in. The format is provider-region, for example:google-europe-west1. The available cloud regions can differ per project and service. Changing this value migrates the service to another cloud provider or region. The migration runs in the background and includes a DNS update to redirect traffic to the new region. Most services experience no downtime, but some databases may have a brief interruption during DNS propagation.
- 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.
- maintenanceWindow StringDow 
- Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenanceWindow StringTime 
- Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql
MySql Mysql 
- MySQL server-provided values.
- mysqlUser MyConfig Sql Mysql User Config 
- Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- projectVpc StringId 
- Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- serviceIntegrations List<MySql Service Integration> 
- 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
- 
List<MySql Tag> 
- Tags are key-value pairs that allow you to categorize services.
- techEmails List<MySql Tech Email> 
- The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- terminationProtection Boolean
- Prevents the service from being deleted. It is recommended to set this to truefor 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-xandpremium-xwherexis (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page.
- project string
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- 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.
- additionalDisk stringSpace 
- Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart, and there might be a short downtime for services without an autoscaler integration or high availability capabilities. The field can be safely removed when autoscaler is enabled without causing any changes.
- cloudName string
- The cloud provider and region the service is hosted in. The format is provider-region, for example:google-europe-west1. The available cloud regions can differ per project and service. Changing this value migrates the service to another cloud provider or region. The migration runs in the background and includes a DNS update to redirect traffic to the new region. Most services experience no downtime, but some databases may have a brief interruption during DNS propagation.
- 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.
- maintenanceWindow stringDow 
- Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenanceWindow stringTime 
- Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql
MySql Mysql 
- MySQL server-provided values.
- mysqlUser MyConfig Sql Mysql User Config 
- Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- projectVpc stringId 
- Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- serviceIntegrations MySql Service Integration[] 
- 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
- 
MySql Tag[] 
- Tags are key-value pairs that allow you to categorize services.
- techEmails MySql Tech Email[] 
- The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- terminationProtection boolean
- Prevents the service from being deleted. It is recommended to set this to truefor 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-xandpremium-xwherexis (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page.
- project str
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- service_name str
- Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
- additional_disk_ strspace 
- Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart, and there might be a short downtime for services without an autoscaler integration or high availability capabilities. The field can be safely removed when autoscaler is enabled without causing any changes.
- cloud_name str
- The cloud provider and region the service is hosted in. The format is provider-region, for example:google-europe-west1. The available cloud regions can differ per project and service. Changing this value migrates the service to another cloud provider or region. The migration runs in the background and includes a DNS update to redirect traffic to the new region. Most services experience no downtime, but some databases may have a brief interruption during DNS propagation.
- disk_space str
- Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- maintenance_window_ strdow 
- Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenance_window_ strtime 
- Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql
MySql Mysql Args 
- MySQL server-provided values.
- mysql_user_ Myconfig Sql Mysql User Config Args 
- Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- project_vpc_ strid 
- Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- service_integrations Sequence[MySql Service Integration Args] 
- Service integrations to specify when creating a service. Not applied after initial service creation
- static_ips Sequence[str]
- Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- 
Sequence[MySql Tag Args] 
- Tags are key-value pairs that allow you to categorize services.
- tech_emails Sequence[MySql Tech Email Args] 
- The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- termination_protection bool
- Prevents the service from being deleted. It is recommended to set this to truefor 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-xandpremium-xwherexis (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page.
- project String
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- 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.
- additionalDisk StringSpace 
- Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart, and there might be a short downtime for services without an autoscaler integration or high availability capabilities. The field can be safely removed when autoscaler is enabled without causing any changes.
- cloudName String
- The cloud provider and region the service is hosted in. The format is provider-region, for example:google-europe-west1. The available cloud regions can differ per project and service. Changing this value migrates the service to another cloud provider or region. The migration runs in the background and includes a DNS update to redirect traffic to the new region. Most services experience no downtime, but some databases may have a brief interruption during DNS propagation.
- 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.
- maintenanceWindow StringDow 
- Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenanceWindow StringTime 
- Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql Property Map
- MySQL server-provided values.
- mysqlUser Property MapConfig 
- Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- projectVpc StringId 
- Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- 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
- 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 truefor 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<MySql Component> 
- Service component information objects
- DiskSpace stringCap 
- The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- DiskSpace stringDefault 
- The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
- DiskSpace stringStep 
- The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_spaceneeds to increment fromdisk_space_defaultby increments of this size.
- DiskSpace stringUsed 
- 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
- Components
[]MySql Component 
- Service component information objects
- DiskSpace stringCap 
- The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- DiskSpace stringDefault 
- The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
- DiskSpace stringStep 
- The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_spaceneeds to increment fromdisk_space_defaultby increments of this size.
- DiskSpace stringUsed 
- 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
- components
List<MySql Component> 
- Service component information objects
- diskSpace StringCap 
- The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- diskSpace StringDefault 
- The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
- diskSpace StringStep 
- The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_spaceneeds to increment fromdisk_space_defaultby increments of this size.
- diskSpace StringUsed 
- 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
- components
MySql Component[] 
- Service component information objects
- diskSpace stringCap 
- The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- diskSpace stringDefault 
- The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
- diskSpace stringStep 
- The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_spaceneeds to increment fromdisk_space_defaultby increments of this size.
- diskSpace stringUsed 
- 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
- components
Sequence[MySql Component] 
- Service component information objects
- disk_space_ strcap 
- The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- disk_space_ strdefault 
- The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
- disk_space_ strstep 
- The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_spaceneeds to increment fromdisk_space_defaultby increments of this size.
- disk_space_ strused 
- Disk space that service is currently using
- id str
- The provider-assigned unique ID for this managed resource.
- service_host str
- The hostname of the service.
- service_password str
- Password used for connecting to the service, if applicable
- service_port int
- The port of the service
- service_type str
- Aiven internal service type code
- service_uri str
- URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- service_username str
- Username used for connecting to the service, if applicable
- state str
- components List<Property Map>
- Service component information objects
- diskSpace StringCap 
- The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- diskSpace StringDefault 
- The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
- diskSpace StringStep 
- The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_spaceneeds to increment fromdisk_space_defaultby increments of this size.
- diskSpace StringUsed 
- 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
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) -> MySqlfunc GetMySql(ctx *Context, name string, id IDInput, state *MySqlState, opts ...ResourceOption) (*MySql, error)public static MySql Get(string name, Input<string> id, MySqlState? state, CustomResourceOptions? opts = null)public static MySql get(String name, Output<String> id, MySqlState state, CustomResourceOptions options)resources:  _:    type: aiven:MySql    get:      id: ${id}- name
- 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.
- AdditionalDisk stringSpace 
- Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart, and there might be a short downtime for services without an autoscaler integration or high availability capabilities. The field can be safely removed when autoscaler is enabled without causing any changes.
- CloudName string
- The cloud provider and region the service is hosted in. The format is provider-region, for example:google-europe-west1. The available cloud regions can differ per project and service. Changing this value migrates the service to another cloud provider or region. The migration runs in the background and includes a DNS update to redirect traffic to the new region. Most services experience no downtime, but some databases may have a brief interruption during DNS propagation.
- Components
List<MySql Component> 
- 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.
- DiskSpace stringCap 
- The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- DiskSpace stringDefault 
- The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
- DiskSpace stringStep 
- The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_spaceneeds to increment fromdisk_space_defaultby increments of this size.
- DiskSpace stringUsed 
- Disk space that service is currently using
- MaintenanceWindow stringDow 
- Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- MaintenanceWindow stringTime 
- Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- Mysql
MySql Mysql 
- MySQL server-provided values.
- MysqlUser MyConfig Sql Mysql User Config 
- Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- Plan string
- Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are hobbyist,startup-x,business-xandpremium-xwherexis (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page.
- Project string
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- ProjectVpc stringId 
- Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- ServiceHost string
- The hostname of the service.
- ServiceIntegrations List<MySql Service Integration> 
- 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
- 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
- 
List<MySql Tag> 
- Tags are key-value pairs that allow you to categorize services.
- TechEmails List<MySql Tech Email> 
- The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- TerminationProtection bool
- Prevents the service from being deleted. It is recommended to set this to truefor 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.
- AdditionalDisk stringSpace 
- Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart, and there might be a short downtime for services without an autoscaler integration or high availability capabilities. The field can be safely removed when autoscaler is enabled without causing any changes.
- CloudName string
- The cloud provider and region the service is hosted in. The format is provider-region, for example:google-europe-west1. The available cloud regions can differ per project and service. Changing this value migrates the service to another cloud provider or region. The migration runs in the background and includes a DNS update to redirect traffic to the new region. Most services experience no downtime, but some databases may have a brief interruption during DNS propagation.
- Components
[]MySql Component Args 
- 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.
- DiskSpace stringCap 
- The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- DiskSpace stringDefault 
- The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
- DiskSpace stringStep 
- The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_spaceneeds to increment fromdisk_space_defaultby increments of this size.
- DiskSpace stringUsed 
- Disk space that service is currently using
- MaintenanceWindow stringDow 
- Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- MaintenanceWindow stringTime 
- Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- Mysql
MySql Mysql Args 
- MySQL server-provided values.
- MysqlUser MyConfig Sql Mysql User Config Args 
- Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- Plan string
- Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are hobbyist,startup-x,business-xandpremium-xwherexis (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page.
- Project string
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- ProjectVpc stringId 
- Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- ServiceHost string
- The hostname of the service.
- ServiceIntegrations []MySql Service Integration Args 
- 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
- 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
- 
[]MySql Tag Args 
- Tags are key-value pairs that allow you to categorize services.
- TechEmails []MySql Tech Email Args 
- The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- TerminationProtection bool
- Prevents the service from being deleted. It is recommended to set this to truefor 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.
- additionalDisk StringSpace 
- Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart, and there might be a short downtime for services without an autoscaler integration or high availability capabilities. The field can be safely removed when autoscaler is enabled without causing any changes.
- cloudName String
- The cloud provider and region the service is hosted in. The format is provider-region, for example:google-europe-west1. The available cloud regions can differ per project and service. Changing this value migrates the service to another cloud provider or region. The migration runs in the background and includes a DNS update to redirect traffic to the new region. Most services experience no downtime, but some databases may have a brief interruption during DNS propagation.
- components
List<MySql Component> 
- 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.
- diskSpace StringCap 
- The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- diskSpace StringDefault 
- The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
- diskSpace StringStep 
- The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_spaceneeds to increment fromdisk_space_defaultby increments of this size.
- diskSpace StringUsed 
- Disk space that service is currently using
- maintenanceWindow StringDow 
- Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenanceWindow StringTime 
- Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql
MySql Mysql 
- MySQL server-provided values.
- mysqlUser MyConfig Sql Mysql User Config 
- Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- plan String
- Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are hobbyist,startup-x,business-xandpremium-xwherexis (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page.
- project String
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- projectVpc StringId 
- Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- serviceHost String
- The hostname of the service.
- serviceIntegrations List<MySql Service Integration> 
- 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
- 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
- 
List<MySql Tag> 
- Tags are key-value pairs that allow you to categorize services.
- techEmails List<MySql Tech Email> 
- The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- terminationProtection Boolean
- Prevents the service from being deleted. It is recommended to set this to truefor 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.
- additionalDisk stringSpace 
- Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart, and there might be a short downtime for services without an autoscaler integration or high availability capabilities. The field can be safely removed when autoscaler is enabled without causing any changes.
- cloudName string
- The cloud provider and region the service is hosted in. The format is provider-region, for example:google-europe-west1. The available cloud regions can differ per project and service. Changing this value migrates the service to another cloud provider or region. The migration runs in the background and includes a DNS update to redirect traffic to the new region. Most services experience no downtime, but some databases may have a brief interruption during DNS propagation.
- components
MySql Component[] 
- 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.
- diskSpace stringCap 
- The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- diskSpace stringDefault 
- The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
- diskSpace stringStep 
- The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_spaceneeds to increment fromdisk_space_defaultby increments of this size.
- diskSpace stringUsed 
- Disk space that service is currently using
- maintenanceWindow stringDow 
- Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenanceWindow stringTime 
- Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql
MySql Mysql 
- MySQL server-provided values.
- mysqlUser MyConfig Sql Mysql User Config 
- Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- plan string
- Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are hobbyist,startup-x,business-xandpremium-xwherexis (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page.
- project string
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- projectVpc stringId 
- Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- serviceHost string
- The hostname of the service.
- serviceIntegrations MySql Service Integration[] 
- 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
- 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
- 
MySql Tag[] 
- Tags are key-value pairs that allow you to categorize services.
- techEmails MySql Tech Email[] 
- The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- terminationProtection boolean
- Prevents the service from being deleted. It is recommended to set this to truefor all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
- additional_disk_ strspace 
- Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart, and there might be a short downtime for services without an autoscaler integration or high availability capabilities. The field can be safely removed when autoscaler is enabled without causing any changes.
- cloud_name str
- The cloud provider and region the service is hosted in. The format is provider-region, for example:google-europe-west1. The available cloud regions can differ per project and service. Changing this value migrates the service to another cloud provider or region. The migration runs in the background and includes a DNS update to redirect traffic to the new region. Most services experience no downtime, but some databases may have a brief interruption during DNS propagation.
- components
Sequence[MySql Component Args] 
- Service component information objects
- disk_space str
- Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- disk_space_ strcap 
- The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- disk_space_ strdefault 
- The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
- disk_space_ strstep 
- The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_spaceneeds to increment fromdisk_space_defaultby increments of this size.
- disk_space_ strused 
- Disk space that service is currently using
- maintenance_window_ strdow 
- Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenance_window_ strtime 
- Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql
MySql Mysql Args 
- MySQL server-provided values.
- mysql_user_ Myconfig Sql Mysql User Config Args 
- Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- plan str
- Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are hobbyist,startup-x,business-xandpremium-xwherexis (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page.
- project str
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- project_vpc_ strid 
- Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- service_host str
- The hostname of the service.
- service_integrations Sequence[MySql Service Integration Args] 
- Service integrations to specify when creating a service. Not applied after initial service creation
- service_name str
- Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
- service_password str
- Password used for connecting to the service, if applicable
- service_port int
- The port of the service
- service_type str
- Aiven internal service type code
- service_uri str
- URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- service_username str
- Username used for connecting to the service, if applicable
- state str
- static_ips Sequence[str]
- Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- 
Sequence[MySql Tag Args] 
- Tags are key-value pairs that allow you to categorize services.
- tech_emails Sequence[MySql Tech Email Args] 
- The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
- termination_protection bool
- Prevents the service from being deleted. It is recommended to set this to truefor 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.
- additionalDisk StringSpace 
- Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart, and there might be a short downtime for services without an autoscaler integration or high availability capabilities. The field can be safely removed when autoscaler is enabled without causing any changes.
- cloudName String
- The cloud provider and region the service is hosted in. The format is provider-region, for example:google-europe-west1. The available cloud regions can differ per project and service. Changing this value migrates the service to another cloud provider or region. The migration runs in the background and includes a DNS update to redirect traffic to the new region. Most services experience no downtime, but some databases may have a brief interruption during DNS propagation.
- 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.
- diskSpace StringCap 
- The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- diskSpace StringDefault 
- The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
- diskSpace StringStep 
- The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_spaceneeds to increment fromdisk_space_defaultby increments of this size.
- diskSpace StringUsed 
- Disk space that service is currently using
- maintenanceWindow StringDow 
- Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenanceWindow StringTime 
- Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql Property Map
- MySQL server-provided values.
- mysqlUser Property MapConfig 
- Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
- plan String
- Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are hobbyist,startup-x,business-xandpremium-xwherexis (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seen from the Aiven pricing page.
- project String
- The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
- projectVpc StringId 
- Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- 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
- 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
- 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 truefor 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
- KafkaAuthentication stringMethod 
- Kafka authentication method. This is a value specific to the 'kafka' service component
- KafkaSsl stringCa 
- Kafka certificate used. The possible values are letsencryptandproject_ca.
- 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
- KafkaAuthentication stringMethod 
- Kafka authentication method. This is a value specific to the 'kafka' service component
- KafkaSsl stringCa 
- Kafka certificate used. The possible values are letsencryptandproject_ca.
- 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
- kafkaAuthentication StringMethod 
- Kafka authentication method. This is a value specific to the 'kafka' service component
- kafkaSsl StringCa 
- Kafka certificate used. The possible values are letsencryptandproject_ca.
- 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
- kafkaAuthentication stringMethod 
- Kafka authentication method. This is a value specific to the 'kafka' service component
- kafkaSsl stringCa 
- Kafka certificate used. The possible values are letsencryptandproject_ca.
- port number
- Port number for connecting to the service component
- route string
- Network access route
- ssl boolean
- Whether the endpoint is encrypted or accepts plaintext. By default endpoints are always encrypted and this property is only included for service components they may disable encryption
- usage string
- DNS usage name
- component str
- Service component name
- connection_uri str
- Connection info for connecting to the service component. This is a combination of host and port.
- host str
- Host name for connecting to the service component
- kafka_authentication_ strmethod 
- Kafka authentication method. This is a value specific to the 'kafka' service component
- kafka_ssl_ strca 
- Kafka certificate used. The possible values are letsencryptandproject_ca.
- 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
- kafkaAuthentication StringMethod 
- Kafka authentication method. This is a value specific to the 'kafka' service component
- kafkaSsl StringCa 
- Kafka certificate used. The possible values are letsencryptandproject_ca.
- 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<MySql Mysql Param> 
- MySQL connection parameters.
- ReplicaUri string
- MySQL replica URI for services with a replica.
- StandbyUris List<string>
- MySQL standby connection URIs.
- SyncingUris List<string>
- MySQL syncing connection URIs.
- Uris List<string>
- MySQL connection URIs.
- Params
[]MySql Mysql Param 
- MySQL connection parameters.
- ReplicaUri string
- MySQL replica URI for services with a replica.
- StandbyUris []string
- MySQL standby connection URIs.
- SyncingUris []string
- MySQL syncing connection URIs.
- Uris []string
- MySQL connection URIs.
- params
List<MySql Mysql Param> 
- MySQL connection parameters.
- replicaUri String
- MySQL replica URI for services with a replica.
- standbyUris List<String>
- MySQL standby connection URIs.
- syncingUris List<String>
- MySQL syncing connection URIs.
- uris List<String>
- MySQL connection URIs.
- params
MySql Mysql Param[] 
- MySQL connection parameters.
- replicaUri string
- MySQL replica URI for services with a replica.
- standbyUris string[]
- MySQL standby connection URIs.
- syncingUris string[]
- MySQL syncing connection URIs.
- uris string[]
- MySQL connection URIs.
- params
Sequence[MySql Mysql Param] 
- MySQL connection parameters.
- replica_uri str
- MySQL replica URI for services with a replica.
- standby_uris Sequence[str]
- MySQL standby connection URIs.
- syncing_uris Sequence[str]
- MySQL syncing connection URIs.
- uris Sequence[str]
- MySQL connection URIs.
- params List<Property Map>
- MySQL connection parameters.
- replicaUri String
- MySQL replica URI for services with a replica.
- standbyUris List<String>
- MySQL standby connection URIs.
- syncingUris List<String>
- MySQL syncing connection URIs.
- uris List<String>
- MySQL connection URIs.
MySqlMysqlParam, MySqlMysqlParamArgs        
MySqlMysqlUserConfig, MySqlMysqlUserConfigArgs          
- AdditionalBackup stringRegions 
- 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.
- BinlogRetention intPeriod 
- The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector. Example: 600.
- IpFilter List<MyObjects Sql Mysql User Config Ip Filter Object> 
- Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16
- IpFilter List<string>Strings 
- 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.
- Migration
MySql Mysql User Config Migration 
- Migrate data from existing server
- Mysql
MySql Mysql User Config Mysql 
- mysql.conf configuration values
- MysqlVersion string
- Enum: 8, and newer. MySQL major version.
- PrivateAccess MySql Mysql User Config Private Access 
- Allow access to selected service ports from private networks
- PrivatelinkAccess MySql Mysql User Config Privatelink Access 
- Allow access to selected service components through Privatelink
- ProjectTo stringFork From 
- Name of another project to fork a service from. This has effect only when a new service is being created. Example: anotherprojectname.
- PublicAccess MySql Mysql User Config Public Access 
- Allow access to selected service ports from the public Internet
- RecoveryTarget stringTime 
- Recovery target time when forking a service. This has effect only when a new service is being created. Example: 2019-01-01 23:34:45.
- ServiceLog bool
- Store logs for the service so that they are available in the HTTP API and console.
- ServiceTo stringFork From 
- 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.
- AdditionalBackup stringRegions 
- 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.
- BinlogRetention intPeriod 
- The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector. Example: 600.
- IpFilter []MyObjects Sql Mysql User Config Ip Filter Object 
- Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16
- IpFilter []stringStrings 
- 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.
- Migration
MySql Mysql User Config Migration 
- Migrate data from existing server
- Mysql
MySql Mysql User Config Mysql 
- mysql.conf configuration values
- MysqlVersion string
- Enum: 8, and newer. MySQL major version.
- PrivateAccess MySql Mysql User Config Private Access 
- Allow access to selected service ports from private networks
- PrivatelinkAccess MySql Mysql User Config Privatelink Access 
- Allow access to selected service components through Privatelink
- ProjectTo stringFork From 
- Name of another project to fork a service from. This has effect only when a new service is being created. Example: anotherprojectname.
- PublicAccess MySql Mysql User Config Public Access 
- Allow access to selected service ports from the public Internet
- RecoveryTarget stringTime 
- Recovery target time when forking a service. This has effect only when a new service is being created. Example: 2019-01-01 23:34:45.
- ServiceLog bool
- Store logs for the service so that they are available in the HTTP API and console.
- ServiceTo stringFork From 
- 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.
- additionalBackup StringRegions 
- 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.
- binlogRetention IntegerPeriod 
- The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector. Example: 600.
- ipFilter List<MyObjects Sql Mysql User Config Ip Filter Object> 
- Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16
- ipFilter List<String>Strings 
- 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.
- migration
MySql Mysql User Config Migration 
- Migrate data from existing server
- mysql
MySql Mysql User Config Mysql 
- mysql.conf configuration values
- mysqlVersion String
- Enum: 8, and newer. MySQL major version.
- privateAccess MySql Mysql User Config Private Access 
- Allow access to selected service ports from private networks
- privatelinkAccess MySql Mysql User Config Privatelink Access 
- Allow access to selected service components through Privatelink
- projectTo StringFork From 
- Name of another project to fork a service from. This has effect only when a new service is being created. Example: anotherprojectname.
- publicAccess MySql Mysql User Config Public Access 
- Allow access to selected service ports from the public Internet
- recoveryTarget StringTime 
- Recovery target time when forking a service. This has effect only when a new service is being created. Example: 2019-01-01 23:34:45.
- serviceLog Boolean
- Store logs for the service so that they are available in the HTTP API and console.
- serviceTo StringFork From 
- 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.
- additionalBackup stringRegions 
- 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.
- binlogRetention numberPeriod 
- The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector. Example: 600.
- ipFilter MyObjects Sql Mysql User Config Ip Filter Object[] 
- Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16
- ipFilter string[]Strings 
- 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.
- migration
MySql Mysql User Config Migration 
- Migrate data from existing server
- mysql
MySql Mysql User Config Mysql 
- mysql.conf configuration values
- mysqlVersion string
- Enum: 8, and newer. MySQL major version.
- privateAccess MySql Mysql User Config Private Access 
- Allow access to selected service ports from private networks
- privatelinkAccess MySql Mysql User Config Privatelink Access 
- Allow access to selected service components through Privatelink
- projectTo stringFork From 
- Name of another project to fork a service from. This has effect only when a new service is being created. Example: anotherprojectname.
- publicAccess MySql Mysql User Config Public Access 
- Allow access to selected service ports from the public Internet
- recoveryTarget stringTime 
- Recovery target time when forking a service. This has effect only when a new service is being created. Example: 2019-01-01 23:34:45.
- serviceLog boolean
- Store logs for the service so that they are available in the HTTP API and console.
- serviceTo stringFork From 
- 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_ strregions 
- Additional Cloud Regions for Backup Replication.
- admin_password str
- Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
- admin_username str
- Custom username for admin user. This must be set only when a new service is being created. Example: avnadmin.
- backup_hour int
- The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed. Example: 3.
- backup_minute int
- The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed. Example: 30.
- binlog_retention_ intperiod 
- The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector. Example: 600.
- ip_filter_ Sequence[Myobjects Sql Mysql User Config Ip Filter Object] 
- Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16
- ip_filter_ Sequence[str]strings 
- Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16.
- ip_filters Sequence[str]
- Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16.
- migration
MySql Mysql User Config Migration 
- Migrate data from existing server
- mysql
MySql Mysql User Config Mysql 
- mysql.conf configuration values
- mysql_version str
- Enum: 8, and newer. MySQL major version.
- private_access MySql Mysql User Config Private Access 
- Allow access to selected service ports from private networks
- privatelink_access MySql Mysql User Config Privatelink Access 
- Allow access to selected service components through Privatelink
- project_to_ strfork_ from 
- Name of another project to fork a service from. This has effect only when a new service is being created. Example: anotherprojectname.
- public_access MySql Mysql User Config Public Access 
- Allow access to selected service ports from the public Internet
- recovery_target_ strtime 
- Recovery target time when forking a service. This has effect only when a new service is being created. Example: 2019-01-01 23:34:45.
- service_log bool
- Store logs for the service so that they are available in the HTTP API and console.
- service_to_ strfork_ from 
- Name of another service to fork from. This has effect only when a new service is being created. Example: anotherservicename.
- static_ips bool
- Use static public IP addresses.
- additionalBackup StringRegions 
- 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.
- binlogRetention NumberPeriod 
- The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector. Example: 600.
- ipFilter List<Property Map>Objects 
- Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16
- ipFilter List<String>Strings 
- 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.
- 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
- projectTo StringFork From 
- 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
- recoveryTarget StringTime 
- Recovery target time when forking a service. This has effect only when a new service is being created. Example: 2019-01-01 23:34:45.
- serviceLog Boolean
- Store logs for the service so that they are available in the HTTP API and console.
- serviceTo StringFork From 
- 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.
- IgnoreRoles string
- Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment). Example: role1,role2.
- Method string
- Enum: dump,replication. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
- Password string
- Password for authentication with the server where to migrate data from. Example: jjKk45Nnd.
- Ssl bool
- The server where to migrate data from is secured with SSL. Default: true.
- Username string
- User name for authentication with the server where to migrate data from. Example: myname.
- Host 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.
- IgnoreRoles string
- Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment). Example: role1,role2.
- Method string
- Enum: dump,replication. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
- Password string
- Password for authentication with the server where to migrate data from. Example: jjKk45Nnd.
- Ssl bool
- The server where to migrate data from is secured with SSL. Default: true.
- Username string
- User name for authentication with the server where to migrate data from. Example: myname.
- host 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.
- ignoreRoles String
- Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment). Example: role1,role2.
- method String
- Enum: dump,replication. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
- password String
- Password for authentication with the server where to migrate data from. Example: jjKk45Nnd.
- ssl Boolean
- The server where to migrate data from is secured with SSL. Default: true.
- username String
- User name for authentication with the server where to migrate data from. Example: myname.
- host 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.
- ignoreRoles string
- Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment). Example: role1,role2.
- method string
- Enum: dump,replication. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
- password string
- Password for authentication with the server where to migrate data from. Example: jjKk45Nnd.
- ssl boolean
- The server where to migrate data from is secured with SSL. Default: true.
- username string
- User name for authentication with the server where to migrate data from. Example: myname.
- host str
- Hostname or IP address of the server where to migrate data from. Example: my.server.com.
- port int
- Port number of the server where to migrate data from. Example: 1234.
- dbname str
- Database name for bootstrapping the initial connection. Example: defaultdb.
- ignore_dbs str
- Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment). Example: db1,db2.
- ignore_roles str
- Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment). Example: role1,role2.
- method str
- Enum: dump,replication. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
- password str
- Password for authentication with the server where to migrate data from. Example: jjKk45Nnd.
- ssl bool
- The server where to migrate data from is secured with SSL. Default: true.
- username str
- User name for authentication with the server where to migrate data from. Example: myname.
- host String
- Hostname or IP address of the server where to migrate data from. Example: my.server.com.
- port Number
- Port number of the server where to migrate data from. Example: 1234.
- dbname String
- Database name for bootstrapping the initial connection. Example: defaultdb.
- ignoreDbs String
- Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment). Example: db1,db2.
- ignoreRoles String
- Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment). Example: role1,role2.
- method String
- Enum: dump,replication. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
- password String
- Password for authentication with the server where to migrate data from. Example: jjKk45Nnd.
- ssl Boolean
- The server where to migrate data from is secured with SSL. Default: true.
- username String
- User name for authentication with the server where to migrate data from. Example: myname.
MySqlMysqlUserConfigMysql, MySqlMysqlUserConfigMysqlArgs            
- ConnectTimeout int
- The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake. Example: 10.
- DefaultTime stringZone 
- Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or SYSTEMto use the MySQL server default. Example:+03:00.
- GroupConcat intMax Len 
- The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example: 1024.
- InformationSchema intStats Expiry 
- The time, in seconds, before cached statistics expire. Example: 86400.
- InnodbChange intBuffer Max Size 
- Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example: 30.
- InnodbFlush intNeighbors 
- Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent. Example: 0.
- InnodbFt intMin Token Size 
- Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service. Example: 3.
- InnodbFt stringServer Stopword Table 
- This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example: db_name/table_name.
- InnodbLock intWait Timeout 
- The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example: 50.
- InnodbLog intBuffer Size 
- The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example: 16777216.
- InnodbOnline intAlter Log Max Size 
- The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example: 134217728.
- InnodbPrint boolAll Deadlocks 
- When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
- InnodbRead intIo Threads 
- The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
- InnodbRollback boolOn Timeout 
- When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
- InnodbThread intConcurrency 
- Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example: 10.
- InnodbWrite intIo Threads 
- The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
- InteractiveTimeout int
- The number of seconds the server waits for activity on an interactive connection before closing it. Example: 3600.
- InternalTmp stringMem Storage Engine 
- Enum: MEMORY,TempTable. The storage engine for in-memory internal temporary tables.
- LogOutput string
- Enum: INSIGHTS,INSIGHTS,TABLE,NONE,TABLE. The slow log output destination when slowquerylog is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slowlog table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slowlog table, choose TABLE. To silence slow logs, choose NONE.
- LongQuery doubleTime 
- The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Example: 10.0.
- MaxAllowed intPacket 
- Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example: 67108864.
- MaxHeap intTable Size 
- Limits the size of internal in-memory tables. Also set tmptablesize. Default is 16777216 (16M). Example: 16777216.
- NetBuffer intLength 
- Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service. Example: 16384.
- NetRead intTimeout 
- The number of seconds to wait for more data from a connection before aborting the read. Example: 30.
- NetWrite intTimeout 
- The number of seconds to wait for a block to be written to a connection before aborting the write. Example: 30.
- SlowQuery boolLog 
- Slow query log enables capturing of slow queries. Setting slowquerylog to false also truncates the mysql.slow_log table.
- SortBuffer intSize 
- 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.
- SqlRequire boolPrimary Key 
- Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
- TmpTable intSize 
- 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.
- DefaultTime stringZone 
- Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or SYSTEMto use the MySQL server default. Example:+03:00.
- GroupConcat intMax Len 
- The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example: 1024.
- InformationSchema intStats Expiry 
- The time, in seconds, before cached statistics expire. Example: 86400.
- InnodbChange intBuffer Max Size 
- Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example: 30.
- InnodbFlush intNeighbors 
- Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent. Example: 0.
- InnodbFt intMin Token Size 
- Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service. Example: 3.
- InnodbFt stringServer Stopword Table 
- This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example: db_name/table_name.
- InnodbLock intWait Timeout 
- The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example: 50.
- InnodbLog intBuffer Size 
- The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example: 16777216.
- InnodbOnline intAlter Log Max Size 
- The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example: 134217728.
- InnodbPrint boolAll Deadlocks 
- When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
- InnodbRead intIo Threads 
- The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
- InnodbRollback boolOn Timeout 
- When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
- InnodbThread intConcurrency 
- Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example: 10.
- InnodbWrite intIo Threads 
- The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
- InteractiveTimeout int
- The number of seconds the server waits for activity on an interactive connection before closing it. Example: 3600.
- InternalTmp stringMem Storage Engine 
- Enum: MEMORY,TempTable. The storage engine for in-memory internal temporary tables.
- LogOutput string
- Enum: INSIGHTS,INSIGHTS,TABLE,NONE,TABLE. The slow log output destination when slowquerylog is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slowlog table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slowlog table, choose TABLE. To silence slow logs, choose NONE.
- LongQuery float64Time 
- The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Example: 10.0.
- MaxAllowed intPacket 
- Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example: 67108864.
- MaxHeap intTable Size 
- Limits the size of internal in-memory tables. Also set tmptablesize. Default is 16777216 (16M). Example: 16777216.
- NetBuffer intLength 
- Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service. Example: 16384.
- NetRead intTimeout 
- The number of seconds to wait for more data from a connection before aborting the read. Example: 30.
- NetWrite intTimeout 
- The number of seconds to wait for a block to be written to a connection before aborting the write. Example: 30.
- SlowQuery boolLog 
- Slow query log enables capturing of slow queries. Setting slowquerylog to false also truncates the mysql.slow_log table.
- SortBuffer intSize 
- 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.
- SqlRequire boolPrimary Key 
- Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
- TmpTable intSize 
- 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.
- defaultTime StringZone 
- Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or SYSTEMto use the MySQL server default. Example:+03:00.
- groupConcat IntegerMax Len 
- The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example: 1024.
- informationSchema IntegerStats Expiry 
- The time, in seconds, before cached statistics expire. Example: 86400.
- innodbChange IntegerBuffer Max Size 
- Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example: 30.
- innodbFlush IntegerNeighbors 
- Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent. Example: 0.
- innodbFt IntegerMin Token Size 
- Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service. Example: 3.
- innodbFt StringServer Stopword Table 
- This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example: db_name/table_name.
- innodbLock IntegerWait Timeout 
- The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example: 50.
- innodbLog IntegerBuffer Size 
- The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example: 16777216.
- innodbOnline IntegerAlter Log Max Size 
- The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example: 134217728.
- innodbPrint BooleanAll Deadlocks 
- When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
- innodbRead IntegerIo Threads 
- The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
- innodbRollback BooleanOn Timeout 
- When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
- innodbThread IntegerConcurrency 
- Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example: 10.
- innodbWrite IntegerIo Threads 
- The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
- interactiveTimeout Integer
- The number of seconds the server waits for activity on an interactive connection before closing it. Example: 3600.
- internalTmp StringMem Storage Engine 
- Enum: MEMORY,TempTable. The storage engine for in-memory internal temporary tables.
- logOutput String
- Enum: INSIGHTS,INSIGHTS,TABLE,NONE,TABLE. The slow log output destination when slowquerylog is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slowlog table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slowlog table, choose TABLE. To silence slow logs, choose NONE.
- longQuery DoubleTime 
- The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Example: 10.0.
- maxAllowed IntegerPacket 
- Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example: 67108864.
- maxHeap IntegerTable Size 
- Limits the size of internal in-memory tables. Also set tmptablesize. Default is 16777216 (16M). Example: 16777216.
- netBuffer IntegerLength 
- Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service. Example: 16384.
- netRead IntegerTimeout 
- The number of seconds to wait for more data from a connection before aborting the read. Example: 30.
- netWrite IntegerTimeout 
- The number of seconds to wait for a block to be written to a connection before aborting the write. Example: 30.
- slowQuery BooleanLog 
- Slow query log enables capturing of slow queries. Setting slowquerylog to false also truncates the mysql.slow_log table.
- sortBuffer IntegerSize 
- 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.
- sqlRequire BooleanPrimary Key 
- Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
- tmpTable IntegerSize 
- 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.
- defaultTime stringZone 
- Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or SYSTEMto use the MySQL server default. Example:+03:00.
- groupConcat numberMax Len 
- The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example: 1024.
- informationSchema numberStats Expiry 
- The time, in seconds, before cached statistics expire. Example: 86400.
- innodbChange numberBuffer Max Size 
- Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example: 30.
- innodbFlush numberNeighbors 
- Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent. Example: 0.
- innodbFt numberMin Token Size 
- Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service. Example: 3.
- innodbFt stringServer Stopword Table 
- This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example: db_name/table_name.
- innodbLock numberWait Timeout 
- The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example: 50.
- innodbLog numberBuffer Size 
- The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example: 16777216.
- innodbOnline numberAlter Log Max Size 
- The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example: 134217728.
- innodbPrint booleanAll Deadlocks 
- When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
- innodbRead numberIo Threads 
- The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
- innodbRollback booleanOn Timeout 
- When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
- innodbThread numberConcurrency 
- Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example: 10.
- innodbWrite numberIo Threads 
- The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
- interactiveTimeout number
- The number of seconds the server waits for activity on an interactive connection before closing it. Example: 3600.
- internalTmp stringMem Storage Engine 
- Enum: MEMORY,TempTable. The storage engine for in-memory internal temporary tables.
- logOutput string
- Enum: INSIGHTS,INSIGHTS,TABLE,NONE,TABLE. The slow log output destination when slowquerylog is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slowlog table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slowlog table, choose TABLE. To silence slow logs, choose NONE.
- longQuery numberTime 
- The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Example: 10.0.
- maxAllowed numberPacket 
- Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example: 67108864.
- maxHeap numberTable Size 
- Limits the size of internal in-memory tables. Also set tmptablesize. Default is 16777216 (16M). Example: 16777216.
- netBuffer numberLength 
- Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service. Example: 16384.
- netRead numberTimeout 
- The number of seconds to wait for more data from a connection before aborting the read. Example: 30.
- netWrite numberTimeout 
- The number of seconds to wait for a block to be written to a connection before aborting the write. Example: 30.
- slowQuery booleanLog 
- Slow query log enables capturing of slow queries. Setting slowquerylog to false also truncates the mysql.slow_log table.
- sortBuffer numberSize 
- 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.
- sqlRequire booleanPrimary Key 
- Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
- tmpTable numberSize 
- 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_ strzone 
- Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or SYSTEMto use the MySQL server default. Example:+03:00.
- group_concat_ intmax_ len 
- The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example: 1024.
- information_schema_ intstats_ expiry 
- The time, in seconds, before cached statistics expire. Example: 86400.
- innodb_change_ intbuffer_ max_ size 
- Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example: 30.
- innodb_flush_ intneighbors 
- Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent. Example: 0.
- innodb_ft_ intmin_ token_ size 
- Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service. Example: 3.
- innodb_ft_ strserver_ stopword_ table 
- This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example: db_name/table_name.
- innodb_lock_ intwait_ timeout 
- The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example: 50.
- innodb_log_ intbuffer_ size 
- The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example: 16777216.
- innodb_online_ intalter_ log_ max_ size 
- The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example: 134217728.
- innodb_print_ boolall_ deadlocks 
- When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
- innodb_read_ intio_ threads 
- The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
- innodb_rollback_ boolon_ timeout 
- When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
- innodb_thread_ intconcurrency 
- Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example: 10.
- innodb_write_ intio_ threads 
- The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
- interactive_timeout int
- The number of seconds the server waits for activity on an interactive connection before closing it. Example: 3600.
- internal_tmp_ strmem_ storage_ engine 
- Enum: MEMORY,TempTable. The storage engine for in-memory internal temporary tables.
- log_output str
- Enum: INSIGHTS,INSIGHTS,TABLE,NONE,TABLE. The slow log output destination when slowquerylog is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slowlog table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slowlog table, choose TABLE. To silence slow logs, choose NONE.
- long_query_ floattime 
- The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Example: 10.0.
- max_allowed_ intpacket 
- Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example: 67108864.
- max_heap_ inttable_ size 
- Limits the size of internal in-memory tables. Also set tmptablesize. Default is 16777216 (16M). Example: 16777216.
- net_buffer_ intlength 
- Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service. Example: 16384.
- net_read_ inttimeout 
- The number of seconds to wait for more data from a connection before aborting the read. Example: 30.
- net_write_ inttimeout 
- The number of seconds to wait for a block to be written to a connection before aborting the write. Example: 30.
- slow_query_ boollog 
- Slow query log enables capturing of slow queries. Setting slowquerylog to false also truncates the mysql.slow_log table.
- sort_buffer_ intsize 
- Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K). Example: 262144.
- sql_mode str
- Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned. Example: ANSI,TRADITIONAL.
- sql_require_ boolprimary_ key 
- Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
- tmp_table_ intsize 
- Limits the size of internal in-memory tables. Also set maxheaptable_size. Default is 16777216 (16M). Example: 16777216.
- wait_timeout int
- The number of seconds the server waits for activity on a noninteractive connection before closing it. Example: 28800.
- connectTimeout Number
- The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake. Example: 10.
- defaultTime StringZone 
- Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or SYSTEMto use the MySQL server default. Example:+03:00.
- groupConcat NumberMax Len 
- The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example: 1024.
- informationSchema NumberStats Expiry 
- The time, in seconds, before cached statistics expire. Example: 86400.
- innodbChange NumberBuffer Max Size 
- Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example: 30.
- innodbFlush NumberNeighbors 
- Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent. Example: 0.
- innodbFt NumberMin Token Size 
- Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service. Example: 3.
- innodbFt StringServer Stopword Table 
- This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example: db_name/table_name.
- innodbLock NumberWait Timeout 
- The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example: 50.
- innodbLog NumberBuffer Size 
- The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example: 16777216.
- innodbOnline NumberAlter Log Max Size 
- The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example: 134217728.
- innodbPrint BooleanAll Deadlocks 
- When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
- innodbRead NumberIo Threads 
- The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
- innodbRollback BooleanOn Timeout 
- When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
- innodbThread NumberConcurrency 
- Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example: 10.
- innodbWrite NumberIo Threads 
- The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
- interactiveTimeout Number
- The number of seconds the server waits for activity on an interactive connection before closing it. Example: 3600.
- internalTmp StringMem Storage Engine 
- Enum: MEMORY,TempTable. The storage engine for in-memory internal temporary tables.
- logOutput String
- Enum: INSIGHTS,INSIGHTS,TABLE,NONE,TABLE. The slow log output destination when slowquerylog is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slowlog table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slowlog table, choose TABLE. To silence slow logs, choose NONE.
- longQuery NumberTime 
- The slowquerylogs work as SQL statements that take more than longquerytime seconds to execute. Example: 10.0.
- maxAllowed NumberPacket 
- Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example: 67108864.
- maxHeap NumberTable Size 
- Limits the size of internal in-memory tables. Also set tmptablesize. Default is 16777216 (16M). Example: 16777216.
- netBuffer NumberLength 
- Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service. Example: 16384.
- netRead NumberTimeout 
- The number of seconds to wait for more data from a connection before aborting the read. Example: 30.
- netWrite NumberTimeout 
- The number of seconds to wait for a block to be written to a connection before aborting the write. Example: 30.
- slowQuery BooleanLog 
- Slow query log enables capturing of slow queries. Setting slowquerylog to false also truncates the mysql.slow_log table.
- sortBuffer NumberSize 
- 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.
- sqlRequire BooleanPrimary Key 
- Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
- tmpTable NumberSize 
- 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 possible value is read_replica.
- SourceService stringName 
- Name of the source service
- IntegrationType string
- Type of the service integration. The possible value is read_replica.
- SourceService stringName 
- Name of the source service
- integrationType String
- Type of the service integration. The possible value is read_replica.
- sourceService StringName 
- Name of the source service
- integrationType string
- Type of the service integration. The possible value is read_replica.
- sourceService stringName 
- Name of the source service
- integration_type str
- Type of the service integration. The possible value is read_replica.
- source_service_ strname 
- Name of the source service
- integrationType String
- Type of the service integration. The possible value is read_replica.
- sourceService StringName 
- Name of the source service
MySqlTag, MySqlTagArgs      
MySqlTechEmail, MySqlTechEmailArgs        
- Email string
- An email address to contact for technical issues
- Email string
- An email address to contact for technical issues
- email String
- An email address to contact for technical issues
- email string
- An email address to contact for technical issues
- email str
- An email address to contact for technical issues
- email String
- An email address to contact for technical issues
Import
$ pulumi import aiven:index/mySql:MySql example_mysql 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 aivenTerraform Provider.