Create a read replica Cloud SQL for MySQL instance
Stay organized with collections
Save and categorize content based on your preferences.
This sample demonstrates how to create a read replica of the primary Cloud SQL for MySQL instance. A read replica reflects changes to the primary in almost real time, in normal circumstances.
Explore further
For detailed documentation that includes this code sample, see the following:
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 read replica Cloud SQL for MySQL instance\n\nThis sample demonstrates how to create a read replica of the primary Cloud SQL for MySQL instance. A read replica reflects changes to the primary in almost real time, in normal circumstances.\n\nExplore further\n---------------\n\n\nFor detailed documentation that includes this code sample, see the following:\n\n- [Create read replicas](/sql/docs/mysql/replication/create-replica)\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\" \"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)."]]