Meta tags:

Headings (most frequently used words):

replication, rest, curl, linux, macos, or, cloud, shell, powershell, windows, response, parallel, console, gcloud, v1, v1beta4, flags, read, replicas, and, for, manage, stay, organized, with, collections, save, categorize, content, based, on, your, preferences, disable, enable, promote, replica, configure, check, status, troubleshoot, what, next, basic, steps, to, change, primary, instance, mysql, client, products, pricing, support, resources, engage,

Text of the page (most frequently used words):
the (420), #replica (136), and (118), replication (107), sql (102), cloud (99), gcloud (85), for (84), #instance (82), you (68), instances (63), name (54), mysql (53), using (49), project (49), with (48), request (47), running (46), command (46), auth (46), following (44), com (41), read (40), primary (38), use (38), connect (38), json (36), from (35), googleapis (35), database (33), access (33), that (32), https (30), sqladmin (30), projects (30), manage (29), can (29), status (28), flags (27), about (26), account (26), your (26), user (25), replicas (24), token (24), this (23), execute (22), create (20), set (20), these (20), parallel (20), lag (20), high (20), thread (20), check (20), data (20), google (19), cli (19), more (18), are (18), state (18), operation (18), v1beta4 (18), print (18), headers (18), curl (18), patch (18), overview (18), configure (17), enable (17), note (17), value (16), select (16), logs (16), content (15), send (15), when (15), availability (15), flag (14), time (14), have (14), currently (14), metric (14), active (14), console (14), application (14), page (13), external (13), upgrade (13), shell (13), see (12), information (12), error (12), log (12), default (12), response (12), cred (12), authorization (12), bearer (12), method (12), expand (12), assumes (12), logged (12), list (12), login (12), init (12), rest (12), body (12), transaction (11), storage (11), which (11), disable (11), type (11), monitor (11), click (11), one (10), service (10), charset (10), utf (10), file (10), private (10), quickstart (10), events (9), learn (9), queries (9), into (9), operations (9), metrics (9), before (9), performance (9), server (9), example (9), save (9), settings (9), import (9), engine (9), add (8), write (8), then (8), api (8), any (8), not (8), should (8), invoke (8), promotereplica (8), automatically (8), named (8), databases (8), thumb (7), its (7), policies (7), how (7), long (7), transactions (7), binlog_transaction_dependency_tracking (7), transaction_write_set_extraction (7), off (7), also (7), table (7), memory (7), disk (7), checking (7), options (7), view (7), reference (7), values (7), enabling (7), windows (7), recovery (7), backups (7), management (7), vector (7), managed (7), resources (6), all (6), configuration (6), update (6), enabled (6), documentation (6), has (6), client (6), connection (6), slave (6), run (6), version (6), kind (6), targetlink (6), pending (6), inserttime (6), 2020 (6), 21t22 (6), 981z (6), operationtype (6), targetid (6), selflink (6), targetproject (6), receive (6), similar (6), webrequest (6), post (6), uri (6), object (6), powershell (6), linux (6), macos (6), http (6), url (6), make (6), replacements (6), line (6), prompt (6), acquire (6), apis (6), explorer (6), promote (6), promoting (6), issues (6), export (6), iam (6), authentication (6), code (5), samples (5), otherwise (5), best (5), practices (5), amount (5), query (5), some (5), possible (5), tables (5), reduce (5), increase (5), updates (5), field (5), restart (5), files (5), replicating (5), show (5), whether (5), threads (5), relay (5), yes (5), databasereplicationenabled (5), chart (5), monitoring (5), custom (5), reports (5), cloudsql (5), available (5), allowed (5), replica_preserve_commit_order (5), earlier (5), later (5), optimize (5), disabled (5), users (5), migration (5), disaster (5), tools (5), usage (5), certificates (5), ssl (5), tls (5), encryption (5), embeddings (5), choose (5), app (5), proxy (5), português (4), español (4), terms (4), other (4), down (4), indexes (4), creation (4), writeset (4), xxhash64 (4), single (4), start (4), binary (4), timestamp (4), would (4), large (4), increasing (4), solutions (4), place (4), temporary (4), edit (4), number (4), delete (4), find (4), there (4), logging (4), networking (4), troubleshoot (4), output (4), they (4), applied (4), applications (4), replica_name (4), filter (4), shows (4), dashboard (4), region (4), cross (4), manual (4), indicates (4), does (4), replica_pending_jobs_size_max (4), setting (4), option (4), versions (4), configuring (4), contenttype (4), infile (4), disabling (4), compute (4), public (4), reconfigure (4), language (4), build (4), control (4), organization (4), major (4), maintenance (4), free (4), system (3), support (3), understand (3), details (3), requirements (3), cause (3), after (3), modify (3), commit_order (3), changing (3), source (3), current (3), period (3), include (3), unable (3), size (3), key (3), full (3), maximum (3), cache (3), actual (3), inspect (3), equal (3), exec_master_log_pos (3), read_master_log_pos (3), relay_master_log_file (3), master_log_file (3), committed (3), seconds_behind_master (3), both (3), look (3), describe (3), behind (3), replica_lag (3), network (3), non (3), get (3), 25000 (3), contains (3), ranges (3), supports (3), links (3), legacy (3), logical_clock (3), replica_parallel_type (3), promoted (3), configured (3), clicking (3), stop (3), regional (3), guides (3), observability (3), analytics (3), capacity (3), prevent (3), backup (3), open (3), auditing (3), insights (3), mcp (3), capture (3), audit (3), search (3), model (3), endpoint (3), restore (3), standard (3), migrate (3), vpc (3), pooling (3), connectors (3), customer (3), tags (3), secure (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), action (2), join (2), site (2), youtube (2), architecture (2), started (2), pricing (2), products (2), incorrect (2), missing (2), need (2), last (2), updated (2), 2026 (2), utc (2), licensed (2), under (2), license (2), feedback (2), recreate (2), slave_pending_jobs_size_max (2), statements (2), binlog (2), result (2), row (2), changes (2), during (2), catch (2), processing (2), multiple (2), avoid (2), load (2), too (2), handle (2), takes (2), causes (2), fix (2), slow (2), index (2), based (2), must (2), unique (2), was (2), automatic (2), stopped (2), uses (2), than (2), probably (2), specific (2), continue (2), explicitly (2), max_connections (2), troubleshooting (2), executed (2), same (2), received (2), seconds (2), lags (2), difference (2), between (2), original (2), being (2), executing (2), slave_sql_running (2), slave_io_running (2), tab (2), connecting (2), network_lag (2), but (2), apply (2), end (2), lagging (2), particular (2), writes (2), may (2), been (2), yet (2), including (2), murmur32 (2), writeset_session (2), deprecated (2), binlog_transaction_dependency_history_size (2), several (2), 1gb (2), failover (2), only (2), 1024 (2), replica_parallel_workers (2), steps (2), instead (2), work (2), describes (2), consider (2), promote_replica (2), standalone (2), true (2), longer (2), new (2), false (2), extended (2), might (2), clone (2), debug (2), sdk (2), languages (2), frameworks (2), infrastructure (2), costs (2), security (2), industry (2), distributed (2), hybrid (2), multicloud (2), pipelines (2), hosting (2), development (2), known (2), password (2), remove (2), authorized (2), networks (2), loss (2), automated (2), improve (2), enterprise (2), plus (2), assistance (2), agents (2), saved (2), generate (2), predictions (2), dump (2), perform (2), point (2), back (2), replicate (2), pool (2), pools (2), kubernetes (2), flexible (2), phpmyadmin (2), authorize (2), services (2), keys (2), cmek (2), parameterized (2), views (2), studio (2), built (2), minor (2), edition (2), shrink (2), environment (2), technology (2), areas (2), close (2), subscribe, newsletter, our, third, decade, climate, cookies, privacy, tech, twitter, blog, engage, training, certification, center, getting, github, release, notes, community, forums, contact, sales, marketplace, easy, easytounderstand, solved, problem, solvedmyproblem, otherup, hard, hardtounderstand, sample, incorrectinformationorsamplecode, missingtheinformationsamplesineed, otherdown, tell, except, noted, java, registered, trademark, oracle, affiliates, developers, apache, creative, commons, attribution, stored, procedures, what, next, uncommitted, fail, stopping, fails, timeout, 33554432, displaying, message, results, caused, statement, multi, commits, recorded, receives, event, compares, calculate, hence, immediate, spend, once, finishes, depend, workload, speed, try, separate, mixed, dmls, chunk, smaller, batches, break, small, suddenly, spikes, keep, kinds, workloads, permanent, given, schema, typical, identify, traffic, tips, working, innodb_flush_log_at_trx_commit, like, since, huge, piled, where, 50000000, every, such, without, scans, them, consistently, limit, reached, isn, often, requested, lead, reclaim, space, much, become, larger, creates, necessary, process, servicenetworking, serviceagent, role, consumer, unknown, invalid, could, provided, appropriately, first, greater, invalidflagvalue, didn, issue, coordinates, filename, offset, processed, broken, null, respectively, responsible, transferring, those, master_host, property, replicanames, primary_instance_name, properties, masterinstancename, resource, give, dashboards, servers, wish, slave_sql_running_state, reading, slave_io_running_state, zero, negligible, able, fast, enough, writing, reach, cascading, each, pair, monitored, separately, yields, counted, even, report, below, consult, actively, streaming, description, additional, display, administration, brief, summary, 1000000, tune, associated, sets, bytes, applier, queues, holding, cannot, requires, prevents, gaps, sequence, 128mb, 16mb, optionally, please, commands, basic, change, threaded, document, unsupported, simplicity, three, scenarios, used, collected, reduces, sometimes, called, multithreaded, reducing, important, managing, occurs, fall, section, confirm, correctly, needed, newly, were, verify, wait, until, reported, follow, instructions, still, serving, clients, cases, aren, just, done, way, stops, converts, capabilities, will, take, case, button, bar, accumulate, transactional, let, resume, creating, becomes, charged, stand, alone, starts, however, analyze, ready, doesn, works, postgresql, categorize, preferences, stay, organized, collections, home, updating, orphan, diagnose, messages, looker, rotate, broad, underprovisioned, overprovisioned, idle, retention, out, cpu, definitions, reliability, enforce, recommendations, advisor, natural, querydata, conversational, securing, agent, interactions, remote, preview, register, interact, models, llm, powered, langchain, embedding, workflow, online, integrate, vertex, generative, develop, cancel, csv, importing, exporting, deleted, enhanced, advanced, percona, xtrabackup, physical, autoscaling, outside, connections, functions, operator, dns, certificate, authority, across, vpcs, brute, force, protection, controls, endpoints, side, attach, fine, grained, conditions, roles, permissions, identity, predefined, secret, manager, secrets, residency, knowledge, catalog, gemini, character, collation, operational, guidelines, general, migrating, peering, allowlists, self, connectivity, tests, locations, supported, deletion, label, machine, series, plan, prepare, local, computer, features, editions, discover, skip, main,

Text of the page (random words):
primary instance to disable replication console in the google cloud console go to the cloud sql instances page go to cloud sql instances select a replica instance by clicking its name click disable replication in the button bar click ok gcloud gcloud sql instances patch replica_name no enable database replication rest v1 to execute this curl command at a command line prompt you acquire an access token by using the gcloud auth print access token command you can also use the apis explorer on the instances patch page to send the rest api request before using any of the request data make the following replacements project id the project id replica name the name of the replica instance http method and url patch https sqladmin googleapis com v1 projects project id instances replica name request json body settings databasereplicationenabled false 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 patch 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 id instances replica name 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 patch headers headers contenttype application json charset utf 8 infile request json uri https sqladmin googleapis com v1 projects project id instances replica name 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 id instances replica name status pending user user example com inserttime 2020 01 21t22 43 37 981z operationtype update name operation id targetid replica name selflink https sqladmin googleapis com v1 projects project id operations operation id targetproject project id rest v1beta4 to execute this curl command at a command line prompt you acquire an access token by using the gcloud auth print access token command you can also use the apis explorer on the instances patch page to send the rest api request before using any of the request data make the following replacements project id the project id replica name the name of the replica instance http method and url patch https sqladmin googleapis com sql v1beta4 projects project id instances replica name request json body settings databasereplicationenabled false 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 patch 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 id instances replica name 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 patch headers headers contenttype application json charset utf 8 infile request json uri https sqladmin googleapis com sql v1beta4 projects project id instances replica name 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 id instances replica name status pending user user example com inserttime 2020 01 21t22 43 37 981z operationtype update name operation id targetid replica name selflink https sqladmin googleapis com sql v1beta4 projects project id operations operation id targetproject project id enable replication if a replica has not been replicating for a long time it will take longer for it to catch up to the primary instance in this case delete the replica and create a new one to enable replication console in the google cloud console go to the cloud sql instances page go to cloud sql instances select a replica instance by clicking its name click enable replication click ok gcloud gcloud sql instances patch replica_name enable database replication rest v1 to execute this curl command at a command line prompt you acquire an access token by using the gcloud auth print access token command you can also use the apis explorer on the instances patch page to send the rest api request before using any of the request data make the following replacements project id the project id replica name the name of the replica instance http method and url patch https sqladmin googleapis com v1 projects project id instances replica name request json body settings databasereplicationenabled true 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 patch 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 id instances replica name 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 patch headers headers contenttype application json charset utf 8 infile request json uri https sqladmin googleapis com v1 projects project id instances replica name 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 id instances replica name status pending user user example com inserttime 2020 01 21t22 43 37 981z operationtype update name operation id targetid replica name selflink https sqladmin googleapis com v1 projects project id operations operation id targetproject project id rest v1beta4 to execute this curl command at a command line prompt you acquire an access token by using the gcloud auth print access token command you can also use the apis explorer on the instances patch page to send the rest api request before using any of the request data make the following replacements project id the project id replica name the name of the replica instance http method and url patch https sqladmin googleapis com sql v1beta4 projects project id instances replica name request json body settings databasereplicationenabled true 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 patch 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 id instances replica name 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 patch headers headers contenttype application json charset utf 8 infile request json uri https sqladmin googleapis com sql v1beta4 projects project id instances replica name 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 id instances replica name status pending user user example com inserttime 2020 01 21t22 43 37 981z operationtype update name operation id targetid replica name selflink https sqladmin googleapis com sql v1beta4 projects project id operations operation id targetproject project id promote a replica promoting a read replica stops replication and converts the instance to a standalone cloud sql primary instance with read and write capabilities when promoted read replicas are automatically configured with backups but they aren t automatically configured as high availability ha instances you can enable high availability after promoting the replica just as you would for any non replica instance configuring a read replica for high availability is done the same way as for a primary instance learn more about configuring the instance for high availability see promoting replicas for regional migration or disaster recovery to learn more about use cases for cross region replicas before promoting a read replica if the primary is still available and serving clients you should do the following stop all writes to the primary instance check the replication status of the replica follow the instructions in the mysql client tab verify that the replica is replicating and then wait until the replication lag reported by the seconds_behind_master metric is 0 otherwise a newly promoted instance may be missing some transactions that were committed to the primary instance to promote a replica to a standalone instance console in the google cloud console go to the cloud sql instances page go to cloud sql instances select a replica instance by clicking its name click promote replica click ok gcloud gcloud sql instances promote replica replica_name rest v1 to execute this curl command at a command line prompt you acquire an access token by using the gcloud auth print access token command you can also use the apis explorer on the instances promotereplica page to send the rest api request before using any of the request data make the following replacements project id the project id replica name the name of the replica instance http method and url post https sqladmin googleapis com v1 projects project id instances replica name promotereplica 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 execute the following command curl x post h authorization bearer gcloud auth print access token h content type application json charset utf 8 d https sqladmin googleapis com v1 projects project id instances replica name promotereplica 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 execute the following command cred gcloud auth print access token headers authorization bearer cred invoke webrequest method post headers headers uri https sqladmin googleapis com v1 projects project id instances replica name promotereplica 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 id instances replica name status pending user user example com inserttime 2020 01 21t22 43 37 981z operationtype promote_replica name operation id targetid replica name selflink https sqladmin googleapis com v1 projects project id operations operation id targetproject project id rest v1beta4 to execute this curl command at a command line prompt you acquire an access token by using the gcloud auth print access token command you can also use the apis explorer on the instances promotereplica page to send the rest api request before using any of the request data make the following replacements project id the project id replica name the name of the replica instance http method and url post https sqladmin googleapis com sql v1beta4 projects project id instances replica name promotereplica 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 execute the following command curl x post h authorization bearer gcloud auth print access token h content type application json charset utf 8 d https sqladmin googleapis com sql v1beta4 projects project id instances replica name promotereplica 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 execute the following command cred gcloud auth print access token headers authorization bearer cred invoke webrequest method post headers headers uri https sqladmin googleapis com sql v1beta4 projects project id instances replica name promotereplica select object expand content you should receive a json response similar to the following response kind sql operation t...