linode.getDatabaseMysql

Explore with Pulumi AI

Linode v4.37.0 published on Thursday, Apr 10, 2025 by Pulumi

Example Usage

Get information about a MySQL database:

TypeScript
Python
Go
C#
Java
YAML

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

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

import pulumi
import pulumi_linode as linode

my_db = linode.get_database_mysql(id=12345)

package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := linode.LookupDatabaseMysql(ctx, &linode.LookupDatabaseMysqlArgs{
			Id: pulumi.IntRef(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.GetDatabaseMysql.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.GetDatabaseMysqlArgs;
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.getDatabaseMysql(GetDatabaseMysqlArgs.builder()
            .id(12345)
            .build());

    }
}

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

updates

The following arguments are exported by 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 - Whether maintenance occurs on a weekly or monthly basis. (weekly, monthly)
hour_of_day - The hour to begin maintenance based in UTC time. (0..23)
week_of_month - The week of the month to perform monthly frequency updates. Required for monthly frequency updates. (1..4)

Using getDatabaseMysql

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.

TypeScript
Python
Go
C#
Java
YAML

function getDatabaseMysql(args: GetDatabaseMysqlArgs, opts?: InvokeOptions): Promise<GetDatabaseMysqlResult>
function getDatabaseMysqlOutput(args: GetDatabaseMysqlOutputArgs, opts?: InvokeOptions): Output<GetDatabaseMysqlResult>

def get_database_mysql(database_id: Optional[int] = None,
                       id: Optional[int] = None,
                       opts: Optional[InvokeOptions] = None) -> GetDatabaseMysqlResult
def get_database_mysql_output(database_id: Optional[pulumi.Input[int]] = None,
                       id: Optional[pulumi.Input[int]] = None,
                       opts: Optional[InvokeOptions] = None) -> Output[GetDatabaseMysqlResult]

func LookupDatabaseMysql(ctx *Context, args *LookupDatabaseMysqlArgs, opts ...InvokeOption) (*LookupDatabaseMysqlResult, error)
func LookupDatabaseMysqlOutput(ctx *Context, args *LookupDatabaseMysqlOutputArgs, opts ...InvokeOption) LookupDatabaseMysqlResultOutput

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

public static class GetDatabaseMysql 
{
    public static Task<GetDatabaseMysqlResult> InvokeAsync(GetDatabaseMysqlArgs args, InvokeOptions? opts = null)
    public static Output<GetDatabaseMysqlResult> Invoke(GetDatabaseMysqlInvokeArgs args, InvokeOptions? opts = null)
}

public static CompletableFuture<GetDatabaseMysqlResult> getDatabaseMysql(GetDatabaseMysqlArgs args, InvokeOptions options)
public static Output<GetDatabaseMysqlResult> getDatabaseMysql(GetDatabaseMysqlArgs args, InvokeOptions options)

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

The following arguments are supported:

DatabaseId int: The ID of the MySQL database. Deprecated: Use id instead.
Deprecated: Configure id instead. This attribute will be removed in the next major version of the provider.
Id int: The ID of the MySQL database. Mutually exclusive with database_id.

DatabaseId int: The ID of the MySQL database. Deprecated: Use id instead.
Deprecated: Configure id instead. This attribute will be removed in the next major version of the provider.
Id int: The ID of the MySQL database. Mutually exclusive with database_id.

databaseId Integer: The ID of the MySQL database. Deprecated: Use id instead.
Deprecated: Configure id instead. This attribute will be removed in the next major version of the provider.
id Integer: The ID of the MySQL database. Mutually exclusive with database_id.

databaseId number: The ID of the MySQL database. Deprecated: Use id instead.
Deprecated: Configure id instead. This attribute will be removed in the next major version of the provider.
id number: The ID of the MySQL database. Mutually exclusive with database_id.

database_id int: The ID of the MySQL database. Deprecated: Use id instead.
Deprecated: Configure id instead. This attribute will be removed in the next major version of the provider.
id int: The ID of the MySQL database. Mutually exclusive with database_id.

databaseId Number: The ID of the MySQL database. Deprecated: Use id instead.
Deprecated: Configure id instead. This attribute will be removed in the next major version of the provider.
id Number: The ID of the MySQL database. Mutually exclusive with database_id.

getDatabaseMysql 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.
CaCert string: The base64-encoded SSL CA certificate for the Managed Database instance.
ClusterSize int: The number of Linode Instance nodes deployed to the Managed Database.
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)
EngineId string: The Managed Database engine in engine/version format. (e.g. mysql/8.0.30)
HostPrimary string: The primary host for the Managed Database.
HostSecondary string: The secondary/private network host for the Managed Database.
Label string: A unique, user-defined string referring to the Managed Database.
Region string: The region that hosts this Linode Managed Database.
ReplicationType string: The replication method used for the Managed Database. (none, asynch, semi_synch)
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.
Type string: The Linode Instance type used for the nodes of the Managed Database instance.
Updated string: When this Managed Database was last updated.
Updates List<GetDatabaseMysqlUpdate>
Version string: The Managed Database engine version. (e.g. v8.0.26)
DatabaseId int: Deprecated: Configure id instead. This attribute will be removed in the next major version of the provider.
Id int

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.
CaCert string: The base64-encoded SSL CA certificate for the Managed Database instance.
ClusterSize int: The number of Linode Instance nodes deployed to the Managed Database.
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)
EngineId string: The Managed Database engine in engine/version format. (e.g. mysql/8.0.30)
HostPrimary string: The primary host for the Managed Database.
HostSecondary string: The secondary/private network host for the Managed Database.
Label string: A unique, user-defined string referring to the Managed Database.
Region string: The region that hosts this Linode Managed Database.
ReplicationType string: The replication method used for the Managed Database. (none, asynch, semi_synch)
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.
Type string: The Linode Instance type used for the nodes of the Managed Database instance.
Updated string: When this Managed Database was last updated.
Updates []GetDatabaseMysqlUpdate
Version string: The Managed Database engine version. (e.g. v8.0.26)
DatabaseId int: Deprecated: Configure id instead. This attribute will be removed in the next major version of the provider.
Id int

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.
caCert String: The base64-encoded SSL CA certificate for the Managed Database instance.
clusterSize Integer: The number of Linode Instance nodes deployed to the Managed Database.
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)
engineId String: The Managed Database engine in engine/version format. (e.g. mysql/8.0.30)
hostPrimary String: The primary host for the Managed Database.
hostSecondary String: The secondary/private network host for the Managed Database.
label String: A unique, user-defined string referring to the Managed Database.
region String: The region that hosts this Linode Managed Database.
replicationType String: The replication method used for the Managed Database. (none, asynch, semi_synch)
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.
type String: The Linode Instance type used for the nodes of the Managed Database instance.
updated String: When this Managed Database was last updated.
updates List<GetDatabaseMysqlUpdate>
version String: The Managed Database engine version. (e.g. v8.0.26)
databaseId Integer: Deprecated: Configure id instead. This attribute will be removed in the next major version of the provider.
id Integer

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.
caCert string: The base64-encoded SSL CA certificate for the Managed Database instance.
clusterSize number: The number of Linode Instance nodes deployed to the Managed Database.
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)
engineId string: The Managed Database engine in engine/version format. (e.g. mysql/8.0.30)
hostPrimary string: The primary host for the Managed Database.
hostSecondary string: The secondary/private network host for the Managed Database.
label string: A unique, user-defined string referring to the Managed Database.
region string: The region that hosts this Linode Managed Database.
replicationType string: The replication method used for the Managed Database. (none, asynch, semi_synch)
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.
type string: The Linode Instance type used for the nodes of the Managed Database instance.
updated string: When this Managed Database was last updated.
updates GetDatabaseMysqlUpdate[]
version string: The Managed Database engine version. (e.g. v8.0.26)
databaseId number: Deprecated: Configure id instead. This attribute will be removed in the next major version of the provider.
id number

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.
ca_cert str: The base64-encoded SSL CA certificate for the Managed Database instance.
cluster_size int: The number of Linode Instance nodes deployed to the Managed Database.
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_id str: The Managed Database engine in engine/version format. (e.g. mysql/8.0.30)
host_primary str: The primary host for the Managed Database.
host_secondary str: The secondary/private network host for the Managed Database.
label str: A unique, user-defined string referring to the Managed Database.
region str: The region that hosts this Linode Managed Database.
replication_type str: The replication method used for the Managed Database. (none, asynch, semi_synch)
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.
type str: The Linode Instance type used for the nodes of the Managed Database instance.
updated str: When this Managed Database was last updated.
updates Sequence[GetDatabaseMysqlUpdate]
version str: The Managed Database engine version. (e.g. v8.0.26)
database_id int: Deprecated: Configure id instead. This attribute will be removed in the next major version of the provider.
id int

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.
caCert String: The base64-encoded SSL CA certificate for the Managed Database instance.
clusterSize Number: The number of Linode Instance nodes deployed to the Managed Database.
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)
engineId String: The Managed Database engine in engine/version format. (e.g. mysql/8.0.30)
hostPrimary String: The primary host for the Managed Database.
hostSecondary String: The secondary/private network host for the Managed Database.
label String: A unique, user-defined string referring to the Managed Database.
region String: The region that hosts this Linode Managed Database.
replicationType String: The replication method used for the Managed Database. (none, asynch, semi_synch)
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.
type String: The Linode Instance type used for the nodes of the Managed Database instance.
updated String: When this Managed Database was last updated.
updates List<Property Map>
version String: The Managed Database engine version. (e.g. v8.0.26)
databaseId Number: Deprecated: Configure id instead. This attribute will be removed in the next major version of the provider.
id Number