Implement new cloud SQL API switchover

[lychgoogle]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request.
• Please do not leave +1 or me too comments, they generate extra noise for issue followers and do not help prioritize the request.
• If you are interested in working on this issue or have submitted a pull request, please leave a comment.
• If an issue is assigned to a user, that user is claiming responsibility for the issue.
• Customers working with a Google Technical Account Manager or Customer Engineer can ask them to reach out internally to expedite investigation and resolution of this issue.

Description

We have new API switchover on cloud SQL (API doc) https://cloud.google.com/sql/docs/mysql/admin-api/rest/v1/instances/switchover , and we want to support them in terraform.

New or Affected Resource(s)

• google_sql_database_instance

Potential Terraform Configuration

Suppose we have "original-primary" and "original-replica", then we make following change to the replica to trigger switchover.

resource "google_sql_database_instance" "original-replica" {
  provider = google-beta
  name = "original-replica"
  project = "my-project"
-  instance_type = "READ_REPLICA_INSTANCE"
+  instance_type = "CLOUD_SQL_INSTANCE" 
+  replica_names = ["original-primary"]
# irrelevant fields are omitted.
}

References

No response

b/359238666

[lychgoogle]

Addition on assignee: I'd like to work it myself, but not sure how to make me as an assignee.