search

hashicorp / terraform-provider-mysql

Terraform MySQL provider – This Terraform provider is archived per our provider archiving process: https://terraform.io/docs/internals/archiving.html
https://www.terraform.io/docs/providers/mysql/
Mozilla Public License 2.0
61 stars 189 forks source link

Feature: Configurable timeouts for connection to MySQL #71

Open Blokje5 opened 5 years ago

Blokje5 commented 5 years ago

Terraform Version

v0.11.11

Affected Resource(s)

Terraform Configuration Files

Currently the MySQL provider does not support configurable timeouts for connections. It will timeout after 5 minutes.

It would be nice if we could configure the connection timeout. Especially if there already is an existing database you are connecting with, 5 minutes is a long time to wait for the timeout to happen. e.g.

provider "mysql" {
  endpoint = "${var.endpoint}"
  username = "${var.username}"
  password = "${var.password}"
  connection_timeout = 1
}

Expected Behavior

Configuring the timeout allows the retry of the connection to timeout quicker than the default of 5 minutes.

Actual Behavior

Configuration of the timeout is not possible.

schuettecarsten commented 4 years ago

It is very important to specify a connection timeout when you use this Provider to connect to a Maria DB Aure instance - because connections simply timeout if you missed to add the firewall rule, which happens quite often in Corona Home Office situations. It's very annoying if you have to wait 5 minutes every time...