Feature: Configurable timeouts for connection to MySQL

[Blokje5]

Terraform Version

v0.11.11

Affected Resource(s)

• mysql provider

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]

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...