Aiven v6.28.0, Nov 15 24

Aiven v6.28.0 published on Friday, Nov 15, 2024 by Pulumi

aiven.getMySql

Explore with Pulumi AI

Aiven v6.28.0 published on Friday, Nov 15, 2024 by Pulumi

Example Usage

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

const mysql1 = aiven.getMySql({
    project: foo.project,
    serviceName: "my-mysql1",
});

import pulumi
import pulumi_aiven as aiven

mysql1 = aiven.get_my_sql(project=foo["project"],
    service_name="my-mysql1")

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.LookupMySql(ctx, &aiven.LookupMySqlArgs{
			Project:     foo.Project,
			ServiceName: "my-mysql1",
		}, nil)
		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 = Aiven.GetMySql.Invoke(new()
    {
        Project = foo.Project,
        ServiceName = "my-mysql1",
    });

});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.aiven.AivenFunctions;
import com.pulumi.aiven.inputs.GetMySqlArgs;
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) {
        final var mysql1 = AivenFunctions.getMySql(GetMySqlArgs.builder()
            .project(foo.project())
            .serviceName("my-mysql1")
            .build());

    }
}

variables:
  mysql1:
    fn::invoke:
      Function: aiven:getMySql
      Arguments:
        project: ${foo.project}
        serviceName: my-mysql1

Using getMySql

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

function getMySql(args: GetMySqlArgs, opts?: InvokeOptions): Promise<GetMySqlResult>
function getMySqlOutput(args: GetMySqlOutputArgs, opts?: InvokeOptions): Output<GetMySqlResult>

def get_my_sql(project: Optional[str] = None,
               service_name: Optional[str] = None,
               opts: Optional[InvokeOptions] = None) -> GetMySqlResult
def get_my_sql_output(project: Optional[pulumi.Input[str]] = None,
               service_name: Optional[pulumi.Input[str]] = None,
               opts: Optional[InvokeOptions] = None) -> Output[GetMySqlResult]

func LookupMySql(ctx *Context, args *LookupMySqlArgs, opts ...InvokeOption) (*LookupMySqlResult, error)
func LookupMySqlOutput(ctx *Context, args *LookupMySqlOutputArgs, opts ...InvokeOption) LookupMySqlResultOutput

> Note: This function is named LookupMySql in the Go SDK.

public static class GetMySql 
{
    public static Task<GetMySqlResult> InvokeAsync(GetMySqlArgs args, InvokeOptions? opts = null)
    public static Output<GetMySqlResult> Invoke(GetMySqlInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetMySqlResult> getMySql(GetMySqlArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet

fn::invoke:
  function: aiven:index/getMySql:getMySql
  arguments:
    # arguments dictionary

The following arguments are supported:

Project string: The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
ServiceName string: Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.

Project string: The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
ServiceName string: Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.

project String: The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
serviceName String: Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.

project string: The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
serviceName string: Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.

project str: The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
service_name str: Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.

project String: The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
serviceName String: Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.

getMySql Result

The following output properties are available:

AdditionalDiskSpace string: Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart and there might be a short downtime for services with no HA capabilities.
CloudName string: Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (aws, azure, do google, upcloud, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS.
Components List<GetMySqlComponent>: 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.
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.
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.
MysqlUserConfigs List<GetMySqlMysqlUserConfig>: Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
Mysqls List<GetMySqlMysql>: 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 seen from the Aiven pricing page.
Project string: The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
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<GetMySqlServiceIntegration>: 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<GetMySqlTag>: Tags are key-value pairs that allow you to categorize services.
TechEmails List<GetMySqlTechEmail>: The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
TerminationProtection bool: Prevents the service from being deleted. It is recommended to set this to true for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.

AdditionalDiskSpace string: Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart and there might be a short downtime for services with no HA capabilities.
CloudName string: Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (aws, azure, do google, upcloud, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS.
Components []GetMySqlComponent: 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.
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.
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.
MysqlUserConfigs []GetMySqlMysqlUserConfig: Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
Mysqls []GetMySqlMysql: 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 seen from the Aiven pricing page.
Project string: The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
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 []GetMySqlServiceIntegration: 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 []GetMySqlTag: Tags are key-value pairs that allow you to categorize services.
TechEmails []GetMySqlTechEmail: The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
TerminationProtection bool: Prevents the service from being deleted. It is recommended to set this to true for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.

additionalDiskSpace String: Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart and there might be a short downtime for services with no HA capabilities.
cloudName String: Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (aws, azure, do google, upcloud, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS.
components List<GetMySqlComponent>: 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.
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.
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.
mysqlUserConfigs List<GetMySqlMysqlUserConfig>: Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
mysqls List<GetMySqlMysql>: 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 seen from the Aiven pricing page.
project String: The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
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<GetMySqlServiceIntegration>: 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<GetMySqlTag>: Tags are key-value pairs that allow you to categorize services.
techEmails List<GetMySqlTechEmail>: The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
terminationProtection Boolean: Prevents the service from being deleted. It is recommended to set this to true for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.

additionalDiskSpace string: Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart and there might be a short downtime for services with no HA capabilities.
cloudName string: Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (aws, azure, do google, upcloud, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS.
components GetMySqlComponent[]: 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.
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.
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.
mysqlUserConfigs GetMySqlMysqlUserConfig[]: Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
mysqls GetMySqlMysql[]: 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 seen from the Aiven pricing page.
project string: The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
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 GetMySqlServiceIntegration[]: 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 GetMySqlTag[]: Tags are key-value pairs that allow you to categorize services.
techEmails GetMySqlTechEmail[]: The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
terminationProtection boolean: Prevents the service from being deleted. It is recommended to set this to true for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.

additional_disk_space str: Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart and there might be a short downtime for services with no HA capabilities.
cloud_name str: Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (aws, azure, do google, upcloud, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS.
components Sequence[GetMySqlComponent]: Service component information objects
disk_space str: Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
disk_space_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.
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_configs Sequence[GetMySqlMysqlUserConfig]: Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
mysqls Sequence[GetMySqlMysql]: 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 seen from the Aiven pricing page.
project str: The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
project_vpc_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[GetMySqlServiceIntegration]: 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[GetMySqlTag]: Tags are key-value pairs that allow you to categorize services.
tech_emails Sequence[GetMySqlTechEmail]: The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
termination_protection bool: Prevents the service from being deleted. It is recommended to set this to true for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.

additionalDiskSpace String: Add disk storage in increments of 30 GiB to scale your service. The maximum value depends on the service type and cloud provider. Removing additional storage causes the service nodes to go through a rolling restart and there might be a short downtime for services with no HA capabilities.
cloudName String: Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (aws, azure, do google, upcloud, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS.
components List<Property Map>: Service component information objects
diskSpace String: Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
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.
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.
mysqlUserConfigs List<Property Map>: Mysql user configurable settings. Warning: There's no way to reset advanced configuration options to default. Options that you add cannot be removed later
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 seen from the Aiven pricing page.
project String: The name of the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. Changing this property forces recreation of the resource.
projectVpcId String: Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
serviceHost String: The hostname of the service.
serviceIntegrations List<Property Map>: Service integrations to specify when creating a service. Not applied after initial service creation
serviceName String: Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
servicePassword String: Password used for connecting to the service, if applicable
servicePort Number: The port of the service
serviceType String: Aiven internal service type code
serviceUri String: URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
serviceUsername String: Username used for connecting to the service, if applicable
state String: Service state. One of POWEROFF, REBALANCING, REBUILDING or RUNNING
staticIps List<String>: Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
tags List<Property Map>: Tags are key-value pairs that allow you to categorize services.
techEmails List<Property Map>: The email addresses for service contacts, who will receive important alerts and updates about this service. You can also set email contacts at the project level.
terminationProtection Boolean: Prevents the service from being deleted. It is recommended to set this to true for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.

Supporting Types

GetMySqlComponent

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

GetMySqlMysql

Params List<GetMySqlMysqlParam>: MySQL connection parameters
ReplicaUri string: MySQL replica URI for services with a replica
StandbyUris List<string>: MySQL standby connection URIs
SyncingUris List<string>: MySQL syncing connection URIs
Uris List<string>: MySQL master connection URIs

Params []GetMySqlMysqlParam: MySQL connection parameters
ReplicaUri string: MySQL replica URI for services with a replica
StandbyUris []string: MySQL standby connection URIs
SyncingUris []string: MySQL syncing connection URIs
Uris []string: MySQL master connection URIs

params List<GetMySqlMysqlParam>: MySQL connection parameters
replicaUri String: MySQL replica URI for services with a replica
standbyUris List<String>: MySQL standby connection URIs
syncingUris List<String>: MySQL syncing connection URIs
uris List<String>: MySQL master connection URIs

params GetMySqlMysqlParam[]: MySQL connection parameters
replicaUri string: MySQL replica URI for services with a replica
standbyUris string[]: MySQL standby connection URIs
syncingUris string[]: MySQL syncing connection URIs
uris string[]: MySQL master connection URIs

params Sequence[GetMySqlMysqlParam]: MySQL connection parameters
replica_uri str: MySQL replica URI for services with a replica
standby_uris Sequence[str]: MySQL standby connection URIs
syncing_uris Sequence[str]: MySQL syncing connection URIs
uris Sequence[str]: MySQL master connection URIs

params List<Property Map>: MySQL connection parameters
replicaUri String: MySQL replica URI for services with a replica
standbyUris List<String>: MySQL standby connection URIs
syncingUris List<String>: MySQL syncing connection URIs
uris List<String>: MySQL master connection URIs

GetMySqlMysqlParam

DatabaseName string: Primary MySQL database name
Host string: MySQL host IP or name
Password string: MySQL admin user password
Port int: MySQL port
Sslmode string: MySQL sslmode setting (currently always "require")
User string: MySQL admin user name

DatabaseName string: Primary MySQL database name
Host string: MySQL host IP or name
Password string: MySQL admin user password
Port int: MySQL port
Sslmode string: MySQL sslmode setting (currently always "require")
User string: MySQL admin user name

databaseName String: Primary MySQL database name
host String: MySQL host IP or name
password String: MySQL admin user password
port Integer: MySQL port
sslmode String: MySQL sslmode setting (currently always "require")
user String: MySQL admin user name

databaseName string: Primary MySQL database name
host string: MySQL host IP or name
password string: MySQL admin user password
port number: MySQL port
sslmode string: MySQL sslmode setting (currently always "require")
user string: MySQL admin user name

database_name str: Primary MySQL database name
host str: MySQL host IP or name
password str: MySQL admin user password
port int: MySQL port
sslmode str: MySQL sslmode setting (currently always "require")
user str: MySQL admin user name

databaseName String: Primary MySQL database name
host String: MySQL host IP or name
password String: MySQL admin user password
port Number: MySQL port
sslmode String: MySQL sslmode setting (currently always "require")
user String: MySQL admin user name

GetMySqlMysqlUserConfig

AdditionalBackupRegions string: Additional Cloud Regions for Backup Replication.
AdminPassword string: Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
AdminUsername string: Custom username for admin user. This must be set only when a new service is being created. Example: avnadmin.
BackupHour int: The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed. Example: 3.
BackupMinute int: The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed. Example: 30.
BinlogRetentionPeriod int: The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector. Example: 600.
IpFilterObjects List<GetMySqlMysqlUserConfigIpFilterObject>: 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 GetMySqlMysqlUserConfigMigration: Migrate data from existing server
Mysql GetMySqlMysqlUserConfigMysql: mysql.conf configuration values
MysqlVersion string: Enum: 8, and newer. MySQL major version.
PrivateAccess GetMySqlMysqlUserConfigPrivateAccess: Allow access to selected service ports from private networks
PrivatelinkAccess GetMySqlMysqlUserConfigPrivatelinkAccess: Allow access to selected service components through Privatelink
ProjectToForkFrom string: Name of another project to fork a service from. This has effect only when a new service is being created. Example: anotherprojectname.
PublicAccess GetMySqlMysqlUserConfigPublicAccess: Allow access to selected service ports from the public Internet
RecoveryTargetTime string: Recovery target time when forking a service. This has effect only when a new service is being created. Example: 2019-01-01 23:34:45.
ServiceLog bool: Store logs for the service so that they are available in the HTTP API and console.
ServiceToForkFrom string: Name of another service to fork from. This has effect only when a new service is being created. Example: anotherservicename.
StaticIps bool: Use static public IP addresses.

AdditionalBackupRegions string: Additional Cloud Regions for Backup Replication.
AdminPassword string: Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
AdminUsername string: Custom username for admin user. This must be set only when a new service is being created. Example: avnadmin.
BackupHour int: The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed. Example: 3.
BackupMinute int: The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed. Example: 30.
BinlogRetentionPeriod int: The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector. Example: 600.
IpFilterObjects []GetMySqlMysqlUserConfigIpFilterObject: 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 GetMySqlMysqlUserConfigMigration: Migrate data from existing server
Mysql GetMySqlMysqlUserConfigMysql: mysql.conf configuration values
MysqlVersion string: Enum: 8, and newer. MySQL major version.
PrivateAccess GetMySqlMysqlUserConfigPrivateAccess: Allow access to selected service ports from private networks
PrivatelinkAccess GetMySqlMysqlUserConfigPrivatelinkAccess: Allow access to selected service components through Privatelink
ProjectToForkFrom string: Name of another project to fork a service from. This has effect only when a new service is being created. Example: anotherprojectname.
PublicAccess GetMySqlMysqlUserConfigPublicAccess: Allow access to selected service ports from the public Internet
RecoveryTargetTime string: Recovery target time when forking a service. This has effect only when a new service is being created. Example: 2019-01-01 23:34:45.
ServiceLog bool: Store logs for the service so that they are available in the HTTP API and console.
ServiceToForkFrom string: Name of another service to fork from. This has effect only when a new service is being created. Example: anotherservicename.
StaticIps bool: Use static public IP addresses.

additionalBackupRegions String: Additional Cloud Regions for Backup Replication.
adminPassword String: Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
adminUsername String: Custom username for admin user. This must be set only when a new service is being created. Example: avnadmin.
backupHour Integer: The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed. Example: 3.
backupMinute Integer: The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed. Example: 30.
binlogRetentionPeriod Integer: The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector. Example: 600.
ipFilterObjects List<GetMySqlMysqlUserConfigIpFilterObject>: 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 GetMySqlMysqlUserConfigMigration: Migrate data from existing server
mysql GetMySqlMysqlUserConfigMysql: mysql.conf configuration values
mysqlVersion String: Enum: 8, and newer. MySQL major version.
privateAccess GetMySqlMysqlUserConfigPrivateAccess: Allow access to selected service ports from private networks
privatelinkAccess GetMySqlMysqlUserConfigPrivatelinkAccess: Allow access to selected service components through Privatelink
projectToForkFrom String: Name of another project to fork a service from. This has effect only when a new service is being created. Example: anotherprojectname.
publicAccess GetMySqlMysqlUserConfigPublicAccess: Allow access to selected service ports from the public Internet
recoveryTargetTime String: Recovery target time when forking a service. This has effect only when a new service is being created. Example: 2019-01-01 23:34:45.
serviceLog Boolean: Store logs for the service so that they are available in the HTTP API and console.
serviceToForkFrom String: Name of another service to fork from. This has effect only when a new service is being created. Example: anotherservicename.
staticIps Boolean: Use static public IP addresses.

additionalBackupRegions string: Additional Cloud Regions for Backup Replication.
adminPassword string: Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
adminUsername string: Custom username for admin user. This must be set only when a new service is being created. Example: avnadmin.
backupHour number: The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed. Example: 3.
backupMinute number: The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed. Example: 30.
binlogRetentionPeriod number: The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector. Example: 600.
ipFilterObjects GetMySqlMysqlUserConfigIpFilterObject[]: 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 GetMySqlMysqlUserConfigMigration: Migrate data from existing server
mysql GetMySqlMysqlUserConfigMysql: mysql.conf configuration values
mysqlVersion string: Enum: 8, and newer. MySQL major version.
privateAccess GetMySqlMysqlUserConfigPrivateAccess: Allow access to selected service ports from private networks
privatelinkAccess GetMySqlMysqlUserConfigPrivatelinkAccess: Allow access to selected service components through Privatelink
projectToForkFrom string: Name of another project to fork a service from. This has effect only when a new service is being created. Example: anotherprojectname.
publicAccess GetMySqlMysqlUserConfigPublicAccess: Allow access to selected service ports from the public Internet
recoveryTargetTime string: Recovery target time when forking a service. This has effect only when a new service is being created. Example: 2019-01-01 23:34:45.
serviceLog boolean: Store logs for the service so that they are available in the HTTP API and console.
serviceToForkFrom string: Name of another service to fork from. This has effect only when a new service is being created. Example: anotherservicename.
staticIps boolean: Use static public IP addresses.

additional_backup_regions str: Additional Cloud Regions for Backup Replication.
admin_password str: Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
admin_username str: Custom username for admin user. This must be set only when a new service is being created. Example: avnadmin.
backup_hour int: The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed. Example: 3.
backup_minute int: The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed. Example: 30.
binlog_retention_period int: The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector. Example: 600.
ip_filter_objects Sequence[GetMySqlMysqlUserConfigIpFilterObject]: 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 GetMySqlMysqlUserConfigMigration: Migrate data from existing server
mysql GetMySqlMysqlUserConfigMysql: mysql.conf configuration values
mysql_version str: Enum: 8, and newer. MySQL major version.
private_access GetMySqlMysqlUserConfigPrivateAccess: Allow access to selected service ports from private networks
privatelink_access GetMySqlMysqlUserConfigPrivatelinkAccess: Allow access to selected service components through Privatelink
project_to_fork_from str: Name of another project to fork a service from. This has effect only when a new service is being created. Example: anotherprojectname.
public_access GetMySqlMysqlUserConfigPublicAccess: Allow access to selected service ports from the public Internet
recovery_target_time str: Recovery target time when forking a service. This has effect only when a new service is being created. Example: 2019-01-01 23:34:45.
service_log bool: Store logs for the service so that they are available in the HTTP API and console.
service_to_fork_from str: Name of another service to fork from. This has effect only when a new service is being created. Example: anotherservicename.
static_ips bool: Use static public IP addresses.

additionalBackupRegions String: Additional Cloud Regions for Backup Replication.
adminPassword String: Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
adminUsername String: Custom username for admin user. This must be set only when a new service is being created. Example: avnadmin.
backupHour Number: The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed. Example: 3.
backupMinute Number: The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed. Example: 30.
binlogRetentionPeriod Number: The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default for example if using the MySQL Debezium Kafka connector. Example: 600.
ipFilterObjects List<Property Map>: Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16
ipFilterStrings List<String>: Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16.
ipFilters List<String>: Allow incoming connections from CIDR address block, e.g. 10.20.0.0/16.
Deprecated: Deprecated. Use ip_filter_string instead.
migration Property Map: Migrate data from existing server
mysql Property Map: mysql.conf configuration values
mysqlVersion String: Enum: 8, and newer. MySQL major version.
privateAccess Property Map: Allow access to selected service ports from private networks
privatelinkAccess Property Map: Allow access to selected service components through Privatelink
projectToForkFrom String: Name of another project to fork a service from. This has effect only when a new service is being created. Example: anotherprojectname.
publicAccess Property Map: Allow access to selected service ports from the public Internet
recoveryTargetTime String: Recovery target time when forking a service. This has effect only when a new service is being created. Example: 2019-01-01 23:34:45.
serviceLog Boolean: Store logs for the service so that they are available in the HTTP API and console.
serviceToForkFrom String: Name of another service to fork from. This has effect only when a new service is being created. Example: anotherservicename.
staticIps Boolean: Use static public IP addresses.

GetMySqlMysqlUserConfigIpFilterObject

Network string: CIDR address block. Example: 10.20.0.0/16.
Description string: Description for IP filter list entry. Example: Production service IP range.

Network string: CIDR address block. Example: 10.20.0.0/16.
Description string: Description for IP filter list entry. Example: Production service IP range.

network String: CIDR address block. Example: 10.20.0.0/16.
description String: Description for IP filter list entry. Example: Production service IP range.

network string: CIDR address block. Example: 10.20.0.0/16.
description string: Description for IP filter list entry. Example: Production service IP range.

network str: CIDR address block. Example: 10.20.0.0/16.
description str: Description for IP filter list entry. Example: Production service IP range.

network String: CIDR address block. Example: 10.20.0.0/16.
description String: Description for IP filter list entry. Example: Production service IP range.

GetMySqlMysqlUserConfigMigration

Host string: Hostname or IP address of the server where to migrate data from. Example: my.server.com.
Port int: Port number of the server where to migrate data from. Example: 1234.
Dbname string: Database name for bootstrapping the initial connection. Example: defaultdb.
IgnoreDbs string: Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment). Example: db1,db2.
IgnoreRoles string: Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment). Example: role1,role2.
Method string: Enum: dump, replication. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
Password string: Password for authentication with the server where to migrate data from. Example: jjKk45Nnd.
Ssl bool: The server where to migrate data from is secured with SSL. Default: true.
Username string: User name for authentication with the server where to migrate data from. Example: myname.

Host string: Hostname or IP address of the server where to migrate data from. Example: my.server.com.
Port int: Port number of the server where to migrate data from. Example: 1234.
Dbname string: Database name for bootstrapping the initial connection. Example: defaultdb.
IgnoreDbs string: Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment). Example: db1,db2.
IgnoreRoles string: Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment). Example: role1,role2.
Method string: Enum: dump, replication. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
Password string: Password for authentication with the server where to migrate data from. Example: jjKk45Nnd.
Ssl bool: The server where to migrate data from is secured with SSL. Default: true.
Username string: User name for authentication with the server where to migrate data from. Example: myname.

host String: Hostname or IP address of the server where to migrate data from. Example: my.server.com.
port Integer: Port number of the server where to migrate data from. Example: 1234.
dbname String: Database name for bootstrapping the initial connection. Example: defaultdb.
ignoreDbs String: Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment). Example: db1,db2.
ignoreRoles String: Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment). Example: role1,role2.
method String: Enum: dump, replication. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
password String: Password for authentication with the server where to migrate data from. Example: jjKk45Nnd.
ssl Boolean: The server where to migrate data from is secured with SSL. Default: true.
username String: User name for authentication with the server where to migrate data from. Example: myname.

host string: Hostname or IP address of the server where to migrate data from. Example: my.server.com.
port number: Port number of the server where to migrate data from. Example: 1234.
dbname string: Database name for bootstrapping the initial connection. Example: defaultdb.
ignoreDbs string: Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment). Example: db1,db2.
ignoreRoles string: Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment). Example: role1,role2.
method string: Enum: dump, replication. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
password string: Password for authentication with the server where to migrate data from. Example: jjKk45Nnd.
ssl boolean: The server where to migrate data from is secured with SSL. Default: true.
username string: User name for authentication with the server where to migrate data from. Example: myname.

host str: Hostname or IP address of the server where to migrate data from. Example: my.server.com.
port int: Port number of the server where to migrate data from. Example: 1234.
dbname str: Database name for bootstrapping the initial connection. Example: defaultdb.
ignore_dbs str: Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment). Example: db1,db2.
ignore_roles str: Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment). Example: role1,role2.
method str: Enum: dump, replication. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
password str: Password for authentication with the server where to migrate data from. Example: jjKk45Nnd.
ssl bool: The server where to migrate data from is secured with SSL. Default: true.
username str: User name for authentication with the server where to migrate data from. Example: myname.

host String: Hostname or IP address of the server where to migrate data from. Example: my.server.com.
port Number: Port number of the server where to migrate data from. Example: 1234.
dbname String: Database name for bootstrapping the initial connection. Example: defaultdb.
ignoreDbs String: Comma-separated list of databases, which should be ignored during migration (supported by MySQL and PostgreSQL only at the moment). Example: db1,db2.
ignoreRoles String: Comma-separated list of database roles, which should be ignored during migration (supported by PostgreSQL only at the moment). Example: role1,role2.
method String: Enum: dump, replication. The migration method to be used (currently supported only by Redis, Dragonfly, MySQL and PostgreSQL service types).
password String: Password for authentication with the server where to migrate data from. Example: jjKk45Nnd.
ssl Boolean: The server where to migrate data from is secured with SSL. Default: true.
username String: User name for authentication with the server where to migrate data from. Example: myname.

GetMySqlMysqlUserConfigMysql

ConnectTimeout int: The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake. Example: 10.
DefaultTimeZone string: Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or SYSTEM to use the MySQL server default. Example: +03:00.
GroupConcatMaxLen int: The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example: 1024.
InformationSchemaStatsExpiry int: The time, in seconds, before cached statistics expire. Example: 86400.
InnodbChangeBufferMaxSize int: Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example: 30.
InnodbFlushNeighbors int: Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent. Example: 0.
InnodbFtMinTokenSize int: Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service. Example: 3.
InnodbFtServerStopwordTable string: This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example: db_name/table_name.
InnodbLockWaitTimeout int: The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example: 50.
InnodbLogBufferSize int: The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example: 16777216.
InnodbOnlineAlterLogMaxSize int: The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example: 134217728.
InnodbPrintAllDeadlocks bool: When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
InnodbReadIoThreads int: The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
InnodbRollbackOnTimeout bool: When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
InnodbThreadConcurrency int: Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example: 10.
InnodbWriteIoThreads int: The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
InteractiveTimeout int: The number of seconds the server waits for activity on an interactive connection before closing it. Example: 3600.
InternalTmpMemStorageEngine string: Enum: MEMORY, TempTable. The storage engine for in-memory internal temporary tables.
LogOutput string: Enum: INSIGHTS, INSIGHTS,TABLE, NONE, TABLE. The slow log output destination when slow_query_log is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slow_log table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slow_log table, choose TABLE. To silence slow logs, choose NONE.
LongQueryTime double: The slow_query_logs work as SQL statements that take more than long_query_time seconds to execute. Example: 10.0.
MaxAllowedPacket int: Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example: 67108864.
MaxHeapTableSize int: Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M). Example: 16777216.
NetBufferLength int: Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service. Example: 16384.
NetReadTimeout int: The number of seconds to wait for more data from a connection before aborting the read. Example: 30.
NetWriteTimeout int: The number of seconds to wait for a block to be written to a connection before aborting the write. Example: 30.
SlowQueryLog bool: Slow query log enables capturing of slow queries. Setting slow_query_log to false also truncates the mysql.slow_log table.
SortBufferSize int: Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K). Example: 262144.
SqlMode string: Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned. Example: ANSI,TRADITIONAL.
SqlRequirePrimaryKey bool: Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
TmpTableSize int: Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M). Example: 16777216.
WaitTimeout int: The number of seconds the server waits for activity on a noninteractive connection before closing it. Example: 28800.

ConnectTimeout int: The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake. Example: 10.
DefaultTimeZone string: Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or SYSTEM to use the MySQL server default. Example: +03:00.
GroupConcatMaxLen int: The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example: 1024.
InformationSchemaStatsExpiry int: The time, in seconds, before cached statistics expire. Example: 86400.
InnodbChangeBufferMaxSize int: Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example: 30.
InnodbFlushNeighbors int: Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent. Example: 0.
InnodbFtMinTokenSize int: Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service. Example: 3.
InnodbFtServerStopwordTable string: This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example: db_name/table_name.
InnodbLockWaitTimeout int: The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example: 50.
InnodbLogBufferSize int: The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example: 16777216.
InnodbOnlineAlterLogMaxSize int: The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example: 134217728.
InnodbPrintAllDeadlocks bool: When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
InnodbReadIoThreads int: The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
InnodbRollbackOnTimeout bool: When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
InnodbThreadConcurrency int: Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example: 10.
InnodbWriteIoThreads int: The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
InteractiveTimeout int: The number of seconds the server waits for activity on an interactive connection before closing it. Example: 3600.
InternalTmpMemStorageEngine string: Enum: MEMORY, TempTable. The storage engine for in-memory internal temporary tables.
LogOutput string: Enum: INSIGHTS, INSIGHTS,TABLE, NONE, TABLE. The slow log output destination when slow_query_log is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slow_log table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slow_log table, choose TABLE. To silence slow logs, choose NONE.
LongQueryTime float64: The slow_query_logs work as SQL statements that take more than long_query_time seconds to execute. Example: 10.0.
MaxAllowedPacket int: Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example: 67108864.
MaxHeapTableSize int: Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M). Example: 16777216.
NetBufferLength int: Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service. Example: 16384.
NetReadTimeout int: The number of seconds to wait for more data from a connection before aborting the read. Example: 30.
NetWriteTimeout int: The number of seconds to wait for a block to be written to a connection before aborting the write. Example: 30.
SlowQueryLog bool: Slow query log enables capturing of slow queries. Setting slow_query_log to false also truncates the mysql.slow_log table.
SortBufferSize int: Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K). Example: 262144.
SqlMode string: Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned. Example: ANSI,TRADITIONAL.
SqlRequirePrimaryKey bool: Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
TmpTableSize int: Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M). Example: 16777216.
WaitTimeout int: The number of seconds the server waits for activity on a noninteractive connection before closing it. Example: 28800.

connectTimeout Integer: The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake. Example: 10.
defaultTimeZone String: Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or SYSTEM to use the MySQL server default. Example: +03:00.
groupConcatMaxLen Integer: The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example: 1024.
informationSchemaStatsExpiry Integer: The time, in seconds, before cached statistics expire. Example: 86400.
innodbChangeBufferMaxSize Integer: Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example: 30.
innodbFlushNeighbors Integer: Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent. Example: 0.
innodbFtMinTokenSize Integer: Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service. Example: 3.
innodbFtServerStopwordTable String: This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example: db_name/table_name.
innodbLockWaitTimeout Integer: The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example: 50.
innodbLogBufferSize Integer: The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example: 16777216.
innodbOnlineAlterLogMaxSize Integer: The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example: 134217728.
innodbPrintAllDeadlocks Boolean: When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
innodbReadIoThreads Integer: The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
innodbRollbackOnTimeout Boolean: When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
innodbThreadConcurrency Integer: Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example: 10.
innodbWriteIoThreads Integer: The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
interactiveTimeout Integer: The number of seconds the server waits for activity on an interactive connection before closing it. Example: 3600.
internalTmpMemStorageEngine String: Enum: MEMORY, TempTable. The storage engine for in-memory internal temporary tables.
logOutput String: Enum: INSIGHTS, INSIGHTS,TABLE, NONE, TABLE. The slow log output destination when slow_query_log is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slow_log table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slow_log table, choose TABLE. To silence slow logs, choose NONE.
longQueryTime Double: The slow_query_logs work as SQL statements that take more than long_query_time seconds to execute. Example: 10.0.
maxAllowedPacket Integer: Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example: 67108864.
maxHeapTableSize Integer: Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M). Example: 16777216.
netBufferLength Integer: Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service. Example: 16384.
netReadTimeout Integer: The number of seconds to wait for more data from a connection before aborting the read. Example: 30.
netWriteTimeout Integer: The number of seconds to wait for a block to be written to a connection before aborting the write. Example: 30.
slowQueryLog Boolean: Slow query log enables capturing of slow queries. Setting slow_query_log to false also truncates the mysql.slow_log table.
sortBufferSize Integer: Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K). Example: 262144.
sqlMode String: Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned. Example: ANSI,TRADITIONAL.
sqlRequirePrimaryKey Boolean: Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
tmpTableSize Integer: Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M). Example: 16777216.
waitTimeout Integer: The number of seconds the server waits for activity on a noninteractive connection before closing it. Example: 28800.

connectTimeout number: The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake. Example: 10.
defaultTimeZone string: Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or SYSTEM to use the MySQL server default. Example: +03:00.
groupConcatMaxLen number: The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example: 1024.
informationSchemaStatsExpiry number: The time, in seconds, before cached statistics expire. Example: 86400.
innodbChangeBufferMaxSize number: Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example: 30.
innodbFlushNeighbors number: Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent. Example: 0.
innodbFtMinTokenSize number: Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service. Example: 3.
innodbFtServerStopwordTable string: This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example: db_name/table_name.
innodbLockWaitTimeout number: The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example: 50.
innodbLogBufferSize number: The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example: 16777216.
innodbOnlineAlterLogMaxSize number: The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example: 134217728.
innodbPrintAllDeadlocks boolean: When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
innodbReadIoThreads number: The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
innodbRollbackOnTimeout boolean: When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
innodbThreadConcurrency number: Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example: 10.
innodbWriteIoThreads number: The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
interactiveTimeout number: The number of seconds the server waits for activity on an interactive connection before closing it. Example: 3600.
internalTmpMemStorageEngine string: Enum: MEMORY, TempTable. The storage engine for in-memory internal temporary tables.
logOutput string: Enum: INSIGHTS, INSIGHTS,TABLE, NONE, TABLE. The slow log output destination when slow_query_log is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slow_log table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slow_log table, choose TABLE. To silence slow logs, choose NONE.
longQueryTime number: The slow_query_logs work as SQL statements that take more than long_query_time seconds to execute. Example: 10.0.
maxAllowedPacket number: Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example: 67108864.
maxHeapTableSize number: Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M). Example: 16777216.
netBufferLength number: Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service. Example: 16384.
netReadTimeout number: The number of seconds to wait for more data from a connection before aborting the read. Example: 30.
netWriteTimeout number: The number of seconds to wait for a block to be written to a connection before aborting the write. Example: 30.
slowQueryLog boolean: Slow query log enables capturing of slow queries. Setting slow_query_log to false also truncates the mysql.slow_log table.
sortBufferSize number: Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K). Example: 262144.
sqlMode string: Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned. Example: ANSI,TRADITIONAL.
sqlRequirePrimaryKey boolean: Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
tmpTableSize number: Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M). Example: 16777216.
waitTimeout number: The number of seconds the server waits for activity on a noninteractive connection before closing it. Example: 28800.

connect_timeout int: The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake. Example: 10.
default_time_zone str: Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or SYSTEM to use the MySQL server default. Example: +03:00.
group_concat_max_len int: The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example: 1024.
information_schema_stats_expiry int: The time, in seconds, before cached statistics expire. Example: 86400.
innodb_change_buffer_max_size int: Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example: 30.
innodb_flush_neighbors int: Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent. Example: 0.
innodb_ft_min_token_size int: Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service. Example: 3.
innodb_ft_server_stopword_table str: This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example: db_name/table_name.
innodb_lock_wait_timeout int: The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example: 50.
innodb_log_buffer_size int: The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example: 16777216.
innodb_online_alter_log_max_size int: The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example: 134217728.
innodb_print_all_deadlocks bool: When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
innodb_read_io_threads int: The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
innodb_rollback_on_timeout bool: When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
innodb_thread_concurrency int: Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example: 10.
innodb_write_io_threads int: The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
interactive_timeout int: The number of seconds the server waits for activity on an interactive connection before closing it. Example: 3600.
internal_tmp_mem_storage_engine str: Enum: MEMORY, TempTable. The storage engine for in-memory internal temporary tables.
log_output str: Enum: INSIGHTS, INSIGHTS,TABLE, NONE, TABLE. The slow log output destination when slow_query_log is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slow_log table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slow_log table, choose TABLE. To silence slow logs, choose NONE.
long_query_time float: The slow_query_logs work as SQL statements that take more than long_query_time seconds to execute. Example: 10.0.
max_allowed_packet int: Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example: 67108864.
max_heap_table_size int: Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M). Example: 16777216.
net_buffer_length int: Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service. Example: 16384.
net_read_timeout int: The number of seconds to wait for more data from a connection before aborting the read. Example: 30.
net_write_timeout int: The number of seconds to wait for a block to be written to a connection before aborting the write. Example: 30.
slow_query_log bool: Slow query log enables capturing of slow queries. Setting slow_query_log to false also truncates the mysql.slow_log table.
sort_buffer_size int: Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K). Example: 262144.
sql_mode str: Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned. Example: ANSI,TRADITIONAL.
sql_require_primary_key bool: Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
tmp_table_size int: Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M). Example: 16777216.
wait_timeout int: The number of seconds the server waits for activity on a noninteractive connection before closing it. Example: 28800.

connectTimeout Number: The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake. Example: 10.
defaultTimeZone String: Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or SYSTEM to use the MySQL server default. Example: +03:00.
groupConcatMaxLen Number: The maximum permitted result length in bytes for the GROUP_CONCAT() function. Example: 1024.
informationSchemaStatsExpiry Number: The time, in seconds, before cached statistics expire. Example: 86400.
innodbChangeBufferMaxSize Number: Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25. Example: 30.
innodbFlushNeighbors Number: Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent. Example: 0.
innodbFtMinTokenSize Number: Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service. Example: 3.
innodbFtServerStopwordTable String: This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables. Example: db_name/table_name.
innodbLockWaitTimeout Number: The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120. Example: 50.
innodbLogBufferSize Number: The size in bytes of the buffer that InnoDB uses to write to the log files on disk. Example: 16777216.
innodbOnlineAlterLogMaxSize Number: The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables. Example: 134217728.
innodbPrintAllDeadlocks Boolean: When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
innodbReadIoThreads Number: The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
innodbRollbackOnTimeout Boolean: When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
innodbThreadConcurrency Number: Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit). Example: 10.
innodbWriteIoThreads Number: The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service. Example: 10.
interactiveTimeout Number: The number of seconds the server waits for activity on an interactive connection before closing it. Example: 3600.
internalTmpMemStorageEngine String: Enum: MEMORY, TempTable. The storage engine for in-memory internal temporary tables.
logOutput String: Enum: INSIGHTS, INSIGHTS,TABLE, NONE, TABLE. The slow log output destination when slow_query_log is ON. To enable MySQL AI Insights, choose INSIGHTS. To use MySQL AI Insights and the mysql.slow_log table at the same time, choose INSIGHTS,TABLE. To only use the mysql.slow_log table, choose TABLE. To silence slow logs, choose NONE.
longQueryTime Number: The slow_query_logs work as SQL statements that take more than long_query_time seconds to execute. Example: 10.0.
maxAllowedPacket Number: Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M). Example: 67108864.
maxHeapTableSize Number: Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M). Example: 16777216.
netBufferLength Number: Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service. Example: 16384.
netReadTimeout Number: The number of seconds to wait for more data from a connection before aborting the read. Example: 30.
netWriteTimeout Number: The number of seconds to wait for a block to be written to a connection before aborting the write. Example: 30.
slowQueryLog Boolean: Slow query log enables capturing of slow queries. Setting slow_query_log to false also truncates the mysql.slow_log table.
sortBufferSize Number: Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K). Example: 262144.
sqlMode String: Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned. Example: ANSI,TRADITIONAL.
sqlRequirePrimaryKey Boolean: Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
tmpTableSize Number: Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M). Example: 16777216.
waitTimeout Number: The number of seconds the server waits for activity on a noninteractive connection before closing it. Example: 28800.

GetMySqlMysqlUserConfigPrivateAccess

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.

GetMySqlMysqlUserConfigPrivatelinkAccess

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.

GetMySqlMysqlUserConfigPublicAccess

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.

GetMySqlServiceIntegration

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

GetMySqlTag

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

GetMySqlTechEmail

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

Package Details

Repository: Aiven pulumi/pulumi-aiven
License: Apache-2.0
Notes: This Pulumi package is based on the aiven Terraform Provider.

Aiven v6.28.0 published on Friday, Nov 15, 2024 by Pulumi

pulumi/pulumi-aiven

aiven.getMySql

On this page

On this page

Example Usage

Using getMySql

getMySql Result

Supporting Types

GetMySqlComponent

GetMySqlMysql

GetMySqlMysqlParam

GetMySqlMysqlUserConfig

GetMySqlMysqlUserConfigIpFilterObject

GetMySqlMysqlUserConfigMigration

GetMySqlMysqlUserConfigMysql

GetMySqlMysqlUserConfigPrivateAccess

GetMySqlMysqlUserConfigPrivatelinkAccess

GetMySqlMysqlUserConfigPublicAccess

GetMySqlServiceIntegration

GetMySqlTag

GetMySqlTechEmail

Package Details

On this page

On this page