getMySql

# MySQL Data Source

The MySQL data source provides information about the existing Aiven MySQL service.

Example Usage

using Pulumi;
using Aiven = Pulumi.Aiven;

class MyStack : Stack
{
    public MyStack()
    {
        var mysql1 = Output.Create(Aiven.GetMySql.InvokeAsync(new Aiven.GetMySqlArgs
        {
            Project = data.Aiven_project.Foo.Project,
            ServiceName = "my-mysql1",
        }));
    }

}

package main

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

func main() {
    pulumi.Run(func(ctx *pulumi.Context) error {
        _, err := aiven.LookupMySql(ctx, &aiven.LookupMySqlArgs{
            Project:     data.Aiven_project.Foo.Project,
            ServiceName: "my-mysql1",
        }, nil)
        if err != nil {
            return err
        }
        return nil
    })
}

import pulumi
import pulumi_aiven as aiven

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

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

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

Using getMySql

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

def get_my_sql(cloud_name: Optional[str] = None, components: Optional[Sequence[GetMySqlComponentArgs]] = None, maintenance_window_dow: Optional[str] = None, maintenance_window_time: Optional[str] = None, mysql: Optional[GetMySqlMysqlArgs] = None, mysql_user_config: Optional[GetMySqlMysqlUserConfigArgs] = None, plan: Optional[str] = None, project: Optional[str] = None, project_vpc_id: Optional[str] = None, service_host: Optional[str] = None, service_integrations: Optional[Sequence[GetMySqlServiceIntegrationArgs]] = None, service_name: Optional[str] = None, service_password: Optional[str] = None, service_port: Optional[int] = None, service_type: Optional[str] = None, service_uri: Optional[str] = None, service_username: Optional[str] = None, state: Optional[str] = None, termination_protection: Optional[bool] = None, opts: Optional[InvokeOptions] = None) -> GetMySqlResult

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

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

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

The following arguments are supported:

Project string: identifies the project the service belongs to. To set up proper dependency between the project and the service, refer to the project as shown in the above example. Project cannot be changed later without destroying and re-creating the service.
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.
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<GetMySqlComponentArgs>
MaintenanceWindowDow string: day of week when maintenance operations should be performed. On monday, tuesday, wednesday, etc.
MaintenanceWindowTime string: time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
Mysql GetMySqlMysqlArgs: MySQL specific server provided values.
MysqlUserConfig GetMySqlMysqlUserConfigArgs: defines MySQL specific additional configuration options. The following configuration options available:
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 exact options can be seen from the Aiven web console’s Create Service dialog.
ProjectVpcId string: optionally 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 as shown above 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: MySQL hostname.
ServiceIntegrations List<GetMySqlServiceIntegrationArgs>
ServicePassword string: Password used for connecting to the MySQL service, if applicable.
ServicePort int: MySQL port.
ServiceType string
ServiceUri string: URI for connecting to the MySQL service.
ServiceUsername string: Username used for connecting to the MySQL service, if applicable.
State string: Service state.
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.

Project string: identifies the project the service belongs to. To set up proper dependency between the project and the service, refer to the project as shown in the above example. Project cannot be changed later without destroying and re-creating the service.
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.
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
MaintenanceWindowDow string: day of week when maintenance operations should be performed. On monday, tuesday, wednesday, etc.
MaintenanceWindowTime string: time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
Mysql GetMySqlMysql: MySQL specific server provided values.
MysqlUserConfig GetMySqlMysqlUserConfig: defines MySQL specific additional configuration options. The following configuration options available:
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 exact options can be seen from the Aiven web console’s Create Service dialog.
ProjectVpcId string: optionally 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 as shown above 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: MySQL hostname.
ServiceIntegrations []GetMySqlServiceIntegration
ServicePassword string: Password used for connecting to the MySQL service, if applicable.
ServicePort int: MySQL port.
ServiceType string
ServiceUri string: URI for connecting to the MySQL service.
ServiceUsername string: Username used for connecting to the MySQL service, if applicable.
State string: Service state.
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.

project string: identifies the project the service belongs to. To set up proper dependency between the project and the service, refer to the project as shown in the above example. Project cannot be changed later without destroying and re-creating the service.
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.
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[]
maintenanceWindowDow string: day of week when maintenance operations should be performed. On monday, tuesday, wednesday, etc.
maintenanceWindowTime string: time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
mysql GetMySqlMysql: MySQL specific server provided values.
mysqlUserConfig GetMySqlMysqlUserConfig: defines MySQL specific additional configuration options. The following configuration options available:
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 exact options can be seen from the Aiven web console’s Create Service dialog.
projectVpcId string: optionally 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 as shown above 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: MySQL hostname.
serviceIntegrations GetMySqlServiceIntegration[]
servicePassword string: Password used for connecting to the MySQL service, if applicable.
servicePort number: MySQL port.
serviceType string
serviceUri string: URI for connecting to the MySQL service.
serviceUsername string: Username used for connecting to the MySQL service, if applicable.
state string: Service state.
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.

project str: identifies the project the service belongs to. To set up proper dependency between the project and the service, refer to the project as shown in the above example. Project cannot be changed later without destroying and re-creating the service.
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.
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[GetMySqlComponentArgs]
maintenance_window_dow str: day of week when maintenance operations should be performed. On 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 GetMySqlMysqlArgs: MySQL specific server provided values.
mysql_user_config GetMySqlMysqlUserConfigArgs: defines MySQL specific additional configuration options. The following configuration options available:
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 exact options can be seen from the Aiven web console’s Create Service dialog.
project_vpc_id str: optionally 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 as shown above 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: MySQL hostname.
service_integrations Sequence[GetMySqlServiceIntegrationArgs]
service_password str: Password used for connecting to the MySQL service, if applicable.
service_port int: MySQL port.
service_type str
service_uri str: URI for connecting to the MySQL service.
service_username str: Username used for connecting to the MySQL service, if applicable.
state str: Service state.
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.

getMySql Result

The following output properties are available:

Components List<GetMySqlComponent>
Id string: The provider-assigned unique ID for this managed resource.
Mysql GetMySqlMysql: MySQL specific server provided values.
Project string
ServiceHost string: MySQL hostname.
ServiceName string
ServicePassword string: Password used for connecting to the MySQL service, if applicable.
ServicePort int: MySQL port.
ServiceType string
ServiceUri string: URI for connecting to the MySQL service.
ServiceUsername string: Username used for connecting to the MySQL service, if applicable.
State string: Service state.
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.
MaintenanceWindowDow string: day of week when maintenance operations should be performed. On monday, tuesday, wednesday, etc.
MaintenanceWindowTime string: time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
MysqlUserConfig GetMySqlMysqlUserConfig: defines MySQL specific additional configuration options. The following configuration options available:
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 exact options can be seen from the Aiven web console’s Create Service dialog.
ProjectVpcId string: optionally 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 as shown above to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
ServiceIntegrations List<GetMySqlServiceIntegration>
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.

Components []GetMySqlComponent
Id string: The provider-assigned unique ID for this managed resource.
Mysql GetMySqlMysql: MySQL specific server provided values.
Project string
ServiceHost string: MySQL hostname.
ServiceName string
ServicePassword string: Password used for connecting to the MySQL service, if applicable.
ServicePort int: MySQL port.
ServiceType string
ServiceUri string: URI for connecting to the MySQL service.
ServiceUsername string: Username used for connecting to the MySQL service, if applicable.
State string: Service state.
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.
MaintenanceWindowDow string: day of week when maintenance operations should be performed. On monday, tuesday, wednesday, etc.
MaintenanceWindowTime string: time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
MysqlUserConfig GetMySqlMysqlUserConfig: defines MySQL specific additional configuration options. The following configuration options available:
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 exact options can be seen from the Aiven web console’s Create Service dialog.
ProjectVpcId string: optionally 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 as shown above to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
ServiceIntegrations []GetMySqlServiceIntegration
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.

components GetMySqlComponent[]
id string: The provider-assigned unique ID for this managed resource.
mysql GetMySqlMysql: MySQL specific server provided values.
project string
serviceHost string: MySQL hostname.
serviceName string
servicePassword string: Password used for connecting to the MySQL service, if applicable.
servicePort number: MySQL port.
serviceType string
serviceUri string: URI for connecting to the MySQL service.
serviceUsername string: Username used for connecting to the MySQL service, if applicable.
state string: Service state.
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.
maintenanceWindowDow string: day of week when maintenance operations should be performed. On monday, tuesday, wednesday, etc.
maintenanceWindowTime string: time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
mysqlUserConfig GetMySqlMysqlUserConfig: defines MySQL specific additional configuration options. The following configuration options available:
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 exact options can be seen from the Aiven web console’s Create Service dialog.
projectVpcId string: optionally 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 as shown above to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
serviceIntegrations GetMySqlServiceIntegration[]
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.

components Sequence[GetMySqlComponent]
id str: The provider-assigned unique ID for this managed resource.
mysql GetMySqlMysql: MySQL specific server provided values.
project str
service_host str: MySQL hostname.
service_name str
service_password str: Password used for connecting to the MySQL service, if applicable.
service_port int: MySQL port.
service_type str
service_uri str: URI for connecting to the MySQL service.
service_username str: Username used for connecting to the MySQL service, if applicable.
state str: Service state.
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.
maintenance_window_dow str: day of week when maintenance operations should be performed. On monday, tuesday, wednesday, etc.
maintenance_window_time str: time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
mysql_user_config GetMySqlMysqlUserConfig: defines MySQL specific additional configuration options. The following configuration options available:
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 exact options can be seen from the Aiven web console’s Create Service dialog.
project_vpc_id str: optionally 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 as shown above to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
service_integrations Sequence[GetMySqlServiceIntegration]
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.

Supporting Types

GetMySqlComponent

Component string
Host string
KafkaAuthenticationMethod string
Port int
Route string
Ssl bool
Usage string

Component string
Host string
KafkaAuthenticationMethod string
Port int
Route string
Ssl bool
Usage string

component string
host string
kafkaAuthenticationMethod string
port number
route string
ssl boolean
usage string

component str
host str
kafka_authentication_method str
port int
route str
ssl bool
usage str

GetMySqlMysqlUserConfig

AdminPassword string: Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
AdminUsername string: Custom username for admin user. This must be set only when a new service is being created.
BackupHour string: The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
BackupMinute string: The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
IpFilters List<string>: Allow incoming connections from CIDR address block, e.g. ‘10.20.0.0/16’
Mysql GetMySqlMysqlUserConfigMysqlArgs: MySQL specific server provided values.
MysqlVersion string: MySQL major version
PrivateAccess GetMySqlMysqlUserConfigPrivateAccessArgs: Allow access to selected service ports from private networks
ProjectToForkFrom string: Name of another project to fork a service from. This has effect only when a new service is being created.
PublicAccess GetMySqlMysqlUserConfigPublicAccessArgs: 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.
ServiceToForkFrom string: Name of another service to fork from. This has effect only when a new service is being created.

AdminPassword string: Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
AdminUsername string: Custom username for admin user. This must be set only when a new service is being created.
BackupHour string: The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
BackupMinute string: The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
IpFilters []string: Allow incoming connections from CIDR address block, e.g. ‘10.20.0.0/16’
Mysql GetMySqlMysqlUserConfigMysql: MySQL specific server provided values.
MysqlVersion string: MySQL major version
PrivateAccess GetMySqlMysqlUserConfigPrivateAccess: Allow access to selected service ports from private networks
ProjectToForkFrom string: Name of another project to fork a service from. This has effect only when a new service is being created.
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.
ServiceToForkFrom string: Name of another service to fork from. This has effect only when a new service is being created.

adminPassword string: Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
adminUsername string: Custom username for admin user. This must be set only when a new service is being created.
backupHour string: The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
backupMinute string: The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
ipFilters string[]: Allow incoming connections from CIDR address block, e.g. ‘10.20.0.0/16’
mysql GetMySqlMysqlUserConfigMysql: MySQL specific server provided values.
mysqlVersion string: MySQL major version
privateAccess GetMySqlMysqlUserConfigPrivateAccess: Allow access to selected service ports from private networks
projectToForkFrom string: Name of another project to fork a service from. This has effect only when a new service is being created.
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.
serviceToForkFrom string: Name of another service to fork from. This has effect only when a new service is being created.

admin_password str: Custom password for admin user. Defaults to random string. This must be set only when a new service is being created.
admin_username str: Custom username for admin user. This must be set only when a new service is being created.
backup_hour str: The hour of day (in UTC) when backup for the service is started. New backup is only started if previous backup has already completed.
backup_minute str: The minute of an hour when backup for the service is started. New backup is only started if previous backup has already completed.
ip_filters Sequence[str]: Allow incoming connections from CIDR address block, e.g. ‘10.20.0.0/16’
mysql GetMySqlMysqlUserConfigMysqlArgs: MySQL specific server provided values.
mysql_version str: MySQL major version
private_access GetMySqlMysqlUserConfigPrivateAccessArgs: Allow access to selected service ports from private networks
project_to_fork_from str: Name of another project to fork a service from. This has effect only when a new service is being created.
public_access GetMySqlMysqlUserConfigPublicAccessArgs: Allow access to selected service ports from the public Internet
recovery_target_time str: Recovery target time when forking a service. This has effect only when a new service is being created.
service_to_fork_from str: Name of another service to fork from. This has effect only when a new service is being created.

GetMySqlMysqlUserConfigMysql

ConnectTimeout string: The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake
DefaultTimeZone string: Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or ‘SYSTEM’ to use the MySQL server default.
GroupConcatMaxLen string: The maximum permitted result length in bytes for the GROUP_CONCAT() function.
InformationSchemaStatsExpiry string: The time, in seconds, before cached statistics expire
InnodbFtMinTokenSize string: Minimum length of words that are stored in an InnoDB FULLTEXT index.
InnodbFtServerStopwordTable string: This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
InnodbLockWaitTimeout string: The length of time in seconds an InnoDB transaction waits for a row lock before giving up.
InnodbLogBufferSize string: The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
InnodbOnlineAlterLogMaxSize string: The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
InnodbPrintAllDeadlocks string: When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
InnodbRollbackOnTimeout string: When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction.
InteractiveTimeout string: The number of seconds the server waits for activity on an interactive connection before closing it.
MaxAllowedPacket string: Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M)
MaxHeapTableSize string: Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M)
NetReadTimeout string: The number of seconds to wait for more data from a connection before aborting the read.
NetWriteTimeout string: The number of seconds to wait for a block to be written to a connection before aborting the write.
SortBufferSize string: Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K)
SqlMode string: Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned.
SqlRequirePrimaryKey string: 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 string: Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M)
WaitTimeout string: The number of seconds the server waits for activity on a noninteractive connection before closing it.

ConnectTimeout string: The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake
DefaultTimeZone string: Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or ‘SYSTEM’ to use the MySQL server default.
GroupConcatMaxLen string: The maximum permitted result length in bytes for the GROUP_CONCAT() function.
InformationSchemaStatsExpiry string: The time, in seconds, before cached statistics expire
InnodbFtMinTokenSize string: Minimum length of words that are stored in an InnoDB FULLTEXT index.
InnodbFtServerStopwordTable string: This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
InnodbLockWaitTimeout string: The length of time in seconds an InnoDB transaction waits for a row lock before giving up.
InnodbLogBufferSize string: The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
InnodbOnlineAlterLogMaxSize string: The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
InnodbPrintAllDeadlocks string: When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
InnodbRollbackOnTimeout string: When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction.
InteractiveTimeout string: The number of seconds the server waits for activity on an interactive connection before closing it.
MaxAllowedPacket string: Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M)
MaxHeapTableSize string: Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M)
NetReadTimeout string: The number of seconds to wait for more data from a connection before aborting the read.
NetWriteTimeout string: The number of seconds to wait for a block to be written to a connection before aborting the write.
SortBufferSize string: Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K)
SqlMode string: Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned.
SqlRequirePrimaryKey string: 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 string: Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M)
WaitTimeout string: The number of seconds the server waits for activity on a noninteractive connection before closing it.

connectTimeout string: The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake
defaultTimeZone string: Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or ‘SYSTEM’ to use the MySQL server default.
groupConcatMaxLen string: The maximum permitted result length in bytes for the GROUP_CONCAT() function.
informationSchemaStatsExpiry string: The time, in seconds, before cached statistics expire
innodbFtMinTokenSize string: Minimum length of words that are stored in an InnoDB FULLTEXT index.
innodbFtServerStopwordTable string: This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
innodbLockWaitTimeout string: The length of time in seconds an InnoDB transaction waits for a row lock before giving up.
innodbLogBufferSize string: The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
innodbOnlineAlterLogMaxSize string: The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
innodbPrintAllDeadlocks string: When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
innodbRollbackOnTimeout string: When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction.
interactiveTimeout string: The number of seconds the server waits for activity on an interactive connection before closing it.
maxAllowedPacket string: Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M)
maxHeapTableSize string: Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M)
netReadTimeout string: The number of seconds to wait for more data from a connection before aborting the read.
netWriteTimeout string: The number of seconds to wait for a block to be written to a connection before aborting the write.
sortBufferSize string: Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K)
sqlMode string: Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned.
sqlRequirePrimaryKey string: 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 string: Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M)
waitTimeout string: The number of seconds the server waits for activity on a noninteractive connection before closing it.

connect_timeout str: The number of seconds that the mysqld server waits for a connect packet before responding with Bad handshake
default_time_zone str: Default server time zone as an offset from UTC (from -12:00 to +12:00), a time zone name, or ‘SYSTEM’ to use the MySQL server default.
group_concat_max_len str: The maximum permitted result length in bytes for the GROUP_CONCAT() function.
information_schema_stats_expiry str: The time, in seconds, before cached statistics expire
innodb_ft_min_token_size str: Minimum length of words that are stored in an InnoDB FULLTEXT index.
innodb_ft_server_stopword_table str: This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
innodb_lock_wait_timeout str: The length of time in seconds an InnoDB transaction waits for a row lock before giving up.
innodb_log_buffer_size str: The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
innodb_online_alter_log_max_size str: The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
innodb_print_all_deadlocks str: When enabled, information about all deadlocks in InnoDB user transactions is recorded in the error log. Disabled by default.
innodb_rollback_on_timeout str: When enabled a transaction timeout causes InnoDB to abort and roll back the entire transaction.
interactive_timeout str: The number of seconds the server waits for activity on an interactive connection before closing it.
max_allowed_packet str: Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M)
max_heap_table_size str: Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M)
net_read_timeout str: The number of seconds to wait for more data from a connection before aborting the read.
net_write_timeout str: The number of seconds to wait for a block to be written to a connection before aborting the write.
sort_buffer_size str: Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K)
sql_mode str: Global SQL mode. Set to empty to use MySQL server defaults. When creating a new service and not setting this field Aiven default SQL mode (strict, SQL standard compliant) will be assigned.
sql_require_primary_key str: 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 str: Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M)
wait_timeout str: The number of seconds the server waits for activity on a noninteractive connection before closing it.

GetMySqlMysqlUserConfigPrivateAccess

Mysql string: MySQL specific server provided values.
Prometheus string: 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 string: MySQL specific server provided values.
Prometheus string: 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 string: MySQL specific server provided values.
prometheus string: 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 str: MySQL specific server provided values.
prometheus str: 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

GetMySqlMysqlUserConfigPublicAccess

Mysql string: MySQL specific server provided values.
Prometheus string: 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 string: MySQL specific server provided values.
Prometheus string: 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 string: MySQL specific server provided values.
prometheus string: 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 str: MySQL specific server provided values.
prometheus str: 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
SourceServiceName string

IntegrationType string
SourceServiceName string

integrationType string
sourceServiceName string

integration_type str
source_service_name str

Package Details

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

The Pulumi Platform

Get Started

Migrate to Pulumi

Solutions for All Teams and Engineers

Any Code

Any Cloud

getMySql

# MySQL Data Source

Example Usage

Using getMySql

getMySql Result

Supporting Types

GetMySqlComponent

GetMySqlMysqlUserConfig

GetMySqlMysqlUserConfigMysql

GetMySqlMysqlUserConfigPrivateAccess

GetMySqlMysqlUserConfigPublicAccess

GetMySqlServiceIntegration

Package Details

On This Page