linode.getDatabaseMysqlV2

Explore with Pulumi AI

Linode v5.1.1 published on Thursday, Jul 31, 2025 by Pulumi

pulumi/pulumi-linode

Example Usage

Get information about a MySQL database:

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

const my_db = linode.getDatabaseMysqlV2({
    id: "12345",
});

import pulumi
import pulumi_linode as linode

my_db = linode.get_database_mysql_v2(id="12345")

package main

import (
	"github.com/pulumi/pulumi-linode/sdk/v5/go/linode"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := linode.LookupDatabaseMysqlV2(ctx, &linode.LookupDatabaseMysqlV2Args{
			Id: "12345",
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Linode = Pulumi.Linode;

return await Deployment.RunAsync(() => 
{
    var my_db = Linode.GetDatabaseMysqlV2.Invoke(new()
    {
        Id = "12345",
    });

});

package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.linode.LinodeFunctions;
import com.pulumi.linode.inputs.GetDatabaseMysqlV2Args;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var my-db = LinodeFunctions.getDatabaseMysqlV2(GetDatabaseMysqlV2Args.builder()
            .id("12345")
            .build());

    }
}

variables:
  my-db:
    fn::invoke:
      function: linode:getDatabaseMysqlV2
      arguments:
        id: 12345

pending_updates

The following arguments are exposed by each entry in the pending_updates attribute:

deadline - The time when a mandatory update needs to be applied.
description - A description of the update.
planned_for - The date and time a maintenance update will be applied.

updates

The following arguments are supported in the updates specification block:

day_of_week - The day to perform maintenance. (monday, tuesday, …)
duration - The maximum maintenance window time in hours. (1..3)
frequency - The frequency at which maintenance occurs. (weekly)
hour_of_day - The hour to begin maintenance based in UTC time. (0..23)

Using getDatabaseMysqlV2

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

function getDatabaseMysqlV2(args: GetDatabaseMysqlV2Args, opts?: InvokeOptions): Promise<GetDatabaseMysqlV2Result>
function getDatabaseMysqlV2Output(args: GetDatabaseMysqlV2OutputArgs, opts?: InvokeOptions): Output<GetDatabaseMysqlV2Result>

def get_database_mysql_v2(id: Optional[str] = None,
                          opts: Optional[InvokeOptions] = None) -> GetDatabaseMysqlV2Result
def get_database_mysql_v2_output(id: Optional[pulumi.Input[str]] = None,
                          opts: Optional[InvokeOptions] = None) -> Output[GetDatabaseMysqlV2Result]

func LookupDatabaseMysqlV2(ctx *Context, args *LookupDatabaseMysqlV2Args, opts ...InvokeOption) (*LookupDatabaseMysqlV2Result, error)
func LookupDatabaseMysqlV2Output(ctx *Context, args *LookupDatabaseMysqlV2OutputArgs, opts ...InvokeOption) LookupDatabaseMysqlV2ResultOutput

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

public static class GetDatabaseMysqlV2 
{
    public static Task<GetDatabaseMysqlV2Result> InvokeAsync(GetDatabaseMysqlV2Args args, InvokeOptions? opts = null)
    public static Output<GetDatabaseMysqlV2Result> Invoke(GetDatabaseMysqlV2InvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetDatabaseMysqlV2Result> getDatabaseMysqlV2(GetDatabaseMysqlV2Args args, InvokeOptions options)
public static Output<GetDatabaseMysqlV2Result> getDatabaseMysqlV2(GetDatabaseMysqlV2Args args, InvokeOptions options)

fn::invoke:
  function: linode:index/getDatabaseMysqlV2:getDatabaseMysqlV2
  arguments:
    # arguments dictionary

The following arguments are supported:

Id string: The ID of the MySQL database.

Id string: The ID of the MySQL database.

id String: The ID of the MySQL database.

id string: The ID of the MySQL database.

id str: The ID of the MySQL database.

id String: The ID of the MySQL database.

getDatabaseMysqlV2 Result

The following output properties are available:

AllowLists List<string>: A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.
CaCert string: The base64-encoded SSL CA certificate for the Managed Database.
ClusterSize int: The number of Linode Instance nodes deployed to the Managed Database. (default 1)
Created string: When this Managed Database was created.
Encrypted bool: Whether the Managed Databases is encrypted.
Engine string: The Managed Database engine. (e.g. mysql)
EngineConfigBinlogRetentionPeriod int: The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default, for example if using the MySQL Debezium Kafka connector.
EngineConfigMysqlConnectTimeout int: The number of seconds that the mysqld server waits for a connect packet before responding with "Bad handshake".
EngineConfigMysqlDefaultTimeZone 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.
EngineConfigMysqlGroupConcatMaxLen double: The maximum permitted result length in bytes for the GROUP_CONCAT() function.
EngineConfigMysqlInformationSchemaStatsExpiry int: The time, in seconds, before cached statistics expire.
EngineConfigMysqlInnodbChangeBufferMaxSize int: Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
EngineConfigMysqlInnodbFlushNeighbors int: Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent.
EngineConfigMysqlInnodbFtMinTokenSize int: Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service.
EngineConfigMysqlInnodbFtServerStopwordTable string: This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
EngineConfigMysqlInnodbLockWaitTimeout int: The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
EngineConfigMysqlInnodbLogBufferSize int: The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
EngineConfigMysqlInnodbOnlineAlterLogMaxSize int: The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
EngineConfigMysqlInnodbReadIoThreads int: The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
EngineConfigMysqlInnodbRollbackOnTimeout bool: When enabled, a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
EngineConfigMysqlInnodbThreadConcurrency int: Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
EngineConfigMysqlInnodbWriteIoThreads int: The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
EngineConfigMysqlInteractiveTimeout int: The number of seconds the server waits for activity on an interactive connection before closing it.
EngineConfigMysqlInternalTmpMemStorageEngine string: The storage engine for in-memory internal temporary tables.
EngineConfigMysqlMaxAllowedPacket int: Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
EngineConfigMysqlMaxHeapTableSize int: Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
EngineConfigMysqlNetBufferLength int: Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service.
EngineConfigMysqlNetReadTimeout int: The number of seconds to wait for more data from a connection before aborting the read.
EngineConfigMysqlNetWriteTimeout int: The number of seconds to wait for a block to be written to a connection before aborting the write.
EngineConfigMysqlSortBufferSize int: Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
EngineConfigMysqlSqlMode 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.
EngineConfigMysqlSqlRequirePrimaryKey bool: Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
EngineConfigMysqlTmpTableSize int: Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
EngineConfigMysqlWaitTimeout int: The number of seconds the server waits for activity on a noninteractive connection before closing it.
EngineId string: The Managed Database engine in engine/version format. (e.g. mysql)
ForkRestoreTime string: The database timestamp from which it was restored.
ForkSource int: The ID of the database that was forked from.
HostPrimary string: The primary host for the Managed Database.
HostSecondary string: The secondary/private host for the managed database.
Id string
Label string: A unique, user-defined string referring to the Managed Database.
Members Dictionary<string, string>
OldestRestoreTime string
PendingUpdates List<GetDatabaseMysqlV2PendingUpdate>
Platform string: The back-end platform for relational databases used by the service.
Port int: The access port for this Managed Database.
Region string: The region to use for the Managed Database.
RootPassword string: The randomly-generated root password for the Managed Database instance.
RootUsername string: The root username for the Managed Database instance.
SslConnection bool: Whether to require SSL credentials to establish a connection to the Managed Database.
Status string: The operating status of the Managed Database.
Suspended bool: Whether this Managed Database is suspended.
Type string: The Linode Instance type used for the nodes of the Managed Database.
Updated string: When this Managed Database was last updated.
Updates GetDatabaseMysqlV2Updates
Version string: The Managed Database engine version. (e.g. 13.2)

AllowLists []string: A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.
CaCert string: The base64-encoded SSL CA certificate for the Managed Database.
ClusterSize int: The number of Linode Instance nodes deployed to the Managed Database. (default 1)
Created string: When this Managed Database was created.
Encrypted bool: Whether the Managed Databases is encrypted.
Engine string: The Managed Database engine. (e.g. mysql)
EngineConfigBinlogRetentionPeriod int: The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default, for example if using the MySQL Debezium Kafka connector.
EngineConfigMysqlConnectTimeout int: The number of seconds that the mysqld server waits for a connect packet before responding with "Bad handshake".
EngineConfigMysqlDefaultTimeZone 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.
EngineConfigMysqlGroupConcatMaxLen float64: The maximum permitted result length in bytes for the GROUP_CONCAT() function.
EngineConfigMysqlInformationSchemaStatsExpiry int: The time, in seconds, before cached statistics expire.
EngineConfigMysqlInnodbChangeBufferMaxSize int: Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
EngineConfigMysqlInnodbFlushNeighbors int: Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent.
EngineConfigMysqlInnodbFtMinTokenSize int: Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service.
EngineConfigMysqlInnodbFtServerStopwordTable string: This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
EngineConfigMysqlInnodbLockWaitTimeout int: The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
EngineConfigMysqlInnodbLogBufferSize int: The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
EngineConfigMysqlInnodbOnlineAlterLogMaxSize int: The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
EngineConfigMysqlInnodbReadIoThreads int: The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
EngineConfigMysqlInnodbRollbackOnTimeout bool: When enabled, a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
EngineConfigMysqlInnodbThreadConcurrency int: Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
EngineConfigMysqlInnodbWriteIoThreads int: The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
EngineConfigMysqlInteractiveTimeout int: The number of seconds the server waits for activity on an interactive connection before closing it.
EngineConfigMysqlInternalTmpMemStorageEngine string: The storage engine for in-memory internal temporary tables.
EngineConfigMysqlMaxAllowedPacket int: Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
EngineConfigMysqlMaxHeapTableSize int: Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
EngineConfigMysqlNetBufferLength int: Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service.
EngineConfigMysqlNetReadTimeout int: The number of seconds to wait for more data from a connection before aborting the read.
EngineConfigMysqlNetWriteTimeout int: The number of seconds to wait for a block to be written to a connection before aborting the write.
EngineConfigMysqlSortBufferSize int: Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
EngineConfigMysqlSqlMode 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.
EngineConfigMysqlSqlRequirePrimaryKey bool: Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
EngineConfigMysqlTmpTableSize int: Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
EngineConfigMysqlWaitTimeout int: The number of seconds the server waits for activity on a noninteractive connection before closing it.
EngineId string: The Managed Database engine in engine/version format. (e.g. mysql)
ForkRestoreTime string: The database timestamp from which it was restored.
ForkSource int: The ID of the database that was forked from.
HostPrimary string: The primary host for the Managed Database.
HostSecondary string: The secondary/private host for the managed database.
Id string
Label string: A unique, user-defined string referring to the Managed Database.
Members map[string]string
OldestRestoreTime string
PendingUpdates []GetDatabaseMysqlV2PendingUpdate
Platform string: The back-end platform for relational databases used by the service.
Port int: The access port for this Managed Database.
Region string: The region to use for the Managed Database.
RootPassword string: The randomly-generated root password for the Managed Database instance.
RootUsername string: The root username for the Managed Database instance.
SslConnection bool: Whether to require SSL credentials to establish a connection to the Managed Database.
Status string: The operating status of the Managed Database.
Suspended bool: Whether this Managed Database is suspended.
Type string: The Linode Instance type used for the nodes of the Managed Database.
Updated string: When this Managed Database was last updated.
Updates GetDatabaseMysqlV2Updates
Version string: The Managed Database engine version. (e.g. 13.2)

allowLists List<String>: A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.
caCert String: The base64-encoded SSL CA certificate for the Managed Database.
clusterSize Integer: The number of Linode Instance nodes deployed to the Managed Database. (default 1)
created String: When this Managed Database was created.
encrypted Boolean: Whether the Managed Databases is encrypted.
engine String: The Managed Database engine. (e.g. mysql)
engineConfigBinlogRetentionPeriod Integer: The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default, for example if using the MySQL Debezium Kafka connector.
engineConfigMysqlConnectTimeout Integer: The number of seconds that the mysqld server waits for a connect packet before responding with "Bad handshake".
engineConfigMysqlDefaultTimeZone 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.
engineConfigMysqlGroupConcatMaxLen Double: The maximum permitted result length in bytes for the GROUP_CONCAT() function.
engineConfigMysqlInformationSchemaStatsExpiry Integer: The time, in seconds, before cached statistics expire.
engineConfigMysqlInnodbChangeBufferMaxSize Integer: Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
engineConfigMysqlInnodbFlushNeighbors Integer: Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent.
engineConfigMysqlInnodbFtMinTokenSize Integer: Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service.
engineConfigMysqlInnodbFtServerStopwordTable String: This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
engineConfigMysqlInnodbLockWaitTimeout Integer: The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
engineConfigMysqlInnodbLogBufferSize Integer: The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
engineConfigMysqlInnodbOnlineAlterLogMaxSize Integer: The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
engineConfigMysqlInnodbReadIoThreads Integer: The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
engineConfigMysqlInnodbRollbackOnTimeout Boolean: When enabled, a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
engineConfigMysqlInnodbThreadConcurrency Integer: Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
engineConfigMysqlInnodbWriteIoThreads Integer: The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
engineConfigMysqlInteractiveTimeout Integer: The number of seconds the server waits for activity on an interactive connection before closing it.
engineConfigMysqlInternalTmpMemStorageEngine String: The storage engine for in-memory internal temporary tables.
engineConfigMysqlMaxAllowedPacket Integer: Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
engineConfigMysqlMaxHeapTableSize Integer: Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
engineConfigMysqlNetBufferLength Integer: Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service.
engineConfigMysqlNetReadTimeout Integer: The number of seconds to wait for more data from a connection before aborting the read.
engineConfigMysqlNetWriteTimeout Integer: The number of seconds to wait for a block to be written to a connection before aborting the write.
engineConfigMysqlSortBufferSize Integer: Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
engineConfigMysqlSqlMode 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.
engineConfigMysqlSqlRequirePrimaryKey Boolean: Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
engineConfigMysqlTmpTableSize Integer: Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
engineConfigMysqlWaitTimeout Integer: The number of seconds the server waits for activity on a noninteractive connection before closing it.
engineId String: The Managed Database engine in engine/version format. (e.g. mysql)
forkRestoreTime String: The database timestamp from which it was restored.
forkSource Integer: The ID of the database that was forked from.
hostPrimary String: The primary host for the Managed Database.
hostSecondary String: The secondary/private host for the managed database.
id String
label String: A unique, user-defined string referring to the Managed Database.
members Map<String,String>
oldestRestoreTime String
pendingUpdates List<GetDatabaseMysqlV2PendingUpdate>
platform String: The back-end platform for relational databases used by the service.
port Integer: The access port for this Managed Database.
region String: The region to use for the Managed Database.
rootPassword String: The randomly-generated root password for the Managed Database instance.
rootUsername String: The root username for the Managed Database instance.
sslConnection Boolean: Whether to require SSL credentials to establish a connection to the Managed Database.
status String: The operating status of the Managed Database.
suspended Boolean: Whether this Managed Database is suspended.
type String: The Linode Instance type used for the nodes of the Managed Database.
updated String: When this Managed Database was last updated.
updates GetDatabaseMysqlV2Updates
version String: The Managed Database engine version. (e.g. 13.2)

allowLists string[]: A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.
caCert string: The base64-encoded SSL CA certificate for the Managed Database.
clusterSize number: The number of Linode Instance nodes deployed to the Managed Database. (default 1)
created string: When this Managed Database was created.
encrypted boolean: Whether the Managed Databases is encrypted.
engine string: The Managed Database engine. (e.g. mysql)
engineConfigBinlogRetentionPeriod number: The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default, for example if using the MySQL Debezium Kafka connector.
engineConfigMysqlConnectTimeout number: The number of seconds that the mysqld server waits for a connect packet before responding with "Bad handshake".
engineConfigMysqlDefaultTimeZone 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.
engineConfigMysqlGroupConcatMaxLen number: The maximum permitted result length in bytes for the GROUP_CONCAT() function.
engineConfigMysqlInformationSchemaStatsExpiry number: The time, in seconds, before cached statistics expire.
engineConfigMysqlInnodbChangeBufferMaxSize number: Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
engineConfigMysqlInnodbFlushNeighbors number: Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent.
engineConfigMysqlInnodbFtMinTokenSize number: Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service.
engineConfigMysqlInnodbFtServerStopwordTable string: This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
engineConfigMysqlInnodbLockWaitTimeout number: The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
engineConfigMysqlInnodbLogBufferSize number: The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
engineConfigMysqlInnodbOnlineAlterLogMaxSize number: The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
engineConfigMysqlInnodbReadIoThreads number: The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
engineConfigMysqlInnodbRollbackOnTimeout boolean: When enabled, a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
engineConfigMysqlInnodbThreadConcurrency number: Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
engineConfigMysqlInnodbWriteIoThreads number: The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
engineConfigMysqlInteractiveTimeout number: The number of seconds the server waits for activity on an interactive connection before closing it.
engineConfigMysqlInternalTmpMemStorageEngine string: The storage engine for in-memory internal temporary tables.
engineConfigMysqlMaxAllowedPacket number: Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
engineConfigMysqlMaxHeapTableSize number: Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
engineConfigMysqlNetBufferLength number: Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service.
engineConfigMysqlNetReadTimeout number: The number of seconds to wait for more data from a connection before aborting the read.
engineConfigMysqlNetWriteTimeout number: The number of seconds to wait for a block to be written to a connection before aborting the write.
engineConfigMysqlSortBufferSize number: Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
engineConfigMysqlSqlMode 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.
engineConfigMysqlSqlRequirePrimaryKey boolean: Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
engineConfigMysqlTmpTableSize number: Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
engineConfigMysqlWaitTimeout number: The number of seconds the server waits for activity on a noninteractive connection before closing it.
engineId string: The Managed Database engine in engine/version format. (e.g. mysql)
forkRestoreTime string: The database timestamp from which it was restored.
forkSource number: The ID of the database that was forked from.
hostPrimary string: The primary host for the Managed Database.
hostSecondary string: The secondary/private host for the managed database.
id string
label string: A unique, user-defined string referring to the Managed Database.
members {[key: string]: string}
oldestRestoreTime string
pendingUpdates GetDatabaseMysqlV2PendingUpdate[]
platform string: The back-end platform for relational databases used by the service.
port number: The access port for this Managed Database.
region string: The region to use for the Managed Database.
rootPassword string: The randomly-generated root password for the Managed Database instance.
rootUsername string: The root username for the Managed Database instance.
sslConnection boolean: Whether to require SSL credentials to establish a connection to the Managed Database.
status string: The operating status of the Managed Database.
suspended boolean: Whether this Managed Database is suspended.
type string: The Linode Instance type used for the nodes of the Managed Database.
updated string: When this Managed Database was last updated.
updates GetDatabaseMysqlV2Updates
version string: The Managed Database engine version. (e.g. 13.2)

allow_lists Sequence[str]: A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.
ca_cert str: The base64-encoded SSL CA certificate for the Managed Database.
cluster_size int: The number of Linode Instance nodes deployed to the Managed Database. (default 1)
created str: When this Managed Database was created.
encrypted bool: Whether the Managed Databases is encrypted.
engine str: The Managed Database engine. (e.g. mysql)
engine_config_binlog_retention_period int: The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default, for example if using the MySQL Debezium Kafka connector.
engine_config_mysql_connect_timeout int: The number of seconds that the mysqld server waits for a connect packet before responding with "Bad handshake".
engine_config_mysql_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.
engine_config_mysql_group_concat_max_len float: The maximum permitted result length in bytes for the GROUP_CONCAT() function.
engine_config_mysql_information_schema_stats_expiry int: The time, in seconds, before cached statistics expire.
engine_config_mysql_innodb_change_buffer_max_size int: Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
engine_config_mysql_innodb_flush_neighbors int: Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent.
engine_config_mysql_innodb_ft_min_token_size int: Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service.
engine_config_mysql_innodb_ft_server_stopword_table str: This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
engine_config_mysql_innodb_lock_wait_timeout int: The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
engine_config_mysql_innodb_log_buffer_size int: The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
engine_config_mysql_innodb_online_alter_log_max_size int: The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
engine_config_mysql_innodb_read_io_threads int: The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
engine_config_mysql_innodb_rollback_on_timeout bool: When enabled, a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
engine_config_mysql_innodb_thread_concurrency int: Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
engine_config_mysql_innodb_write_io_threads int: The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
engine_config_mysql_interactive_timeout int: The number of seconds the server waits for activity on an interactive connection before closing it.
engine_config_mysql_internal_tmp_mem_storage_engine str: The storage engine for in-memory internal temporary tables.
engine_config_mysql_max_allowed_packet int: Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
engine_config_mysql_max_heap_table_size int: Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
engine_config_mysql_net_buffer_length int: Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service.
engine_config_mysql_net_read_timeout int: The number of seconds to wait for more data from a connection before aborting the read.
engine_config_mysql_net_write_timeout int: The number of seconds to wait for a block to be written to a connection before aborting the write.
engine_config_mysql_sort_buffer_size int: Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
engine_config_mysql_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.
engine_config_mysql_sql_require_primary_key bool: Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
engine_config_mysql_tmp_table_size int: Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
engine_config_mysql_wait_timeout int: The number of seconds the server waits for activity on a noninteractive connection before closing it.
engine_id str: The Managed Database engine in engine/version format. (e.g. mysql)
fork_restore_time str: The database timestamp from which it was restored.
fork_source int: The ID of the database that was forked from.
host_primary str: The primary host for the Managed Database.
host_secondary str: The secondary/private host for the managed database.
id str
label str: A unique, user-defined string referring to the Managed Database.
members Mapping[str, str]
oldest_restore_time str
pending_updates Sequence[GetDatabaseMysqlV2PendingUpdate]
platform str: The back-end platform for relational databases used by the service.
port int: The access port for this Managed Database.
region str: The region to use for the Managed Database.
root_password str: The randomly-generated root password for the Managed Database instance.
root_username str: The root username for the Managed Database instance.
ssl_connection bool: Whether to require SSL credentials to establish a connection to the Managed Database.
status str: The operating status of the Managed Database.
suspended bool: Whether this Managed Database is suspended.
type str: The Linode Instance type used for the nodes of the Managed Database.
updated str: When this Managed Database was last updated.
updates GetDatabaseMysqlV2Updates
version str: The Managed Database engine version. (e.g. 13.2)

allowLists List<String>: A list of IP addresses that can access the Managed Database. Each item can be a single IP address or a range in CIDR format. Use linode.DatabaseAccessControls to manage your allow list separately.
caCert String: The base64-encoded SSL CA certificate for the Managed Database.
clusterSize Number: The number of Linode Instance nodes deployed to the Managed Database. (default 1)
created String: When this Managed Database was created.
encrypted Boolean: Whether the Managed Databases is encrypted.
engine String: The Managed Database engine. (e.g. mysql)
engineConfigBinlogRetentionPeriod Number: The minimum amount of time in seconds to keep binlog entries before deletion. This may be extended for services that require binlog entries for longer than the default, for example if using the MySQL Debezium Kafka connector.
engineConfigMysqlConnectTimeout Number: The number of seconds that the mysqld server waits for a connect packet before responding with "Bad handshake".
engineConfigMysqlDefaultTimeZone 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.
engineConfigMysqlGroupConcatMaxLen Number: The maximum permitted result length in bytes for the GROUP_CONCAT() function.
engineConfigMysqlInformationSchemaStatsExpiry Number: The time, in seconds, before cached statistics expire.
engineConfigMysqlInnodbChangeBufferMaxSize Number: Maximum size for the InnoDB change buffer, as a percentage of the total size of the buffer pool. Default is 25.
engineConfigMysqlInnodbFlushNeighbors Number: Specifies whether flushing a page from the InnoDB buffer pool also flushes other dirty pages in the same extent (default is 1): 0 - dirty pages in the same extent are not flushed, 1 - flush contiguous dirty pages in the same extent, 2 - flush dirty pages in the same extent.
engineConfigMysqlInnodbFtMinTokenSize Number: Minimum length of words that are stored in an InnoDB FULLTEXT index. Changing this parameter will lead to a restart of the MySQL service.
engineConfigMysqlInnodbFtServerStopwordTable String: This option is used to specify your own InnoDB FULLTEXT index stopword list for all InnoDB tables.
engineConfigMysqlInnodbLockWaitTimeout Number: The length of time in seconds an InnoDB transaction waits for a row lock before giving up. Default is 120.
engineConfigMysqlInnodbLogBufferSize Number: The size in bytes of the buffer that InnoDB uses to write to the log files on disk.
engineConfigMysqlInnodbOnlineAlterLogMaxSize Number: The upper limit in bytes on the size of the temporary log files used during online DDL operations for InnoDB tables.
engineConfigMysqlInnodbReadIoThreads Number: The number of I/O threads for read operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
engineConfigMysqlInnodbRollbackOnTimeout Boolean: When enabled, a transaction timeout causes InnoDB to abort and roll back the entire transaction. Changing this parameter will lead to a restart of the MySQL service.
engineConfigMysqlInnodbThreadConcurrency Number: Defines the maximum number of threads permitted inside of InnoDB. Default is 0 (infinite concurrency - no limit).
engineConfigMysqlInnodbWriteIoThreads Number: The number of I/O threads for write operations in InnoDB. Default is 4. Changing this parameter will lead to a restart of the MySQL service.
engineConfigMysqlInteractiveTimeout Number: The number of seconds the server waits for activity on an interactive connection before closing it.
engineConfigMysqlInternalTmpMemStorageEngine String: The storage engine for in-memory internal temporary tables.
engineConfigMysqlMaxAllowedPacket Number: Size of the largest message in bytes that can be received by the server. Default is 67108864 (64M).
engineConfigMysqlMaxHeapTableSize Number: Limits the size of internal in-memory tables. Also set tmp_table_size. Default is 16777216 (16M).
engineConfigMysqlNetBufferLength Number: Start sizes of connection buffer and result buffer. Default is 16384 (16K). Changing this parameter will lead to a restart of the MySQL service.
engineConfigMysqlNetReadTimeout Number: The number of seconds to wait for more data from a connection before aborting the read.
engineConfigMysqlNetWriteTimeout Number: The number of seconds to wait for a block to be written to a connection before aborting the write.
engineConfigMysqlSortBufferSize Number: Sort buffer size in bytes for ORDER BY optimization. Default is 262144 (256K).
engineConfigMysqlSqlMode 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.
engineConfigMysqlSqlRequirePrimaryKey Boolean: Require primary key to be defined for new tables or old tables modified with ALTER TABLE and fail if missing. It is recommended to always have primary keys because various functionality may break if any large table is missing them.
engineConfigMysqlTmpTableSize Number: Limits the size of internal in-memory tables. Also set max_heap_table_size. Default is 16777216 (16M).
engineConfigMysqlWaitTimeout Number: The number of seconds the server waits for activity on a noninteractive connection before closing it.
engineId String: The Managed Database engine in engine/version format. (e.g. mysql)
forkRestoreTime String: The database timestamp from which it was restored.
forkSource Number: The ID of the database that was forked from.
hostPrimary String: The primary host for the Managed Database.
hostSecondary String: The secondary/private host for the managed database.
id String
label String: A unique, user-defined string referring to the Managed Database.
members Map<String>
oldestRestoreTime String
pendingUpdates List<Property Map>
platform String: The back-end platform for relational databases used by the service.
port Number: The access port for this Managed Database.
region String: The region to use for the Managed Database.
rootPassword String: The randomly-generated root password for the Managed Database instance.
rootUsername String: The root username for the Managed Database instance.
sslConnection Boolean: Whether to require SSL credentials to establish a connection to the Managed Database.
status String: The operating status of the Managed Database.
suspended Boolean: Whether this Managed Database is suspended.
type String: The Linode Instance type used for the nodes of the Managed Database.
updated String: When this Managed Database was last updated.
updates Property Map
version String: The Managed Database engine version. (e.g. 13.2)