The trove client is the command-line interface (CLI) for the Database service (trove) API and its extensions.
This chapter documents trove version 2.10.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-copybackup-createbackup-deletebackup-listbackup-list-instancebackup-showcluster-createcluster-deletecluster-force-deletecluster-growcluster-instancescluster-listcluster-modulescluster-reset-statuscluster-showcluster-shrinkcluster-upgradeconfiguration-attachconfiguration-createconfiguration-defaultconfiguration-deleteconfiguration-detachconfiguration-instancesconfiguration-listconfiguration-parameter-listconfiguration-parameter-showconfiguration-patchconfiguration-showconfiguration-updatecreatedatabase-createdatabase-deletedatabase-listdatastore-listdatastore-showdatastore-version-listdatastore-version-showdeletedetach-replicaeject-replica-sourceexecution-deleteexecution-listflavor-listflavor-showforce-deletelimit-listlistlog-disablelog-discardlog-enablelog-listlog-publishlog-savelog-showlog-tailmetadata-createmetadata-deletemetadata-editmetadata-listmetadata-showmetadata-updatemodule-applymodule-createmodule-deletemodule-instance-countmodule-instancesmodule-listmodule-list-instancemodule-querymodule-reapplymodule-removemodule-retrievemodule-showmodule-updatepromote-to-replica-sourcequota-showquota-updatereset-statusresize-instanceresize-volumerestartroot-disableroot-enableroot-showschedule-createschedule-deleteschedule-listschedule-showsecgroup-add-rulesecgroup-delete-rulesecgroup-listsecgroup-list-rulessecgroup-showshowupdateupgradeuser-createuser-deleteuser-grant-accessuser-listuser-revoke-accessuser-showuser-show-accessuser-update-attributesvolume-type-listvolume-type-showbash-completionhelp--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-outputenv[OS_JSON_OUTPUT].--profile HMAC_KEYenv[OS_PROFILE_HMACKEY].--os-auth-type <name>, --os-auth-plugin <name>--os-region-name <region-name>env[OS_REGION_NAME].usage: trove backup-copy [--description <description>] <name> <backup>
Creates a backup from another backup.
Positional arguments:
<name><backup>Optional arguments:
--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>--incrementalusage: 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>--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>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>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 cluster-upgrade <cluster> <datastore_version>
Upgrades a cluster to a new datastore version.
Positional arguments:
<cluster><datastore_version>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>
[--limit <limit>] [--marker <ID>]
Lists all instances associated with a configuration group.
Positional arguments:
<configuration_group>Optional arguments:
--limit <limit>--marker <ID>usage: trove configuration-list [--limit <limit>] [--marker <ID>]
Lists all configuration groups.
Optional arguments:
--limit <limit>--marker <ID>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>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>--include_clustered, --include-clusteredusage: trove log-disable [--discard] <instance> <log_name>
Instructs Trove guest to stop collecting log details.
Positional arguments:
<instance><log_name>Optional arguments:
--discardusage: 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--discardusage: 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_accessusage: trove module-delete <module>
Delete a module.
Positional arguments:
<module>usage: trove module-instance-count [--include_clustered] <module>
Lists a count of the instances for each module md5.
Positional arguments:
<module>Optional arguments:
--include_clusteredusage: 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>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-reapply <module>
[--md5 <md5>] [--include_clustered]
[--batch_size <batch_size>] [--delay <delay>]
[--force]
Reapply a module.
Positional arguments:
<module>Optional arguments:
--md5 <md5>--include_clustered--batch_size <batch_size>--delay <delay>--forceusage: 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_accessusage: 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>--incrementalusage: 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--remove_configurationusage: 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>usage: trove volume-type-list [--datastore_type <datastore_type>]
[--datastore_version_id <datastore_version_id>]
Lists available volume types.
Optional arguments:
--datastore_type <datastore_type>--datastore_version_id <datastore_version_id>usage: trove volume-type-show <volume_type>
Shows details of a volume type.
Positional arguments:
<volume_type>
Except where otherwise noted, this document is licensed under Creative Commons Attribution 3.0 License. See all OpenStack Legal Documents.