1. Packages
  2. Aiven
  3. API Docs
  4. MySql
Aiven v6.13.0 published on Monday, Mar 25, 2024 by Pulumi

aiven.MySql

Explore with Pulumi AI

aiven logo
Aiven v6.13.0 published on Monday, Mar 25, 2024 by Pulumi

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

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as aiven from "@pulumi/aiven";
    
    const mysql1 = new aiven.MySql("mysql1", {
        project: data.aiven_project.foo.project,
        cloudName: "google-europe-west1",
        plan: "business-4",
        serviceName: "my-mysql1",
        maintenanceWindowDow: "monday",
        maintenanceWindowTime: "10:00:00",
        mysqlUserConfig: {
            mysqlVersion: "8",
            mysql: {
                sqlMode: "ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE",
                sqlRequirePrimaryKey: true,
            },
            publicAccess: {
                mysql: true,
            },
        },
    });
    
    import pulumi
    import pulumi_aiven as aiven
    
    mysql1 = aiven.MySql("mysql1",
        project=data["aiven_project"]["foo"]["project"],
        cloud_name="google-europe-west1",
        plan="business-4",
        service_name="my-mysql1",
        maintenance_window_dow="monday",
        maintenance_window_time="10:00:00",
        mysql_user_config=aiven.MySqlMysqlUserConfigArgs(
            mysql_version="8",
            mysql=aiven.MySqlMysqlUserConfigMysqlArgs(
                sql_mode="ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE",
                sql_require_primary_key=True,
            ),
            public_access=aiven.MySqlMysqlUserConfigPublicAccessArgs(
                mysql=True,
            ),
        ))
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-aiven/sdk/v6/go/aiven"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := aiven.NewMySql(ctx, "mysql1", &aiven.MySqlArgs{
    			Project:               pulumi.Any(data.Aiven_project.Foo.Project),
    			CloudName:             pulumi.String("google-europe-west1"),
    			Plan:                  pulumi.String("business-4"),
    			ServiceName:           pulumi.String("my-mysql1"),
    			MaintenanceWindowDow:  pulumi.String("monday"),
    			MaintenanceWindowTime: pulumi.String("10:00:00"),
    			MysqlUserConfig: &aiven.MySqlMysqlUserConfigArgs{
    				MysqlVersion: pulumi.String("8"),
    				Mysql: &aiven.MySqlMysqlUserConfigMysqlArgs{
    					SqlMode:              pulumi.String("ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE"),
    					SqlRequirePrimaryKey: pulumi.Bool(true),
    				},
    				PublicAccess: &aiven.MySqlMysqlUserConfigPublicAccessArgs{
    					Mysql: pulumi.Bool(true),
    				},
    			},
    		})
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Aiven = Pulumi.Aiven;
    
    return await Deployment.RunAsync(() => 
    {
        var mysql1 = new Aiven.MySql("mysql1", new()
        {
            Project = data.Aiven_project.Foo.Project,
            CloudName = "google-europe-west1",
            Plan = "business-4",
            ServiceName = "my-mysql1",
            MaintenanceWindowDow = "monday",
            MaintenanceWindowTime = "10:00:00",
            MysqlUserConfig = new Aiven.Inputs.MySqlMysqlUserConfigArgs
            {
                MysqlVersion = "8",
                Mysql = new Aiven.Inputs.MySqlMysqlUserConfigMysqlArgs
                {
                    SqlMode = "ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE",
                    SqlRequirePrimaryKey = true,
                },
                PublicAccess = new Aiven.Inputs.MySqlMysqlUserConfigPublicAccessArgs
                {
                    Mysql = true,
                },
            },
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.aiven.MySql;
    import com.pulumi.aiven.MySqlArgs;
    import com.pulumi.aiven.inputs.MySqlMysqlUserConfigArgs;
    import com.pulumi.aiven.inputs.MySqlMysqlUserConfigMysqlArgs;
    import com.pulumi.aiven.inputs.MySqlMysqlUserConfigPublicAccessArgs;
    import java.util.List;
    import java.util.ArrayList;
    import java.util.Map;
    import java.io.File;
    import java.nio.file.Files;
    import java.nio.file.Paths;
    
    public class App {
        public static void main(String[] args) {
            Pulumi.run(App::stack);
        }
    
        public static void stack(Context ctx) {
            var mysql1 = new MySql("mysql1", MySqlArgs.builder()        
                .project(data.aiven_project().foo().project())
                .cloudName("google-europe-west1")
                .plan("business-4")
                .serviceName("my-mysql1")
                .maintenanceWindowDow("monday")
                .maintenanceWindowTime("10:00:00")
                .mysqlUserConfig(MySqlMysqlUserConfigArgs.builder()
                    .mysqlVersion(8)
                    .mysql(MySqlMysqlUserConfigMysqlArgs.builder()
                        .sqlMode("ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE")
                        .sqlRequirePrimaryKey(true)
                        .build())
                    .publicAccess(MySqlMysqlUserConfigPublicAccessArgs.builder()
                        .mysql(true)
                        .build())
                    .build())
                .build());
    
        }
    }
    
    resources:
      mysql1:
        type: aiven:MySql
        properties:
          project: ${data.aiven_project.foo.project}
          cloudName: google-europe-west1
          plan: business-4
          serviceName: my-mysql1
          maintenanceWindowDow: monday
          maintenanceWindowTime: 10:00:00
          mysqlUserConfig:
            mysqlVersion: 8
            mysql:
              sqlMode: ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE
              sqlRequirePrimaryKey: true
            publicAccess:
              mysql: true
    

    Create MySql Resource

    new MySql(name: string, args: MySqlArgs, opts?: CustomResourceOptions);
    @overload
    def MySql(resource_name: str,
              opts: Optional[ResourceOptions] = None,
              additional_disk_space: Optional[str] = None,
              cloud_name: Optional[str] = None,
              disk_space: Optional[str] = None,
              maintenance_window_dow: Optional[str] = None,
              maintenance_window_time: Optional[str] = None,
              mysql_user_config: Optional[MySqlMysqlUserConfigArgs] = None,
              plan: Optional[str] = None,
              project: Optional[str] = None,
              project_vpc_id: Optional[str] = None,
              service_integrations: Optional[Sequence[MySqlServiceIntegrationArgs]] = None,
              service_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)
    @overload
    def MySql(resource_name: str,
              args: MySqlArgs,
              opts: Optional[ResourceOptions] = None)
    func NewMySql(ctx *Context, name string, args MySqlArgs, opts ...ResourceOption) (*MySql, error)
    public MySql(string name, MySqlArgs args, CustomResourceOptions? opts = null)
    public MySql(String name, MySqlArgs args)
    public MySql(String name, MySqlArgs args, CustomResourceOptions options)
    
    type: aiven:MySql
    properties: # The arguments to resource properties.
    options: # Bag of options to control resource's behavior.
    
    
    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.

    MySql Resource Properties

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

    Inputs

    The MySql resource accepts the following input properties:

    Plan string
    Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are hobbyist, startup-x, business-x and premium-x where x is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.
    Project string
    Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    ServiceName string
    Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
    AdditionalDiskSpace string
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    CloudName string
    Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (aws, azure, do google, upcloud, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS.
    DiskSpace string
    Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.

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

    MaintenanceWindowDow string
    Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
    MaintenanceWindowTime string
    Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
    MysqlUserConfig MySqlMysqlUserConfig
    Mysql user configurable settings
    ProjectVpcId string
    Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
    ServiceIntegrations List<MySqlServiceIntegration>
    Service integrations to specify when creating a service. Not applied after initial service creation
    StaticIps List<string>
    Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
    Tags List<MySqlTag>
    Tags are key-value pairs that allow you to categorize services.
    TechEmails List<MySqlTechEmail>
    Defines the email addresses that will receive alerts about upcoming maintenance updates or warnings about service instability.
    TerminationProtection bool
    Prevents the service from being deleted. It is recommended to set this to true for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
    Plan string
    Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are hobbyist, startup-x, business-x and premium-x where x is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.
    Project string
    Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    ServiceName string
    Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
    AdditionalDiskSpace string
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    CloudName string
    Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (aws, azure, do google, upcloud, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS.
    DiskSpace string
    Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.

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

    MaintenanceWindowDow string
    Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
    MaintenanceWindowTime string
    Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
    MysqlUserConfig MySqlMysqlUserConfigArgs
    Mysql user configurable settings
    ProjectVpcId string
    Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
    ServiceIntegrations []MySqlServiceIntegrationArgs
    Service integrations to specify when creating a service. Not applied after initial service creation
    StaticIps []string
    Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
    Tags []MySqlTagArgs
    Tags are key-value pairs that allow you to categorize services.
    TechEmails []MySqlTechEmailArgs
    Defines the email addresses that will receive alerts about upcoming maintenance updates or warnings about service instability.
    TerminationProtection bool
    Prevents the service from being deleted. It is recommended to set this to true for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
    plan String
    Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are hobbyist, startup-x, business-x and premium-x where x is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.
    project String
    Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    serviceName String
    Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
    additionalDiskSpace String
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    cloudName String
    Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (aws, azure, do google, upcloud, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS.
    diskSpace String
    Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.

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

    maintenanceWindowDow String
    Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
    maintenanceWindowTime String
    Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
    mysqlUserConfig MySqlMysqlUserConfig
    Mysql user configurable settings
    projectVpcId String
    Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
    serviceIntegrations List<MySqlServiceIntegration>
    Service integrations to specify when creating a service. Not applied after initial service creation
    staticIps List<String>
    Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
    tags List<MySqlTag>
    Tags are key-value pairs that allow you to categorize services.
    techEmails List<MySqlTechEmail>
    Defines the email addresses that will receive alerts about upcoming maintenance updates or warnings about service instability.
    terminationProtection Boolean
    Prevents the service from being deleted. It is recommended to set this to true for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
    plan string
    Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are hobbyist, startup-x, business-x and premium-x where x is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.
    project string
    Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    serviceName string
    Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
    additionalDiskSpace string
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    cloudName string
    Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (aws, azure, do google, upcloud, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS.
    diskSpace string
    Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.

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

    maintenanceWindowDow string
    Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
    maintenanceWindowTime string
    Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
    mysqlUserConfig MySqlMysqlUserConfig
    Mysql user configurable settings
    projectVpcId string
    Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
    serviceIntegrations MySqlServiceIntegration[]
    Service integrations to specify when creating a service. Not applied after initial service creation
    staticIps string[]
    Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
    tags MySqlTag[]
    Tags are key-value pairs that allow you to categorize services.
    techEmails MySqlTechEmail[]
    Defines the email addresses that will receive alerts about upcoming maintenance updates or warnings about service instability.
    terminationProtection boolean
    Prevents the service from being deleted. It is recommended to set this to true for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
    plan str
    Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are hobbyist, startup-x, business-x and premium-x where x is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.
    project str
    Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    service_name str
    Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
    additional_disk_space str
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    cloud_name str
    Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (aws, azure, do google, upcloud, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS.
    disk_space str
    Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.

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

    maintenance_window_dow str
    Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
    maintenance_window_time str
    Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
    mysql_user_config MySqlMysqlUserConfigArgs
    Mysql user configurable settings
    project_vpc_id str
    Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
    service_integrations Sequence[MySqlServiceIntegrationArgs]
    Service integrations to specify when creating a service. Not applied after initial service creation
    static_ips Sequence[str]
    Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
    tags Sequence[MySqlTagArgs]
    Tags are key-value pairs that allow you to categorize services.
    tech_emails Sequence[MySqlTechEmailArgs]
    Defines the email addresses that will receive alerts about upcoming maintenance updates or warnings about service instability.
    termination_protection bool
    Prevents the service from being deleted. It is recommended to set this to true for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
    plan String
    Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are hobbyist, startup-x, business-x and premium-x where x is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.
    project String
    Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    serviceName String
    Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
    additionalDiskSpace String
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    cloudName String
    Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (aws, azure, do google, upcloud, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS.
    diskSpace String
    Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.

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

    maintenanceWindowDow String
    Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
    maintenanceWindowTime String
    Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
    mysqlUserConfig Property Map
    Mysql user configurable settings
    projectVpcId String
    Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
    serviceIntegrations List<Property Map>
    Service integrations to specify when creating a service. Not applied after initial service creation
    staticIps List<String>
    Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
    tags List<Property Map>
    Tags are key-value pairs that allow you to categorize services.
    techEmails List<Property Map>
    Defines the email addresses that will receive alerts about upcoming maintenance updates or warnings about service instability.
    terminationProtection Boolean
    Prevents the service from being deleted. It is recommended to set this to true for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the MySql resource produces the following output properties:

    Components List<MySqlComponent>
    Service component information objects
    DiskSpaceCap string
    The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
    DiskSpaceDefault string
    The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
    DiskSpaceStep string
    The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_space needs to increment from disk_space_default by increments of this size.
    DiskSpaceUsed string
    Disk space that service is currently using
    Id string
    The provider-assigned unique ID for this managed resource.
    Mysqls List<MySqlMysql>
    MySQL specific server provided values
    ServiceHost string
    The hostname of the service.
    ServicePassword string
    Password used for connecting to the service, if applicable
    ServicePort int
    The port of the service
    ServiceType string
    Aiven internal service type code
    ServiceUri string
    URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
    ServiceUsername string
    Username used for connecting to the service, if applicable
    State string
    Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING
    Components []MySqlComponent
    Service component information objects
    DiskSpaceCap string
    The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
    DiskSpaceDefault string
    The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
    DiskSpaceStep string
    The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_space needs to increment from disk_space_default by increments of this size.
    DiskSpaceUsed string
    Disk space that service is currently using
    Id string
    The provider-assigned unique ID for this managed resource.
    Mysqls []MySqlMysql
    MySQL specific server provided values
    ServiceHost string
    The hostname of the service.
    ServicePassword string
    Password used for connecting to the service, if applicable
    ServicePort int
    The port of the service
    ServiceType string
    Aiven internal service type code
    ServiceUri string
    URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
    ServiceUsername string
    Username used for connecting to the service, if applicable
    State string
    Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING
    components List<MySqlComponent>
    Service component information objects
    diskSpaceCap String
    The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
    diskSpaceDefault String
    The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
    diskSpaceStep String
    The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_space needs to increment from disk_space_default by increments of this size.
    diskSpaceUsed String
    Disk space that service is currently using
    id String
    The provider-assigned unique ID for this managed resource.
    mysqls List<MySqlMysql>
    MySQL specific server provided values
    serviceHost String
    The hostname of the service.
    servicePassword String
    Password used for connecting to the service, if applicable
    servicePort Integer
    The port of the service
    serviceType String
    Aiven internal service type code
    serviceUri String
    URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
    serviceUsername String
    Username used for connecting to the service, if applicable
    state String
    Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING
    components MySqlComponent[]
    Service component information objects
    diskSpaceCap string
    The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
    diskSpaceDefault string
    The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
    diskSpaceStep string
    The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_space needs to increment from disk_space_default by increments of this size.
    diskSpaceUsed string
    Disk space that service is currently using
    id string
    The provider-assigned unique ID for this managed resource.
    mysqls MySqlMysql[]
    MySQL specific server provided values
    serviceHost string
    The hostname of the service.
    servicePassword string
    Password used for connecting to the service, if applicable
    servicePort number
    The port of the service
    serviceType string
    Aiven internal service type code
    serviceUri string
    URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
    serviceUsername string
    Username used for connecting to the service, if applicable
    state string
    Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING
    components Sequence[MySqlComponent]
    Service component information objects
    disk_space_cap str
    The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
    disk_space_default str
    The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
    disk_space_step str
    The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_space needs to increment from disk_space_default by increments of this size.
    disk_space_used str
    Disk space that service is currently using
    id str
    The provider-assigned unique ID for this managed resource.
    mysqls Sequence[MySqlMysql]
    MySQL specific server provided values
    service_host str
    The hostname of the service.
    service_password str
    Password used for connecting to the service, if applicable
    service_port int
    The port of the service
    service_type str
    Aiven internal service type code
    service_uri str
    URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
    service_username str
    Username used for connecting to the service, if applicable
    state str
    Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING
    components List<Property Map>
    Service component information objects
    diskSpaceCap String
    The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
    diskSpaceDefault String
    The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
    diskSpaceStep String
    The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_space needs to increment from disk_space_default by increments of this size.
    diskSpaceUsed String
    Disk space that service is currently using
    id String
    The provider-assigned unique ID for this managed resource.
    mysqls List<Property Map>
    MySQL specific server provided values
    serviceHost String
    The hostname of the service.
    servicePassword String
    Password used for connecting to the service, if applicable
    servicePort Number
    The port of the service
    serviceType String
    Aiven internal service type code
    serviceUri String
    URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
    serviceUsername String
    Username used for connecting to the service, if applicable
    state String
    Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING

    Look up Existing MySql Resource

    Get an existing MySql resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: MySqlState, opts?: CustomResourceOptions): MySql
    @staticmethod
    def get(resource_name: str,
            id: str,
            opts: Optional[ResourceOptions] = None,
            additional_disk_space: Optional[str] = None,
            cloud_name: Optional[str] = None,
            components: Optional[Sequence[MySqlComponentArgs]] = None,
            disk_space: Optional[str] = None,
            disk_space_cap: Optional[str] = None,
            disk_space_default: Optional[str] = None,
            disk_space_step: Optional[str] = None,
            disk_space_used: Optional[str] = None,
            maintenance_window_dow: Optional[str] = None,
            maintenance_window_time: Optional[str] = None,
            mysql_user_config: Optional[MySqlMysqlUserConfigArgs] = None,
            mysqls: Optional[Sequence[MySqlMysqlArgs]] = None,
            plan: Optional[str] = None,
            project: Optional[str] = None,
            project_vpc_id: Optional[str] = None,
            service_host: Optional[str] = None,
            service_integrations: Optional[Sequence[MySqlServiceIntegrationArgs]] = None,
            service_name: Optional[str] = None,
            service_password: Optional[str] = None,
            service_port: Optional[int] = None,
            service_type: Optional[str] = None,
            service_uri: Optional[str] = None,
            service_username: Optional[str] = None,
            state: Optional[str] = None,
            static_ips: Optional[Sequence[str]] = None,
            tags: Optional[Sequence[MySqlTagArgs]] = None,
            tech_emails: Optional[Sequence[MySqlTechEmailArgs]] = None,
            termination_protection: Optional[bool] = None) -> MySql
    func GetMySql(ctx *Context, name string, id IDInput, state *MySqlState, opts ...ResourceOption) (*MySql, error)
    public static MySql Get(string name, Input<string> id, MySqlState? state, CustomResourceOptions? opts = null)
    public static MySql get(String name, Output<String> id, MySqlState state, CustomResourceOptions options)
    Resource lookup is not supported in YAML
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    AdditionalDiskSpace string
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    CloudName string
    Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (aws, azure, do google, upcloud, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS.
    Components List<MySqlComponent>
    Service component information objects
    DiskSpace string
    Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.

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

    DiskSpaceCap string
    The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
    DiskSpaceDefault string
    The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
    DiskSpaceStep string
    The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_space needs to increment from disk_space_default by increments of this size.
    DiskSpaceUsed string
    Disk space that service is currently using
    MaintenanceWindowDow string
    Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
    MaintenanceWindowTime string
    Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
    MysqlUserConfig MySqlMysqlUserConfig
    Mysql user configurable settings
    Mysqls List<MySqlMysql>
    MySQL specific server provided values
    Plan string
    Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are hobbyist, startup-x, business-x and premium-x where x is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.
    Project string
    Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    ProjectVpcId string
    Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
    ServiceHost string
    The hostname of the service.
    ServiceIntegrations List<MySqlServiceIntegration>
    Service integrations to specify when creating a service. Not applied after initial service creation
    ServiceName string
    Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
    ServicePassword string
    Password used for connecting to the service, if applicable
    ServicePort int
    The port of the service
    ServiceType string
    Aiven internal service type code
    ServiceUri string
    URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
    ServiceUsername string
    Username used for connecting to the service, if applicable
    State string
    Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING
    StaticIps List<string>
    Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
    Tags List<MySqlTag>
    Tags are key-value pairs that allow you to categorize services.
    TechEmails List<MySqlTechEmail>
    Defines the email addresses that will receive alerts about upcoming maintenance updates or warnings about service instability.
    TerminationProtection bool
    Prevents the service from being deleted. It is recommended to set this to true for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
    AdditionalDiskSpace string
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    CloudName string
    Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (aws, azure, do google, upcloud, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS.
    Components []MySqlComponentArgs
    Service component information objects
    DiskSpace string
    Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.

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

    DiskSpaceCap string
    The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
    DiskSpaceDefault string
    The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
    DiskSpaceStep string
    The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_space needs to increment from disk_space_default by increments of this size.
    DiskSpaceUsed string
    Disk space that service is currently using
    MaintenanceWindowDow string
    Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
    MaintenanceWindowTime string
    Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
    MysqlUserConfig MySqlMysqlUserConfigArgs
    Mysql user configurable settings
    Mysqls []MySqlMysqlArgs
    MySQL specific server provided values
    Plan string
    Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are hobbyist, startup-x, business-x and premium-x where x is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.
    Project string
    Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    ProjectVpcId string
    Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
    ServiceHost string
    The hostname of the service.
    ServiceIntegrations []MySqlServiceIntegrationArgs
    Service integrations to specify when creating a service. Not applied after initial service creation
    ServiceName string
    Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
    ServicePassword string
    Password used for connecting to the service, if applicable
    ServicePort int
    The port of the service
    ServiceType string
    Aiven internal service type code
    ServiceUri string
    URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
    ServiceUsername string
    Username used for connecting to the service, if applicable
    State string
    Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING
    StaticIps []string
    Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
    Tags []MySqlTagArgs
    Tags are key-value pairs that allow you to categorize services.
    TechEmails []MySqlTechEmailArgs
    Defines the email addresses that will receive alerts about upcoming maintenance updates or warnings about service instability.
    TerminationProtection bool
    Prevents the service from being deleted. It is recommended to set this to true for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
    additionalDiskSpace String
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    cloudName String
    Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (aws, azure, do google, upcloud, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS.
    components List<MySqlComponent>
    Service component information objects
    diskSpace String
    Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.

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

    diskSpaceCap String
    The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
    diskSpaceDefault String
    The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
    diskSpaceStep String
    The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_space needs to increment from disk_space_default by increments of this size.
    diskSpaceUsed String
    Disk space that service is currently using
    maintenanceWindowDow String
    Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
    maintenanceWindowTime String
    Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
    mysqlUserConfig MySqlMysqlUserConfig
    Mysql user configurable settings
    mysqls List<MySqlMysql>
    MySQL specific server provided values
    plan String
    Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are hobbyist, startup-x, business-x and premium-x where x is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.
    project String
    Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    projectVpcId String
    Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
    serviceHost String
    The hostname of the service.
    serviceIntegrations List<MySqlServiceIntegration>
    Service integrations to specify when creating a service. Not applied after initial service creation
    serviceName String
    Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
    servicePassword String
    Password used for connecting to the service, if applicable
    servicePort Integer
    The port of the service
    serviceType String
    Aiven internal service type code
    serviceUri String
    URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
    serviceUsername String
    Username used for connecting to the service, if applicable
    state String
    Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING
    staticIps List<String>
    Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
    tags List<MySqlTag>
    Tags are key-value pairs that allow you to categorize services.
    techEmails List<MySqlTechEmail>
    Defines the email addresses that will receive alerts about upcoming maintenance updates or warnings about service instability.
    terminationProtection Boolean
    Prevents the service from being deleted. It is recommended to set this to true for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
    additionalDiskSpace string
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    cloudName string
    Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (aws, azure, do google, upcloud, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS.
    components MySqlComponent[]
    Service component information objects
    diskSpace string
    Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.

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

    diskSpaceCap string
    The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
    diskSpaceDefault string
    The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
    diskSpaceStep string
    The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_space needs to increment from disk_space_default by increments of this size.
    diskSpaceUsed string
    Disk space that service is currently using
    maintenanceWindowDow string
    Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
    maintenanceWindowTime string
    Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
    mysqlUserConfig MySqlMysqlUserConfig
    Mysql user configurable settings
    mysqls MySqlMysql[]
    MySQL specific server provided values
    plan string
    Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are hobbyist, startup-x, business-x and premium-x where x is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.
    project string
    Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    projectVpcId string
    Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
    serviceHost string
    The hostname of the service.
    serviceIntegrations MySqlServiceIntegration[]
    Service integrations to specify when creating a service. Not applied after initial service creation
    serviceName string
    Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
    servicePassword string
    Password used for connecting to the service, if applicable
    servicePort number
    The port of the service
    serviceType string
    Aiven internal service type code
    serviceUri string
    URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
    serviceUsername string
    Username used for connecting to the service, if applicable
    state string
    Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING
    staticIps string[]
    Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
    tags MySqlTag[]
    Tags are key-value pairs that allow you to categorize services.
    techEmails MySqlTechEmail[]
    Defines the email addresses that will receive alerts about upcoming maintenance updates or warnings about service instability.
    terminationProtection boolean
    Prevents the service from being deleted. It is recommended to set this to true for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
    additional_disk_space str
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    cloud_name str
    Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (aws, azure, do google, upcloud, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS.
    components Sequence[MySqlComponentArgs]
    Service component information objects
    disk_space str
    Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.

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

    disk_space_cap str
    The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
    disk_space_default str
    The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
    disk_space_step str
    The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_space needs to increment from disk_space_default by increments of this size.
    disk_space_used str
    Disk space that service is currently using
    maintenance_window_dow str
    Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
    maintenance_window_time str
    Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
    mysql_user_config MySqlMysqlUserConfigArgs
    Mysql user configurable settings
    mysqls Sequence[MySqlMysqlArgs]
    MySQL specific server provided values
    plan str
    Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are hobbyist, startup-x, business-x and premium-x where x is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.
    project str
    Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    project_vpc_id str
    Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
    service_host str
    The hostname of the service.
    service_integrations Sequence[MySqlServiceIntegrationArgs]
    Service integrations to specify when creating a service. Not applied after initial service creation
    service_name str
    Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
    service_password str
    Password used for connecting to the service, if applicable
    service_port int
    The port of the service
    service_type str
    Aiven internal service type code
    service_uri str
    URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
    service_username str
    Username used for connecting to the service, if applicable
    state str
    Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING
    static_ips Sequence[str]
    Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
    tags Sequence[MySqlTagArgs]
    Tags are key-value pairs that allow you to categorize services.
    tech_emails Sequence[MySqlTechEmailArgs]
    Defines the email addresses that will receive alerts about upcoming maintenance updates or warnings about service instability.
    termination_protection bool
    Prevents the service from being deleted. It is recommended to set this to true for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
    additionalDiskSpace String
    Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
    cloudName String
    Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (aws, azure, do google, upcloud, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS.
    components List<Property Map>
    Service component information objects
    diskSpace String
    Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.

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

    diskSpaceCap String
    The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
    diskSpaceDefault String
    The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for disk_space
    diskSpaceStep String
    The default disk space step of the service, possible values depend on the service type, the cloud provider and the project. disk_space needs to increment from disk_space_default by increments of this size.
    diskSpaceUsed String
    Disk space that service is currently using
    maintenanceWindowDow String
    Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
    maintenanceWindowTime String
    Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
    mysqlUserConfig Property Map
    Mysql user configurable settings
    mysqls List<Property Map>
    MySQL specific server provided values
    plan String
    Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are hobbyist, startup-x, business-x and premium-x where x is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.
    project String
    Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
    projectVpcId String
    Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
    serviceHost String
    The hostname of the service.
    serviceIntegrations List<Property Map>
    Service integrations to specify when creating a service. Not applied after initial service creation
    serviceName String
    Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
    servicePassword String
    Password used for connecting to the service, if applicable
    servicePort Number
    The port of the service
    serviceType String
    Aiven internal service type code
    serviceUri String
    URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
    serviceUsername String
    Username used for connecting to the service, if applicable
    state String
    Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING
    staticIps List<String>
    Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
    tags List<Property Map>
    Tags are key-value pairs that allow you to categorize services.
    techEmails List<Property Map>
    Defines the email addresses that will receive alerts about upcoming maintenance updates or warnings about service instability.
    terminationProtection Boolean
    Prevents the service from being deleted. It is recommended to set this to true for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.

    Supporting Types

    MySqlComponent, MySqlComponentArgs

    Component string
    Service component name
    ConnectionUri string
    Connection info for connecting to the service component. This is a combination of host and port.
    Host string
    Host name for connecting to the service component
    KafkaAuthenticationMethod string
    Kafka authentication method. This is a value specific to the 'kafka' service component
    Port int
    Port number for connecting to the service component
    Route string
    Network access route
    Ssl bool
    Whether the endpoint is encrypted or accepts plaintext. By default endpoints are always encrypted and this property is only included for service components they may disable encryption
    Usage string
    DNS usage name
    Component string
    Service component name
    ConnectionUri string
    Connection info for connecting to the service component. This is a combination of host and port.
    Host string
    Host name for connecting to the service component
    KafkaAuthenticationMethod string
    Kafka authentication method. This is a value specific to the 'kafka' service component
    Port int
    Port number for connecting to the service component
    Route string
    Network access route
    Ssl bool
    Whether the endpoint is encrypted or accepts plaintext. By default endpoints are always encrypted and this property is only included for service components they may disable encryption
    Usage string
    DNS usage name
    component String
    Service component name
    connectionUri String
    Connection info for connecting to the service component. This is a combination of host and port.
    host String
    Host name for connecting to the service component
    kafkaAuthenticationMethod String
    Kafka authentication method. This is a value specific to the 'kafka' service component
    port Integer
    Port number for connecting to the service component
    route String
    Network access route
    ssl Boolean
    Whether the endpoint is encrypted or accepts plaintext. By default endpoints are always encrypted and this property is only included for service components they may disable encryption
    usage String
    DNS usage name
    component string
    Service component name
    connectionUri string
    Connection info for connecting to the service component. This is a combination of host and port.
    host string
    Host name for connecting to the service component
    kafkaAuthenticationMethod string
    Kafka authentication method. This is a value specific to the 'kafka' service component
    port number
    Port number for connecting to the service component
    route string
    Network access route
    ssl boolean
    Whether the endpoint is encrypted or accepts plaintext. By default endpoints are always encrypted and this property is only included for service components they may disable encryption
    usage string
    DNS usage name
    component str
    Service component name
    connection_uri str
    Connection info for connecting to the service component. This is a combination of host and port.
    host str
    Host name for connecting to the service component
    kafka_authentication_method str
    Kafka authentication method. This is a value specific to the 'kafka' service component
    port int
    Port number for connecting to the service component
    route str
    Network access route
    ssl bool
    Whether the endpoint is encrypted or accepts plaintext. By default endpoints are always encrypted and this property is only included for service components they may disable encryption
    usage str
    DNS usage name
    component String
    Service component name
    connectionUri String
    Connection info for connecting to the service component. This is a combination of host and port.
    host String
    Host name for connecting to the service component
    kafkaAuthenticationMethod String
    Kafka authentication method. This is a value specific to the 'kafka' service component
    port Number
    Port number for connecting to the service component
    route String
    Network access route
    ssl Boolean
    Whether the endpoint is encrypted or accepts plaintext. By default endpoints are always encrypted and this property is only included for service components they may disable encryption
    usage String
    DNS usage name

    MySqlMysqlUserConfig, MySqlMysqlUserConfigArgs

    AdditionalBackupRegions string
    Additional Cloud Regions for Backup Replication.
    AdminPassword string
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    AdminUsername string
    Custom username for admin user. This must be set only when a new service is being created.
    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.
    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.
    BinlogRetentionPeriod int
    The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector.
    IpFilterObjects List<MySqlMysqlUserConfigIpFilterObject>
    Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'
    IpFilterStrings List<string>
    Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    IpFilters List<string>
    Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.

    Deprecated:Deprecated. Use ip_filter_string instead.

    Migration MySqlMysqlUserConfigMigration
    Migrate data from existing server
    Mysql MySqlMysqlUserConfigMysql
    mysql.conf configuration values
    MysqlVersion string
    MySQL major version.
    PrivateAccess MySqlMysqlUserConfigPrivateAccess
    Allow access to selected service ports from private networks
    PrivatelinkAccess MySqlMysqlUserConfigPrivatelinkAccess
    Allow access to selected service components through Privatelink
    ProjectToForkFrom string
    Name of another project to fork a service from. This has effect only when a new service is being created.
    PublicAccess MySqlMysqlUserConfigPublicAccess
    Allow access to selected service ports from the public Internet
    RecoveryTargetTime string
    Recovery target time when forking a service. This has effect only when a new service is being created.
    ServiceLog bool
    Store logs for the service so that they are available in the HTTP API and console.
    ServiceToForkFrom string
    Name of another service to fork from. This has effect only when a new service is being created.
    StaticIps bool
    Use static public IP addresses.
    AdditionalBackupRegions string
    Additional Cloud Regions for Backup Replication.
    AdminPassword string
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    AdminUsername string
    Custom username for admin user. This must be set only when a new service is being created.
    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.
    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.
    BinlogRetentionPeriod int
    The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector.
    IpFilterObjects []MySqlMysqlUserConfigIpFilterObject
    Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'
    IpFilterStrings []string
    Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    IpFilters []string
    Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.

    Deprecated:Deprecated. Use ip_filter_string instead.

    Migration MySqlMysqlUserConfigMigration
    Migrate data from existing server
    Mysql MySqlMysqlUserConfigMysql
    mysql.conf configuration values
    MysqlVersion string
    MySQL major version.
    PrivateAccess MySqlMysqlUserConfigPrivateAccess
    Allow access to selected service ports from private networks
    PrivatelinkAccess MySqlMysqlUserConfigPrivatelinkAccess
    Allow access to selected service components through Privatelink
    ProjectToForkFrom string
    Name of another project to fork a service from. This has effect only when a new service is being created.
    PublicAccess MySqlMysqlUserConfigPublicAccess
    Allow access to selected service ports from the public Internet
    RecoveryTargetTime string
    Recovery target time when forking a service. This has effect only when a new service is being created.
    ServiceLog bool
    Store logs for the service so that they are available in the HTTP API and console.
    ServiceToForkFrom string
    Name of another service to fork from. This has effect only when a new service is being created.
    StaticIps bool
    Use static public IP addresses.
    additionalBackupRegions String
    Additional Cloud Regions for Backup Replication.
    adminPassword String
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    adminUsername String
    Custom username for admin user. This must be set only when a new service is being created.
    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.
    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.
    binlogRetentionPeriod Integer
    The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector.
    ipFilterObjects List<MySqlMysqlUserConfigIpFilterObject>
    Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'
    ipFilterStrings List<String>
    Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    ipFilters List<String>
    Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.

    Deprecated:Deprecated. Use ip_filter_string instead.

    migration MySqlMysqlUserConfigMigration
    Migrate data from existing server
    mysql MySqlMysqlUserConfigMysql
    mysql.conf configuration values
    mysqlVersion String
    MySQL major version.
    privateAccess MySqlMysqlUserConfigPrivateAccess
    Allow access to selected service ports from private networks
    privatelinkAccess MySqlMysqlUserConfigPrivatelinkAccess
    Allow access to selected service components through Privatelink
    projectToForkFrom String
    Name of another project to fork a service from. This has effect only when a new service is being created.
    publicAccess MySqlMysqlUserConfigPublicAccess
    Allow access to selected service ports from the public Internet
    recoveryTargetTime String
    Recovery target time when forking a service. This has effect only when a new service is being created.
    serviceLog Boolean
    Store logs for the service so that they are available in the HTTP API and console.
    serviceToForkFrom String
    Name of another service to fork from. This has effect only when a new service is being created.
    staticIps Boolean
    Use static public IP addresses.
    additionalBackupRegions string
    Additional Cloud Regions for Backup Replication.
    adminPassword string
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    adminUsername string
    Custom username for admin user. This must be set only when a new service is being created.
    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.
    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.
    binlogRetentionPeriod number
    The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector.
    ipFilterObjects MySqlMysqlUserConfigIpFilterObject[]
    Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'
    ipFilterStrings string[]
    Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    ipFilters string[]
    Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.

    Deprecated:Deprecated. Use ip_filter_string instead.

    migration MySqlMysqlUserConfigMigration
    Migrate data from existing server
    mysql MySqlMysqlUserConfigMysql
    mysql.conf configuration values
    mysqlVersion string
    MySQL major version.
    privateAccess MySqlMysqlUserConfigPrivateAccess
    Allow access to selected service ports from private networks
    privatelinkAccess MySqlMysqlUserConfigPrivatelinkAccess
    Allow access to selected service components through Privatelink
    projectToForkFrom string
    Name of another project to fork a service from. This has effect only when a new service is being created.
    publicAccess MySqlMysqlUserConfigPublicAccess
    Allow access to selected service ports from the public Internet
    recoveryTargetTime string
    Recovery target time when forking a service. This has effect only when a new service is being created.
    serviceLog boolean
    Store logs for the service so that they are available in the HTTP API and console.
    serviceToForkFrom string
    Name of another service to fork from. This has effect only when a new service is being created.
    staticIps boolean
    Use static public IP addresses.
    additional_backup_regions str
    Additional Cloud Regions for Backup Replication.
    admin_password str
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    admin_username str
    Custom username for admin user. This must be set only when a new service is being created.
    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.
    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.
    binlog_retention_period int
    The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector.
    ip_filter_objects Sequence[MySqlMysqlUserConfigIpFilterObject]
    Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'
    ip_filter_strings Sequence[str]
    Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    ip_filters Sequence[str]
    Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.

    Deprecated:Deprecated. Use ip_filter_string instead.

    migration MySqlMysqlUserConfigMigration
    Migrate data from existing server
    mysql MySqlMysqlUserConfigMysql
    mysql.conf configuration values
    mysql_version str
    MySQL major version.
    private_access MySqlMysqlUserConfigPrivateAccess
    Allow access to selected service ports from private networks
    privatelink_access MySqlMysqlUserConfigPrivatelinkAccess
    Allow access to selected service components through Privatelink
    project_to_fork_from str
    Name of another project to fork a service from. This has effect only when a new service is being created.
    public_access MySqlMysqlUserConfigPublicAccess
    Allow access to selected service ports from the public Internet
    recovery_target_time str
    Recovery target time when forking a service. This has effect only when a new service is being created.
    service_log bool
    Store logs for the service so that they are available in the HTTP API and console.
    service_to_fork_from str
    Name of another service to fork from. This has effect only when a new service is being created.
    static_ips bool
    Use static public IP addresses.
    additionalBackupRegions String
    Additional Cloud Regions for Backup Replication.
    adminPassword String
    Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
    adminUsername String
    Custom username for admin user. This must be set only when a new service is being created.
    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.
    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.
    binlogRetentionPeriod Number
    The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector.
    ipFilterObjects List<Property Map>
    Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'
    ipFilterStrings List<String>
    Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.
    ipFilters List<String>
    Allow incoming connections from CIDR address block, e.g. '10.20.0.0/16'.

    Deprecated:Deprecated. Use ip_filter_string instead.

    migration Property Map
    Migrate data from existing server
    mysql Property Map
    mysql.conf configuration values
    mysqlVersion String
    MySQL major version.
    privateAccess Property Map
    Allow access to selected service ports from private networks
    privatelinkAccess Property Map
    Allow access to selected service components through Privatelink
    projectToForkFrom String
    Name of another project to fork a service from. This has effect only when a new service is being created.
    publicAccess Property Map
    Allow access to selected service ports from the public Internet
    recoveryTargetTime String
    Recovery target time when forking a service. This has effect only when a new service is being created.
    serviceLog Boolean
    Store logs for the service so that they are available in the HTTP API and console.
    serviceToForkFrom String
    Name of another service to fork from. This has effect only when a new service is being created.
    staticIps Boolean
    Use static public IP addresses.

    MySqlMysqlUserConfigIpFilterObject, MySqlMysqlUserConfigIpFilterObjectArgs

    Network string
    CIDR address block.
    Description string
    Description for IP filter list entry.
    Network string
    CIDR address block.
    Description string
    Description for IP filter list entry.
    network String
    CIDR address block.
    description String
    Description for IP filter list entry.
    network string
    CIDR address block.
    description string
    Description for IP filter list entry.
    network str
    CIDR address block.
    description str
    Description for IP filter list entry.
    network String
    CIDR address block.
    description String
    Description for IP filter list entry.

    MySqlMysqlUserConfigMigration, MySqlMysqlUserConfigMigrationArgs

    Host string
    Hostname or IP address of the server where to migrate data from.
    Port int
    Port number of the server where to migrate data from.
    Dbname string
    Database name for bootstrapping the initial connection.
    IgnoreDbs string
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    Method string
    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.
    Ssl bool
    The server where to migrate data from is secured with SSL. The default value is true.
    Username string
    User name for authentication with the server where to migrate data from.
    Host string
    Hostname or IP address of the server where to migrate data from.
    Port int
    Port number of the server where to migrate data from.
    Dbname string
    Database name for bootstrapping the initial connection.
    IgnoreDbs string
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    Method string
    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.
    Ssl bool
    The server where to migrate data from is secured with SSL. The default value is true.
    Username string
    User name for authentication with the server where to migrate data from.
    host String
    Hostname or IP address of the server where to migrate data from.
    port Integer
    Port number of the server where to migrate data from.
    dbname String
    Database name for bootstrapping the initial connection.
    ignoreDbs String
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    method String
    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.
    ssl Boolean
    The server where to migrate data from is secured with SSL. The default value is true.
    username String
    User name for authentication with the server where to migrate data from.
    host string
    Hostname or IP address of the server where to migrate data from.
    port number
    Port number of the server where to migrate data from.
    dbname string
    Database name for bootstrapping the initial connection.
    ignoreDbs string
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    method string
    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.
    ssl boolean
    The server where to migrate data from is secured with SSL. The default value is true.
    username string
    User name for authentication with the server where to migrate data from.
    host str
    Hostname or IP address of the server where to migrate data from.
    port int
    Port number of the server where to migrate data from.
    dbname str
    Database name for bootstrapping the initial connection.
    ignore_dbs str
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    method str
    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.
    ssl bool
    The server where to migrate data from is secured with SSL. The default value is true.
    username str
    User name for authentication with the server where to migrate data from.
    host String
    Hostname or IP address of the server where to migrate data from.
    port Number
    Port number of the server where to migrate data from.
    dbname String
    Database name for bootstrapping the initial connection.
    ignoreDbs String
    Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment).
    method String
    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.
    ssl Boolean
    The server where to migrate data from is secured with SSL. The default value is true.
    username String
    User name for authentication with the server where to migrate data from.

    MySqlMysqlUserConfigMysql, MySqlMysqlUserConfigMysqlArgs

    ConnectTimeout int
    The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
    DefaultTimeZone string
    Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or 'SYSTEM' to use the MySQL server default.
    GroupConcatMaxLen int
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    InformationSchemaStatsExpiry int
    The time, in seconds, before cached statistics expire.
    InnodbChangeBufferMaxSize int
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    InnodbFlushNeighbors int
    Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent.
    InnodbFtMinTokenSize int
    Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service.
    InnodbFtServerStopwordTable string
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
    InnodbLockWaitTimeout int
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    InnodbLogBufferSize int
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    InnodbOnlineAlterLogMaxSize int
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    InnodbPrintAllDeadlocks bool
    When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
    InnodbReadIoThreads int
    The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    InnodbRollbackOnTimeout bool
    When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
    InnodbThreadConcurrency int
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    InnodbWriteIoThreads int
    The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    InteractiveTimeout int
    The number of seconds the server waits for activity on an interactive connection before closing it.
    InternalTmpMemStorageEngine string
    The storage engine for in-memory internal temporary tables.
    LongQueryTime double
    The slow_query_logs work as SQL statements that take more than long_query_time seconds to execute. Default is 10s.
    MaxAllowedPacket int
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    MaxHeapTableSize int
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    NetBufferLength int
    Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service.
    NetReadTimeout int
    The number of seconds to wait for more data from a connection before aborting the read.
    NetWriteTimeout int
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    SlowQueryLog bool
    Slow query log enables capturing of slow queries. Setting slow_query_log to false also truncates the mysql.slow_log table. Default is off.
    SortBufferSize int
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    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.
    SqlRequirePrimaryKey bool
    Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
    TmpTableSize int
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    WaitTimeout int
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    ConnectTimeout int
    The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
    DefaultTimeZone string
    Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or 'SYSTEM' to use the MySQL server default.
    GroupConcatMaxLen int
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    InformationSchemaStatsExpiry int
    The time, in seconds, before cached statistics expire.
    InnodbChangeBufferMaxSize int
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    InnodbFlushNeighbors int
    Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent.
    InnodbFtMinTokenSize int
    Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service.
    InnodbFtServerStopwordTable string
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
    InnodbLockWaitTimeout int
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    InnodbLogBufferSize int
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    InnodbOnlineAlterLogMaxSize int
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    InnodbPrintAllDeadlocks bool
    When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
    InnodbReadIoThreads int
    The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    InnodbRollbackOnTimeout bool
    When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
    InnodbThreadConcurrency int
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    InnodbWriteIoThreads int
    The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    InteractiveTimeout int
    The number of seconds the server waits for activity on an interactive connection before closing it.
    InternalTmpMemStorageEngine string
    The storage engine for in-memory internal temporary tables.
    LongQueryTime float64
    The slow_query_logs work as SQL statements that take more than long_query_time seconds to execute. Default is 10s.
    MaxAllowedPacket int
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    MaxHeapTableSize int
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    NetBufferLength int
    Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service.
    NetReadTimeout int
    The number of seconds to wait for more data from a connection before aborting the read.
    NetWriteTimeout int
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    SlowQueryLog bool
    Slow query log enables capturing of slow queries. Setting slow_query_log to false also truncates the mysql.slow_log table. Default is off.
    SortBufferSize int
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    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.
    SqlRequirePrimaryKey bool
    Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
    TmpTableSize int
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    WaitTimeout int
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    connectTimeout Integer
    The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
    defaultTimeZone String
    Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or 'SYSTEM' to use the MySQL server default.
    groupConcatMaxLen Integer
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    informationSchemaStatsExpiry Integer
    The time, in seconds, before cached statistics expire.
    innodbChangeBufferMaxSize Integer
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    innodbFlushNeighbors Integer
    Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent.
    innodbFtMinTokenSize Integer
    Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service.
    innodbFtServerStopwordTable String
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
    innodbLockWaitTimeout Integer
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    innodbLogBufferSize Integer
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    innodbOnlineAlterLogMaxSize Integer
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    innodbPrintAllDeadlocks Boolean
    When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
    innodbReadIoThreads Integer
    The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    innodbRollbackOnTimeout Boolean
    When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
    innodbThreadConcurrency Integer
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    innodbWriteIoThreads Integer
    The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    interactiveTimeout Integer
    The number of seconds the server waits for activity on an interactive connection before closing it.
    internalTmpMemStorageEngine String
    The storage engine for in-memory internal temporary tables.
    longQueryTime Double
    The slow_query_logs work as SQL statements that take more than long_query_time seconds to execute. Default is 10s.
    maxAllowedPacket Integer
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    maxHeapTableSize Integer
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    netBufferLength Integer
    Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service.
    netReadTimeout Integer
    The number of seconds to wait for more data from a connection before aborting the read.
    netWriteTimeout Integer
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    slowQueryLog Boolean
    Slow query log enables capturing of slow queries. Setting slow_query_log to false also truncates the mysql.slow_log table. Default is off.
    sortBufferSize Integer
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    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.
    sqlRequirePrimaryKey Boolean
    Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
    tmpTableSize Integer
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    waitTimeout Integer
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    connectTimeout number
    The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
    defaultTimeZone string
    Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or 'SYSTEM' to use the MySQL server default.
    groupConcatMaxLen number
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    informationSchemaStatsExpiry number
    The time, in seconds, before cached statistics expire.
    innodbChangeBufferMaxSize number
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    innodbFlushNeighbors number
    Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent.
    innodbFtMinTokenSize number
    Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service.
    innodbFtServerStopwordTable string
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
    innodbLockWaitTimeout number
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    innodbLogBufferSize number
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    innodbOnlineAlterLogMaxSize number
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    innodbPrintAllDeadlocks boolean
    When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
    innodbReadIoThreads number
    The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    innodbRollbackOnTimeout boolean
    When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
    innodbThreadConcurrency number
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    innodbWriteIoThreads number
    The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    interactiveTimeout number
    The number of seconds the server waits for activity on an interactive connection before closing it.
    internalTmpMemStorageEngine string
    The storage engine for in-memory internal temporary tables.
    longQueryTime number
    The slow_query_logs work as SQL statements that take more than long_query_time seconds to execute. Default is 10s.
    maxAllowedPacket number
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    maxHeapTableSize number
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    netBufferLength number
    Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service.
    netReadTimeout number
    The number of seconds to wait for more data from a connection before aborting the read.
    netWriteTimeout number
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    slowQueryLog boolean
    Slow query log enables capturing of slow queries. Setting slow_query_log to false also truncates the mysql.slow_log table. Default is off.
    sortBufferSize number
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    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.
    sqlRequirePrimaryKey boolean
    Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
    tmpTableSize number
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    waitTimeout number
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    connect_timeout int
    The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
    default_time_zone str
    Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or 'SYSTEM' to use the MySQL server default.
    group_concat_max_len int
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    information_schema_stats_expiry int
    The time, in seconds, before cached statistics expire.
    innodb_change_buffer_max_size int
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    innodb_flush_neighbors int
    Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent.
    innodb_ft_min_token_size int
    Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service.
    innodb_ft_server_stopword_table str
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
    innodb_lock_wait_timeout int
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    innodb_log_buffer_size int
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    innodb_online_alter_log_max_size int
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    innodb_print_all_deadlocks bool
    When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
    innodb_read_io_threads int
    The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    innodb_rollback_on_timeout bool
    When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
    innodb_thread_concurrency int
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    innodb_write_io_threads int
    The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    interactive_timeout int
    The number of seconds the server waits for activity on an interactive connection before closing it.
    internal_tmp_mem_storage_engine str
    The storage engine for in-memory internal temporary tables.
    long_query_time float
    The slow_query_logs work as SQL statements that take more than long_query_time seconds to execute. Default is 10s.
    max_allowed_packet int
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    max_heap_table_size int
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    net_buffer_length int
    Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service.
    net_read_timeout int
    The number of seconds to wait for more data from a connection before aborting the read.
    net_write_timeout int
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    slow_query_log bool
    Slow query log enables capturing of slow queries. Setting slow_query_log to false also truncates the mysql.slow_log table. Default is off.
    sort_buffer_size int
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    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.
    sql_require_primary_key bool
    Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
    tmp_table_size int
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    wait_timeout int
    The number of seconds the server waits for activity on a noninteractive connection before closing it.
    connectTimeout Number
    The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake.
    defaultTimeZone String
    Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or 'SYSTEM' to use the MySQL server default.
    groupConcatMaxLen Number
    The maximum permitted result length in bytes for the GROUP_CONCAT() function.
    informationSchemaStatsExpiry Number
    The time, in seconds, before cached statistics expire.
    innodbChangeBufferMaxSize Number
    Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
    innodbFlushNeighbors Number
    Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent.
    innodbFtMinTokenSize Number
    Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service.
    innodbFtServerStopwordTable String
    This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
    innodbLockWaitTimeout Number
    The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
    innodbLogBufferSize Number
    The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
    innodbOnlineAlterLogMaxSize Number
    The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
    innodbPrintAllDeadlocks Boolean
    When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
    innodbReadIoThreads Number
    The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    innodbRollbackOnTimeout Boolean
    When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
    innodbThreadConcurrency Number
    Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
    innodbWriteIoThreads Number
    The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
    interactiveTimeout Number
    The number of seconds the server waits for activity on an interactive connection before closing it.
    internalTmpMemStorageEngine String
    The storage engine for in-memory internal temporary tables.
    longQueryTime Number
    The slow_query_logs work as SQL statements that take more than long_query_time seconds to execute. Default is 10s.
    maxAllowedPacket Number
    Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
    maxHeapTableSize Number
    Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
    netBufferLength Number
    Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service.
    netReadTimeout Number
    The number of seconds to wait for more data from a connection before aborting the read.
    netWriteTimeout Number
    The number of seconds to wait for a block to be written to a connection before aborting the write.
    slowQueryLog Boolean
    Slow query log enables capturing of slow queries. Setting slow_query_log to false also truncates the mysql.slow_log table. Default is off.
    sortBufferSize Number
    Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
    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.
    sqlRequirePrimaryKey Boolean
    Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
    tmpTableSize Number
    Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
    waitTimeout Number
    The number of seconds the server waits for activity on a noninteractive connection before closing it.

    MySqlMysqlUserConfigPrivateAccess, MySqlMysqlUserConfigPrivateAccessArgs

    Mysql bool
    Allow clients to connect to mysql with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
    Mysqlx bool
    Allow clients to connect to mysqlx with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
    Prometheus bool
    Allow clients to connect to prometheus with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
    Mysql bool
    Allow clients to connect to mysql with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
    Mysqlx bool
    Allow clients to connect to mysqlx with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
    Prometheus bool
    Allow clients to connect to prometheus with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
    mysql Boolean
    Allow clients to connect to mysql with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
    mysqlx Boolean
    Allow clients to connect to mysqlx with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
    prometheus Boolean
    Allow clients to connect to prometheus with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
    mysql boolean
    Allow clients to connect to mysql with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
    mysqlx boolean
    Allow clients to connect to mysqlx with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
    prometheus boolean
    Allow clients to connect to prometheus with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
    mysql bool
    Allow clients to connect to mysql with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
    mysqlx bool
    Allow clients to connect to mysqlx with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
    prometheus bool
    Allow clients to connect to prometheus with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
    mysql Boolean
    Allow clients to connect to mysql with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
    mysqlx Boolean
    Allow clients to connect to mysqlx with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.
    prometheus Boolean
    Allow clients to connect to prometheus with a DNS name that always resolves to the service's private IP addresses. Only available in certain network locations.

    MySqlMysqlUserConfigPrivatelinkAccess, MySqlMysqlUserConfigPrivatelinkAccessArgs

    Mysql bool
    Enable mysql.
    Mysqlx bool
    Enable mysqlx.
    Prometheus bool
    Enable prometheus.
    Mysql bool
    Enable mysql.
    Mysqlx bool
    Enable mysqlx.
    Prometheus bool
    Enable prometheus.
    mysql Boolean
    Enable mysql.
    mysqlx Boolean
    Enable mysqlx.
    prometheus Boolean
    Enable prometheus.
    mysql boolean
    Enable mysql.
    mysqlx boolean
    Enable mysqlx.
    prometheus boolean
    Enable prometheus.
    mysql bool
    Enable mysql.
    mysqlx bool
    Enable mysqlx.
    prometheus bool
    Enable prometheus.
    mysql Boolean
    Enable mysql.
    mysqlx Boolean
    Enable mysqlx.
    prometheus Boolean
    Enable prometheus.

    MySqlMysqlUserConfigPublicAccess, MySqlMysqlUserConfigPublicAccessArgs

    Mysql bool
    Allow clients to connect to mysql from the public internet for service nodes that are in a project VPC or another type of private network.
    Mysqlx bool
    Allow clients to connect to mysqlx from the public internet for service nodes that are in a project VPC or another type of private network.
    Prometheus bool
    Allow clients to connect to prometheus from the public internet for service nodes that are in a project VPC or another type of private network.
    Mysql bool
    Allow clients to connect to mysql from the public internet for service nodes that are in a project VPC or another type of private network.
    Mysqlx bool
    Allow clients to connect to mysqlx from the public internet for service nodes that are in a project VPC or another type of private network.
    Prometheus bool
    Allow clients to connect to prometheus from the public internet for service nodes that are in a project VPC or another type of private network.
    mysql Boolean
    Allow clients to connect to mysql from the public internet for service nodes that are in a project VPC or another type of private network.
    mysqlx Boolean
    Allow clients to connect to mysqlx from the public internet for service nodes that are in a project VPC or another type of private network.
    prometheus Boolean
    Allow clients to connect to prometheus from the public internet for service nodes that are in a project VPC or another type of private network.
    mysql boolean
    Allow clients to connect to mysql from the public internet for service nodes that are in a project VPC or another type of private network.
    mysqlx boolean
    Allow clients to connect to mysqlx from the public internet for service nodes that are in a project VPC or another type of private network.
    prometheus boolean
    Allow clients to connect to prometheus from the public internet for service nodes that are in a project VPC or another type of private network.
    mysql bool
    Allow clients to connect to mysql from the public internet for service nodes that are in a project VPC or another type of private network.
    mysqlx bool
    Allow clients to connect to mysqlx from the public internet for service nodes that are in a project VPC or another type of private network.
    prometheus bool
    Allow clients to connect to prometheus from the public internet for service nodes that are in a project VPC or another type of private network.
    mysql Boolean
    Allow clients to connect to mysql from the public internet for service nodes that are in a project VPC or another type of private network.
    mysqlx Boolean
    Allow clients to connect to mysqlx from the public internet for service nodes that are in a project VPC or another type of private network.
    prometheus Boolean
    Allow clients to connect to prometheus from the public internet for service nodes that are in a project VPC or another type of private network.

    MySqlServiceIntegration, MySqlServiceIntegrationArgs

    IntegrationType string
    Type of the service integration. The only supported value at the moment is read_replica
    SourceServiceName string
    Name of the source service
    IntegrationType string
    Type of the service integration. The only supported value at the moment is read_replica
    SourceServiceName string
    Name of the source service
    integrationType String
    Type of the service integration. The only supported value at the moment is read_replica
    sourceServiceName String
    Name of the source service
    integrationType string
    Type of the service integration. The only supported value at the moment is read_replica
    sourceServiceName string
    Name of the source service
    integration_type str
    Type of the service integration. The only supported value at the moment is read_replica
    source_service_name str
    Name of the source service
    integrationType String
    Type of the service integration. The only supported value at the moment is read_replica
    sourceServiceName String
    Name of the source service

    MySqlTag, MySqlTagArgs

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

    MySqlTechEmail, MySqlTechEmailArgs

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

    Import

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

    Package Details

    Repository
    Aiven pulumi/pulumi-aiven
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the aiven Terraform Provider.
    aiven logo
    Aiven v6.13.0 published on Monday, Mar 25, 2024 by Pulumi