Create a replica Cloud SQL for MySQL instance
Stay organized with collections
Save and categorize content based on your preferences.
This Terraform shows how to create a replica MySQL instance
Code sample
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],[],[],[],null,["# Create a replica Cloud SQL for MySQL instance\n\nThis Terraform shows how to create a replica MySQL instance\n\nCode sample\n-----------\n\n### Terraform\n\n\nTo learn how to apply or remove a Terraform configuration, see\n[Basic Terraform commands](/docs/terraform/basic-commands).\n\n\nFor more information, see the\n[Terraform provider reference documentation](https://registry.terraform.io/providers/hashicorp/google/latest/docs).\n\n resource \"google_sql_database_instance\" \"primary\" {\n name = \"mysql-primary-instance-name\"\n region = \"europe-west4\"\n database_version = \"MYSQL_8_0\"\n settings {\n tier = \"db-n1-standard-2\"\n backup_configuration {\n enabled = \"true\"\n binary_log_enabled = \"true\"\n }\n }\n # set `deletion_protection` to true, will ensure that one cannot accidentally delete this instance by\n # use of Terraform whereas `deletion_protection_enabled` flag protects this instance at the GCP level.\n deletion_protection = false\n }\n\n resource \"google_sql_database_instance\" \"read_replica\" {\n name = \"mysql-replica-instance-name\"\n master_instance_name = google_sql_database_instance.primary.name\n region = \"europe-west4\"\n database_version = \"MYSQL_8_0\"\n\n replica_configuration {\n failover_target = false\n }\n\n settings {\n tier = \"db-n1-standard-2\"\n availability_type = \"ZONAL\"\n disk_size = \"100\"\n }\n # set `deletion_protection` to true, will ensure that one cannot accidentally delete this instance by\n # use of Terraform whereas `deletion_protection_enabled` flag protects this instance at the GCP level.\n deletion_protection = false\n }\n\nWhat's next\n-----------\n\n\nTo search and filter code samples for other Google Cloud products, see the\n[Google Cloud sample browser](/docs/samples?product=cloud_sql_mysql)."]]