Need ability to create Google Cloud SQL 2nd Gen *failover* replica instance

[ryan-mf]

Hi,

When using Terraform to create Google Cloud SQL 2nd Gen instances, I'm trying to create a master and a failover slave/replication instance. While the docs (https://www.terraform.io/docs/providers/google/r/sql_database_instance.html) explain how to define an instance as a replica, there doesn't seem to be any way to define the slave as a replica type "failover". As a result, I have to do this in the GCE Cloud SQL web UI which prevents automation.

Terraform Version

Terraform v0.8.5

Affected Resource(s)

• google_sql_database_instance

Terraform Configuration Files

// GCP Cloud SQL Secondary DB in Zone us-central1-c
resource "google_sql_database_instance" "archesdb-secondary" {
  provider           = "google.gcp-central"
  region             = "us-central"
  database_version   = "MYSQL_5_7"
  master_instance_name = "${google_sql_database_instance.archesdb-primary.name}"

  replica_configuration {
    connect_retry_interval = "30"
  }

  settings {
    tier             = "db-n1-standard-1"

    ip_configuration {
        require_ssl        = "true"
    }

    location_preference {
        zone               = "us-central1-c"
    }
  }
}

Expected Behavior

There should be a configuration flag in the replica options to specify the instance as a failover. Google Cloud SQL considers failover replicas (of which you can only have one per master instance) differently than plain read-only replicas.

Actual Behavior

Unable to specify replica type as failover.

References

None found.

[ghost]

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues.

If you have found a problem that seems similar to this, please open a new issue and complete the issue template so we can capture all the details necessary to investigate further.