This terraform module simplifies the creation and management of azure sql servers, offering a flexible and customizable solution for deploying fully-configured instances. It encapsulates best practices and provides a range of options to meet various requirements.
The main objective is to create a more logic data structure, achieved by combining and grouping related resources together in a complex object.
The structure of the module promotes reusability. It's intended to be a repeatable component, simplifying the process of building diverse workloads and platform accelerators consistently.
A primary goal is to utilize keys and values in the object that correspond to the REST API's structure. This enables us to carry out iterations, increasing its practical value as time goes on.
A last key goal is to separate logic from configuration in the module, thereby enhancing its scalability, ease of customization, and manageability.
- manages multiple sql databases and elastic pools.
- ability to associate multiple databases within a single elastic pool.
- support for adding virtual network and firewall rules
- utilization of terratest for robust validation.
- integrates seamlessly with private endpoint capabilities for direct and secure connectivity
- supports both system and multiple user assigned identities
| Name | Version |
|---|---|
| terraform | ~> 1.0 |
| azurerm | ~> 3.61 |
| Name | Version |
|---|---|
| azurerm | ~> 3.61 |
| Name | Type |
|---|---|
| azurerm_mssql_server | resource |
| azurerm_mssql_firewall_rule | resource |
| azurerm_mssql_virtual_network_rule | resource |
| azurerm_mssql_elasticpool | resource |
| azurerm_mssql_database | resource |
| azurerm_user_assigned_identity | resource |
| Name | Description | Type | Required |
|---|---|---|---|
instance |
describes sql server related configuration | object | yes |
naming |
used for naming purposes | string | yes |
location |
default azure region tho be used | string | no |
resourcegroup |
default resource group to be used | string | no |
tags |
tags to be added to the resources | map(string) | no |
| Name | Description |
|---|---|
server |
contains all sql server details |
elasticpools |
contains elastic pools |
databases |
contains databases |
As a prerequirement, please ensure that both go and terraform are properly installed on your system.
The Makefile includes two distinct variations of tests. The first one is designed to deploy different usage scenarios of the module. These tests are executed by specifying the TF_PATH environment variable, which determines the different usages located in the example directory.
To execute this test, input the command make test TF_PATH=default, substituting default with the specific usage you wish to test.
The second variation is known as a extended test. This one performs additional checks and can be executed without specifying any parameters, using the command make test_extended.
Both are designed to be executed locally and are also integrated into the github workflow.
Each of these tests contributes to the robustness and resilience of the module. They ensure the module performs consistently and accurately under different scenarios and configurations.
Using a dedicated module, we've developed a naming convention for resources that's based on specific regular expressions for each type, ensuring correct abbreviations and offering flexibility with multiple prefixes and suffixes
Full examples detailing all usages, along with integrations with dependency modules, are located in the examples directory
To streamline integration with the enterprise scale module, private endpoints can also make use of existing zones.
Module is maintained by these awesome contributors.
MIT Licensed. See LICENSE for full details.