1. Packages
  2. Linode
  3. API Docs
  4. getDatabaseMysql
Linode v4.6.1 published on Friday, Sep 15, 2023 by Pulumi

linode.getDatabaseMysql

Explore with Pulumi AI

linode logo
Linode v4.6.1 published on Friday, Sep 15, 2023 by Pulumi

    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 System.Linq;
    using Pulumi;
    using Linode = Pulumi.Linode;
    
    return await Deployment.RunAsync(() => 
    {
        var my_db = Linode.GetDatabaseMysql.Invoke(new()
        {
            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
    	})
    }
    
    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());
    
        }
    }
    
    import pulumi
    import pulumi_linode as linode
    
    my_db = linode.get_database_mysql(id=12345)
    
    import * as pulumi from "@pulumi/pulumi";
    import * as linode from "@pulumi/linode";
    
    const my-db = linode.getDatabaseMysql({
        id: 12345,
    });
    
    variables:
      my-db:
        fn::invoke:
          Function: linode:getDatabaseMysql
          Arguments:
            id: 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,
                           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)
    // 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. 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

    Supporting Types

    GetDatabaseMysqlUpdate

    dayOfWeek String
    duration Integer
    frequency String
    hourOfDay Integer
    weekOfMonth Integer
    dayOfWeek string
    duration number
    frequency string
    hourOfDay number
    weekOfMonth number
    dayOfWeek String
    duration Number
    frequency String
    hourOfDay Number
    weekOfMonth Number

    Package Details

    Repository
    Linode pulumi/pulumi-linode
    License
    Apache-2.0
    Notes

    This Pulumi package is based on the linode Terraform Provider.

    linode logo
    Linode v4.6.1 published on Friday, Sep 15, 2023 by Pulumi