Elastic
data class ElasticPoolArgs(val elasticPoolName: Output<String>? = null, val highAvailabilityReplicaCount: Output<Int>? = null, val licenseType: Output<Either<String, ElasticPoolLicenseType>>? = null, val location: Output<String>? = null, val maintenanceConfigurationId: Output<String>? = null, val maxSizeBytes: Output<Double>? = null, val minCapacity: Output<Double>? = null, val perDatabaseSettings: Output<ElasticPoolPerDatabaseSettingsArgs>? = null, val resourceGroupName: Output<String>? = null, val serverName: Output<String>? = null, val sku: Output<SkuArgs>? = null, val tags: Output<Map<String, String>>? = null, val zoneRedundant: Output<Boolean>? = null) : ConvertibleToJava<ElasticPoolArgs>
An elastic pool. Uses Azure REST API version 2021-11-01. In version 1.x of the Azure Native provider, it used API version 2020-11-01-preview. Other available API versions: 2014-04-01, 2022-11-01-preview, 2023-02-01-preview, 2023-05-01-preview, 2023-08-01, 2023-08-01-preview, 2024-05-01-preview.
Example Usage
Create or update Hyperscale elastic pool with high availability replica count parameter
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var elasticPool = new AzureNative.Sql.ElasticPool("elasticPool", new()
{
ElasticPoolName = "sqlcrudtest-8102",
HighAvailabilityReplicaCount = 2,
Location = "Japan East",
ResourceGroupName = "sqlcrudtest-2369",
ServerName = "sqlcrudtest-8069",
Sku = new AzureNative.Sql.Inputs.SkuArgs
{
Name = "HS_Gen5_4",
},
});
});Content copied to clipboard
package main
import (
sql "github.com/pulumi/pulumi-azure-native-sdk/sql/v2"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := sql.NewElasticPool(ctx, "elasticPool", &sql.ElasticPoolArgs{
ElasticPoolName: pulumi.String("sqlcrudtest-8102"),
HighAvailabilityReplicaCount: pulumi.Int(2),
Location: pulumi.String("Japan East"),
ResourceGroupName: pulumi.String("sqlcrudtest-2369"),
ServerName: pulumi.String("sqlcrudtest-8069"),
Sku: &sql.SkuArgs{
Name: pulumi.String("HS_Gen5_4"),
},
})
if err != nil {
return err
}
return nil
})
}Content copied to clipboard
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sql.ElasticPool;
import com.pulumi.azurenative.sql.ElasticPoolArgs;
import com.pulumi.azurenative.sql.inputs.SkuArgs;
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) {
var elasticPool = new ElasticPool("elasticPool", ElasticPoolArgs.builder()
.elasticPoolName("sqlcrudtest-8102")
.highAvailabilityReplicaCount(2)
.location("Japan East")
.resourceGroupName("sqlcrudtest-2369")
.serverName("sqlcrudtest-8069")
.sku(SkuArgs.builder()
.name("HS_Gen5_4")
.build())
.build());
}
}Content copied to clipboard
Create or update elastic pool with all parameter
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var elasticPool = new AzureNative.Sql.ElasticPool("elasticPool", new()
{
ElasticPoolName = "sqlcrudtest-8102",
Location = "Japan East",
PerDatabaseSettings = new AzureNative.Sql.Inputs.ElasticPoolPerDatabaseSettingsArgs
{
MaxCapacity = 2,
MinCapacity = 0.25,
},
ResourceGroupName = "sqlcrudtest-2369",
ServerName = "sqlcrudtest-8069",
Sku = new AzureNative.Sql.Inputs.SkuArgs
{
Capacity = 2,
Name = "GP_Gen4_2",
Tier = "GeneralPurpose",
},
});
});Content copied to clipboard
package main
import (
sql "github.com/pulumi/pulumi-azure-native-sdk/sql/v2"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := sql.NewElasticPool(ctx, "elasticPool", &sql.ElasticPoolArgs{
ElasticPoolName: pulumi.String("sqlcrudtest-8102"),
Location: pulumi.String("Japan East"),
PerDatabaseSettings: &sql.ElasticPoolPerDatabaseSettingsArgs{
MaxCapacity: pulumi.Float64(2),
MinCapacity: pulumi.Float64(0.25),
},
ResourceGroupName: pulumi.String("sqlcrudtest-2369"),
ServerName: pulumi.String("sqlcrudtest-8069"),
Sku: &sql.SkuArgs{
Capacity: pulumi.Int(2),
Name: pulumi.String("GP_Gen4_2"),
Tier: pulumi.String("GeneralPurpose"),
},
})
if err != nil {
return err
}
return nil
})
}Content copied to clipboard
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sql.ElasticPool;
import com.pulumi.azurenative.sql.ElasticPoolArgs;
import com.pulumi.azurenative.sql.inputs.ElasticPoolPerDatabaseSettingsArgs;
import com.pulumi.azurenative.sql.inputs.SkuArgs;
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) {
var elasticPool = new ElasticPool("elasticPool", ElasticPoolArgs.builder()
.elasticPoolName("sqlcrudtest-8102")
.location("Japan East")
.perDatabaseSettings(ElasticPoolPerDatabaseSettingsArgs.builder()
.maxCapacity(2)
.minCapacity(0.25)
.build())
.resourceGroupName("sqlcrudtest-2369")
.serverName("sqlcrudtest-8069")
.sku(SkuArgs.builder()
.capacity(2)
.name("GP_Gen4_2")
.tier("GeneralPurpose")
.build())
.build());
}
}Content copied to clipboard
Create or update elastic pool with maintenance configuration parameter
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var elasticPool = new AzureNative.Sql.ElasticPool("elasticPool", new()
{
ElasticPoolName = "sqlcrudtest-8102",
Location = "Japan East",
MaintenanceConfigurationId = "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_JapanEast_1",
ResourceGroupName = "sqlcrudtest-2369",
ServerName = "sqlcrudtest-8069",
});
});Content copied to clipboard
package main
import (
sql "github.com/pulumi/pulumi-azure-native-sdk/sql/v2"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := sql.NewElasticPool(ctx, "elasticPool", &sql.ElasticPoolArgs{
ElasticPoolName: pulumi.String("sqlcrudtest-8102"),
Location: pulumi.String("Japan East"),
MaintenanceConfigurationId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_JapanEast_1"),
ResourceGroupName: pulumi.String("sqlcrudtest-2369"),
ServerName: pulumi.String("sqlcrudtest-8069"),
})
if err != nil {
return err
}
return nil
})
}Content copied to clipboard
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sql.ElasticPool;
import com.pulumi.azurenative.sql.ElasticPoolArgs;
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) {
var elasticPool = new ElasticPool("elasticPool", ElasticPoolArgs.builder()
.elasticPoolName("sqlcrudtest-8102")
.location("Japan East")
.maintenanceConfigurationId("/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_JapanEast_1")
.resourceGroupName("sqlcrudtest-2369")
.serverName("sqlcrudtest-8069")
.build());
}
}Content copied to clipboard
Create or update elastic pool with minimum parameters
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var elasticPool = new AzureNative.Sql.ElasticPool("elasticPool", new()
{
ElasticPoolName = "sqlcrudtest-8102",
Location = "Japan East",
ResourceGroupName = "sqlcrudtest-2369",
ServerName = "sqlcrudtest-8069",
});
});Content copied to clipboard
package main
import (
sql "github.com/pulumi/pulumi-azure-native-sdk/sql/v2"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := sql.NewElasticPool(ctx, "elasticPool", &sql.ElasticPoolArgs{
ElasticPoolName: pulumi.String("sqlcrudtest-8102"),
Location: pulumi.String("Japan East"),
ResourceGroupName: pulumi.String("sqlcrudtest-2369"),
ServerName: pulumi.String("sqlcrudtest-8069"),
})
if err != nil {
return err
}
return nil
})
}Content copied to clipboard
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sql.ElasticPool;
import com.pulumi.azurenative.sql.ElasticPoolArgs;
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) {
var elasticPool = new ElasticPool("elasticPool", ElasticPoolArgs.builder()
.elasticPoolName("sqlcrudtest-8102")
.location("Japan East")
.resourceGroupName("sqlcrudtest-2369")
.serverName("sqlcrudtest-8069")
.build());
}
}Content copied to clipboard
Import
An existing resource can be imported using its type token, name, and identifier, e.g.
$ pulumi import azure-native:sql:ElasticPool sqlcrudtest-8102 /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/elasticPools/{elasticPoolName}Content copied to clipboard
Constructors
Link copied to clipboard
constructor(elasticPoolName: Output<String>? = null, highAvailabilityReplicaCount: Output<Int>? = null, licenseType: Output<Either<String, ElasticPoolLicenseType>>? = null, location: Output<String>? = null, maintenanceConfigurationId: Output<String>? = null, maxSizeBytes: Output<Double>? = null, minCapacity: Output<Double>? = null, perDatabaseSettings: Output<ElasticPoolPerDatabaseSettingsArgs>? = null, resourceGroupName: Output<String>? = null, serverName: Output<String>? = null, sku: Output<SkuArgs>? = null, tags: Output<Map<String, String>>? = null, zoneRedundant: Output<Boolean>? = null)
Properties
Link copied to clipboard
The name of the elastic pool.
Link copied to clipboard
The number of secondary replicas associated with the elastic pool that are used to provide high availability. Applicable only to Hyperscale elastic pools.
Link copied to clipboard
The license type to apply for this elastic pool.
Link copied to clipboard
Maintenance configuration id assigned to the elastic pool. This configuration defines the period when the maintenance updates will will occur.
Link copied to clipboard
The storage limit for the database elastic pool in bytes.
Link copied to clipboard
Minimal capacity that serverless pool will not shrink below, if not paused
Link copied to clipboard
The per database settings for the elastic pool.
Link copied to clipboard
The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
Link copied to clipboard
The name of the server.
Link copied to clipboard
The elastic pool SKU. The list of SKUs may vary by region and support offer. To determine the SKUs (including the SKU name, tier/edition, family, and capacity) that are available to your subscription in an Azure region, use the Capabilities_ListByLocation REST API or the following command:
Link copied to clipboard