aiven.MySql
Explore with Pulumi AI
The MySQL resource allows the creation and management of Aiven MySQL services.
Example Usage
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Aiven = Pulumi.Aiven;
return await Deployment.RunAsync(() =>
{
var mysql1 = new Aiven.MySql("mysql1", new()
{
Project = data.Aiven_project.Foo.Project,
CloudName = "google-europe-west1",
Plan = "business-4",
ServiceName = "my-mysql1",
MaintenanceWindowDow = "monday",
MaintenanceWindowTime = "10:00:00",
MysqlUserConfig = new Aiven.Inputs.MySqlMysqlUserConfigArgs
{
MysqlVersion = "8",
Mysql = new Aiven.Inputs.MySqlMysqlUserConfigMysqlArgs
{
SqlMode = "ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE",
SqlRequirePrimaryKey = true,
},
PublicAccess = new Aiven.Inputs.MySqlMysqlUserConfigPublicAccessArgs
{
Mysql = true,
},
},
});
});
package main
import (
"github.com/pulumi/pulumi-aiven/sdk/v6/go/aiven"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := aiven.NewMySql(ctx, "mysql1", &aiven.MySqlArgs{
Project: pulumi.Any(data.Aiven_project.Foo.Project),
CloudName: pulumi.String("google-europe-west1"),
Plan: pulumi.String("business-4"),
ServiceName: pulumi.String("my-mysql1"),
MaintenanceWindowDow: pulumi.String("monday"),
MaintenanceWindowTime: pulumi.String("10:00:00"),
MysqlUserConfig: &aiven.MySqlMysqlUserConfigArgs{
MysqlVersion: pulumi.String("8"),
Mysql: &aiven.MySqlMysqlUserConfigMysqlArgs{
SqlMode: pulumi.String("ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE"),
SqlRequirePrimaryKey: pulumi.Bool(true),
},
PublicAccess: &aiven.MySqlMysqlUserConfigPublicAccessArgs{
Mysql: pulumi.Bool(true),
},
},
})
if err != nil {
return err
}
return nil
})
}
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.aiven.MySql;
import com.pulumi.aiven.MySqlArgs;
import com.pulumi.aiven.inputs.MySqlMysqlUserConfigArgs;
import com.pulumi.aiven.inputs.MySqlMysqlUserConfigMysqlArgs;
import com.pulumi.aiven.inputs.MySqlMysqlUserConfigPublicAccessArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
public static void main(String[] args) {
Pulumi.run(App::stack);
}
public static void stack(Context ctx) {
var mysql1 = new MySql("mysql1", MySqlArgs.builder()
.project(data.aiven_project().foo().project())
.cloudName("google-europe-west1")
.plan("business-4")
.serviceName("my-mysql1")
.maintenanceWindowDow("monday")
.maintenanceWindowTime("10:00:00")
.mysqlUserConfig(MySqlMysqlUserConfigArgs.builder()
.mysqlVersion(8)
.mysql(MySqlMysqlUserConfigMysqlArgs.builder()
.sqlMode("ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE")
.sqlRequirePrimaryKey(true)
.build())
.publicAccess(MySqlMysqlUserConfigPublicAccessArgs.builder()
.mysql(true)
.build())
.build())
.build());
}
}
import pulumi
import pulumi_aiven as aiven
mysql1 = aiven.MySql("mysql1",
project=data["aiven_project"]["foo"]["project"],
cloud_name="google-europe-west1",
plan="business-4",
service_name="my-mysql1",
maintenance_window_dow="monday",
maintenance_window_time="10:00:00",
mysql_user_config=aiven.MySqlMysqlUserConfigArgs(
mysql_version="8",
mysql=aiven.MySqlMysqlUserConfigMysqlArgs(
sql_mode="ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE",
sql_require_primary_key=True,
),
public_access=aiven.MySqlMysqlUserConfigPublicAccessArgs(
mysql=True,
),
))
import * as pulumi from "@pulumi/pulumi";
import * as aiven from "@pulumi/aiven";
const mysql1 = new aiven.MySql("mysql1", {
project: data.aiven_project.foo.project,
cloudName: "google-europe-west1",
plan: "business-4",
serviceName: "my-mysql1",
maintenanceWindowDow: "monday",
maintenanceWindowTime: "10:00:00",
mysqlUserConfig: {
mysqlVersion: "8",
mysql: {
sqlMode: "ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE",
sqlRequirePrimaryKey: true,
},
publicAccess: {
mysql: true,
},
},
});
resources:
mysql1:
type: aiven:MySql
properties:
project: ${data.aiven_project.foo.project}
cloudName: google-europe-west1
plan: business-4
serviceName: my-mysql1
maintenanceWindowDow: monday
maintenanceWindowTime: 10:00:00
mysqlUserConfig:
mysqlVersion: 8
mysql:
sqlMode: ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE
sqlRequirePrimaryKey: true
publicAccess:
mysql: true
Create MySql Resource
new MySql(name: string, args: MySqlArgs, opts?: CustomResourceOptions);
@overload
def MySql(resource_name: str,
opts: Optional[ResourceOptions] = None,
additional_disk_space: Optional[str] = None,
cloud_name: Optional[str] = None,
disk_space: Optional[str] = None,
maintenance_window_dow: Optional[str] = None,
maintenance_window_time: Optional[str] = None,
mysql_user_config: Optional[MySqlMysqlUserConfigArgs] = None,
plan: Optional[str] = None,
project: Optional[str] = None,
project_vpc_id: Optional[str] = None,
service_integrations: Optional[Sequence[MySqlServiceIntegrationArgs]] = None,
service_name: Optional[str] = None,
static_ips: Optional[Sequence[str]] = None,
tags: Optional[Sequence[MySqlTagArgs]] = None,
termination_protection: Optional[bool] = None)
@overload
def MySql(resource_name: str,
args: MySqlArgs,
opts: Optional[ResourceOptions] = None)
func NewMySql(ctx *Context, name string, args MySqlArgs, opts ...ResourceOption) (*MySql, error)
public MySql(string name, MySqlArgs args, CustomResourceOptions? opts = null)
type: aiven:MySql
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args MySqlArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- resource_name str
- The unique name of the resource.
- args MySqlArgs
- The arguments to resource properties.
- opts ResourceOptions
- Bag of options to control resource's behavior.
- ctx Context
- Context object for the current deployment.
- name string
- The unique name of the resource.
- args MySqlArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args MySqlArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args MySqlArgs
- The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
MySql Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
The MySql resource accepts the following input properties:
- Plan string
Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are
hobbyist
,startup-x
,business-x
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.- Project string
Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. This property cannot be changed, doing so forces recreation of the resource.
- Service
Name 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.
- Additional
Disk stringSpace Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- Cloud
Name 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.- Disk
Space 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.
This will be removed in v5.0.0. Please use
additional_disk_space
to specify the space to be added to the defaultdisk_space
defined by the plan.- Maintenance
Window stringDow Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- Maintenance
Window stringTime Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- Mysql
User MyConfig Sql Mysql User Config Mysql user configurable settings
- Project
Vpc stringId Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- Service
Integrations List<MySql Service Integration> Service integrations to specify when creating a service. Not applied after initial service creation
- Static
Ips List<string> Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- List<My
Sql Tag> Tags are key-value pairs that allow you to categorize services.
- Termination
Protection bool Prevents the service from being deleted. It is recommended to set this to
true
for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
- Plan string
Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are
hobbyist
,startup-x
,business-x
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.- Project string
Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. This property cannot be changed, doing so forces recreation of the resource.
- Service
Name 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.
- Additional
Disk stringSpace Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- Cloud
Name 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.- Disk
Space 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.
This will be removed in v5.0.0. Please use
additional_disk_space
to specify the space to be added to the defaultdisk_space
defined by the plan.- Maintenance
Window stringDow Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- Maintenance
Window stringTime Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- Mysql
User MyConfig Sql Mysql User Config Args Mysql user configurable settings
- Project
Vpc stringId Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- Service
Integrations []MySql Service Integration Args Service integrations to specify when creating a service. Not applied after initial service creation
- Static
Ips []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
- []My
Sql Tag Args Tags are key-value pairs that allow you to categorize services.
- Termination
Protection bool Prevents the service from being deleted. It is recommended to set this to
true
for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
- plan String
Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are
hobbyist
,startup-x
,business-x
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.- project String
Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. This property cannot be changed, doing so forces recreation of the resource.
- service
Name 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.
- additional
Disk StringSpace Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- cloud
Name 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.- disk
Space 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.
This will be removed in v5.0.0. Please use
additional_disk_space
to specify the space to be added to the defaultdisk_space
defined by the plan.- maintenance
Window StringDow Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenance
Window StringTime Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql
User MyConfig Sql Mysql User Config Mysql user configurable settings
- project
Vpc StringId Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- service
Integrations List<MySql Service Integration> Service integrations to specify when creating a service. Not applied after initial service creation
- static
Ips List<String> Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- List<My
Sql Tag> Tags are key-value pairs that allow you to categorize services.
- termination
Protection Boolean Prevents the service from being deleted. It is recommended to set this to
true
for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
- plan string
Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are
hobbyist
,startup-x
,business-x
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.- project string
Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. This property cannot be changed, doing so forces recreation of the resource.
- service
Name 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.
- additional
Disk stringSpace Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- cloud
Name 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.- disk
Space 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.
This will be removed in v5.0.0. Please use
additional_disk_space
to specify the space to be added to the defaultdisk_space
defined by the plan.- maintenance
Window stringDow Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenance
Window stringTime Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql
User MyConfig Sql Mysql User Config Mysql user configurable settings
- project
Vpc stringId Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- service
Integrations MySql Service Integration[] Service integrations to specify when creating a service. Not applied after initial service creation
- static
Ips 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
- My
Sql Tag[] Tags are key-value pairs that allow you to categorize services.
- termination
Protection boolean Prevents the service from being deleted. It is recommended to set this to
true
for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
- plan str
Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are
hobbyist
,startup-x
,business-x
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.- project str
Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. This property cannot be changed, doing so forces recreation of the resource.
- service_
name str Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
- additional_
disk_ strspace Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- cloud_
name str Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (
aws
,azure
,do
google
,upcloud
, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS.- disk_
space str Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
This will be removed in v5.0.0. Please use
additional_disk_space
to specify the space to be added to the defaultdisk_space
defined by the plan.- maintenance_
window_ strdow Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenance_
window_ strtime Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql_
user_ Myconfig Sql Mysql User Config Args Mysql user configurable settings
- project_
vpc_ strid Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- service_
integrations Sequence[MySql Service Integration Args] Service integrations to specify when creating a service. Not applied after initial service creation
- static_
ips Sequence[str] Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- Sequence[My
Sql Tag Args] Tags are key-value pairs that allow you to categorize services.
- termination_
protection bool Prevents the service from being deleted. It is recommended to set this to
true
for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
- plan String
Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are
hobbyist
,startup-x
,business-x
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.- project String
Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. This property cannot be changed, doing so forces recreation of the resource.
- service
Name 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.
- additional
Disk StringSpace Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- cloud
Name 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.- disk
Space 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.
This will be removed in v5.0.0. Please use
additional_disk_space
to specify the space to be added to the defaultdisk_space
defined by the plan.- maintenance
Window StringDow Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenance
Window StringTime Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql
User Property MapConfig Mysql user configurable settings
- project
Vpc StringId Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- service
Integrations List<Property Map> Service integrations to specify when creating a service. Not applied after initial service creation
- static
Ips List<String> Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- List<Property Map>
Tags are key-value pairs that allow you to categorize services.
- termination
Protection Boolean Prevents the service from being deleted. It is recommended to set this to
true
for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
Outputs
All input properties are implicitly available as output properties. Additionally, the MySql resource produces the following output properties:
- Components
List<My
Sql Component> Service component information objects
- Disk
Space stringCap The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- Disk
Space stringDefault The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- Disk
Space stringStep 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 fromdisk_space_default
by increments of this size.- Disk
Space stringUsed Disk space that service is currently using
- Id string
The provider-assigned unique ID for this managed resource.
- Mysqls
List<My
Sql Mysql> MySQL specific server provided values
- Service
Host string The hostname of the service.
- Service
Password string Password used for connecting to the service, if applicable
- Service
Port int The port of the service
- Service
Type string Aiven internal service type code
- Service
Uri string URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- Service
Username string Username used for connecting to the service, if applicable
- State string
Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- Components
[]My
Sql Component Service component information objects
- Disk
Space stringCap The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- Disk
Space stringDefault The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- Disk
Space stringStep 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 fromdisk_space_default
by increments of this size.- Disk
Space stringUsed Disk space that service is currently using
- Id string
The provider-assigned unique ID for this managed resource.
- Mysqls
[]My
Sql Mysql MySQL specific server provided values
- Service
Host string The hostname of the service.
- Service
Password string Password used for connecting to the service, if applicable
- Service
Port int The port of the service
- Service
Type string Aiven internal service type code
- Service
Uri string URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- Service
Username string Username used for connecting to the service, if applicable
- State string
Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- components
List<My
Sql Component> Service component information objects
- disk
Space StringCap The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- disk
Space StringDefault The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- disk
Space StringStep 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 fromdisk_space_default
by increments of this size.- disk
Space StringUsed Disk space that service is currently using
- id String
The provider-assigned unique ID for this managed resource.
- mysqls
List<My
Sql Mysql> MySQL specific server provided values
- service
Host String The hostname of the service.
- service
Password String Password used for connecting to the service, if applicable
- service
Port Integer The port of the service
- service
Type String Aiven internal service type code
- service
Uri String URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- service
Username String Username used for connecting to the service, if applicable
- state String
Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- components
My
Sql Component[] Service component information objects
- disk
Space stringCap The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- disk
Space stringDefault The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- disk
Space stringStep 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 fromdisk_space_default
by increments of this size.- disk
Space stringUsed Disk space that service is currently using
- id string
The provider-assigned unique ID for this managed resource.
- mysqls
My
Sql Mysql[] MySQL specific server provided values
- service
Host string The hostname of the service.
- service
Password string Password used for connecting to the service, if applicable
- service
Port number The port of the service
- service
Type string Aiven internal service type code
- service
Uri string URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- service
Username string Username used for connecting to the service, if applicable
- state string
Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- components
Sequence[My
Sql Component] Service component information objects
- disk_
space_ strcap The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- disk_
space_ strdefault The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- disk_
space_ strstep The default disk space step of the service, possible values depend on the service type, the cloud provider and the project.
disk_space
needs to increment fromdisk_space_default
by increments of this size.- disk_
space_ strused Disk space that service is currently using
- id str
The provider-assigned unique ID for this managed resource.
- mysqls
Sequence[My
Sql Mysql] MySQL specific server provided values
- service_
host str The hostname of the service.
- service_
password str Password used for connecting to the service, if applicable
- service_
port int The port of the service
- service_
type str Aiven internal service type code
- service_
uri str URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- service_
username str Username used for connecting to the service, if applicable
- state str
Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- components List<Property Map>
Service component information objects
- disk
Space StringCap The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- disk
Space StringDefault The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- disk
Space StringStep 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 fromdisk_space_default
by increments of this size.- disk
Space StringUsed Disk space that service is currently using
- id String
The provider-assigned unique ID for this managed resource.
- mysqls List<Property Map>
MySQL specific server provided values
- service
Host String The hostname of the service.
- service
Password String Password used for connecting to the service, if applicable
- service
Port Number The port of the service
- service
Type String Aiven internal service type code
- service
Uri String URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- service
Username String Username used for connecting to the service, if applicable
- state String
Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
Look up Existing MySql Resource
Get an existing MySql resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.
public static get(name: string, id: Input<ID>, state?: MySqlState, opts?: CustomResourceOptions): MySql
@staticmethod
def get(resource_name: str,
id: str,
opts: Optional[ResourceOptions] = None,
additional_disk_space: Optional[str] = None,
cloud_name: Optional[str] = None,
components: Optional[Sequence[MySqlComponentArgs]] = None,
disk_space: Optional[str] = None,
disk_space_cap: Optional[str] = None,
disk_space_default: Optional[str] = None,
disk_space_step: Optional[str] = None,
disk_space_used: Optional[str] = None,
maintenance_window_dow: Optional[str] = None,
maintenance_window_time: Optional[str] = None,
mysql_user_config: Optional[MySqlMysqlUserConfigArgs] = None,
mysqls: Optional[Sequence[MySqlMysqlArgs]] = None,
plan: Optional[str] = None,
project: Optional[str] = None,
project_vpc_id: Optional[str] = None,
service_host: Optional[str] = None,
service_integrations: Optional[Sequence[MySqlServiceIntegrationArgs]] = None,
service_name: Optional[str] = None,
service_password: Optional[str] = None,
service_port: Optional[int] = None,
service_type: Optional[str] = None,
service_uri: Optional[str] = None,
service_username: Optional[str] = None,
state: Optional[str] = None,
static_ips: Optional[Sequence[str]] = None,
tags: Optional[Sequence[MySqlTagArgs]] = None,
termination_protection: Optional[bool] = None) -> MySql
func GetMySql(ctx *Context, name string, id IDInput, state *MySqlState, opts ...ResourceOption) (*MySql, error)
public static MySql Get(string name, Input<string> id, MySqlState? state, CustomResourceOptions? opts = null)
public static MySql get(String name, Output<String> id, MySqlState state, CustomResourceOptions options)
Resource lookup is not supported in YAML
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- resource_name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- Additional
Disk stringSpace Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- Cloud
Name 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<My
Sql Component> Service component information objects
- Disk
Space 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.
This will be removed in v5.0.0. Please use
additional_disk_space
to specify the space to be added to the defaultdisk_space
defined by the plan.- Disk
Space stringCap The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- Disk
Space stringDefault The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- Disk
Space stringStep 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 fromdisk_space_default
by increments of this size.- Disk
Space stringUsed Disk space that service is currently using
- Maintenance
Window stringDow Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- Maintenance
Window stringTime Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- Mysql
User MyConfig Sql Mysql User Config Mysql user configurable settings
- Mysqls
List<My
Sql Mysql> 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
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.- Project string
Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. This property cannot be changed, doing so forces recreation of the resource.
- Project
Vpc stringId Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- Service
Host string The hostname of the service.
- Service
Integrations List<MySql Service Integration> Service integrations to specify when creating a service. Not applied after initial service creation
- Service
Name 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.
- Service
Password string Password used for connecting to the service, if applicable
- Service
Port int The port of the service
- Service
Type string Aiven internal service type code
- Service
Uri string URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- Service
Username string Username used for connecting to the service, if applicable
- State string
Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- Static
Ips List<string> Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- List<My
Sql Tag> Tags are key-value pairs that allow you to categorize services.
- 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.
- Additional
Disk stringSpace Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- Cloud
Name 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
[]My
Sql Component Args Service component information objects
- Disk
Space 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.
This will be removed in v5.0.0. Please use
additional_disk_space
to specify the space to be added to the defaultdisk_space
defined by the plan.- Disk
Space stringCap The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- Disk
Space stringDefault The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- Disk
Space stringStep 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 fromdisk_space_default
by increments of this size.- Disk
Space stringUsed Disk space that service is currently using
- Maintenance
Window stringDow Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- Maintenance
Window stringTime Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- Mysql
User MyConfig Sql Mysql User Config Args Mysql user configurable settings
- Mysqls
[]My
Sql Mysql Args 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
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.- Project string
Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. This property cannot be changed, doing so forces recreation of the resource.
- Project
Vpc stringId Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- Service
Host string The hostname of the service.
- Service
Integrations []MySql Service Integration Args Service integrations to specify when creating a service. Not applied after initial service creation
- Service
Name 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.
- Service
Password string Password used for connecting to the service, if applicable
- Service
Port int The port of the service
- Service
Type string Aiven internal service type code
- Service
Uri string URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- Service
Username string Username used for connecting to the service, if applicable
- State string
Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- Static
Ips []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
- []My
Sql Tag Args Tags are key-value pairs that allow you to categorize services.
- 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.
- additional
Disk StringSpace Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- cloud
Name 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<My
Sql Component> Service component information objects
- disk
Space 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.
This will be removed in v5.0.0. Please use
additional_disk_space
to specify the space to be added to the defaultdisk_space
defined by the plan.- disk
Space StringCap The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- disk
Space StringDefault The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- disk
Space StringStep 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 fromdisk_space_default
by increments of this size.- disk
Space StringUsed Disk space that service is currently using
- maintenance
Window StringDow Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenance
Window StringTime Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql
User MyConfig Sql Mysql User Config Mysql user configurable settings
- mysqls
List<My
Sql Mysql> 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
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.- project String
Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. This property cannot be changed, doing so forces recreation of the resource.
- project
Vpc StringId Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- service
Host String The hostname of the service.
- service
Integrations List<MySql Service Integration> Service integrations to specify when creating a service. Not applied after initial service creation
- service
Name 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.
- service
Password String Password used for connecting to the service, if applicable
- service
Port Integer The port of the service
- service
Type String Aiven internal service type code
- service
Uri String URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- service
Username String Username used for connecting to the service, if applicable
- state String
Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- static
Ips List<String> Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- List<My
Sql Tag> Tags are key-value pairs that allow you to categorize services.
- termination
Protection 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 stringSpace Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- cloud
Name 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
My
Sql Component[] Service component information objects
- disk
Space 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.
This will be removed in v5.0.0. Please use
additional_disk_space
to specify the space to be added to the defaultdisk_space
defined by the plan.- disk
Space stringCap The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- disk
Space stringDefault The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- disk
Space stringStep 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 fromdisk_space_default
by increments of this size.- disk
Space stringUsed Disk space that service is currently using
- maintenance
Window stringDow Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenance
Window stringTime Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql
User MyConfig Sql Mysql User Config Mysql user configurable settings
- mysqls
My
Sql Mysql[] 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
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.- project string
Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. This property cannot be changed, doing so forces recreation of the resource.
- project
Vpc stringId Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- service
Host string The hostname of the service.
- service
Integrations MySql Service Integration[] Service integrations to specify when creating a service. Not applied after initial service creation
- service
Name 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.
- service
Password string Password used for connecting to the service, if applicable
- service
Port number The port of the service
- service
Type string Aiven internal service type code
- service
Uri string URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- service
Username string Username used for connecting to the service, if applicable
- state string
Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- static
Ips 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
- My
Sql Tag[] Tags are key-value pairs that allow you to categorize services.
- termination
Protection 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_ strspace Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- cloud_
name str Defines where the cloud provider and region where the service is hosted in. This can be changed freely after service is created. Changing the value will trigger a potentially lengthy migration process for the service. Format is cloud provider name (
aws
,azure
,do
google
,upcloud
, etc.), dash, and the cloud provider specific region name. These are documented on each Cloud provider's own support articles, like here for Google and here for AWS.- components
Sequence[My
Sql Component Args] Service component information objects
- disk_
space str Service disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
This will be removed in v5.0.0. Please use
additional_disk_space
to specify the space to be added to the defaultdisk_space
defined by the plan.- disk_
space_ strcap The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- disk_
space_ strdefault The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- disk_
space_ strstep The default disk space step of the service, possible values depend on the service type, the cloud provider and the project.
disk_space
needs to increment fromdisk_space_default
by increments of this size.- disk_
space_ strused Disk space that service is currently using
- maintenance_
window_ strdow Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenance_
window_ strtime Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql_
user_ Myconfig Sql Mysql User Config Args Mysql user configurable settings
- mysqls
Sequence[My
Sql Mysql Args] 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
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.- project str
Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. This property cannot be changed, doing so forces recreation of the resource.
- project_
vpc_ strid Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- service_
host str The hostname of the service.
- service_
integrations Sequence[MySql Service Integration Args] Service integrations to specify when creating a service. Not applied after initial service creation
- service_
name str Specifies the actual name of the service. The name cannot be changed later without destroying and re-creating the service so name should be picked based on intended service usage rather than current attributes.
- service_
password str Password used for connecting to the service, if applicable
- service_
port int The port of the service
- service_
type str Aiven internal service type code
- service_
uri str URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- service_
username str Username used for connecting to the service, if applicable
- state str
Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- static_
ips Sequence[str] Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- Sequence[My
Sql Tag Args] Tags are key-value pairs that allow you to categorize services.
- 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.
- additional
Disk StringSpace Additional disk space. Possible values depend on the service type, the cloud provider and the project. Therefore, reducing will result in the service rebalancing.
- cloud
Name 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
- disk
Space 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.
This will be removed in v5.0.0. Please use
additional_disk_space
to specify the space to be added to the defaultdisk_space
defined by the plan.- disk
Space StringCap The maximum disk space of the service, possible values depend on the service type, the cloud provider and the project.
- disk
Space StringDefault The default disk space of the service, possible values depend on the service type, the cloud provider and the project. Its also the minimum value for
disk_space
- disk
Space StringStep 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 fromdisk_space_default
by increments of this size.- disk
Space StringUsed Disk space that service is currently using
- maintenance
Window StringDow Day of week when maintenance operations should be performed. One monday, tuesday, wednesday, etc.
- maintenance
Window StringTime Time of day when maintenance operations should be performed. UTC time in HH:mm:ss format.
- mysql
User Property MapConfig Mysql user configurable settings
- mysqls List<Property Map>
MySQL specific server provided values
- plan String
Defines what kind of computing resources are allocated for the service. It can be changed after creation, though there are some restrictions when going to a smaller plan such as the new plan must have sufficient amount of disk space to store all current data and switching to a plan with fewer nodes might not be supported. The basic plan names are
hobbyist
,startup-x
,business-x
andpremium-x
wherex
is (roughly) the amount of memory on each node (also other attributes like number of CPUs and amount of disk space varies but naming is based on memory). The available options can be seem from the Aiven pricing page.- project String
Identifies the project this resource belongs to. To set up proper dependencies please refer to this variable as a reference. This property cannot be changed, doing so forces recreation of the resource.
- project
Vpc StringId Specifies the VPC the service should run in. If the value is not set the service is not run inside a VPC. When set, the value should be given as a reference to set up dependencies correctly and the VPC must be in the same cloud and region as the service itself. Project can be freely moved to and from VPC after creation but doing so triggers migration to new servers so the operation can take significant amount of time to complete if the service has a lot of data.
- service
Host String The hostname of the service.
- service
Integrations List<Property Map> Service integrations to specify when creating a service. Not applied after initial service creation
- service
Name 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.
- service
Password String Password used for connecting to the service, if applicable
- service
Port Number The port of the service
- service
Type String Aiven internal service type code
- service
Uri String URI for connecting to the service. Service specific info is under "kafka", "pg", etc.
- service
Username String Username used for connecting to the service, if applicable
- state String
Service state. One of
POWEROFF
,REBALANCING
,REBUILDING
orRUNNING
- static
Ips List<String> Static IPs that are going to be associated with this service. Please assign a value using the 'toset' function. Once a static ip resource is in the 'assigned' state it cannot be unbound from the node again
- List<Property Map>
Tags are key-value pairs that allow you to categorize services.
- termination
Protection Boolean Prevents the service from being deleted. It is recommended to set this to
true
for all production services to prevent unintentional service deletion. This does not shield against deleting databases or topics but for services with backups much of the content can at least be restored from backup in case accidental deletion is done.
Supporting Types
MySqlComponent, MySqlComponentArgs
MySqlMysqlUserConfig, MySqlMysqlUserConfigArgs
- Additional
Backup stringRegions - Admin
Password string - Admin
Username string - Backup
Hour int - Backup
Minute int - Binlog
Retention intPeriod - Ip
Filter List<MyObjects Sql Mysql User Config Ip Filter Object> - Ip
Filter List<string>Strings - Ip
Filters List<string> This will be removed in v5.0.0 and replaced with ip_filter_string instead.
- Migration
My
Sql Mysql User Config Migration - Mysql
My
Sql Mysql User Config Mysql - Mysql
Version string - Private
Access MySql Mysql User Config Private Access - Privatelink
Access MySql Mysql User Config Privatelink Access - Project
To stringFork From - Public
Access MySql Mysql User Config Public Access - Recovery
Target stringTime - Service
To stringFork From - Static
Ips bool
- Additional
Backup stringRegions - Admin
Password string - Admin
Username string - Backup
Hour int - Backup
Minute int - Binlog
Retention intPeriod - Ip
Filter []MyObjects Sql Mysql User Config Ip Filter Object - Ip
Filter []stringStrings - Ip
Filters []string This will be removed in v5.0.0 and replaced with ip_filter_string instead.
- Migration
My
Sql Mysql User Config Migration - Mysql
My
Sql Mysql User Config Mysql - Mysql
Version string - Private
Access MySql Mysql User Config Private Access - Privatelink
Access MySql Mysql User Config Privatelink Access - Project
To stringFork From - Public
Access MySql Mysql User Config Public Access - Recovery
Target stringTime - Service
To stringFork From - Static
Ips bool
- additional
Backup StringRegions - admin
Password String - admin
Username String - backup
Hour Integer - backup
Minute Integer - binlog
Retention IntegerPeriod - ip
Filter List<MyObjects Sql Mysql User Config Ip Filter Object> - ip
Filter List<String>Strings - ip
Filters List<String> This will be removed in v5.0.0 and replaced with ip_filter_string instead.
- migration
My
Sql Mysql User Config Migration - mysql
My
Sql Mysql User Config Mysql - mysql
Version String - private
Access MySql Mysql User Config Private Access - privatelink
Access MySql Mysql User Config Privatelink Access - project
To StringFork From - public
Access MySql Mysql User Config Public Access - recovery
Target StringTime - service
To StringFork From - static
Ips Boolean
- additional
Backup stringRegions - admin
Password string - admin
Username string - backup
Hour number - backup
Minute number - binlog
Retention numberPeriod - ip
Filter MyObjects Sql Mysql User Config Ip Filter Object[] - ip
Filter string[]Strings - ip
Filters string[] This will be removed in v5.0.0 and replaced with ip_filter_string instead.
- migration
My
Sql Mysql User Config Migration - mysql
My
Sql Mysql User Config Mysql - mysql
Version string - private
Access MySql Mysql User Config Private Access - privatelink
Access MySql Mysql User Config Privatelink Access - project
To stringFork From - public
Access MySql Mysql User Config Public Access - recovery
Target stringTime - service
To stringFork From - static
Ips boolean
- additional_
backup_ strregions - admin_
password str - admin_
username str - backup_
hour int - backup_
minute int - binlog_
retention_ intperiod - ip_
filter_ Sequence[Myobjects Sql Mysql User Config Ip Filter Object] - ip_
filter_ Sequence[str]strings - ip_
filters Sequence[str] This will be removed in v5.0.0 and replaced with ip_filter_string instead.
- migration
My
Sql Mysql User Config Migration - mysql
My
Sql Mysql User Config Mysql - mysql_
version str - private_
access MySql Mysql User Config Private Access - privatelink_
access MySql Mysql User Config Privatelink Access - project_
to_ strfork_ from - public_
access MySql Mysql User Config Public Access - recovery_
target_ strtime - service_
to_ strfork_ from - static_
ips bool
- additional
Backup StringRegions - admin
Password String - admin
Username String - backup
Hour Number - backup
Minute Number - binlog
Retention NumberPeriod - ip
Filter List<Property Map>Objects - ip
Filter List<String>Strings - ip
Filters List<String> This will be removed in v5.0.0 and replaced with ip_filter_string instead.
- migration Property Map
- mysql Property Map
- mysql
Version String - private
Access Property Map - privatelink
Access Property Map - project
To StringFork From - public
Access Property Map - recovery
Target StringTime - service
To StringFork From - static
Ips Boolean
MySqlMysqlUserConfigIpFilterObject, MySqlMysqlUserConfigIpFilterObjectArgs
- Network string
- Description string
- Network string
- Description string
- network String
- description String
- network string
- description string
- network str
- description str
- network String
- description String
MySqlMysqlUserConfigMigration, MySqlMysqlUserConfigMigrationArgs
MySqlMysqlUserConfigMysql, MySqlMysqlUserConfigMysqlArgs
- Connect
Timeout int - Default
Time stringZone - Group
Concat intMax Len - Information
Schema intStats Expiry - Innodb
Change intBuffer Max Size - Innodb
Flush intNeighbors - Innodb
Ft intMin Token Size - Innodb
Ft stringServer Stopword Table - Innodb
Lock intWait Timeout - Innodb
Log intBuffer Size - Innodb
Online intAlter Log Max Size - Innodb
Print boolAll Deadlocks - Innodb
Read intIo Threads - Innodb
Rollback boolOn Timeout - Innodb
Thread intConcurrency - Innodb
Write intIo Threads - Interactive
Timeout int - Internal
Tmp stringMem Storage Engine - Long
Query doubleTime - Max
Allowed intPacket - Max
Heap intTable Size - Net
Buffer intLength - Net
Read intTimeout - Net
Write intTimeout - Slow
Query boolLog - Sort
Buffer intSize - Sql
Mode string - Sql
Require boolPrimary Key - Tmp
Table intSize - Wait
Timeout int
- Connect
Timeout int - Default
Time stringZone - Group
Concat intMax Len - Information
Schema intStats Expiry - Innodb
Change intBuffer Max Size - Innodb
Flush intNeighbors - Innodb
Ft intMin Token Size - Innodb
Ft stringServer Stopword Table - Innodb
Lock intWait Timeout - Innodb
Log intBuffer Size - Innodb
Online intAlter Log Max Size - Innodb
Print boolAll Deadlocks - Innodb
Read intIo Threads - Innodb
Rollback boolOn Timeout - Innodb
Thread intConcurrency - Innodb
Write intIo Threads - Interactive
Timeout int - Internal
Tmp stringMem Storage Engine - Long
Query float64Time - Max
Allowed intPacket - Max
Heap intTable Size - Net
Buffer intLength - Net
Read intTimeout - Net
Write intTimeout - Slow
Query boolLog - Sort
Buffer intSize - Sql
Mode string - Sql
Require boolPrimary Key - Tmp
Table intSize - Wait
Timeout int
- connect
Timeout Integer - default
Time StringZone - group
Concat IntegerMax Len - information
Schema IntegerStats Expiry - innodb
Change IntegerBuffer Max Size - innodb
Flush IntegerNeighbors - innodb
Ft IntegerMin Token Size - innodb
Ft StringServer Stopword Table - innodb
Lock IntegerWait Timeout - innodb
Log IntegerBuffer Size - innodb
Online IntegerAlter Log Max Size - innodb
Print BooleanAll Deadlocks - innodb
Read IntegerIo Threads - innodb
Rollback BooleanOn Timeout - innodb
Thread IntegerConcurrency - innodb
Write IntegerIo Threads - interactive
Timeout Integer - internal
Tmp StringMem Storage Engine - long
Query DoubleTime - max
Allowed IntegerPacket - max
Heap IntegerTable Size - net
Buffer IntegerLength - net
Read IntegerTimeout - net
Write IntegerTimeout - slow
Query BooleanLog - sort
Buffer IntegerSize - sql
Mode String - sql
Require BooleanPrimary Key - tmp
Table IntegerSize - wait
Timeout Integer
- connect
Timeout number - default
Time stringZone - group
Concat numberMax Len - information
Schema numberStats Expiry - innodb
Change numberBuffer Max Size - innodb
Flush numberNeighbors - innodb
Ft numberMin Token Size - innodb
Ft stringServer Stopword Table - innodb
Lock numberWait Timeout - innodb
Log numberBuffer Size - innodb
Online numberAlter Log Max Size - innodb
Print booleanAll Deadlocks - innodb
Read numberIo Threads - innodb
Rollback booleanOn Timeout - innodb
Thread numberConcurrency - innodb
Write numberIo Threads - interactive
Timeout number - internal
Tmp stringMem Storage Engine - long
Query numberTime - max
Allowed numberPacket - max
Heap numberTable Size - net
Buffer numberLength - net
Read numberTimeout - net
Write numberTimeout - slow
Query booleanLog - sort
Buffer numberSize - sql
Mode string - sql
Require booleanPrimary Key - tmp
Table numberSize - wait
Timeout number
- connect_
timeout int - default_
time_ strzone - group_
concat_ intmax_ len - information_
schema_ intstats_ expiry - innodb_
change_ intbuffer_ max_ size - innodb_
flush_ intneighbors - innodb_
ft_ intmin_ token_ size - innodb_
ft_ strserver_ stopword_ table - innodb_
lock_ intwait_ timeout - innodb_
log_ intbuffer_ size - innodb_
online_ intalter_ log_ max_ size - innodb_
print_ boolall_ deadlocks - innodb_
read_ intio_ threads - innodb_
rollback_ boolon_ timeout - innodb_
thread_ intconcurrency - innodb_
write_ intio_ threads - interactive_
timeout int - internal_
tmp_ strmem_ storage_ engine - long_
query_ floattime - max_
allowed_ intpacket - max_
heap_ inttable_ size - net_
buffer_ intlength - net_
read_ inttimeout - net_
write_ inttimeout - slow_
query_ boollog - sort_
buffer_ intsize - sql_
mode str - sql_
require_ boolprimary_ key - tmp_
table_ intsize - wait_
timeout int
- connect
Timeout Number - default
Time StringZone - group
Concat NumberMax Len - information
Schema NumberStats Expiry - innodb
Change NumberBuffer Max Size - innodb
Flush NumberNeighbors - innodb
Ft NumberMin Token Size - innodb
Ft StringServer Stopword Table - innodb
Lock NumberWait Timeout - innodb
Log NumberBuffer Size - innodb
Online NumberAlter Log Max Size - innodb
Print BooleanAll Deadlocks - innodb
Read NumberIo Threads - innodb
Rollback BooleanOn Timeout - innodb
Thread NumberConcurrency - innodb
Write NumberIo Threads - interactive
Timeout Number - internal
Tmp StringMem Storage Engine - long
Query NumberTime - max
Allowed NumberPacket - max
Heap NumberTable Size - net
Buffer NumberLength - net
Read NumberTimeout - net
Write NumberTimeout - slow
Query BooleanLog - sort
Buffer NumberSize - sql
Mode String - sql
Require BooleanPrimary Key - tmp
Table NumberSize - wait
Timeout Number
MySqlMysqlUserConfigPrivateAccess, MySqlMysqlUserConfigPrivateAccessArgs
- Mysql bool
- Mysqlx bool
- Prometheus bool
- Mysql bool
- Mysqlx bool
- Prometheus bool
- mysql Boolean
- mysqlx Boolean
- prometheus Boolean
- mysql boolean
- mysqlx boolean
- prometheus boolean
- mysql bool
- mysqlx bool
- prometheus bool
- mysql Boolean
- mysqlx Boolean
- prometheus Boolean
MySqlMysqlUserConfigPrivatelinkAccess, MySqlMysqlUserConfigPrivatelinkAccessArgs
- Mysql bool
- Mysqlx bool
- Prometheus bool
- Mysql bool
- Mysqlx bool
- Prometheus bool
- mysql Boolean
- mysqlx Boolean
- prometheus Boolean
- mysql boolean
- mysqlx boolean
- prometheus boolean
- mysql bool
- mysqlx bool
- prometheus bool
- mysql Boolean
- mysqlx Boolean
- prometheus Boolean
MySqlMysqlUserConfigPublicAccess, MySqlMysqlUserConfigPublicAccessArgs
- Mysql bool
- Mysqlx bool
- Prometheus bool
- Mysql bool
- Mysqlx bool
- Prometheus bool
- mysql Boolean
- mysqlx Boolean
- prometheus Boolean
- mysql boolean
- mysqlx boolean
- prometheus boolean
- mysql bool
- mysqlx bool
- prometheus bool
- mysql Boolean
- mysqlx Boolean
- prometheus Boolean
MySqlServiceIntegration, MySqlServiceIntegrationArgs
- Integration
Type string - Source
Service stringName
- Integration
Type string - Source
Service stringName
- integration
Type String - source
Service StringName
- integration
Type string - source
Service stringName
- integration
Type String - source
Service StringName
MySqlTag, MySqlTagArgs
Import
$ pulumi import aiven:index/mySql:MySql mysql1 project/service_name
Package Details
- Repository
- Aiven pulumi/pulumi-aiven
- License
- Apache-2.0
- Notes
This Pulumi package is based on the
aiven
Terraform Provider.