mirror of
https://github.com/OMGeeky/google-apis-rs.git
synced 2026-01-25 12:44:07 +01:00
992 lines
38 KiB
HTML
992 lines
38 KiB
HTML
<!DOCTYPE html>
|
|
<html class="writer-html5" lang="en" >
|
|
<head>
|
|
<meta charset="utf-8" />
|
|
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
|
|
<meta name="viewport" content="width=device-width, initial-scale=1.0" /><link rel="canonical" href="http://byron.github.io/google-apis-rs/google-sql1_beta4-cli/instances_insert/" />
|
|
<link rel="shortcut icon" href="../img/favicon.ico" />
|
|
<title>Insert - SQL Admin v5.0.4+20200331</title>
|
|
<link rel="stylesheet" href="../css/theme.css" />
|
|
<link rel="stylesheet" href="../css/theme_extra.css" />
|
|
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/10.5.0/styles/github.min.css" />
|
|
|
|
<script>
|
|
// Current page data
|
|
var mkdocs_page_name = "Insert";
|
|
var mkdocs_page_input_path = "instances_insert.md";
|
|
var mkdocs_page_url = "/google-apis-rs/google-sql1_beta4-cli/instances_insert/";
|
|
</script>
|
|
|
|
<script src="../js/jquery-3.6.0.min.js" defer></script>
|
|
<!--[if lt IE 9]>
|
|
<script src="../js/html5shiv.min.js"></script>
|
|
<![endif]-->
|
|
<script src="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/10.5.0/highlight.min.js"></script>
|
|
<script>hljs.initHighlightingOnLoad();</script>
|
|
</head>
|
|
|
|
<body class="wy-body-for-nav" role="document">
|
|
|
|
<div class="wy-grid-for-nav">
|
|
<nav data-toggle="wy-nav-shift" class="wy-nav-side stickynav">
|
|
<div class="wy-side-scroll">
|
|
<div class="wy-side-nav-search">
|
|
<a href=".." class="icon icon-home"> SQL Admin v5.0.4+20200331
|
|
</a><div role="search">
|
|
<form id ="rtd-search-form" class="wy-form" action="../search.html" method="get">
|
|
<input type="text" name="q" placeholder="Search docs" title="Type search term here" />
|
|
</form>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="wy-menu wy-menu-vertical" data-spy="affix" role="navigation" aria-label="Navigation menu">
|
|
<ul>
|
|
<li class="toctree-l1"><a class="reference internal" href="..">Home</a>
|
|
</li>
|
|
</ul>
|
|
<p class="caption"><span class="caption-text">Backup Runs</span></p>
|
|
<ul>
|
|
<li class="toctree-l1"><a class="reference internal" href="../backup-runs_delete/">Delete</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../backup-runs_get/">Get</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../backup-runs_insert/">Insert</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../backup-runs_list/">List</a>
|
|
</li>
|
|
</ul>
|
|
<p class="caption"><span class="caption-text">Databases</span></p>
|
|
<ul>
|
|
<li class="toctree-l1"><a class="reference internal" href="../databases_delete/">Delete</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../databases_get/">Get</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../databases_insert/">Insert</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../databases_list/">List</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../databases_patch/">Patch</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../databases_update/">Update</a>
|
|
</li>
|
|
</ul>
|
|
<p class="caption"><span class="caption-text">Flags</span></p>
|
|
<ul>
|
|
<li class="toctree-l1"><a class="reference internal" href="../flags_list/">List</a>
|
|
</li>
|
|
</ul>
|
|
<p class="caption"><span class="caption-text">Instances</span></p>
|
|
<ul class="current">
|
|
<li class="toctree-l1"><a class="reference internal" href="../instances_add-server-ca/">Add Server Ca</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../instances_clone/">Clone</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../instances_delete/">Delete</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../instances_demote-master/">Demote Master</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../instances_export/">Export</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../instances_failover/">Failover</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../instances_get/">Get</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../instances_import/">Import</a>
|
|
</li>
|
|
<li class="toctree-l1 current"><a class="reference internal current" href="./">Insert</a>
|
|
<ul class="current">
|
|
</ul>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../instances_list/">List</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../instances_list-server-cas/">List Server Cas</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../instances_patch/">Patch</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../instances_promote-replica/">Promote Replica</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../instances_reset-ssl-config/">Reset Ssl Config</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../instances_restart/">Restart</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../instances_restore-backup/">Restore Backup</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../instances_rotate-server-ca/">Rotate Server Ca</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../instances_start-replica/">Start Replica</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../instances_stop-replica/">Stop Replica</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../instances_truncate-log/">Truncate Log</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../instances_update/">Update</a>
|
|
</li>
|
|
</ul>
|
|
<p class="caption"><span class="caption-text">Operations</span></p>
|
|
<ul>
|
|
<li class="toctree-l1"><a class="reference internal" href="../operations_get/">Get</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../operations_list/">List</a>
|
|
</li>
|
|
</ul>
|
|
<p class="caption"><span class="caption-text">Projects</span></p>
|
|
<ul>
|
|
<li class="toctree-l1"><a class="reference internal" href="../projects_instances-reschedule-maintenance/">Instances Reschedule Maintenance</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../projects_instances-start-external-sync/">Instances Start External Sync</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../projects_instances-verify-external-sync-settings/">Instances Verify External Sync Settings</a>
|
|
</li>
|
|
</ul>
|
|
<p class="caption"><span class="caption-text">Ssl Certs</span></p>
|
|
<ul>
|
|
<li class="toctree-l1"><a class="reference internal" href="../ssl-certs_create-ephemeral/">Create Ephemeral</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../ssl-certs_delete/">Delete</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../ssl-certs_get/">Get</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../ssl-certs_insert/">Insert</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../ssl-certs_list/">List</a>
|
|
</li>
|
|
</ul>
|
|
<p class="caption"><span class="caption-text">Tiers</span></p>
|
|
<ul>
|
|
<li class="toctree-l1"><a class="reference internal" href="../tiers_list/">List</a>
|
|
</li>
|
|
</ul>
|
|
<p class="caption"><span class="caption-text">Users</span></p>
|
|
<ul>
|
|
<li class="toctree-l1"><a class="reference internal" href="../users_delete/">Delete</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../users_insert/">Insert</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../users_list/">List</a>
|
|
</li>
|
|
<li class="toctree-l1"><a class="reference internal" href="../users_update/">Update</a>
|
|
</li>
|
|
</ul>
|
|
</div>
|
|
</div>
|
|
</nav>
|
|
|
|
<section data-toggle="wy-nav-shift" class="wy-nav-content-wrap">
|
|
<nav class="wy-nav-top" role="navigation" aria-label="Mobile navigation menu">
|
|
<i data-toggle="wy-nav-top" class="fa fa-bars"></i>
|
|
<a href="..">SQL Admin v5.0.4+20200331</a>
|
|
|
|
</nav>
|
|
<div class="wy-nav-content">
|
|
<div class="rst-content"><div role="navigation" aria-label="breadcrumbs navigation">
|
|
<ul class="wy-breadcrumbs">
|
|
<li><a href=".." class="icon icon-home" alt="Docs"></a> »</li>
|
|
<li>Instances »</li>
|
|
<li>Insert</li>
|
|
<li class="wy-breadcrumbs-aside">
|
|
<a href="https://github.com/Byron/google-apis-rs/tree/main/gen/sql1_beta4-cli/edit/master/docs/instances_insert.md"
|
|
class="icon icon-github"> Edit on GitHub</a>
|
|
</li>
|
|
</ul>
|
|
<hr/>
|
|
</div>
|
|
<div role="main" class="document" itemscope="itemscope" itemtype="http://schema.org/Article">
|
|
<div class="section" itemprop="articleBody">
|
|
|
|
<p>Creates a new Cloud SQL instance.</p>
|
|
<h1 id="scopes">Scopes</h1>
|
|
<p>You will need authorization for at least one of the following scopes to make a valid call:</p>
|
|
<ul>
|
|
<li><em>https://www.googleapis.com/auth/cloud-platform</em></li>
|
|
<li><em>https://www.googleapis.com/auth/sqlservice.admin</em></li>
|
|
</ul>
|
|
<p>If unset, the scope for this method defaults to <em>https://www.googleapis.com/auth/cloud-platform</em>.
|
|
You can set the scope for this method like this: <code>sql1-beta4 --scope <scope> instances insert ...</code></p>
|
|
<h1 id="required-scalar-argument">Required Scalar Argument</h1>
|
|
<ul>
|
|
<li><strong><project></strong> <em>(string)</em><ul>
|
|
<li>Project ID of the project to which the newly created Cloud SQL instances
|
|
should belong.</li>
|
|
</ul>
|
|
</li>
|
|
</ul>
|
|
<h1 id="required-request-value">Required Request Value</h1>
|
|
<p>The request value is a data-structure with various fields. Each field may be a simple scalar or another data-structure.
|
|
In the latter case it is advised to set the field-cursor to the data-structure's field to specify values more concisely.</p>
|
|
<p>For example, a structure like this:</p>
|
|
<pre><code>DatabaseInstance:
|
|
backend-type: string
|
|
connection-name: string
|
|
current-disk-size: string
|
|
database-version: string
|
|
disk-encryption-configuration:
|
|
kind: string
|
|
kms-key-name: string
|
|
disk-encryption-status:
|
|
kind: string
|
|
kms-key-version-name: string
|
|
etag: string
|
|
failover-replica:
|
|
available: boolean
|
|
name: string
|
|
gce-zone: string
|
|
instance-type: string
|
|
ipv6-address: string
|
|
kind: string
|
|
master-instance-name: string
|
|
max-disk-size: string
|
|
name: string
|
|
on-premises-configuration:
|
|
ca-certificate: string
|
|
client-certificate: string
|
|
client-key: string
|
|
dump-file-path: string
|
|
host-port: string
|
|
kind: string
|
|
password: string
|
|
username: string
|
|
project: string
|
|
region: string
|
|
replica-configuration:
|
|
failover-target: boolean
|
|
kind: string
|
|
mysql-replica-configuration:
|
|
ca-certificate: string
|
|
client-certificate: string
|
|
client-key: string
|
|
connect-retry-interval: integer
|
|
dump-file-path: string
|
|
kind: string
|
|
master-heartbeat-period: string
|
|
password: string
|
|
ssl-cipher: string
|
|
username: string
|
|
verify-server-certificate: boolean
|
|
replica-names: [string]
|
|
root-password: string
|
|
scheduled-maintenance:
|
|
can-defer: boolean
|
|
can-reschedule: boolean
|
|
start-time: string
|
|
self-link: string
|
|
server-ca-cert:
|
|
cert: string
|
|
cert-serial-number: string
|
|
common-name: string
|
|
create-time: string
|
|
expiration-time: string
|
|
instance: string
|
|
kind: string
|
|
self-link: string
|
|
sha1-fingerprint: string
|
|
service-account-email-address: string
|
|
settings:
|
|
activation-policy: string
|
|
authorized-gae-applications: [string]
|
|
availability-type: string
|
|
backup-configuration:
|
|
binary-log-enabled: boolean
|
|
enabled: boolean
|
|
kind: string
|
|
location: string
|
|
point-in-time-recovery-enabled: boolean
|
|
replication-log-archiving-enabled: boolean
|
|
start-time: string
|
|
crash-safe-replication-enabled: boolean
|
|
data-disk-size-gb: string
|
|
data-disk-type: string
|
|
database-replication-enabled: boolean
|
|
ip-configuration:
|
|
ipv4-enabled: boolean
|
|
private-network: string
|
|
require-ssl: boolean
|
|
kind: string
|
|
location-preference:
|
|
follow-gae-application: string
|
|
kind: string
|
|
zone: string
|
|
maintenance-window:
|
|
day: integer
|
|
hour: integer
|
|
kind: string
|
|
update-track: string
|
|
pricing-plan: string
|
|
replication-type: string
|
|
settings-version: string
|
|
storage-auto-resize: boolean
|
|
storage-auto-resize-limit: string
|
|
tier: string
|
|
user-labels: { string: string }
|
|
state: string
|
|
suspension-reason: [string]
|
|
|
|
</code></pre>
|
|
<p>can be set completely with the following arguments which are assumed to be executed in the given order. Note how the cursor position is adjusted to the respective structures, allowing simple field names to be used most of the time.</p>
|
|
<ul>
|
|
<li><code>-r . backend-type=accusam</code><ul>
|
|
<li><code>FIRST_GEN</code>: First Generation instance. MySQL only. <br
|
|
/><code>SECOND_GEN</code>: Second Generation instance or PostgreSQL
|
|
instance. <br /><code>EXTERNAL</code>: A database server that is not
|
|
managed by Google. <br>This property is read-only; use the
|
|
<code>tier</code> property in the <code>settings</code> object to determine
|
|
the database type and Second or First Generation.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>connection-name=voluptua.</code><ul>
|
|
<li>Connection name of the Cloud SQL instance used in connection strings.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>current-disk-size=dolore</code><ul>
|
|
<li>The current disk usage of the instance in bytes. This property has been
|
|
deprecated. Users should use the
|
|
"cloudsql.googleapis.com/database/disk/bytes_used" metric in Cloud
|
|
Monitoring API instead. Please see <a
|
|
href="https://groups.google.com/d/msg/google-cloud-sql-announce/I_7-F9EBhT0/BtvFtdFeAgAJ">this
|
|
announcement</a> for details.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>database-version=dolore</code><ul>
|
|
<li>The database engine type and version. The <code>databaseVersion</code>
|
|
field can not be changed after instance creation. MySQL Second Generation
|
|
instances: <code>MYSQL_5_7</code> (default) or <code>MYSQL_5_6</code>.
|
|
PostgreSQL instances: <code>POSTGRES_9_6</code> (default) or
|
|
<code>POSTGRES_11 Beta</code> MySQL First Generation
|
|
instances: <code>MYSQL_5_6</code> (default) or <code>MYSQL_5_5</code></li>
|
|
</ul>
|
|
</li>
|
|
<li><code>disk-encryption-configuration kind=dolore</code><ul>
|
|
<li>This is always <code>sql#diskEncryptionConfiguration</code>.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>kms-key-name=voluptua.</code></p>
|
|
<ul>
|
|
<li>Resource name of KMS key for disk encryption</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>..disk-encryption-status kind=amet.</code></p>
|
|
<ul>
|
|
<li>This is always <code>sql#diskEncryptionStatus</code>.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>kms-key-version-name=ea</code></p>
|
|
<ul>
|
|
<li>KMS key version used to encrypt the Cloud SQL instance resource</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>.. etag=sadipscing</code></p>
|
|
<ul>
|
|
<li>This field is deprecated and will be removed from a future version of the
|
|
API. Use the <code>settings.settingsVersion</code> field instead.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>failover-replica available=true</code><ul>
|
|
<li>The availability status of the failover replica. A false status indicates
|
|
that the failover replica is out of sync. The master can only failover to
|
|
the failover replica when the status is true.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>name=no</code></p>
|
|
<ul>
|
|
<li>The name of the failover replica. If specified at instance creation, a
|
|
failover replica is created for the instance. The name
|
|
doesn't include the project ID. This property is applicable only to
|
|
Second Generation instances.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>.. gce-zone=est</code></p>
|
|
<ul>
|
|
<li>The Compute Engine zone that the instance is currently serving from. This
|
|
value could be different from the zone that was specified when the instance
|
|
was created if the instance has failed over to its secondary zone.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>instance-type=at</code><ul>
|
|
<li>The instance type. This can be one of the following.
|
|
<br><code>CLOUD_SQL_INSTANCE</code>: A Cloud SQL instance that is not
|
|
replicating from a master. <br><code>ON_PREMISES_INSTANCE</code>: An
|
|
instance running on the
|
|
customer's premises. <br><code>READ_REPLICA_INSTANCE</code>: A Cloud SQL
|
|
instance configured as a read-replica.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>ipv6-address=sed</code><ul>
|
|
<li>The IPv6 address assigned to the instance. This property is applicable only
|
|
to First Generation instances.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>kind=sit</code><ul>
|
|
<li>This is always <code>sql#instance</code>.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>master-instance-name=et</code><ul>
|
|
<li>The name of the instance which will act as master in the replication setup.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>max-disk-size=tempor</code><ul>
|
|
<li>The maximum disk size of the instance in bytes.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>name=aliquyam</code><ul>
|
|
<li>Name of the Cloud SQL instance. This does not include the project ID.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>on-premises-configuration ca-certificate=ipsum</code><ul>
|
|
<li>PEM representation of the trusted CA's x509 certificate.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>client-certificate=et</code><ul>
|
|
<li>PEM representation of the slave's x509 certificate.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>client-key=sanctus</code><ul>
|
|
<li>PEM representation of the slave's private key. The corresponsing public key
|
|
is encoded in the client's certificate.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>dump-file-path=lorem</code><ul>
|
|
<li>The dump file to create the Cloud SQL replica.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>host-port=est</code><ul>
|
|
<li>The host and port of the on-premises instance in host:port format</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>kind=sed</code><ul>
|
|
<li>This is always <code>sql#onPremisesConfiguration</code>.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>password=diam</code><ul>
|
|
<li>The password for connecting to on-premises instance.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>username=dolores</code></p>
|
|
<ul>
|
|
<li>The username for connecting to on-premises instance.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>.. project=dolores</code></p>
|
|
<ul>
|
|
<li>The project ID of the project containing the Cloud SQL instance. The Google
|
|
apps domain is prefixed if applicable.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>region=et</code><ul>
|
|
<li>The geographical region. Can be <code>us-central</code>
|
|
(<code>FIRST_GEN</code> instances only), <code>us-central1</code>
|
|
(<code>SECOND_GEN</code> instances only), <code>asia-east1</code> or
|
|
<code>europe-west1</code>. Defaults to <code>us-central</code> or
|
|
<code>us-central1</code> depending on the instance type (First Generation
|
|
or Second Generation). The region can not be changed after instance
|
|
creation.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>replica-configuration failover-target=false</code><ul>
|
|
<li>Specifies if the replica is the failover target. If the field is set to
|
|
<code>true</code> the replica will be designated as a failover replica. In
|
|
case the master instance fails, the replica instance will be promoted as
|
|
the new master instance. <p>Only one replica can be specified as failover
|
|
target, and the replica has to be in different zone with the master
|
|
instance.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>kind=no</code><ul>
|
|
<li>This is always <code>sql#replicaConfiguration</code>.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>mysql-replica-configuration ca-certificate=et</code><ul>
|
|
<li>PEM representation of the trusted CA's x509 certificate.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>client-certificate=elitr</code><ul>
|
|
<li>PEM representation of the slave's x509 certificate.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>client-key=sed</code><ul>
|
|
<li>PEM representation of the slave's private key. The corresponsing public key
|
|
is encoded in the client's certificate.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>connect-retry-interval=40</code><ul>
|
|
<li>Seconds to wait between connect retries. MySQL's default is 60 seconds.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>dump-file-path=nonumy</code><ul>
|
|
<li>Path to a SQL dump file in Google Cloud Storage from which the slave
|
|
instance is to be created. The URI is in the form gs:
|
|
//bucketName/fileName. Compressed gzip files (.gz) are also supported.
|
|
// Dumps should have the binlog co-ordinates from which replication should
|
|
// begin. This can be accomplished by setting --master-data to 1 when using
|
|
// mysqldump.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>kind=at</code><ul>
|
|
<li>This is always <code>sql#mysqlReplicaConfiguration</code>.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>master-heartbeat-period=sadipscing</code><ul>
|
|
<li>Interval in milliseconds between replication heartbeats.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>password=aliquyam</code><ul>
|
|
<li>The password for the replication connection.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>ssl-cipher=dolores</code><ul>
|
|
<li>A list of permissible ciphers to use for SSL encryption.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>username=sadipscing</code><ul>
|
|
<li>The username for the replication connection.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>verify-server-certificate=false</code></p>
|
|
<ul>
|
|
<li>Whether or not to check the master's Common Name value in the certificate
|
|
that it sends during the SSL handshake.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>... replica-names=amet</code></p>
|
|
<ul>
|
|
<li>The replicas of the instance.</li>
|
|
<li>Each invocation of this argument appends the given value to the array.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>root-password=est</code><ul>
|
|
<li>Initial root password. Use only on creation.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>scheduled-maintenance can-defer=false</code><ul>
|
|
<li>No description provided.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>can-reschedule=true</code><ul>
|
|
<li>If the scheduled maintenance can be rescheduled.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>start-time=stet</code></p>
|
|
<ul>
|
|
<li>The start time of any upcoming scheduled maintenance for this instance.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>.. self-link=est</code></p>
|
|
<ul>
|
|
<li>The URI of this resource.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>server-ca-cert cert=aliquyam</code><ul>
|
|
<li>PEM representation.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>cert-serial-number=elitr</code><ul>
|
|
<li>Serial number, as extracted from the certificate.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>common-name=duo</code><ul>
|
|
<li>User supplied name. Constrained to [a-zA-Z.-_ ]+.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>create-time=diam</code><ul>
|
|
<li>The time when the certificate was created in <a
|
|
href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
|
|
<code>2012-11-15T16:19:00.094Z</code></li>
|
|
</ul>
|
|
</li>
|
|
<li><code>expiration-time=est</code><ul>
|
|
<li>The time when the certificate expires in <a
|
|
href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
|
|
<code>2012-11-15T16:19:00.094Z</code>.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>instance=sit</code><ul>
|
|
<li>Name of the database instance.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>kind=sed</code><ul>
|
|
<li>This is always <code>sql#sslCert</code>.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>self-link=eos</code><ul>
|
|
<li>The URI of this resource.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>sha1-fingerprint=lorem</code></p>
|
|
<ul>
|
|
<li>Sha1 Fingerprint.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>.. service-account-email-address=ea</code></p>
|
|
<ul>
|
|
<li>The service account email address assigned to the instance. This property
|
|
is applicable only to Second Generation instances.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>settings activation-policy=stet</code><ul>
|
|
<li>The activation policy specifies when the instance is activated; it is
|
|
applicable only when the instance state is <code>RUNNABLE</code>. Valid
|
|
values: <br><code>ALWAYS</code>: The instance is on, and remains so even in
|
|
the absence of connection requests. <br><code>NEVER</code>: The instance is
|
|
off; it is not activated, even if a connection request arrives.
|
|
<br><code>ON_DEMAND</code>: First Generation instances only. The instance
|
|
responds to incoming requests, and turns itself off when not in use.
|
|
Instances with <code>PER_USE</code> pricing turn off after 15 minutes of
|
|
inactivity. Instances with <code>PER_PACKAGE</code> pricing turn off after
|
|
12 hours of inactivity.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>authorized-gae-applications=dolores</code><ul>
|
|
<li>The App Engine app IDs that can access this instance. First Generation
|
|
instances only.</li>
|
|
<li>Each invocation of this argument appends the given value to the array.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>availability-type=eos</code><ul>
|
|
<li>Availability type (PostgreSQL and MySQL instances only). Potential values:
|
|
<br><code>ZONAL</code>: The instance serves data from only one zone.
|
|
Outages in that zone affect data accessibility. <br><code>REGIONAL</code>:
|
|
The instance can serve data from more than one zone in a region (it is
|
|
highly available). <br>For more information, see <a
|
|
href="https://cloud.google.com/sql/docs/postgres/high-availability">Overview
|
|
of the High Availability Configuration</a>.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>backup-configuration binary-log-enabled=true</code><ul>
|
|
<li>(MySQL only) Whether binary log is enabled. If backup configuration is
|
|
disabled, binarylog must be disabled as well.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>enabled=false</code><ul>
|
|
<li>Whether this configuration is enabled.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>kind=at</code><ul>
|
|
<li>This is always <code>sql#backupConfiguration</code>.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>location=dolore</code><ul>
|
|
<li>Location of the backup</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>point-in-time-recovery-enabled=true</code><ul>
|
|
<li>Reserved for future use.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>replication-log-archiving-enabled=true</code><ul>
|
|
<li>Reserved for future use.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>start-time=accusam</code></p>
|
|
<ul>
|
|
<li>Start time for the daily backup configuration in UTC timezone in the 24
|
|
hour format - <code>HH:MM</code>.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>.. crash-safe-replication-enabled=true</code></p>
|
|
<ul>
|
|
<li>Configuration specific to read replica instances. Indicates whether
|
|
database flags for crash-safe replication are enabled. This property is
|
|
only applicable to First Generation instances.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>data-disk-size-gb=erat</code><ul>
|
|
<li>The size of data disk, in GB. The data disk size minimum is 10GB. Not used
|
|
for First Generation instances.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>data-disk-type=dolores</code><ul>
|
|
<li>The type of data disk: <code>PD_SSD</code> (default) or
|
|
<code>PD_HDD</code>. Not used for First Generation instances.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>database-replication-enabled=false</code><ul>
|
|
<li>Configuration specific to read replica instances. Indicates whether
|
|
replication is enabled or not.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>ip-configuration ipv4-enabled=false</code><ul>
|
|
<li>Whether the instance should be assigned an IP address or not.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>private-network=sea</code><ul>
|
|
<li>The resource link for the VPC network from which the Cloud SQL instance is
|
|
accessible for private IP. For example,
|
|
<code>/projects/myProject/global/networks/default</code>. This setting can
|
|
be updated, but it cannot be removed after it is set.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>require-ssl=true</code></p>
|
|
<ul>
|
|
<li>Whether SSL connections over IP should be enforced or not.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>.. kind=lorem</code></p>
|
|
<ul>
|
|
<li>This is always <code>sql#settings</code>.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>location-preference follow-gae-application=et</code><ul>
|
|
<li>The AppEngine application to follow, it must be in the same region as the
|
|
Cloud SQL instance.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>kind=at</code><ul>
|
|
<li>This is always <code>sql#locationPreference</code>.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>zone=dolor</code></p>
|
|
<ul>
|
|
<li>The preferred Compute Engine zone (e.g. us-central1-a, us-central1-b,
|
|
etc.).</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>..maintenance-window day=79</code></p>
|
|
<ul>
|
|
<li>day of week (1-7), starting on Monday.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>hour=53</code><ul>
|
|
<li>hour of day - 0 to 23.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>kind=erat</code><ul>
|
|
<li>This is always <code>sql#maintenanceWindow</code>.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>update-track=sea</code></p>
|
|
<ul>
|
|
<li>Maintenance timing setting: <code>canary</code> (Earlier) or
|
|
<code>stable</code> (Later). <br /><a
|
|
href="/sql/docs/db_path/instance-settings#maintenance-timing-2ndgen">
|
|
Learn more</a>.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>.. pricing-plan=nonumy</code></p>
|
|
<ul>
|
|
<li>The pricing plan for this instance. This can be either <code>PER_USE</code>
|
|
or <code>PACKAGE</code>. Only <code>PER_USE</code> is supported for Second
|
|
Generation instances.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>replication-type=et</code><ul>
|
|
<li>The type of replication this instance uses. This can be either
|
|
<code>ASYNCHRONOUS</code> or <code>SYNCHRONOUS</code>. This property is
|
|
only applicable to First Generation instances.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>settings-version=gubergren</code><ul>
|
|
<li>The version of instance settings. This is a required field for update
|
|
method to make sure concurrent updates are handled properly. During update,
|
|
use the most recent settingsVersion value for this instance and do not try
|
|
to update this value.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>storage-auto-resize=true</code><ul>
|
|
<li>Configuration to increase storage size automatically. The default value is
|
|
true. Not used for First Generation instances.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>storage-auto-resize-limit=consetetur</code><ul>
|
|
<li>The maximum size to which storage capacity can be automatically increased.
|
|
The default value is 0, which specifies that there is no limit. Not used
|
|
for First Generation instances.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>tier=sit</code><ul>
|
|
<li>The tier (or machine type) for this instance, for example
|
|
<code>db-n1-standard-1</code> (MySQL instances) or
|
|
<code>db-custom-1-3840</code> (PostgreSQL instances). For MySQL instances,
|
|
this property determines whether the instance is First or Second
|
|
Generation. For more information, see <a
|
|
href="/sql/docs/db_path/instance-settings">Instance Settings</a>.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>user-labels=key=aliquyam</code></p>
|
|
<ul>
|
|
<li>User-provided labels, represented as a dictionary where each label is a
|
|
single key value pair.</li>
|
|
<li>the value will be associated with the given <code>key</code></li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><code>.. state=eos</code></p>
|
|
<ul>
|
|
<li>The current serving state of the Cloud SQL instance. This can be one of the
|
|
following. <br><code>RUNNABLE</code>: The instance is running, or is ready
|
|
to run when accessed. <br><code>SUSPENDED</code>: The instance is not
|
|
available, for example due to problems with billing.
|
|
<br><code>PENDING_CREATE</code>: The instance is being created.
|
|
<br><code>MAINTENANCE</code>: The instance is down for maintenance.
|
|
<br><code>FAILED</code>: The instance creation failed.
|
|
<br><code>UNKNOWN_STATE</code>: The state of the instance is unknown.</li>
|
|
</ul>
|
|
</li>
|
|
<li><code>suspension-reason=at</code><ul>
|
|
<li>If the instance state is SUSPENDED, the reason for the suspension.</li>
|
|
<li>Each invocation of this argument appends the given value to the array.</li>
|
|
</ul>
|
|
</li>
|
|
</ul>
|
|
<h3 id="about-cursors">About Cursors</h3>
|
|
<p>The cursor position is key to comfortably set complex nested structures. The following rules apply:</p>
|
|
<ul>
|
|
<li>The cursor position is always set relative to the current one, unless the field name starts with the <code>.</code> character. Fields can be nested such as in <code>-r f.s.o</code> .</li>
|
|
<li>The cursor position is set relative to the top-level structure if it starts with <code>.</code>, e.g. <code>-r .s.s</code></li>
|
|
<li>You can also set nested fields without setting the cursor explicitly. For example, to set a value relative to the current cursor position, you would specify <code>-r struct.sub_struct=bar</code>.</li>
|
|
<li>You can move the cursor one level up by using <code>..</code>. Each additional <code>.</code> moves it up one additional level. E.g. <code>...</code> would go three levels up.</li>
|
|
</ul>
|
|
<h1 id="optional-output-flags">Optional Output Flags</h1>
|
|
<p>The method's return value a JSON encoded structure, which will be written to standard output by default.</p>
|
|
<ul>
|
|
<li><strong>-o out</strong><ul>
|
|
<li><em>out</em> specifies the <em>destination</em> to which to write the server's result to.
|
|
It will be a JSON-encoded structure.
|
|
The <em>destination</em> may be <code>-</code> to indicate standard output, or a filepath that is to contain the received bytes.
|
|
If unset, it defaults to standard output.</li>
|
|
</ul>
|
|
</li>
|
|
</ul>
|
|
<h1 id="optional-general-properties">Optional General Properties</h1>
|
|
<p>The following properties can configure any call, and are not specific to this method.</p>
|
|
<ul>
|
|
<li>
|
|
<p><strong>-p $-xgafv=string</strong></p>
|
|
<ul>
|
|
<li>V1 error format.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><strong>-p access-token=string</strong></p>
|
|
<ul>
|
|
<li>OAuth access token.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><strong>-p alt=string</strong></p>
|
|
<ul>
|
|
<li>Data format for response.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><strong>-p callback=string</strong></p>
|
|
<ul>
|
|
<li>JSONP</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><strong>-p fields=string</strong></p>
|
|
<ul>
|
|
<li>Selector specifying which fields to include in a partial response.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><strong>-p key=string</strong></p>
|
|
<ul>
|
|
<li>API key. Your API key identifies your project and provides you with API access, quota, and reports. Required unless you provide an OAuth 2.0 token.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><strong>-p oauth-token=string</strong></p>
|
|
<ul>
|
|
<li>OAuth 2.0 token for the current user.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><strong>-p pretty-print=boolean</strong></p>
|
|
<ul>
|
|
<li>Returns response with indentations and line breaks.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><strong>-p quota-user=string</strong></p>
|
|
<ul>
|
|
<li>Available to use for quota purposes for server-side applications. Can be any arbitrary string assigned to a user, but should not exceed 40 characters.</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><strong>-p upload-type=string</strong></p>
|
|
<ul>
|
|
<li>Legacy upload protocol for media (e.g. "media", "multipart").</li>
|
|
</ul>
|
|
</li>
|
|
<li>
|
|
<p><strong>-p upload-protocol=string</strong></p>
|
|
<ul>
|
|
<li>Upload protocol for media (e.g. "raw", "multipart").</li>
|
|
</ul>
|
|
</li>
|
|
</ul>
|
|
|
|
</div>
|
|
</div><footer>
|
|
<div class="rst-footer-buttons" role="navigation" aria-label="Footer Navigation">
|
|
<a href="../instances_import/" class="btn btn-neutral float-left" title="Import"><span class="icon icon-circle-arrow-left"></span> Previous</a>
|
|
<a href="../instances_list/" class="btn btn-neutral float-right" title="List">Next <span class="icon icon-circle-arrow-right"></span></a>
|
|
</div>
|
|
|
|
<hr/>
|
|
|
|
<div role="contentinfo">
|
|
<!-- Copyright etc -->
|
|
<p>Copyright © 2015-2020, `Sebastian Thiel`</p>
|
|
</div>
|
|
|
|
Built with <a href="https://www.mkdocs.org/">MkDocs</a> using a <a href="https://github.com/readthedocs/sphinx_rtd_theme">theme</a> provided by <a href="https://readthedocs.org">Read the Docs</a>.
|
|
</footer>
|
|
|
|
</div>
|
|
</div>
|
|
|
|
</section>
|
|
|
|
</div>
|
|
|
|
<div class="rst-versions" role="note" aria-label="Versions">
|
|
<span class="rst-current-version" data-toggle="rst-current-version">
|
|
|
|
<span>
|
|
<a href="https://github.com/Byron/google-apis-rs/tree/main/gen/sql1_beta4-cli" class="fa fa-github" style="color: #fcfcfc"> GitHub</a>
|
|
</span>
|
|
|
|
|
|
<span><a href="../instances_import/" style="color: #fcfcfc">« Previous</a></span>
|
|
|
|
|
|
<span><a href="../instances_list/" style="color: #fcfcfc">Next »</a></span>
|
|
|
|
</span>
|
|
</div>
|
|
<script>var base_url = '..';</script>
|
|
<script src="../js/theme_extra.js" defer></script>
|
|
<script src="../js/theme.js" defer></script>
|
|
<script src="../search/main.js" defer></script>
|
|
<script defer>
|
|
window.onload = function () {
|
|
SphinxRtdTheme.Navigation.enable(true);
|
|
};
|
|
</script>
|
|
|
|
</body>
|
|
</html>
|