/
azure_database.tf
53 lines (46 loc) · 1.83 KB
/
azure_database.tf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
resource "azurerm_mysql_server" "demo" {
name = "mysql-training"
location = azurerm_resource_group.demo.location
resource_group_name = azurerm_resource_group.demo.name
sku {
name = "GP_Gen5_2"
capacity = 2
tier = "GeneralPurpose"
family = "Gen5"
}
storage_profile {
storage_mb = 5120
backup_retention_days = 7
geo_redundant_backup = "Disabled"
}
administrator_login = "mysqladmin"
#administrator_login_password = "SETSECUREPASS"
version = "5.7"
ssl_enforcement = "Enabled"
}
resource "azurerm_mysql_database" "training" {
name = "demodb"
resource_group_name = azurerm_resource_group.demo.name
server_name = azurerm_mysql_server.demo.name
charset = "utf8"
collation = "utf8_unicode_ci"
}
resource "azurerm_mysql_virtual_network_rule" "demo-database-subnet-vnet-rule" {
name = "mysql-vnet-rule"
resource_group_name = azurerm_resource_group.demo.name
server_name = azurerm_mysql_server.demo.name
subnet_id = azurerm_subnet.demo-database-1.id
}
resource "azurerm_mysql_virtual_network_rule" "demo-subnet-vnet-rule" {
name = "mysql-demo-subnet-vnet-rule"
resource_group_name = azurerm_resource_group.demo.name
server_name = azurerm_mysql_server.demo.name
subnet_id = azurerm_subnet.demo-internal-1.id
}
resource "azurerm_mysql_firewall_rule" "demo-allow-demo-instance" {
name = "mysql-demo-instance"
resource_group_name = azurerm_resource_group.demo.name
server_name = azurerm_mysql_server.demo.name
start_ip_address = azurerm_network_interface.demo-instance.private_ip_address
end_ip_address = azurerm_network_interface.demo-instance.private_ip_address
}