Linode v3.12.0, Feb 14 23

linode.getDatabaseMysql

Provides information about a Linode MySQL Database.

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)

Example Usage

Get information about a MySQL database

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

return await Deployment.RunAsync(() => 
{
    var my_db = Linode.GetDatabaseMysql.Invoke(new()
    {
        DatabaseId = 12345,
    });

});

package main

import (
	"github.com/pulumi/pulumi-linode/sdk/v3/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{
			DatabaseId: 12345,
		}, nil)
		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.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()
            .databaseId(12345)
            .build());

    }
}

import pulumi
import pulumi_linode as linode

my_db = linode.get_database_mysql(database_id=12345)

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

const my-db = linode.getDatabaseMysql({
    databaseId: 12345,
});

variables:
  my-db:
    fn::invoke:
      Function: linode:getDatabaseMysql
      Arguments:
        databaseId: 12345

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.

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,
                       opts: Optional[InvokeOptions] = None) -> GetDatabaseMysqlResult
def get_database_mysql_output(database_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)
// Output-based functions aren't available in Java yet

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

The following arguments are supported:

DatabaseId int: The ID of the MySQL database.

DatabaseId int: The ID of the MySQL database.

databaseId Integer: The ID of the MySQL database.

databaseId number: The ID of the MySQL database.

database_id int: The ID of the MySQL database.

databaseId Number: The ID of the MySQL database.

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.
DatabaseId int
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.26)
HostPrimary string: The primary host for the Managed Database.
HostSecondary string: The secondary/private network host for the Managed Database.
Id string: The provider-assigned unique ID for this managed resource.
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)

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.
DatabaseId int
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.26)
HostPrimary string: The primary host for the Managed Database.
HostSecondary string: The secondary/private network host for the Managed Database.
Id string: The provider-assigned unique ID for this managed resource.
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)

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.
databaseId Integer
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.26)
hostPrimary String: The primary host for the Managed Database.
hostSecondary String: The secondary/private network host for the Managed Database.
id String: The provider-assigned unique ID for this managed resource.
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)

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.
databaseId number
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.26)
hostPrimary string: The primary host for the Managed Database.
hostSecondary string: The secondary/private network host for the Managed Database.
id string: The provider-assigned unique ID for this managed resource.
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)

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.
database_id int
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.26)
host_primary str: The primary host for the Managed Database.
host_secondary str: The secondary/private network host for the Managed Database.
id str: The provider-assigned unique ID for this managed resource.
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)

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.
databaseId Number
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.26)
hostPrimary String: The primary host for the Managed Database.
hostSecondary String: The secondary/private network host for the Managed Database.
id String: The provider-assigned unique ID for this managed resource.
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)