The trove client is the command-line interface (CLI) for the Database service API and its extensions.
This chapter documents trove version 2.5.0
.
For help on a specific trove command, enter:
$ trove help COMMAND
usage: trove [--version] [--debug] [--service-type <service-type>]
[--service-name <service-name>] [--bypass-url <bypass-url>]
[--database-service-name <database-service-name>]
[--endpoint-type <endpoint-type>]
[--os-database-api-version <database-api-ver>]
[--retries <retries>] [--json] [--profile HMAC_KEY] [--insecure]
[--os-cacert <ca-certificate>] [--os-cert <certificate>]
[--os-key <key>] [--timeout <seconds>] [--os-auth-type <name>]
[--os-auth-url OS_AUTH_URL] [--os-domain-id OS_DOMAIN_ID]
[--os-domain-name OS_DOMAIN_NAME] [--os-project-id OS_PROJECT_ID]
[--os-project-name OS_PROJECT_NAME]
[--os-project-domain-id OS_PROJECT_DOMAIN_ID]
[--os-project-domain-name OS_PROJECT_DOMAIN_NAME]
[--os-trust-id OS_TRUST_ID]
[--os-default-domain-id OS_DEFAULT_DOMAIN_ID]
[--os-default-domain-name OS_DEFAULT_DOMAIN_NAME]
[--os-user-id OS_USER_ID] [--os-username OS_USERNAME]
[--os-user-domain-id OS_USER_DOMAIN_ID]
[--os-user-domain-name OS_USER_DOMAIN_NAME]
[--os-password OS_PASSWORD] [--os-region-name <region-name>]
<subcommand> ...
Subcommands:
backup-copy
backup-create
backup-delete
backup-list
backup-list-instance
backup-show
cluster-create
cluster-delete
cluster-force-delete
cluster-grow
cluster-instances
cluster-list
cluster-modules
cluster-reset-status
cluster-show
cluster-shrink
configuration-attach
configuration-create
configuration-default
configuration-delete
configuration-detach
configuration-instances
configuration-list
configuration-parameter-list
configuration-parameter-show
configuration-patch
configuration-show
configuration-update
create
database-create
database-delete
database-list
datastore-list
datastore-show
datastore-version-list
datastore-version-show
delete
detach-replica
eject-replica-source
execution-delete
execution-list
flavor-list
flavor-show
force-delete
limit-list
list
log-disable
log-discard
log-enable
log-list
log-publish
log-save
log-show
log-tail
metadata-create
metadata-delete
metadata-edit
metadata-list
metadata-show
metadata-update
module-apply
module-create
module-delete
module-instances
module-list
module-list-instance
module-query
module-remove
module-retrieve
module-show
module-update
promote-to-replica-source
quota-show
quota-update
reset-status
resize-instance
resize-volume
restart
root-disable
root-enable
root-show
schedule-create
schedule-delete
schedule-list
schedule-show
secgroup-add-rule
secgroup-delete-rule
secgroup-list
secgroup-list-rules
secgroup-show
show
update
upgrade
user-create
user-delete
user-grant-access
user-list
user-revoke-access
user-show
user-show-access
user-update-attributes
bash-completion
help
--version
--debug
--service-type <service-type>
--service-name <service-name>
env[TROVE_SERVICE_NAME]
.--bypass-url <bypass-url>
env[TROVE_BYPASS_URL]
.--database-service-name <database-service-name>
env[TROVE_DATABASE_SERVICE_NAME]
.--endpoint-type <endpoint-type>
env[TROVE_ENDPOINT_TYPE]
or
env[OS_ENDPOINT_TYPE]
or publicURL.--os-database-api-version <database-api-ver>
env[OS_DATABASE_API_VERSION]
.--retries <retries>
--json, --os-json-output
env[OS_JSON_OUTPUT]
.--profile HMAC_KEY
env[OS_PROFILE_HMACKEY]
.--os-auth-type <name>, --os-auth-plugin <name>
--os-region-name <region-name>
env[OS_REGION_NAME]
.usage: trove backup-copy <name> <backup>
[--region <region>] [--description <description>]
Creates a backup from another backup.
Positional arguments:
<name>
<backup>
Optional arguments:
--region <region>
--description <description>
usage: trove backup-create <instance> <name>
[--description <description>] [--parent <parent>]
[--incremental]
Creates a backup of an instance.
Positional arguments:
<instance>
<name>
Optional arguments:
--description <description>
--parent <parent>
--incremental
usage: trove backup-delete <backup>
Deletes a backup.
Positional arguments:
<backup>
usage: trove backup-list [--limit <limit>] [--marker <ID>]
[--datastore <datastore>]
Lists available backups.
Optional arguments:
--limit <limit>
--marker <ID>
--limit,
set
this to the last ID displayed in the previous run.--datastore <datastore>
usage: trove backup-list-instance [--limit <limit>] [--marker <ID>] <instance>
Lists available backups for an instance.
Positional arguments:
<instance>
Optional arguments:
--limit <limit>
--marker <ID>
--limit,
set this to the
last ID displayed in the previous run.usage: trove backup-show <backup>
Shows details of a backup.
Positional arguments:
<backup>
usage: trove cluster-create <name> <datastore> <datastore_version>
[--instance "opt=<value>[,opt=<value> ...] "]
[--locality <policy>]
Creates a new cluster.
Positional arguments:
<name>
<datastore>
<datastore_version>
Optional arguments:
--instance "opt=<value>[,opt=<value> ...] "
--locality <policy>
usage: trove cluster-delete <cluster>
Deletes a cluster.
Positional arguments:
<cluster>
usage: trove cluster-force-delete <cluster>
Force delete a cluster
Positional arguments:
<cluster>
usage: trove cluster-grow <cluster>
[--instance "opt=<value>[,opt=<value> ...] "]
Adds more instances to a cluster.
Positional arguments:
<cluster>
Optional arguments:
--instance "opt=<value>[,opt=<value> ...] "
usage: trove cluster-instances <cluster>
Lists all instances of a cluster.
Positional arguments:
<cluster>
usage: trove cluster-list [--limit <limit>] [--marker <ID>]
Lists all the clusters.
Optional arguments:
--limit <limit>
--marker <ID>
--limit,
set this to the
last ID displayed in the previous run.usage: trove cluster-modules <cluster>
Lists all modules for each instance of a cluster.
Positional arguments:
<cluster>
usage: trove cluster-reset-status <cluster>
Set the cluster task to NONE.
Positional arguments:
<cluster>
usage: trove cluster-show <cluster>
Shows details of a cluster.
Positional arguments:
<cluster>
usage: trove cluster-shrink <cluster> <instance> [<instance> ...]
Drops instances from a cluster.
Positional arguments:
<cluster>
<instance>
usage: trove configuration-attach <instance> <configuration>
Attaches a configuration group to an instance.
Positional arguments:
<instance>
<configuration>
usage: trove configuration-create <name> <values>
[--datastore <datastore>]
[--datastore_version <datastore_version>]
[--description <description>]
Creates a configuration group.
Positional arguments:
<name>
<values>
Optional arguments:
--datastore <datastore>
--datastore_version <datastore_version>
--description <description>
usage: trove configuration-default <instance>
Shows the default configuration of an instance.
Positional arguments:
<instance>
usage: trove configuration-delete <configuration_group>
Deletes a configuration group.
Positional arguments:
<configuration_group>
usage: trove configuration-detach <instance>
Detaches a configuration group from an instance.
Positional arguments:
<instance>
usage: trove configuration-instances <configuration_group>
Lists all instances associated with a configuration group.
Positional arguments:
<configuration_group>
usage: trove configuration-parameter-list <datastore_version>
[--datastore <datastore>]
Lists available parameters for a configuration group.
Positional arguments:
<datastore_version>
Optional arguments:
--datastore <datastore>
usage: trove configuration-parameter-show <datastore_version> <parameter>
[--datastore <datastore>]
Shows details of a configuration parameter.
Positional arguments:
<datastore_version>
<parameter>
Optional arguments:
--datastore <datastore>
usage: trove configuration-patch <configuration_group> <values>
Patches a configuration group.
Positional arguments:
<configuration_group>
<values>
usage: trove configuration-show <configuration_group>
Shows details of a configuration group.
Positional arguments:
<configuration_group>
usage: trove configuration-update <configuration_group> <values>
[--name <name>]
[--description <description>]
Updates a configuration group.
Positional arguments:
<configuration_group>
<values>
Optional arguments:
--name <name>
--description <description>
usage: trove create <name> <flavor>
[--size <size>] [--volume_type <volume_type>]
[--databases <database> [<database> ...]]
[--users <user:password> [<user:password> ...]]
[--backup <backup>]
[--availability_zone <availability_zone>]
[--datastore <datastore>]
[--datastore_version <datastore_version>]
[--nic <net-id=<net-uuid>,v4-fixed-ip=<ip-addr>,port-id=<port-uuid>>]
[--configuration <configuration>]
[--replica_of <source_instance>] [--replica_count <count>]
[--module <module>] [--locality <policy>]
Creates a new instance.
Positional arguments:
<name>
<flavor>
Optional arguments:
--size <size>
--volume_type <volume_type>
--databases <database> [<database> ...]
--users <user:password> [<user:password> ...]
--backup <backup>
--availability_zone <availability_zone>
--datastore <datastore>
--datastore_version <datastore_version>
--nic <net-id=<net-uuid>,v4-fixed-ip=<ip-addr>,port-id=<port-uuid>>
--configuration <configuration>
--replica_of <source_instance>
--replica_count <count>
--module <module>
--locality <policy>
usage: trove database-create <instance> <name>
[--character_set <character_set>]
[--collate <collate>]
Creates a database on an instance.
Positional arguments:
<instance>
<name>
Optional arguments:
--character_set <character_set>
--collate <collate>
usage: trove database-delete <instance> <database>
Deletes a database from an instance.
Positional arguments:
<instance>
<database>
usage: trove database-list <instance>
Lists available databases on an instance.
Positional arguments:
<instance>
usage: trove datastore-show <datastore>
Shows details of a datastore.
Positional arguments:
<datastore>
usage: trove datastore-version-list <datastore>
Lists available versions for a datastore.
Positional arguments:
<datastore>
usage: trove datastore-version-show <datastore_version>
[--datastore <datastore>]
Shows details of a datastore version.
Positional arguments:
<datastore_version>
Optional arguments:
--datastore <datastore>
usage: trove delete <instance>
Deletes an instance.
Positional arguments:
<instance>
usage: trove detach-replica <instance>
Detaches a replica instance from its replication source.
Positional arguments:
<instance>
usage: trove eject-replica-source <instance>
Ejects a replica source from its set.
Positional arguments:
<instance>
usage: trove execution-delete <execution>
Deletes an execution.
Positional arguments:
<execution>
usage: trove execution-list [--limit <limit>] [--marker <ID>] <schedule id>
Lists executions of a scheduled backup of an instance.
Positional arguments:
<schedule id>
Optional arguments:
--limit <limit>
--marker <ID>
--limit,
set this to the
last ID displayed in the previous run.usage: trove flavor-list [--datastore_type <datastore_type>]
[--datastore_version_id <datastore_version_id>]
Lists available flavors.
Optional arguments:
--datastore_type <datastore_type>
--datastore_version_id <datastore_version_id>
usage: trove flavor-show <flavor>
Shows details of a flavor.
Positional arguments:
<flavor>
usage: trove force-delete <instance>
Force delete an instance.
Positional arguments:
<instance>
usage: trove list [--limit <limit>] [--marker <ID>] [--include_clustered]
Lists all the instances.
Optional arguments:
--limit <limit>
--marker <ID>
--limit,
set this to the last ID displayed
in the previous run.--include_clustered, --include-clustered
--include-clustered
may be
deprecated in the future, retaining just
--include_clustered
.usage: trove log-disable [--discard] <instance> <log_name>
Instructs Trove guest to stop collecting log details.
Positional arguments:
<instance>
<log_name>
Optional arguments:
--discard
usage: trove log-discard <instance> <log_name>
Instructs Trove guest to discard the container of the published log.
Positional arguments:
<instance>
<log_name>
usage: trove log-enable <instance> <log_name>
Instructs Trove guest to start collecting log details.
Positional arguments:
<instance>
<log_name>
usage: trove log-list <instance>
Lists the log files available for instance.
Positional arguments:
<instance>
usage: trove log-publish [--disable] [--discard] <instance> <log_name>
Instructs Trove guest to publish latest log entries on instance.
Positional arguments:
<instance>
<log_name>
Optional arguments:
--disable
--discard
usage: trove log-save [--publish] [--file <file>] <instance> <log_name>
Save log file for instance.
Positional arguments:
<instance>
<log_name>
Optional arguments:
--publish
--file <file>
usage: trove log-show <instance> <log_name>
Instructs Trove guest to show details of log.
Positional arguments:
<instance>
<log_name>
usage: trove log-tail [--publish] [--lines <lines>] <instance> <log_name>
Display log entries for instance.
Positional arguments:
<instance>
<log_name>
Optional arguments:
--publish
--lines <lines>
usage: trove metadata-create <instance_id> <key> <value>
Creates metadata in the database for instance <id>.
Positional arguments:
<instance_id>
<key>
<value>
usage: trove metadata-delete <instance_id> <key>
Deletes metadata for instance <id>.
Positional arguments:
<instance_id>
<key>
usage: trove metadata-edit <instance_id> <key> <value>
Replaces metadata value with a new one, this is non-destructive.
Positional arguments:
<instance_id>
<key>
<value>
usage: trove metadata-list <instance_id>
Shows all metadata for instance <id>.
Positional arguments:
<instance_id>
usage: trove metadata-show <instance_id> <key>
Shows metadata entry for key <key> and instance <id>.
Positional arguments:
<instance_id>
<key>
usage: trove metadata-update <instance_id> <key> <newkey> <value>
Updates metadata, this is destructive.
Positional arguments:
<instance_id>
<key>
<newkey>
<value>
usage: trove module-apply <instance> <module> [<module> ...]
Apply modules to an instance.
Positional arguments:
<instance>
<module>
usage: trove module-create <name> <type> <filename>
[--description <description>]
[--datastore <datastore>]
[--datastore_version <version>] [--auto_apply]
[--all_tenants] [--hidden] [--live_update]
[--priority_apply]
[--apply_order {0,1,2,3,4,5,6,7,8,9}]
[--full_access]
Create a module.
Positional arguments:
<name>
<type>
<filename>
Optional arguments:
--description <description>
--datastore <datastore>
--datastore_version <version>
--auto_apply
--all_tenants
--hidden
--live_update
--priority_apply
--apply_order {0,1,2,3,4,5,6,7,8,9}
--full_access
usage: trove module-delete <module>
Delete a module.
Positional arguments:
<module>
usage: trove module-instances <module>
[--include_clustered] [--limit <limit>]
[--marker <ID>]
Lists the instances that have a particular module applied.
Positional arguments:
<module>
Optional arguments:
--include_clustered
--limit <limit>
--marker <ID>
--limit,
set this to
the last ID displayed in the previous run.usage: trove module-list [--datastore <datastore>]
Lists the modules available.
Optional arguments:
--datastore <datastore>
usage: trove module-list-instance <instance>
Lists the modules that have been applied to an instance.
Positional arguments:
<instance>
usage: trove module-query <instance>
Query the status of the modules on an instance.
Positional arguments:
<instance>
usage: trove module-remove <instance> <module>
Remove a module from an instance.
Positional arguments:
<instance>
<module>
usage: trove module-retrieve <instance>
[--directory <directory>]
[--prefix <filename_prefix>]
Retrieve module contents from an instance.
Positional arguments:
<instance>
Optional arguments:
--directory <directory>
--prefix <filename_prefix>
usage: trove module-show <module>
Shows details of a module.
Positional arguments:
<module>
usage: trove module-update <module>
[--name <name>] [--type <type>] [--file <filename>]
[--description <description>]
[--datastore <datastore>] [--all_datastores]
[--datastore_version <version>]
[--all_datastore_versions] [--auto_apply]
[--no_auto_apply] [--all_tenants]
[--no_all_tenants] [--hidden] [--no_hidden]
[--live_update] [--no_live_update]
[--priority_apply] [--no_priority_apply]
[--apply_order {0,1,2,3,4,5,6,7,8,9}]
[--full_access] [--no_full_access]
Update a module.
Positional arguments:
<module>
Optional arguments:
--name <name>
--type <type>
--file <filename>
--description <description>
--datastore <datastore>
--all_datastores
--datastore_version <version>
--all_datastore_versions
--auto_apply
--no_auto_apply
--all_tenants
--no_all_tenants
--hidden
--no_hidden
--live_update
--no_live_update
--priority_apply
--no_priority_apply
--apply_order {0,1,2,3,4,5,6,7,8,9}
--full_access
--no_full_access
usage: trove promote-to-replica-source <instance>
Promotes a replica to be the new replica source of its set.
Positional arguments:
<instance>
usage: trove quota-show <tenant_id>
Show quotas for a tenant.
Positional arguments:
<tenant_id>
usage: trove quota-update <tenant_id> <resource> <limit>
Update quotas for a tenant.
Positional arguments:
<tenant_id>
<resource>
<limit>
usage: trove reset-status <instance>
Set the status to NONE.
Positional arguments:
<instance>
usage: trove resize-instance <instance> <flavor>
Resizes an instance with a new flavor.
Positional arguments:
<instance>
<flavor>
usage: trove resize-volume <instance> <size>
Resizes the volume size of an instance.
Positional arguments:
<instance>
<size>
usage: trove restart <instance>
Restarts an instance.
Positional arguments:
<instance>
usage: trove root-disable <instance>
Disables root for an instance.
Positional arguments:
<instance>
usage: trove root-enable <instance_or_cluster>
[--root_password <root_password>]
Enables root for an instance and resets if already exists.
Positional arguments:
<instance_or_cluster>
Optional arguments:
--root_password <root_password>
usage: trove root-show <instance_or_cluster>
Gets status if root was ever enabled for an instance or cluster.
Positional arguments:
<instance_or_cluster>
usage: trove schedule-create <instance> <pattern> <name>
[--description <description>] [--incremental]
Schedules backups for an instance.
Positional arguments:
<instance>
<pattern>
<name>
Optional arguments:
--description <description>
--incremental
usage: trove schedule-delete <schedule id>
Deletes a schedule.
Positional arguments:
<schedule id>
usage: trove schedule-list <instance>
Lists scheduled backups for an instance.
Positional arguments:
<instance>
usage: trove schedule-show <schedule id>
Shows details of a schedule.
Positional arguments:
<schedule id>
usage: trove secgroup-add-rule <security_group> <cidr>
Creates a security group rule.
Positional arguments:
<security_group>
<cidr>
usage: trove secgroup-delete-rule <security_group_rule>
Deletes a security group rule.
Positional arguments:
<security_group_rule>
usage: trove secgroup-list-rules <security_group>
Lists all rules for a security group.
Positional arguments:
<security_group>
usage: trove secgroup-show <security_group>
Shows details of a security group.
Positional arguments:
<security_group>
usage: trove show <instance>
Shows details of an instance.
Positional arguments:
<instance>
usage: trove update <instance>
[--name <name>] [--configuration <configuration>]
[--detach_replica_source] [--remove_configuration]
Updates an instance: Edits name, configuration, or replica source.
Positional arguments:
<instance>
Optional arguments:
--name <name>
--configuration <configuration>
--detach_replica_source, --detach-replica-source
--detach-replica-source
may be deprecated in the future in favor of
just --detach_replica_source
--remove_configuration
usage: trove upgrade <instance> <datastore_version>
Upgrades an instance to a new datastore version.
Positional arguments:
<instance>
<datastore_version>
usage: trove user-create <instance> <name> <password>
[--host <host>]
[--databases <databases> [<databases> ...]]
Creates a user on an instance.
Positional arguments:
<instance>
<name>
<password>
Optional arguments:
--host <host>
--databases <databases> [<databases> ...]
usage: trove user-delete [--host <host>] <instance> <name>
Deletes a user from an instance.
Positional arguments:
<instance>
<name>
Optional arguments:
--host <host>
usage: trove user-grant-access <instance> <name> <databases> [<databases> ...]
[--host <host>]
Grants access to a database(s) for a user.
Positional arguments:
<instance>
<name>
<databases>
Optional arguments:
--host <host>
usage: trove user-list <instance>
Lists the users for an instance.
Positional arguments:
<instance>
usage: trove user-revoke-access [--host <host>] <instance> <name> <database>
Revokes access to a database for a user.
Positional arguments:
<instance>
<name>
<database>
Optional arguments:
--host <host>
usage: trove user-show [--host <host>] <instance> <name>
Shows details of a user of an instance.
Positional arguments:
<instance>
<name>
Optional arguments:
--host <host>
usage: trove user-show-access [--host <host>] <instance> <name>
Shows access details of a user of an instance.
Positional arguments:
<instance>
<name>
Optional arguments:
--host <host>
usage: trove user-update-attributes <instance> <name>
[--host <host>] [--new_name <new_name>]
[--new_password <new_password>]
[--new_host <new_host>]
Updates a user’s attributes on an instance. At least one optional argument must be provided.
Positional arguments:
<instance>
<name>
Optional arguments:
--host <host>
--new_name <new_name>
--new_password <new_password>
--new_host <new_host>
Except where otherwise noted, this document is licensed under Creative Commons Attribution 3.0 License. See all OpenStack Legal Documents.