resource "aws_db_instance" "mysql-master" {
allocated_storage = var.mysql-master-storage-size[var.environment]
engine = "mysql"
engine_version = "5.7"
instance_class = var.mysql-master-instance-type[var.environment]
identifier = "mysql-${var.project_name}"
name = "${var.mysql-master-db-name}"
username = "${var.mysql-master-user-name}"
password = "${var.mysql-master-password}"
db_subnet_group_name = "${aws_db_subnet_group.mysql-subnet.name}"
parameter_group_name = "${aws_db_parameter_group.mysql-parameters.name}"
multi_az = "false"
vpc_security_group_ids = ["${aws_security_group.allow-mysql.id}"]
storage_type = "gp2"
backup_retention_period = 1
# availability_zone = "${aws_subnet.main-private-1.availability_zone}" # prefered AZ
enabled_cloudwatch_logs_exports = ["audit", "general", "error", "slowquery"]
skip_final_snapshot = true
snapshot_identifier = "${var.mysql-master-snapshot}"
auto_minor_version_upgrade = false
lifecycle {
ignore_changes = ["snapshot_identifier"]
}
tags = merge(
var.tags,
{
Name = "master-${var.application-domain}"
Environment = var.environment
}
)
}
*auto_minor_version_upgrade = false*