import * as pulumi from "@pulumi/pulumi"; import { input as inputs, output as outputs } from "./types"; /** * Manages a SQLServer cluster within the Yandex.Cloud. For more information, see * [the official documentation](https://cloud.yandex.com/docs/managed-sqlserver/). * * Please read [Pricing for Managed Service for SQL Server](https://cloud.yandex.com/docs/managed-sqlserver/pricing#prices) before using SQLServer cluster. * * ## Example Usage * * Example of creating a Single Node SQLServer. * * ```typescript * import * as pulumi from "@pulumi/pulumi"; * import * as yandex from "@pulumi/yandex"; * * const fooVpcNetwork = new yandex.VpcNetwork("fooVpcNetwork", {}); * const fooVpcSubnet = new yandex.VpcSubnet("fooVpcSubnet", { * zone: "ru-central1-a", * networkId: fooVpcNetwork.id, * v4CidrBlocks: ["10.5.0.0/24"], * }); * const test_sg_x = new yandex.VpcSecurityGroup("test-sg-x", { * networkId: fooVpcNetwork.id, * ingresses: [{ * protocol: "ANY", * description: "Allow incoming traffic from members of the same security group", * fromPort: 0, * toPort: 65535, * v4CidrBlocks: ["0.0.0.0/0"], * }], * egresses: [{ * protocol: "ANY", * description: "Allow outgoing traffic to members of the same security group", * fromPort: 0, * toPort: 65535, * v4CidrBlocks: ["0.0.0.0/0"], * }], * }); * const fooMdbSqlServerCluster = new yandex.MdbSqlServerCluster("fooMdbSqlServerCluster", { * environment: "PRESTABLE", * networkId: fooVpcNetwork.id, * version: "2016sp2std", * resources: { * resourcePresetId: "s2.small", * diskTypeId: "network-ssd", * diskSize: 20, * }, * labels: { * test_key: "test_value", * }, * backupWindowStart: { * hours: 20, * minutes: 30, * }, * sqlserverConfig: { * fill_factor_percent: 49, * optimize_for_ad_hoc_workloads: true, * }, * databases: [ * { * name: "db_name_a", * }, * { * name: "db_name", * }, * { * name: "db_name_b", * }, * ], * users: [ * { * name: "bob", * password: "mysecurepassword", * }, * { * name: "alice", * password: "mysecurepassword", * permissions: [{ * databaseName: "db_name", * roles: ["DDLADMIN"], * }], * }, * { * name: "chuck", * password: "mysecurepassword", * permissions: [ * { * databaseName: "db_name_a", * roles: ["OWNER"], * }, * { * databaseName: "db_name", * roles: [ * "OWNER", * "DDLADMIN", * ], * }, * { * databaseName: "db_name_b", * roles: [ * "OWNER", * "DDLADMIN", * ], * }, * ], * }, * ], * hosts: [{ * zone: "ru-central1-a", * subnetId: fooVpcSubnet.id, * }], * securityGroupIds: [test_sg_x.id], * hostGroupIds: [ * "host_group_1", * "host_group_2", * ], * }); * ``` * ## SQLServer config * * If not specified `sqlserverConfig` then does not make any changes. * * * maxDegreeOfParallelism - Limits the number of processors to use in parallel plan execution per task. See in-depth description in [SQL Server documentation](https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-configuration-option?view=sql-server-2016). * * * costThresholdForParallelism - Specifies the threshold at which SQL Server creates and runs parallel plans for queries. SQL Server creates and runs a parallel plan for a query only when the estimated cost to run a serial plan for the same query is higher than the value of the option. See in-depth description in [SQL Server documentation](https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-cost-threshold-for-parallelism-server-configuration-option?view=sql-server-2016). * * * auditLevel - Describes how to configure login auditing to monitor SQL Server Database Engine login activity. Possible values: * - 0 — do not log login attempts,˚√ * - 1 — log only failed login attempts, * - 2 — log only successful login attempts (not recommended), * - 3 — log all login attempts (not recommended). * See in-depth description in [SQL Server documentation](https://docs.microsoft.com/en-us/sql/ssms/configure-login-auditing-sql-server-management-studio?view=sql-server-2016). * * * fillFactorPercent - Manages the fill factor server configuration option. When an index is created or rebuilt the fill factor determines the percentage of space on each index leaf-level page to be filled with data, reserving the rest as free space for future growth. Values 0 and 100 mean full page usage (no space reserved). See in-depth description in [SQL Server documentation](https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-fill-factor-server-configuration-option?view=sql-server-2016). * * optimizeForAdHocWorkloads - Determines whether plans should be cached only after second execution. Allows to avoid SQL cache bloat because of single-use plans. See in-depth description in [SQL Server documentation](https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/optimize-for-ad-hoc-workloads-server-configuration-option?view=sql-server-2016). * * ## Import * * A cluster can be imported using the `id` of the resource, e.g. * * ```sh * $ pulumi import yandex:index/mdbSqlServerCluster:MdbSqlServerCluster foo cluster_id * ``` */ export declare class MdbSqlServerCluster extends pulumi.CustomResource { /** * Get an existing MdbSqlServerCluster resource's state with the given name, ID, and optional extra * properties used to qualify the lookup. * * @param name The _unique_ name of the resulting resource. * @param id The _unique_ provider ID of the resource to lookup. * @param state Any extra arguments used during the lookup. * @param opts Optional settings to control the behavior of the CustomResource. */ static get(name: string, id: pulumi.Input, state?: MdbSqlServerClusterState, opts?: pulumi.CustomResourceOptions): MdbSqlServerCluster; /** * Returns true if the given object is an instance of MdbSqlServerCluster. This is designed to work even * when multiple copies of the Pulumi SDK have been loaded into the same process. */ static isInstance(obj: any): obj is MdbSqlServerCluster; /** * Time to start the daily backup, in the UTC. The structure is documented below. */ readonly backupWindowStart: pulumi.Output; /** * Creation timestamp of the cluster. */ readonly createdAt: pulumi.Output; /** * A database of the SQLServer cluster. The structure is documented below. */ readonly databases: pulumi.Output; /** * Inhibits deletion of the cluster. Can be either `true` or `false`. */ readonly deletionProtection: pulumi.Output; /** * Description of the SQLServer cluster. */ readonly description: pulumi.Output; /** * Deployment environment of the SQLServer cluster. (PRODUCTION, PRESTABLE) */ readonly environment: pulumi.Output; /** * The ID of the folder that the resource belongs to. If it * is not provided, the default provider folder is used. */ readonly folderId: pulumi.Output; /** * Aggregated health of the cluster. */ readonly health: pulumi.Output; /** * A list of IDs of the host groups hosting VMs of the cluster. */ readonly hostGroupIds: pulumi.Output; /** * A host of the SQLServer cluster. The structure is documented below. */ readonly hosts: pulumi.Output; /** * A set of key/value label pairs to assign to the SQLServer cluster. */ readonly labels: pulumi.Output<{ [key: string]: string; } | undefined>; /** * The name of the database. */ readonly name: pulumi.Output; /** * ID of the network, to which the SQLServer cluster uses. */ readonly networkId: pulumi.Output; /** * Resources allocated to hosts of the SQLServer cluster. The structure is documented below. */ readonly resources: pulumi.Output; /** * A set of ids of security groups assigned to hosts of the cluster. */ readonly securityGroupIds: pulumi.Output; /** * SQLServer cluster config. Detail info in "SQLServer config" section (documented below). */ readonly sqlserverConfig: pulumi.Output<{ [key: string]: string; }>; /** * Status of the cluster. */ readonly status: pulumi.Output; /** * A user of the SQLServer cluster. The structure is documented below. */ readonly users: pulumi.Output; /** * Version of the SQLServer cluster. (2016sp2std, 2016sp2ent) */ readonly version: pulumi.Output; /** * Create a MdbSqlServerCluster resource with the given unique name, arguments, and options. * * @param name The _unique_ name of the resource. * @param args The arguments to use to populate this resource's properties. * @param opts A bag of options that control this resource's behavior. */ constructor(name: string, args: MdbSqlServerClusterArgs, opts?: pulumi.CustomResourceOptions); } /** * Input properties used for looking up and filtering MdbSqlServerCluster resources. */ export interface MdbSqlServerClusterState { /** * Time to start the daily backup, in the UTC. The structure is documented below. */ backupWindowStart?: pulumi.Input; /** * Creation timestamp of the cluster. */ createdAt?: pulumi.Input; /** * A database of the SQLServer cluster. The structure is documented below. */ databases?: pulumi.Input[]>; /** * Inhibits deletion of the cluster. Can be either `true` or `false`. */ deletionProtection?: pulumi.Input; /** * Description of the SQLServer cluster. */ description?: pulumi.Input; /** * Deployment environment of the SQLServer cluster. (PRODUCTION, PRESTABLE) */ environment?: pulumi.Input; /** * The ID of the folder that the resource belongs to. If it * is not provided, the default provider folder is used. */ folderId?: pulumi.Input; /** * Aggregated health of the cluster. */ health?: pulumi.Input; /** * A list of IDs of the host groups hosting VMs of the cluster. */ hostGroupIds?: pulumi.Input[]>; /** * A host of the SQLServer cluster. The structure is documented below. */ hosts?: pulumi.Input[]>; /** * A set of key/value label pairs to assign to the SQLServer cluster. */ labels?: pulumi.Input<{ [key: string]: pulumi.Input; }>; /** * The name of the database. */ name?: pulumi.Input; /** * ID of the network, to which the SQLServer cluster uses. */ networkId?: pulumi.Input; /** * Resources allocated to hosts of the SQLServer cluster. The structure is documented below. */ resources?: pulumi.Input; /** * A set of ids of security groups assigned to hosts of the cluster. */ securityGroupIds?: pulumi.Input[]>; /** * SQLServer cluster config. Detail info in "SQLServer config" section (documented below). */ sqlserverConfig?: pulumi.Input<{ [key: string]: pulumi.Input; }>; /** * Status of the cluster. */ status?: pulumi.Input; /** * A user of the SQLServer cluster. The structure is documented below. */ users?: pulumi.Input[]>; /** * Version of the SQLServer cluster. (2016sp2std, 2016sp2ent) */ version?: pulumi.Input; } /** * The set of arguments for constructing a MdbSqlServerCluster resource. */ export interface MdbSqlServerClusterArgs { /** * Time to start the daily backup, in the UTC. The structure is documented below. */ backupWindowStart?: pulumi.Input; /** * A database of the SQLServer cluster. The structure is documented below. */ databases: pulumi.Input[]>; /** * Inhibits deletion of the cluster. Can be either `true` or `false`. */ deletionProtection?: pulumi.Input; /** * Description of the SQLServer cluster. */ description?: pulumi.Input; /** * Deployment environment of the SQLServer cluster. (PRODUCTION, PRESTABLE) */ environment: pulumi.Input; /** * The ID of the folder that the resource belongs to. If it * is not provided, the default provider folder is used. */ folderId?: pulumi.Input; /** * A list of IDs of the host groups hosting VMs of the cluster. */ hostGroupIds?: pulumi.Input[]>; /** * A host of the SQLServer cluster. The structure is documented below. */ hosts: pulumi.Input[]>; /** * A set of key/value label pairs to assign to the SQLServer cluster. */ labels?: pulumi.Input<{ [key: string]: pulumi.Input; }>; /** * The name of the database. */ name?: pulumi.Input; /** * ID of the network, to which the SQLServer cluster uses. */ networkId: pulumi.Input; /** * Resources allocated to hosts of the SQLServer cluster. The structure is documented below. */ resources: pulumi.Input; /** * A set of ids of security groups assigned to hosts of the cluster. */ securityGroupIds?: pulumi.Input[]>; /** * SQLServer cluster config. Detail info in "SQLServer config" section (documented below). */ sqlserverConfig?: pulumi.Input<{ [key: string]: pulumi.Input; }>; /** * A user of the SQLServer cluster. The structure is documented below. */ users: pulumi.Input[]>; /** * Version of the SQLServer cluster. (2016sp2std, 2016sp2ent) */ version: pulumi.Input; }