Meta tags:

Headings (most frequently used words):

cloud, shell, or, rest, curl, linux, macos, powershell, windows, response, read, pool, gcloud, v1, v1beta4, terraform, the, and, changes, to, create, prepare, apply, convert, replica, delete, manage, pools, stay, organized, with, collections, save, categorize, content, based, on, your, preferences, before, you, begin, directory, view, information, add, remove, nodes, edit, configuration, connect, what, next, console, products, pricing, support, resources, engage,

Text of the page (most frequently used words):
the (520), #gcloud (191), read (185), pool (152), you (141), sql (131), cloud (130), and (119), project (116), following (114), request (98), instances (96), auth (94), json (84), com (78), use (73), read_pool_name (72), with (68), projects (68), command (68), https (66), sqladmin (66), googleapis (66), name (65), your (61), for (59), running (59), using (58), cli (56), account (56), user (54), instance (54), shell (46), connect (44), headers (42), method (42), v1beta4 (40), patch (40), access (38), from (37), about (35), that (34), want (34), can (33), create (33), type (33), have (31), init (30), body (30), terraform (30), manage (29), execute (29), check (29), active (29), note (29), response (28), cred (28), print (28), token (28), authorization (28), bearer (28), expand (28), assumes (28), logged (28), currently (28), list (28), login (28), curl (28), data (28), number (28), content (27), file (27), nodes (27), information (26), make (26), operation_id (24), any (24), private (24), save (24), application (24), such (23), node_count (23), replica (23), see (22), replacements (22), database (22), primary (22), tier (21), example (20), delete (20), charset (20), utf (20), named (20), settings (20), google (19), similar (19), one (19), overview (19), node (19), logs (18), configuration (18), into (17), convert (17), send (16), invoke (16), set (16), operation (15), windows (15), these (15), before (15), choose (15), central1 (15), mysql (15), status (14), should (14), receive (14), webrequest (14), uri (14), select (14), object (14), powershell (14), which (14), automatically (14), linux (14), macos (14), options (14), http (14), url (14), where (14), rest (14), region (14), update (14), configure (14), read_replica_name (14), upgrade (14), this (13), operations (13), resource (13), apply (13), kind (12), targetlink (12), pending (12), inserttime (12), 2020 (12), 21t22 (12), 981z (12), operationtype (12), targetid (12), selflink (12), targetproject (12), connection (12), proxy (11), engine (11), view (11), machine (11), resources (10), contenttype (10), infile (10), attribute (10), read_pool_instance (10), quickstart (10), started (9), more (9), pools (9), install (9), version (9), nodecount (9), ipaddresses (9), ipaddress (9), get (9), availability (9), edition (9), high (9), import (9), code (8), getting (8), are (8), resides (8), starting (8), run (8), each (8), perf (8), optimized (8), primary_instance_name (8), directory (8), replication (8), server (8), databases (8), external (8), thumb (7), policies (7), installing (7), steps (7), network (7), replicas (7), must (7), export (7), password (7), management (7), vector (7), managed (7), samples (6), compute (6), console (6), same (6), vpc (6), edit (6), then (6), change (6), gcezone (6), dnsname (6), j10o8yqc7pve (6), goog (6), state (6), runnable (6), instancetype (6), zonal (6), post (6), database_version (6), storage (6), issues (6), backups (6), monitor (6), performance (6), recovery (6), service (6), iam (6), authentication (6), support (5), other (5), used (5), open (5), scale (5), read_replica_instance (5), instance_type (5), enterprise_plus (5), reside (5), changes (5), main (5), users (5), public (5), tools (5), usage (5), certificates (5), ssl (5), tls (5), encryption (5), embeddings (5), app (5), português (4), español (4), down (4), sample (4), need (4), updated (4), page (4), details (4), its (4), client (4), address (4), copy (4), complete (4), connector (4), connectors (4), connectivity (4), existing (4), manifest (4), looks (4), modifying (4), out (4), remove (4), describe (4), created (4), enterprise (4), plus (4), endpoint (4), databaseversion (4), false (4), full_network_name (4), networks (4), multiple (4), prompt (4), disable (4), environment (4), true (4), migration (4), reconfigure (4), optimize (4), query (4), language (4), build (4), best (4), practices (4), custom (4), disaster (4), control (4), organization (4), major (4), maintenance (4), free (4), terms (3), system (3), all (3), understand (3), start (3), connections (3), new (3), later (3), when (3), connecting (3), sure (3), limitations (3), modify (3), applied (3), across (3), how (3), instance_id (3), count (3), add (3), connectionname (3), 108 (3), 112 (3), c5bdacb09ffc (3), 113 (3), 8f77c454d6b2 (3), only (3), host (3), entering (3), yes (3), option (3), root (3), prepare (3), google_sql_database_instance (3), services (3), guides (3), observability (3), analytics (3), capacity (3), tables (3), troubleshoot (3), reduce (3), table (3), prevent (3), backup (3), enable (3), auditing (3), indexes (3), insights (3), mcp (3), queries (3), capture (3), audit (3), search (3), model (3), reference (3), applications (3), files (3), restore (3), standard (3), migrate (3), pooling (3), customer (3), tags (3), secure (3), place (3), trial (3), product (3), 한국어 (2), 日本語 (2), עברית (2), brasil (2), italiano (2), indonesia (2), français (2), américa (2), latina (2), deutsch (2), english (2), sign (2), join (2), site (2), youtube (2), events (2), architecture (2), github (2), pricing (2), products (2), last (2), 2026 (2), utc (2), licensed (2), under (2), java (2), license (2), feedback (2), autoscaling (2), section (2), latest (2), required (2), versions (2), include (2), ways (2), methods (2), first (2), available (2), some (2), show (2), uniformly (2), availabilitytype (2), clear (2), availability_type (2), wish (2), previously (2), newly (2), will (2), supported (2), create_read_pool (2), masterinstancename (2), ipconfiguration (2), ipv4enabled (2), privatenetwork (2), full (2), path (2), global (2), mysql_8_0_37 (2), east1 (2), property (2), insert (2), deletion (2), protection (2), deletion_protection (2), enabled (2), review (2), plan (2), once (2), per (2), optionally (2), end (2), tutorial (2), mysql_8_4 (2), europe (2), west4 (2), ip_configuration (2), ipv4_enabled (2), large (2), documentation (2), sdk (2), languages (2), frameworks (2), infrastructure (2), costs (2), security (2), monitoring (2), networking (2), industry (2), solutions (2), distributed (2), hybrid (2), multicloud (2), pipelines (2), hosting (2), development (2), disk (2), known (2), authorized (2), log (2), loss (2), enabling (2), automated (2), memory (2), cache (2), improve (2), assistance (2), agents (2), saved (2), generate (2), predictions (2), dump (2), perform (2), point (2), time (2), back (2), replicate (2), regional (2), kubernetes (2), flexible (2), phpmyadmin (2), authorize (2), write (2), keys (2), cmek (2), parameterized (2), views (2), studio (2), built (2), minor (2), updates (2), shrink (2), cross (2), technology (2), areas (2), close (2), subscribe, newsletter, our, third, decade, climate, action, cookies, privacy, tech, twitter, blog, engage, training, certification, center, release, notes, community, forums, contact, sales, marketplace, easy, easytounderstand, solved, problem, solvedmyproblem, otherup, hard, hardtounderstand, incorrect, incorrectinformationorsamplecode, missing, missingtheinformationsamplesineed, otherdown, tell, except, otherwise, noted, registered, trademark, oracle, affiliates, developers, apache, creative, commons, attribution, what, next, subsequent, two, ssh, taken, click, including, format, projectid, instanceid, python, minimum, usually, require, obtain, described, most, there, many, way, namely, creating, serve, source, attributes, field, different, vertically, detailed, might, look, original, changing, requires, separate, highly, specifying, during, conversion, process, become, clients, without, reconfiguration, destroy, argument, typically, assume, apis, results, navigate, has, them, wait, until, displays, message, verify, going, match, expectations, corrections, necessary, initialize, provider, parameters, recommended, snippet, part, solution, step, within, filename, extension, referred, mkdir, touch, own, also, called, module, variables, overridden, explicit, values, google_cloud_project, project_id, default, configurations, launch, sections, cloud_sql_instance, backup_configuration, binary_log_enabled, master_instance_name, includes, associated, master, assign, after, v532, contain, copies, haven, done, already, while, purpose, guide, uses, begin, describes, workloads, postgresql, categorize, based, preferences, stay, organized, collections, home, updating, orphan, diagnose, debug, error, messages, looker, rotate, broad, ranges, underprovisioned, overprovisioned, idle, temporary, increasing, retention, cpu, definitions, increase, reliability, enforce, recommendations, index, advisor, natural, querydata, conversational, securing, agent, interactions, remote, work, preview, filter, register, interact, models, llm, powered, langchain, embedding, workflow, online, integrate, vertex, generative, develop, cancel, parallel, csv, importing, exporting, deleted, enhanced, advanced, legacy, percona, xtrabackup, physical, replicating, lag, promote, outside, functions, operator, dns, certificate, authority, vpcs, both, learn, brute, force, controls, endpoints, side, attach, fine, grained, conditions, roles, permissions, identity, predefined, secret, manager, handle, secrets, residency, knowledge, catalog, gemini, statements, api, character, collation, operational, guidelines, general, migrating, troubleshooting, peering, allowlists, self, tests, locations, flags, label, stop, restart, clone, series, local, computer, key, features, editions, discover, skip,

Text of the page (random words):
nce audit audit logs mysql database auditing use mysql database auditing performance capture overview configure performance capture view performance capture logs query performance use query insights use index advisor monitor active queries system performance monitor instances view instance logs use system insights monitor cloud sql using the database insights mcp server apply recommendations create indexes or reconfigure join settings disable public ip enable database auditing enforce ssl tls encryption improve instance reliability by enabling high availability improve performance with enterprise plus increase the table open cache manage open tables and open table definitions manage high number of tables monitor disk availability optimize high cpu usage optimize high memory usage optimize instances with high number of out of memory events prevent data loss by enabling automated backups prevent data loss by increasing backup retention reconfigure connection settings reconfigure log settings reconfigure temporary table settings reduce idle cloud sql instances reduce overprovisioned cloud sql instances reduce underprovisioned cloud sql instances remove authorized networks remove broad public ip ranges rotate server certificates set instance password policies set user password policies use looker with cloud sql troubleshoot known issues troubleshoot error messages debug connection issues diagnose issues orphan tables issues updating storage capacity high disk usage issues ai and ml application development application hosting compute data analytics and pipelines databases distributed hybrid and multicloud industry solutions migration networking observability and monitoring security storage access and resources management costs and usage management infrastructure as code sdk languages frameworks and tools home documentation databases cloud sql mysql guides send feedback create and manage read pools stay organized with collections save and categorize content based on your preferences mysql postgresql sql server this page describes how to create and manage read pools for your large read workloads before you begin read pools contain copies of a primary instance if you haven t done so already create a cloud sql enterprise plus edition primary instance while read pools support public ip connectivity for the purpose of this guide create a primary instance with private ip connectivity that uses private services access for more information about primary instances and replication see about replication in cloud sql after the primary instance is created choose a password for the root user and run the following command to set the password on the primary instance save this password to use later when connecting to the read pool gcloud project project sql users set password root host instance primary_instance_name prompt for password make sure you re using gcloud v532 0 0 or later make the following replacements project the name of the project where you want the primary instance and read pool to reside primary_instance_name the name of the primary instance create a read pool gcloud for information about installing and getting started with the gcloud cli see install the gcloud cli for information about starting cloud shell see use cloud shell use the following gcloud sql instances create command to create a read pool with multiple read pool nodes gcloud sql instances create read_pool_name tier tier edition enterprise_plus instance type read_pool_instance node count node_count master instance name primary_instance_name no assign ip make the following replacements read_pool_name the name you want to use for the read pool tier the machine type you want to use for each read pool node in the read pool such as db perf optimized n 4 node_count the number of read pool nodes you want in the read pool choose any number from 1 to 20 primary_instance_name the name of the primary instance associated with the read pool such as my primary instance terraform to create a read pool use a terraform resource then set the instance_type attribute to read_pool_instance and the node_count attribute to the number of nodes you want to use the following example includes resources for the primary instance and the read pool resource google_sql_database_instance primary name mysql primary database_version mysql_8_4 region europe west4 instance_type cloud_sql_instance settings tier db perf optimized n 2 edition enterprise_plus backup_configuration enabled true binary_log_enabled true ip_configuration ipv4_enabled true resource google_sql_database_instance replica name mysql replica database_version mysql_8_4 region europe west4 master_instance_name google_sql_database_instance primary name instance_type read_pool_instance node_count 2 settings tier db perf optimized n 2 edition enterprise_plus ip_configuration ipv4_enabled true apply the changes to apply your terraform configuration in a google cloud project complete the steps in the following sections prepare cloud shell launch cloud shell set the default google cloud project where you want to apply your terraform configurations you only need to run this command once per project and you can run it in any directory export google_cloud_project project_id environment variables are overridden if you set explicit values in the terraform configuration file prepare the directory each terraform configuration file must have its own directory also called a root module in cloud shell create a directory and a new file within that directory the filename must have the tf extension for example main tf in this tutorial the file is referred to as main tf mkdir directory cd directory touch main tf if you are following a tutorial you can copy the sample code in each section or step copy the sample code into the newly created main tf optionally copy the code from github this is recommended when the terraform snippet is part of an end to end solution review and modify the sample parameters to apply to your environment save your changes initialize terraform you only need to do this once per directory terraform init optionally to use the latest google provider version include the upgrade option terraform init upgrade apply the changes review the configuration and verify that the resources that terraform is going to create or update match your expectations terraform plan make corrections to the configuration as necessary apply the terraform configuration by running the following command and entering yes at the prompt terraform apply wait until terraform displays the apply complete message open your google cloud project to view the results in the google cloud console navigate to your resources in the ui to make sure that terraform has created or updated them note terraform samples typically assume that the required apis are enabled in your google cloud project delete the changes to delete your changes do the following to disable deletion protection in your terraform configuration file set the deletion_protection argument to false deletion_protection false apply the updated terraform configuration by running the following command and entering yes at the prompt terraform apply remove resources previously applied with your terraform configuration by running the following command and entering yes at the prompt terraform destroy rest v1 use the insert method of the instances resource to create a read pool with multiple read pool nodes the databaseversion property must be the same as the primary before using any of the request data make the following replacements project the name of the project where you want the primary instance and read pool to reside region the region for the read pool such as us east1 the region must be the same as the primary instance tier the machine type you want to use for each read pool node in the read pool such as db perf optimized n 4 primary_instance_name the name of the primary instance read_pool_name the name you want to use for the read pool such as my read pool database_version the database version you want to use for example mysql_8_0_37 node_count the number of read pool nodes you want in the read pool choose any number from 1 to 20 full_network_name the full network path where you want the read pool to reside such as projects vpc host project global networks my network name http method and url post https sqladmin googleapis com v1 projects project instances request json body name read_pool_name masterinstancename primary_instance_name project project databaseversion database_version region region instancetype read_pool_instance nodecount node_count settings tier tier edition enterprise_plus ipconfiguration ipv4enabled false privatenetwork full_network_name to send your request expand one of these options curl linux macos or cloud shell note the following command assumes that you have logged in to the gcloud cli with your user account by running gcloud init or gcloud auth login or by using cloud shell which automatically logs you into the gcloud cli you can check the currently active account by running gcloud auth list save the request body in a file named request json and execute the following command curl x post h authorization bearer gcloud auth print access token h content type application json charset utf 8 d request json https sqladmin googleapis com v1 projects project instances powershell windows note the following command assumes that you have logged in to the gcloud cli with your user account by running gcloud init or gcloud auth login you can check the currently active account by running gcloud auth list save the request body in a file named request json and execute the following command cred gcloud auth print access token headers authorization bearer cred invoke webrequest method post headers headers contenttype application json charset utf 8 infile request json uri https sqladmin googleapis com v1 projects project instances select object expand content you should receive a json response similar to the following response kind sql operation targetlink https sqladmin googleapis com v1 projects project instances read_pool_name status pending user user example com inserttime 2020 01 21t22 43 37 981z operationtype create_read_pool name operation_id targetid instance_id selflink https sqladmin googleapis com v1 projects project operations operation_id targetproject project rest v1beta4 use the insert method of the instances resource to create a read pool with multiple read pool nodes the databaseversion property must be the same as the primary before using any of the request data make the following replacements project the name of the project where you want the primary instance and read pool to reside region the region for the read pool such as us east1 the region must be the same as the primary instance tier the machine type you want to use for each read pool node in the read pool such as db perf optimized n 4 primary_instance_name the name of the primary instance read_pool_name the name you want to use for the read pool such as my read pool database_version the database version you want to use for example mysql_8_0_37 node_count the number of read pool nodes you want in the read pool choose any number from 1 to 20 full_network_name the full network path where you want the read pool to reside such as projects vpc host project global networks my network name http method and url post https sqladmin googleapis com sql v1beta4 projects project instances request json body name read_pool_name masterinstancename primary_instance_name project project databaseversion database_version region region instancetype read_pool_instance nodecount node_count settings tier tier edition enterprise_plus ipconfiguration ipv4enabled false privatenetwork full_network_name to send your request expand one of these options curl linux macos or cloud shell note the following command assumes that you have logged in to the gcloud cli with your user account by running gcloud init or gcloud auth login or by using cloud shell which automatically logs you into the gcloud cli you can check the currently active account by running gcloud auth list save the request body in a file named request json and execute the following command curl x post h authorization bearer gcloud auth print access token h content type application json charset utf 8 d request json https sqladmin googleapis com sql v1beta4 projects project instances powershell windows note the following command assumes that you have logged in to the gcloud cli with your user account by running gcloud init or gcloud auth login you can check the currently active account by running gcloud auth list save the request body in a file named request json and execute the following command cred gcloud auth print access token headers authorization bearer cred invoke webrequest method post headers headers contenttype application json charset utf 8 infile request json uri https sqladmin googleapis com sql v1beta4 projects project instances select object expand content you should receive a json response similar to the following response kind sql operation targetlink https sqladmin googleapis com sql v1beta4 projects project instances read_pool_name status pending user user example com inserttime 2020 01 21t22 43 37 981z operationtype create_read_pool name operation_id targetid instance_id selflink https sqladmin googleapis com sql v1beta4 projects project operations operation_id targetproject project convert a read replica to a read pool you can convert an existing cloud sql enterprise plus edition read replica into a read pool by specifying the number of nodes in the pool during this conversion process the replica ip will become the read pool ip the read endpoint so existing clients can connect to the pool without reconfiguration the newly created read pool nodes will have the same machine type and configuration as the original read replica changing this machine type or configuration requires a separate operation this operation is only supported for zonal read replicas to convert a highly available ha read replica to a read pool you must first convert it to a zonal read replica for more information see edit read pool configuration gcloud for information about installing and getting started with the gcloud cli see install the gcloud cli for information about starting cloud shell see use cloud shell use the following gcloud sql instances patch command to convert a read replica for use with a read pool gcloud sql instances patch read_replica_name instance type read_pool_instance node count node_count make the following replacements read_replica_name the name of the read replica you want to convert node_count the number of read pool nodes you want in the read pool choose any number from 1 to 20 terraform to convert a read replica to a read pool use a terraform resource the manifest looks similar to the one you used in create a read replica then complete the following steps change the instance_type ...