terraform-azure-databases

This module sets up different types of databases in Azure, including

• MYSQL flexible server
• PostgreSQL flexible server
• MariaDB server

Providers

Name	Version
azurerm	>=3.0

Prerequisites

Before you begin, ensure you have the following requirements met:

1. Install Terraform (>= 1.3.0). You can download the latest version of Terraform from the official website: https://www.terraform.io/downloads.html

2. Azure CLI installed and configured with appropriate access rights. You can install the Azure CLI from https://docs.microsoft.com/en-us/cli/azure/install-azure-cli

3. A Database subnet needs to be created with appropriate SUBNET DELEGATION or NETWORK POLICY FOR PRIVATE ENDPOINTS .

Resources

Name	Description	Type
azurerm_mysql_flexible_server	Azure MYSQL flexible server	azurerm
azurerm_postgresql_flexible_server	Azure POSTGRESQL flexible server	azurerm
azurerm_mariadb_server	Azure mariadb server App.	azurerm
azurerm_mysql_flexible_database	Azure MYSQL flexible server database	azurerm
azurerm_postgresql_flexible_server_database	Azure POSTGRESQL flexible server database	azurerm
azurerm_mariadb_database	Azure mariadb database	azurerm
azurerm_private_dns_zone	Azure private dns zone	azurerm
azurerm_private_dns_zone_virtual_network_link	Azure Private DNS zone Virtual Network Links.	azurerm
azurerm_private_endpoint	Azure private endpoint for mariadb server	azurerm

data source Variables

Module Name	Variable Name	Type	Description
locals	project_name_prefix	string	The name of the project.
data.azurerm_resource_group	resource_group_name	string	The name of your resource group that is already created .
data.azurerm_virtual_network	vnet_name	string	The Name of your existing virtual network if you want to make database as private only .
data.azurerm_subnet	subnet_name	string	The Name of your database subnet where you want to create your database.

MySQL Flexible Server Configuration

Variable Name	Description	Example Value
create_mysql_fs	Set to true to create MySQL Flexible Server.	true
mysql_fs_server_name	Name for the MySQL Flexible Server.	"my-mysql-server"
resource_group_name	Name of the Azure resource group.	"my-resource-group"
location	Azure region for deployment.	"East US"
is_public	if you want to make database server as public	'true'
vnet_name	Name of your existing virtual network if is_public is false to make database as private only	"my-vnet"
subnet_name	Name of your database subnet where you want to create your database.	"database_subnet"
private_dns_zone_name	Name of the private DNS zone for the Database Server."	mysql.mysql.database.azure.com
dns_zone_virtual_network_link_name	Name of the virtual network link for the private DNS zone.	"vnet-private-zone-link"
administrator_login	Administrator login for MySQL Server.	"myadmin"
administrator_password	Administrator password for MySQL Server.	"MyP@ssw0rd123"
mysql_sku_name	SKU name for the MySQL Flexible Server.	"B_Standard_B1s"
backup_retention_days	Number of days to retain backups.	7
create_mode	MySQL Server creation mode.	"Default"
geo_redundant_backup_enabled	Enable geo-redundant backups.	true
zone	Azure Availability Zone for deployment.	2
high_availability	Map of high availability configuration.	See variable definition below
maintenance_window	Map of maintenance window configuration.	See variable definition below
Storage	Map of Storage configuration	See variable definition below
mysql_databases	Map of database configuration	see variable definition below

High Availability Configuration

Variable Name	Description	Example Value
mode	High availability mode for MySQL Flexible Server.	"SameZone" or "ZoneRedundant"
standby_availability_zone	Availability zone for the standby Flexible Server.	1, 2, or 3

Maintenance Window Configuration

Variable Name	Description	Example Value
day	Day of the week for maintenance window.	1 (Monday) to 7 (Sunday)
start_hour	Start hour of the maintenance window.	2
start_minute	Start minute of the maintenance window.	30

Storage Configuration

Variable Name	Description	Example Value
auto_grow_enabled	Enable auto-grow for storage.	true
iops	Input/Output Operations Per Second (IOPS) for storage.	360
size_gb	Size of storage in gigabytes.	20

MySQL Database Configuration

Variable Name	Description	Example Value
create_mysql_fs	Set to true to create MySQL Database.	true
charset	Charset for the MySQL Database.	"utf8mb4"
collation	Collation for the MySQL Database.	"utf8mb4_unicode_ci"

Note: Please refer to the module documentation for additional optional variables and their descriptions.

MySQL Flexible Server Documentation

PostgreSQL Flexible Server Configuration

Variable Name	Description	Example Value
create_postgresql_fs	Set to true to create PostgreSQL Flexible Server.	true
postgres_server_name	Name for the PostgreSQL Flexible Server.	"my-postgresql-server"
resource_group_name	Name of the Azure resource group.	"my-resource-group"
location	Azure region for deployment.	"East US"
is_public	if you want to make database server as public	'true'
vnet_name	Name of your existing virtual network if is_public is false to make database as private only	"my-vnet"
subnet_name	Name of your database subnet where you want to create your database.	"database_subnet"
private_dns_zone_name	Name of the private DNS zone for the Database Server."	"psql.postgres.database.azure.com"
dns_zone_virtual_network_link_name	Name of the virtual network link for the private DNS zone.	"vnet-private-zone-link"
postgres_server_version	Version of PostgreSQL Server.	"16"
administrator_login	Administrator login for PostgreSQL Server.	"myadmin"
administrator_password	Administrator password for PostgreSQL Server.	"MyP@ssw0rd123"
postgres_storage_mb	Storage size in megabytes.	51200
postgres_storage_tier	storage performance tier for IOPS of the PostgreSQL Flexible Server.	"P30"
postgres_sku_name	SKU name for PostgreSQL Flexible Server.	"Standard_D2s_v3"
backup_retention_days	Number of days to retain backups.	7
create_mode	PostgreSQL Server creation mode.	"Default"
geo_redundant_backup_enabled	Enable geo-redundant backups.	false
postgres_zone	Azure Availability Zone for deployment.	1
high_availability	Map of high availability configuration.	See variable definition below
maintenance_window	Map of maintenance window configuration.	See variable definition below
postgres_databases	Map of database configuration	see variable definition below

High Availability Configuration

Variable Name	Description	Example Value
mode	High availability mode for MySQL Flexible Server.	"SameZone" or "ZoneRedundant"
standby_availability_zone	Availability zone for the standby Flexible Server.	1, 2, or 3

Maintenance Window Configuration

Variable Name	Description	Example Value
day	Day of the week for maintenance window.	1 (Monday) to 7 (Sunday)
start_hour	Start hour of the maintenance window.	2
start_minute	Start minute of the maintenance window.	30

PostgreSQL Database Configuration

Variable Name	Description	Example Value
create_postgresql_fs	Set to true to create PostgreSQL Database.	true
collation	Collation for the PostgreSQL Database.	"en_US.UTF-8"
charset	Charset for the PostgreSQL Database.	"UTF8"

Note: Please refer to the module documentation for additional optional variables and their descriptions.

https://registry.terraform.io/providers/hashicorp/azurerm/latest/docs/resources/postgresql_flexible_server

Private Endpoint Configuration

Variable Name	Description	Example Value
create_mariadb	Set to true to create MariaDB resources.	true
server-name	Name for the MariaDB server.	"my-mariadb-server"
location	Azure region for deployment.	"East US"
resource_group_name	Name of the Azure resource group.	"my-resource-group"
private_service_connection_name	Name for the private service connection.	"my-private-connection"
private_service_connection_is_manual_connection	Set to true for manual connection.	true
private_service_connection_subresource_names	List of subresource names for the connection.	["db", "admin"]

MariaDB Server Configuration

Variable Name	Description	Example Value
mariadb_sku	SKU name for MariaDB server.	"GP_Gen5_2"
mariadb_version	Version of MariaDB Server.	"10.3"
mariadb_storage_mb	Storage size in megabytes.	51200
administrator_login	Administrator login for MariaDB Server.	"myadmin"
administrator_password	Administrator password for MariaDB Server.	"MyP@ssw0rd123"
auto_grow_enabled	Set to true to enable auto-grow.	true
backup_retention_days	Number of days to retain backups.	7
mariadb_geo_redundant_backup_enabled	Enable geo-redundant backups.	true
public_network_access_enabled	Set to true to enable public network access.	true
ssl_enforcement_enabled	Enable SSL enforcement.	true
ssl_minimal_tls_version_enforced	Minimal TLS version for SSL enforcement.	"TLS1_2"

MariaDB Database Configuration

Variable Name	Description	Example Value
create_mariadb_database	Set to true to create MariaDB Database.	true
db-name	Name for the MariaDB Database.	"my-database"
databases_charset	Charset for the MariaDB Database.	"UTF8"
databases_collation	Collation for the MariaDB Database.	"en_US.UTF-8"

Note: Please refer to the module documentation for additional optional variables and their descriptions.

https://registry.terraform.io/providers/hashicorp/azurerm/latest/docs/resources

Outputs

Output Name	Description
postgresql_fqdn	Fully Qualified Domain Name (FQDN) for the PostgreSQL server.
mysql_fqdn	Fully Qualified Domain Name (FQDN) for the MySQL server.
mariadb_fqdn	Fully Qualified Domain Name (FQDN) for the MariaDB server.

Note: Please refer to the module documentation for additional optional variables and their descriptions.

https://registry.terraform.io/providers/hashicorp/azurerm/latest/docs/resources/mariadb_server

Note

Make sure to provide the necessary values for the input variables and adjust the module accordingly.

Please refer to the documentation of each individual resource for more details on their usage and specific input variables.

Authors

Module managed by TO THE NEW Pvt. Ltd.

License

Apache 2 Licensed. See LICENSE for full details.