Availability
data class AvailabilityGroupListenerArgs(val availabilityGroupConfiguration: Output<AgConfigurationArgs>? = null, val availabilityGroupListenerName: Output<String>? = null, val availabilityGroupName: Output<String>? = null, val createDefaultAvailabilityGroupIfNotExist: Output<Boolean>? = null, val loadBalancerConfigurations: Output<List<LoadBalancerConfigurationArgs>>? = null, val multiSubnetIpConfigurations: Output<List<MultiSubnetIpConfigurationArgs>>? = null, val port: Output<Int>? = null, val resourceGroupName: Output<String>? = null, val sqlVirtualMachineGroupName: Output<String>? = null) : ConvertibleToJava<AvailabilityGroupListenerArgs>
A SQL Server availability group listener. Uses Azure REST API version 2022-02-01. In version 1.x of the Azure Native provider, it used API version 2017-03-01-preview. Other available API versions: 2023-01-01-preview, 2023-10-01.
Example Usage
Creates or updates an availability group listener using load balancer. This is used for VMs present in single subnet.
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var availabilityGroupListener = new AzureNative.SqlVirtualMachine.AvailabilityGroupListener("availabilityGroupListener", new()
{
AvailabilityGroupListenerName = "agl-test",
AvailabilityGroupName = "ag-test",
LoadBalancerConfigurations = new[]
{
new AzureNative.SqlVirtualMachine.Inputs.LoadBalancerConfigurationArgs
{
LoadBalancerResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Network/loadBalancers/lb-test",
PrivateIpAddress = new AzureNative.SqlVirtualMachine.Inputs.PrivateIPAddressArgs
{
IpAddress = "10.1.0.112",
SubnetResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Network/virtualNetworks/test-vnet/subnets/default",
},
ProbePort = 59983,
SqlVirtualMachineInstances = new[]
{
"/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachines/testvm2",
"/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachines/testvm3",
},
},
},
Port = 1433,
ResourceGroupName = "testrg",
SqlVirtualMachineGroupName = "testvmgroup",
});
});Content copied to clipboard
package main
import (
sqlvirtualmachine "github.com/pulumi/pulumi-azure-native-sdk/sqlvirtualmachine/v2"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := sqlvirtualmachine.NewAvailabilityGroupListener(ctx, "availabilityGroupListener", &sqlvirtualmachine.AvailabilityGroupListenerArgs{
AvailabilityGroupListenerName: pulumi.String("agl-test"),
AvailabilityGroupName: pulumi.String("ag-test"),
LoadBalancerConfigurations: sqlvirtualmachine.LoadBalancerConfigurationArray{
&sqlvirtualmachine.LoadBalancerConfigurationArgs{
LoadBalancerResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Network/loadBalancers/lb-test"),
PrivateIpAddress: &sqlvirtualmachine.PrivateIPAddressArgs{
IpAddress: pulumi.String("10.1.0.112"),
SubnetResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Network/virtualNetworks/test-vnet/subnets/default"),
},
ProbePort: pulumi.Int(59983),
SqlVirtualMachineInstances: pulumi.StringArray{
pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachines/testvm2"),
pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachines/testvm3"),
},
},
},
Port: pulumi.Int(1433),
ResourceGroupName: pulumi.String("testrg"),
SqlVirtualMachineGroupName: pulumi.String("testvmgroup"),
})
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.sqlvirtualmachine.AvailabilityGroupListener;
import com.pulumi.azurenative.sqlvirtualmachine.AvailabilityGroupListenerArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.LoadBalancerConfigurationArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.PrivateIPAddressArgs;
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 availabilityGroupListener = new AvailabilityGroupListener("availabilityGroupListener", AvailabilityGroupListenerArgs.builder()
.availabilityGroupListenerName("agl-test")
.availabilityGroupName("ag-test")
.loadBalancerConfigurations(LoadBalancerConfigurationArgs.builder()
.loadBalancerResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Network/loadBalancers/lb-test")
.privateIpAddress(PrivateIPAddressArgs.builder()
.ipAddress("10.1.0.112")
.subnetResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Network/virtualNetworks/test-vnet/subnets/default")
.build())
.probePort(59983)
.sqlVirtualMachineInstances(
"/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachines/testvm2",
"/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachines/testvm3")
.build())
.port(1433)
.resourceGroupName("testrg")
.sqlVirtualMachineGroupName("testvmgroup")
.build());
}
}Content copied to clipboard
Creates or updates an availability group listener. This is used for VMs present in multi subnet
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var availabilityGroupListener = new AzureNative.SqlVirtualMachine.AvailabilityGroupListener("availabilityGroupListener", new()
{
AvailabilityGroupListenerName = "agl-test",
AvailabilityGroupName = "ag-test",
MultiSubnetIpConfigurations = new[]
{
new AzureNative.SqlVirtualMachine.Inputs.MultiSubnetIpConfigurationArgs
{
PrivateIpAddress = new AzureNative.SqlVirtualMachine.Inputs.PrivateIPAddressArgs
{
IpAddress = "10.0.0.112",
SubnetResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Network/virtualNetworks/test-vnet/subnets/default",
},
SqlVirtualMachineInstance = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachines/testvm2",
},
new AzureNative.SqlVirtualMachine.Inputs.MultiSubnetIpConfigurationArgs
{
PrivateIpAddress = new AzureNative.SqlVirtualMachine.Inputs.PrivateIPAddressArgs
{
IpAddress = "10.0.1.112",
SubnetResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Network/virtualNetworks/test-vnet/subnets/alternate",
},
SqlVirtualMachineInstance = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachines/testvm1",
},
},
Port = 1433,
ResourceGroupName = "testrg",
SqlVirtualMachineGroupName = "testvmgroup",
});
});Content copied to clipboard
package main
import (
sqlvirtualmachine "github.com/pulumi/pulumi-azure-native-sdk/sqlvirtualmachine/v2"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := sqlvirtualmachine.NewAvailabilityGroupListener(ctx, "availabilityGroupListener", &sqlvirtualmachine.AvailabilityGroupListenerArgs{
AvailabilityGroupListenerName: pulumi.String("agl-test"),
AvailabilityGroupName: pulumi.String("ag-test"),
MultiSubnetIpConfigurations: sqlvirtualmachine.MultiSubnetIpConfigurationArray{
&sqlvirtualmachine.MultiSubnetIpConfigurationArgs{
PrivateIpAddress: &sqlvirtualmachine.PrivateIPAddressArgs{
IpAddress: pulumi.String("10.0.0.112"),
SubnetResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Network/virtualNetworks/test-vnet/subnets/default"),
},
SqlVirtualMachineInstance: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachines/testvm2"),
},
&sqlvirtualmachine.MultiSubnetIpConfigurationArgs{
PrivateIpAddress: &sqlvirtualmachine.PrivateIPAddressArgs{
IpAddress: pulumi.String("10.0.1.112"),
SubnetResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Network/virtualNetworks/test-vnet/subnets/alternate"),
},
SqlVirtualMachineInstance: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachines/testvm1"),
},
},
Port: pulumi.Int(1433),
ResourceGroupName: pulumi.String("testrg"),
SqlVirtualMachineGroupName: pulumi.String("testvmgroup"),
})
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.sqlvirtualmachine.AvailabilityGroupListener;
import com.pulumi.azurenative.sqlvirtualmachine.AvailabilityGroupListenerArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.MultiSubnetIpConfigurationArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.PrivateIPAddressArgs;
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 availabilityGroupListener = new AvailabilityGroupListener("availabilityGroupListener", AvailabilityGroupListenerArgs.builder()
.availabilityGroupListenerName("agl-test")
.availabilityGroupName("ag-test")
.multiSubnetIpConfigurations(
MultiSubnetIpConfigurationArgs.builder()
.privateIpAddress(PrivateIPAddressArgs.builder()
.ipAddress("10.0.0.112")
.subnetResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Network/virtualNetworks/test-vnet/subnets/default")
.build())
.sqlVirtualMachineInstance("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachines/testvm2")
.build(),
MultiSubnetIpConfigurationArgs.builder()
.privateIpAddress(PrivateIPAddressArgs.builder()
.ipAddress("10.0.1.112")
.subnetResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Network/virtualNetworks/test-vnet/subnets/alternate")
.build())
.sqlVirtualMachineInstance("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachines/testvm1")
.build())
.port(1433)
.resourceGroupName("testrg")
.sqlVirtualMachineGroupName("testvmgroup")
.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:sqlvirtualmachine:AvailabilityGroupListener agl-test /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/{sqlVirtualMachineGroupName}/availabilityGroupListeners/{availabilityGroupListenerName}Content copied to clipboard
Constructors
Link copied to clipboard
constructor(availabilityGroupConfiguration: Output<AgConfigurationArgs>? = null, availabilityGroupListenerName: Output<String>? = null, availabilityGroupName: Output<String>? = null, createDefaultAvailabilityGroupIfNotExist: Output<Boolean>? = null, loadBalancerConfigurations: Output<List<LoadBalancerConfigurationArgs>>? = null, multiSubnetIpConfigurations: Output<List<MultiSubnetIpConfigurationArgs>>? = null, port: Output<Int>? = null, resourceGroupName: Output<String>? = null, sqlVirtualMachineGroupName: Output<String>? = null)
Properties
Link copied to clipboard
Availability Group configuration.
Link copied to clipboard
Name of the availability group listener.
Link copied to clipboard
Name of the availability group.
Link copied to clipboard
Create a default availability group if it does not exist.
Link copied to clipboard
List of load balancer configurations for an availability group listener.
Link copied to clipboard
List of multi subnet IP configurations for an AG listener.
Link copied to clipboard
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
Name of the SQL virtual machine group.