Chapter 15. Database service command-line client

Subcommands

backup-copy

Creates a backup from another backup.

backup-create

Creates a backup of an instance.

backup-delete

Deletes a backup.

backup-list

Lists available backups.

backup-list-instance

Lists available backups for an instance.

backup-show

Shows details of a backup.

cluster-create

Creates a new cluster.

cluster-delete

Deletes a cluster.

cluster-grow

Adds more instances to a cluster.

cluster-instances

Lists all instances of a cluster.

cluster-list

Lists all the clusters.

cluster-show

Shows details of a cluster.

cluster-shrink

Drops instances from a cluster.

configuration-attach

Attaches a configuration group to an instance.

configuration-create

Creates a configuration group.

configuration-default

Shows the default configuration of an instance.

configuration-delete

Deletes a configuration group.

configuration-detach

Detaches a configuration group from an instance.

configuration-instances

Lists all instances associated with a configuration group.

configuration-list

Lists all configuration groups.

configuration-parameter-list

Lists available parameters for a configuration group.

configuration-parameter-show

Shows details of a configuration parameter.

configuration-patch

Patches a configuration group.

configuration-show

Shows details of a configuration group.

configuration-update

Updates a configuration group.

create

Creates a new instance.

database-create

Creates a database on an instance.

database-delete

Deletes a database from an instance.

database-list

Lists available databases on an instance.

datastore-list

Lists available datastores.

datastore-show

Shows details of a datastore.

datastore-version-list

Lists available versions for a datastore.

datastore-version-show

Shows details of a datastore version.

delete

Deletes an instance.

detach-replica

Detaches a replica instance from its replication source.

eject-replica-source

Ejects a replica source from its set.

flavor-list

Lists available flavors.

flavor-show

Shows details of a flavor.

limit-list

Lists the limits for a tenant.

list

Lists all the instances.

metadata-create

Creates metadata in the database for instance <id>.

metadata-delete

Deletes metadata for instance <id>.

metadata-edit

Replaces metadata value with a new one, this is non-destructive.

metadata-list

Shows all metadata for instance <id>.

metadata-show

Shows metadata entry for key <key> and instance <id>.

metadata-update

Updates metadata, this is destructive.

promote-to-replica-source

Promotes a replica to be the new replica source of its set.

resize-instance

Resizes an instance with a new flavor.

resize-volume

Resizes the volume size of an instance.

restart

Restarts an instance.

root-enable

Enables root for an instance and resets if already exists.

root-show

Gets status if root was ever enabled for an instance or cluster.

secgroup-add-rule

Creates a security group rule.

secgroup-delete-rule

Deletes a security group rule.

secgroup-list

Lists all security groups.

secgroup-list-rules

Lists all rules for a security group.

secgroup-show

Shows details of a security group.

show

Shows details of an instance.

update

Updates an instance: Edits name, configuration, or replica source.

user-create

Creates a user on an instance.

user-delete

Deletes a user from an instance.

user-grant-access

Grants access to a database(s) for a user.

user-list

Lists the users for an instance.

user-revoke-access

Revokes access to a database for a user.

user-show

Shows details of a user of an instance.

user-show-access

Shows access details of a user of an instance.

user-update-attributes

Updates a user's attributes on an instance.

bash-completion

Prints arguments for bash_completion.

help

Displays help about this program or one of its subcommands.

--version

show program's version number and exit

--debug

Print debugging output.

--os-auth-system <auth-system>

Defaults to env[OS_AUTH_SYSTEM].

--service-type <service-type>

Defaults to database for most actions.

--service-name <service-name>

Defaults to env[TROVE_SERVICE_NAME].

--bypass-url <bypass-url>

Defaults to env[TROVE_BYPASS_URL].

--database-service-name <database-service-name>

Defaults to env[TROVE_DATABASE_SERVICE_NAME].

--endpoint-type <endpoint-type>

Defaults to env[TROVE_ENDPOINT_TYPE] or publicURL.

--os-database-api-version <database-api-ver>

Accepts 1, defaults to env[OS_DATABASE_API_VERSION].

--retries <retries>

Number of retries.

--json, --os-json-output

Output JSON instead of prettyprint. Defaults to env[OS_JSON_OUTPUT].

--profile HMAC_KEY

HMAC key used to encrypt context data when profiling the performance of an operation. This key should be set to one of the HMAC keys configured in Trove (they are found in api-paste.ini, typically in /etc/trove). Without the key, profiling will not be triggered even if it is enabled on the server side. Defaults to env[OS_PROFILE_HMACKEY].

--insecure

Explicitly allow client to perform "insecure" TLS (https) requests. The server's certificate will not be verified against any certificate authorities. This option should be used with caution.

--os-cacert <ca-certificate>

Specify a CA bundle file to use in verifying a TLS (https) server certificate. Defaults to env[OS_CACERT].

--os-cert <certificate>

Defaults to env[OS_CERT].

--os-key <key>

Defaults to env[OS_KEY].

--timeout <seconds>

Set request timeout (in seconds).

--os-auth-url OS_AUTH_URL

Authentication URL

--os-domain-id OS_DOMAIN_ID

Domain ID to scope to

--os-domain-name OS_DOMAIN_NAME

Domain name to scope to

--os-project-id OS_PROJECT_ID

Project ID to scope to

--os-project-name OS_PROJECT_NAME

Project name to scope to

--os-project-domain-id OS_PROJECT_DOMAIN_ID

Domain ID containing project

--os-project-domain-name OS_PROJECT_DOMAIN_NAME

Domain name containing project

--os-trust-id OS_TRUST_ID

Trust ID

--os-user-id OS_USER_ID

User ID

--os-user-name OS_USERNAME, --os-username OS_USERNAME

Username

--os-user-domain-id OS_USER_DOMAIN_ID

User's domain id

--os-user-domain-name OS_USER_DOMAIN_NAME

User's domain name

--os-password OS_PASSWORD

User's password

--os-tenant-name <auth-tenant-name>

Tenant to request authorization on. Defaults to env[OS_TENANT_NAME].

--os-tenant-id <tenant-id>

Tenant to request authorization on. Defaults to env[OS_TENANT_ID].

--os-auth-token OS_AUTH_TOKEN

Defaults to env[OS_AUTH_TOKEN]

--os-region-name <region-name>

Specify the region to use. Defaults to env[OS_REGION_NAME].

Positional arguments

<name>

Name of the backup.

<backup>

Backup ID of the source backup.

Optional arguments

--region <region>

Region where the source backup resides.

--description <description>

An optional description for the backup.

Positional arguments

<instance>

ID or name of the instance.

<name>

Name of the backup.

Optional arguments

--description <description>

An optional description for the backup.

--parent <parent>

Optional ID of the parent backup to perform an incremental backup from.

Positional arguments

<backup>

ID of the backup.

Optional arguments

--limit <limit>

Return up to N number of the most recent backups.

--marker <ID>

Begin displaying the results for IDs greater than the specified marker. When used with --limit, set this to the last ID displayed in the previous run.

--datastore <datastore>

Name or ID of the datastore to list backups for.

Positional arguments

<instance>

ID or name of the instance.

Optional arguments

--limit <limit>

Return up to N number of the most recent backups.

--marker <ID>

Begin displaying the results for IDs greater than the specified marker. When used with --limit, set this to the last ID displayed in the previous run.

Positional arguments

<backup>

ID of the backup.

Positional arguments

<name>

Name of the cluster.

<datastore>

A datastore name or UUID.

<datastore_version>

A datastore version name or UUID.

Optional arguments

--instance <flavor=flavor_name_or_id,volume=volume>

Create an instance for the cluster. Specify multiple times to create multiple instances.

Positional arguments

<cluster>

ID or name of the cluster.

Positional arguments

<cluster>

ID or name of the cluster.

Optional arguments

--instance <name=name,flavor=flavor_name_or_id,volume=volume>

Add an instance to the cluster. Specify multiple times to create multiple instances.

Positional arguments

<cluster>

ID or name of the cluster.

Optional arguments

--limit <limit>

Limit the number of results displayed.

--marker <ID>

Begin displaying the results for IDs greater than the specified marker. When used with --limit, set this to the last ID displayed in the previous run.

Positional arguments

<cluster>

ID or name of the cluster.

Positional arguments

<cluster>

ID or name of the cluster.

<instance>

Drop instance(s) from the cluster. Specify multiple ids to drop multiple instances.

Positional arguments

<instance>

ID or name of the instance.

<configuration>

ID of the configuration group to attach to the instance.

Positional arguments

<name>

Name of the configuration group.

<values>

Dictionary of the values to set.

Optional arguments

--datastore <datastore>

Datastore assigned to the configuration group. Required if default datastore is not configured.

--datastore_version <datastore_version>

Datastore version ID assigned to the configuration group.

--description <description>

An optional description for the configuration group.

Positional arguments

<instance>

ID or name of the instance.

Positional arguments

<configuration_group>

ID of the configuration group.

Positional arguments

<instance>

ID or name of the instance.

Positional arguments

<configuration_group>

ID of the configuration group.

Positional arguments

<datastore_version>

Datastore version name or ID assigned to the configuration group.

Optional arguments

--datastore <datastore>

ID or name of the datastore to list configuration parameters for. Optional if the ID of the datastore_version is provided.

Positional arguments

<datastore_version>

Datastore version name or ID assigned to the configuration group.

<parameter>

Name of the configuration parameter.

Optional arguments

--datastore <datastore>

ID or name of the datastore to list configuration parameters for. Optional if the ID of the datastore_version is provided.

Positional arguments

<configuration_group>

ID of the configuration group.

<values>

Dictionary of the values to set.

Positional arguments

<configuration_group>

ID of the configuration group.

Positional arguments

<configuration_group>

ID of the configuration group.

<values>

Dictionary of the values to set.

Optional arguments

--name <name>

Name of the configuration group.

--description <description>

An optional description for the configuration group.

Positional arguments

<name>

Name of the instance.

<flavor>

Flavor ID or name of the instance.

Optional arguments

--size <size>

Size of the instance disk volume in GB. Required when volume support is enabled.

--databases <databases> [<databases> ...]

Optional list of databases.

--users <users> [<users> ...]

Optional list of users in the form user:password.

--backup <backup>

A backup ID.

--availability_zone <availability_zone>

The Zone hint to give to nova.

--datastore <datastore>

A datastore name or ID.

--datastore_version <datastore_version>

A datastore version name or ID.

--nic <net-id=net-uuid,v4-fixed-ip=ip-addr,port-id=port-uuid>

Create a NIC on the instance. Specify option multiple times to create multiple NICs. net- id: attach NIC to network with this ID (either port-id or net-id must be specified), v4-fixed-ip: IPv4 fixed address for NIC (optional), port-id: attach NIC to port with this ID (either port-id or net-id must be specified).

--configuration <configuration>

ID of the configuration group to attach to the instance.

--replica_of <source_instance>

ID or name of an existing instance to replicate from.

--replica_count <count>

Number of replicas to create (defaults to 1).

Positional arguments

<instance>

ID or name of the instance.

<name>

Name of the database.

Optional arguments

--character_set <character_set>

Optional character set for database.

--collate <collate>

Optional collation type for database.

Positional arguments

<instance>

ID or name of the instance.

<database>

Name of the database.

Positional arguments

<instance>

ID or name of the instance.

Positional arguments

<datastore>

ID of the datastore.

Positional arguments

<datastore>

ID or name of the datastore.

Positional arguments

<datastore_version>

ID or name of the datastore version.

Optional arguments

--datastore <datastore>

ID or name of the datastore. Optional if the ID of the datastore_version is provided.

Positional arguments

<instance>

ID or name of the instance.

Positional arguments

<instance>

ID or name of the instance.

Positional arguments

<instance>

ID or name of the instance.

Optional arguments

--datastore_type <datastore_type>

Type of the datastore. For eg: mysql.

--datastore_version_id <datastore_version_id>

ID of the datastore version.

Positional arguments

<flavor>

ID or name of the flavor.

Optional arguments

--limit <limit>

Limit the number of results displayed.

--marker <ID>

Begin displaying the results for IDs greater than the specified marker. When used with --limit, set this to the last ID displayed in the previous run.

--include-clustered

Include instances that are part of a cluster (default false).

Positional arguments

<instance_id>

UUID for instance.

<key>

Key for assignment.

<value>

Value to assign to <key>.

Positional arguments

<instance_id>

UUID for instance.

<key>

Metadata key to delete.

Positional arguments

<instance_id>

UUID for instance.

<key>

Key to replace.

<value>

New value to assign to <key>.

Positional arguments

<instance_id>

UUID for instance.

Positional arguments

<instance_id>

UUID for instance.

<key>

Key to display.

Positional arguments

<instance_id>

UUID for instance.

<key>

Key to update.

<newkey>

New key.

<value>

Value to assign to <newkey>.

Positional arguments

<instance>

ID or name of the instance.

Positional arguments

<instance>

ID or name of the instance.

<flavor>

New flavor of the instance.

Positional arguments

<instance>

ID or name of the instance.

<size>

New size of the instance disk volume in GB.

Positional arguments

<instance>

ID or name of the instance.

Positional arguments

<instance_or_cluster>

ID or name of the instance or cluster.

Optional arguments

--root_password <root_password>

Root password to set.

Positional arguments

<instance_or_cluster>

ID or name of the instance or cluster.

Positional arguments

<security_group>

Security group ID.

<cidr>

CIDR address.

Positional arguments

<security_group_rule>

Name of security group rule.

Positional arguments

<security_group>

Security group ID.

Positional arguments

<security_group>

Security group ID.

Positional arguments

<instance>

ID or name of the instance.

Positional arguments

<instance>

ID or name of the instance.

Optional arguments

--name <name>

Name of the instance.

--configuration <configuration>

ID of the configuration reference to attach.

--detach-replica-source

Detach the replica instance from its replication source.

--remove_configuration

Drops the current configuration reference.

Positional arguments

<instance>

ID or name of the instance.

<name>

Name of user.

<password>

Password of user.

Optional arguments

--host <host>

Optional host of user.

--databases <databases> [<databases> ...]

Optional list of databases.

Positional arguments

<instance>

ID or name of the instance.

<name>

Name of user.

Optional arguments

--host <host>

Optional host of user.

Positional arguments

<instance>

ID or name of the instance.

<name>

Name of user.

<databases>

List of databases.

Optional arguments

--host <host>

Optional host of user.

Positional arguments

<instance>

ID or name of the instance.

Positional arguments

<instance>

ID or name of the instance.

<name>

Name of user.

<database>

A single database.

Optional arguments

--host <host>

Optional host of user.

Positional arguments

<instance>

ID or name of the instance.

<name>

Name of user.

Optional arguments

--host <host>

Optional host of user.

Positional arguments

<instance>

ID or name of the instance.

<name>

Name of user.

Optional arguments

--host <host>

Optional host of user.

Positional arguments

<instance>

ID or name of the instance.

<name>

Name of user.

Optional arguments

--host <host>

Optional host of user.

--new_name <new_name>

Optional new name of user.

--new_password <new_password>

Optional new password of user.

--new_host <new_host>

Optional new host of user.