trove

database backup create

Creates a backup of an instance.

openstack database backup create
    [-i <instance>]
    [--description <description>]
    [--parent <parent>]
    [--incremental]
    [--swift-container SWIFT_CONTAINER]
    [--restore-from RESTORE_FROM]
    [--restore-datastore-version RESTORE_DATASTORE_VERSION]
    [--restore-size RESTORE_SIZE]
    <name>
-i <instance>, --instance <instance>

ID or name of the instance. This is not required if restoring a backup from the data location.

--description <description>

An optional description for the backup.

--parent <parent>

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

--incremental

Create an incremental backup based on the last full or incremental backup. It will create a full backup if no existing backup found.

--swift-container <SWIFT_CONTAINER>

The container name for storing the backup data when Swift is used as backup storage backend. If not specified, will use the container name configured in the backup strategy, otherwise, the default value configured by the cloud operator. Non-existent container is created automatically.

--restore-from <RESTORE_FROM>

The original backup data location, typically this is a Swift object URL.

--restore-datastore-version <RESTORE_DATASTORE_VERSION>

ID of the local datastore version corresponding to the original backup

--restore-size <RESTORE_SIZE>

The original backup size.

name

Name of the backup.

This command is provided by the python-troveclient plugin.

database backup delete

Deletes a backup.

openstack database backup delete backup [backup ...]
backup

Id or name of backup(s).

This command is provided by the python-troveclient plugin.

database backup execution delete

Deletes an execution.

openstack database backup execution delete <execution>
execution

ID of the execution to delete.

This command is provided by the python-troveclient plugin.

database backup list

List database backups

openstack database backup list
    [--sort-column SORT_COLUMN]
    [--sort-ascending | --sort-descending]
    [--limit <limit>]
    [--marker <ID>]
    [--datastore <datastore>]
    [--instance-id INSTANCE_ID]
    [-i INSTANCE]
    [--all-projects]
    [--project-id PROJECT_ID]
--sort-column SORT_COLUMN

specify the column(s) to sort the data (columns specified first have a priority, non-existing columns are ignored), can be repeated

--sort-ascending

sort the column(s) in ascending order

--sort-descending

sort the column(s) in descending order

--limit <limit>

Return up to N number of the most recent bcakups.

--marker <ID>

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

--datastore <datastore>

ID or name of the datastore (to filter backups by).

--instance-id <INSTANCE_ID>

Filter backups by database instance ID. Deprecated since Xena. Use -i/–instance instead.

-i <INSTANCE>, --instance <INSTANCE>

Filter backups by database instance(ID or name).

--all-projects

Get all the backups of all the projects(Admin only).

--project-id <PROJECT_ID>

Filter backups by project ID.

This command is provided by the python-troveclient plugin.

database backup list instance

Lists available backups for an instance.

openstack database backup list instance
    [--sort-column SORT_COLUMN]
    [--sort-ascending | --sort-descending]
    [--limit <limit>]
    [--marker <ID>]
    <instance>
--sort-column SORT_COLUMN

specify the column(s) to sort the data (columns specified first have a priority, non-existing columns are ignored), can be repeated

--sort-ascending

sort the column(s) in ascending order

--sort-descending

sort the column(s) in descending order

--limit <limit>

Return up to N number of the most recent bcakups.

--marker <ID>

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

instance

ID or name of the instance.

This command is provided by the python-troveclient plugin.

database backup show

Shows details of a database backup

openstack database backup show <backup>
backup

ID or name of the backup

This command is provided by the python-troveclient plugin.

database backup strategy create

Creates backup strategy for the project or a particular instance.

openstack database backup strategy create
    [--project-id PROJECT_ID]
    [--instance-id INSTANCE_ID]
    [--swift-container SWIFT_CONTAINER]
--project-id <PROJECT_ID>

Project ID in Keystone. Only admin user is allowed to create backup strategy for other projects.

--instance-id <INSTANCE_ID>

Database instance ID.

--swift-container <SWIFT_CONTAINER>

The container name for storing the backup data when Swift is used as backup storage backend.

This command is provided by the python-troveclient plugin.

database backup strategy delete

Deletes backup strategy.

openstack database backup strategy delete
    [--project-id PROJECT_ID]
    [--instance-id INSTANCE_ID]
--project-id <PROJECT_ID>

Project ID in Keystone. Only admin user is allowed to delete backup strategy for other projects.

--instance-id <INSTANCE_ID>

Database instance ID.

This command is provided by the python-troveclient plugin.

database backup strategy list

List backup strategies

openstack database backup strategy list
    [--sort-column SORT_COLUMN]
    [--sort-ascending | --sort-descending]
    [--instance-id INSTANCE_ID]
    [--project-id PROJECT_ID]
--sort-column SORT_COLUMN

specify the column(s) to sort the data (columns specified first have a priority, non-existing columns are ignored), can be repeated

--sort-ascending

sort the column(s) in ascending order

--sort-descending

sort the column(s) in descending order

--instance-id <INSTANCE_ID>

Filter results by database instance ID.

--project-id <PROJECT_ID>

Project ID in Keystone. Only admin user is allowed to list backup strategy for other projects.

This command is provided by the python-troveclient plugin.

database cluster create

Creates a new database cluster.

openstack database cluster create
    [--instance "opt=<value>[,opt=<value> ...]
    "]
    [--locality <policy>]
    [--extended-properties "opt=<value>[,opt=<value> ...]
    "]
    [--configuration <configuration>]
    <name>
    <datastore>
    <datastore_version>
--instance "opt=<value>[,opt=<value> ...] "

Add an instance to the cluster. Specify multiple times to create multiple instances. Valid options are: flavor=<flavor_name_or_id>, volume=<disk_size_in_GB>, volume_type=<type>, nic=’<net-id=<net-uuid>, v4-fixed-ip=<ip-addr>, port-id=<port-uuid>>’ (where net-id=network_id, v4-fixed-ip=IPv4r_fixed_address, port-id=port_id), availability_zone=<AZ_hint_for_Nova>, module=<module_name_or_id>, type=<type_of_cluster_node>, related_to=<related_attribute>.

--locality <policy>

Locality policy to use when creating cluster. Choose one of %(choices)s.

--extended-properties "opt=<value>[,opt=<value> ...] "

Add extended properties for cluster create. Currently only support MongoDB options, other databases will be added in the future. MongoDB: num_configsvr=<number_of_configsvr>, num_mongos=<number_of_mongos>, configsvr_volume_size=<disk_size_in_GB>, configsvr_volume_type=<volume_type>, mongos_volume_size=<disk_size_in_GB>, mongos_volume_type=<volume_type>.

--configuration <configuration>

ID of the configuration group to attach to the cluster.

name

Name of the cluster.

datastore

A datastore name or ID.

datastore_version

A datastore version name or ID.

This command is provided by the python-troveclient plugin.

database cluster delete

Deletes a cluster.

openstack database cluster delete <cluster>
cluster

ID or name of the cluster.

This command is provided by the python-troveclient plugin.

database cluster force delete

Force delete a cluster.

openstack database cluster force delete <cluster>
cluster

ID or name of the cluster.

This command is provided by the python-troveclient plugin.

database cluster grow

Adds more instances to a cluster.

openstack database cluster grow
    [--instance "opt=<value>[,opt=<value> ...]
    "]
    <cluster>
--instance "opt=<value>[,opt=<value> ...] "

Add an instance to the cluster. Specify multiple times to create multiple instances. Valid options are: flavor=<flavor_name_or_id>, volume=<disk_size_in_GB>, volume_type=<type>, nic=’<net-id=<net-uuid>, v4-fixed-ip=<ip-addr>, port-id=<port-uuid>>’ (where net-id=network_id, v4-fixed-ip=IPv4r_fixed_address, port-id=port_id), availability_zone=<AZ_hint_for_Nova>, module=<module_name_or_id>, type=<type_of_cluster_node>, related_to=<related_attribute>.

cluster

ID or name of the cluster.

This command is provided by the python-troveclient plugin.

database cluster list

List database clusters

openstack database cluster list
    [--sort-column SORT_COLUMN]
    [--sort-ascending | --sort-descending]
    [--limit <limit>]
    [--marker <ID>]
--sort-column SORT_COLUMN

specify the column(s) to sort the data (columns specified first have a priority, non-existing columns are ignored), can be repeated

--sort-ascending

sort the column(s) in ascending order

--sort-descending

sort the column(s) in descending order

--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.

This command is provided by the python-troveclient plugin.

database cluster list instances

Lists all instances of a cluster.

openstack database cluster list instances
    [--sort-column SORT_COLUMN]
    [--sort-ascending | --sort-descending]
    <cluster>
--sort-column SORT_COLUMN

specify the column(s) to sort the data (columns specified first have a priority, non-existing columns are ignored), can be repeated

--sort-ascending

sort the column(s) in ascending order

--sort-descending

sort the column(s) in descending order

cluster

ID or name of the cluster.

This command is provided by the python-troveclient plugin.

database cluster modules

Lists all modules for each instance of a cluster.

openstack database cluster modules
    [--sort-column SORT_COLUMN]
    [--sort-ascending | --sort-descending]
    <cluster>
--sort-column SORT_COLUMN

specify the column(s) to sort the data (columns specified first have a priority, non-existing columns are ignored), can be repeated

--sort-ascending

sort the column(s) in ascending order

--sort-descending

sort the column(s) in descending order

cluster

ID or name of the cluster.

This command is provided by the python-troveclient plugin.

database cluster reset status

Set the cluster task to NONE.

openstack database cluster reset status <cluster>
cluster

ID or name of the cluster.

This command is provided by the python-troveclient plugin.

database cluster show

Shows details of a database cluster

openstack database cluster show <cluster>
cluster

ID or name of the cluster

This command is provided by the python-troveclient plugin.

database cluster shrink

Drops instances from a cluster.

openstack database cluster shrink <cluster> <instance> [<instance> ...]
cluster

ID or name of the cluster.

instance

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

This command is provided by the python-troveclient plugin.

database cluster upgrade

Upgrades a cluster to a new datastore version.

openstack database cluster upgrade <cluster> <datastore_version>
cluster

ID or name of the cluster.

datastore_version

A datastore version name or ID.

This command is provided by the python-troveclient plugin.

database configuration attach

Attaches a configuration group to an instance.

openstack database configuration attach <instance> <configuration>
instance

ID or name of the instance

configuration

ID or name of the configuration group to attach to the instance.

This command is provided by the python-troveclient plugin.

database configuration create

Creates a configuration group.

openstack database configuration create
    [--datastore <datastore>]
    [--datastore-version <datastore_version>]
    [--datastore-version-number DATASTORE_VERSION_NUMBER]
    [--description <description>]
    <name>
    <values>
--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.

--datastore-version-number <DATASTORE_VERSION_NUMBER>

The version number for the database. The version number is needed for the datastore versions with the same name.

--description <description>

An optional description for the configuration group.

name

Name of the configuration group.

values

Dictionary of the values to set.

This command is provided by the python-troveclient plugin.

database configuration default

Shows the default configuration of an instance.

openstack database configuration default <instance>
instance

ID or name of the instance.

This command is provided by the python-troveclient plugin.

database configuration delete

Deletes a configuration group.

openstack database configuration delete <configuration_group>
configuration_group

ID or name of the configuration group

This command is provided by the python-troveclient plugin.

database configuration detach

Detaches a configuration group from an instance.

openstack database configuration detach <instance>
instance

ID or name of the instance.

This command is provided by the python-troveclient plugin.

database configuration instances

Lists all instances associated with a configuration group.

openstack database configuration instances
    [--sort-column SORT_COLUMN]
    [--sort-ascending | --sort-descending]
    [--limit <limit>]
    [--marker <ID>]
    <configuration_group>
--sort-column SORT_COLUMN

specify the column(s) to sort the data (columns specified first have a priority, non-existing columns are ignored), can be repeated

--sort-ascending

sort the column(s) in ascending order

--sort-descending

sort the column(s) in descending order

--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.

configuration_group

ID or name of the configuration group.

This command is provided by the python-troveclient plugin.

database configuration list

List database configurations

openstack database configuration list
    [--sort-column SORT_COLUMN]
    [--sort-ascending | --sort-descending]
    [--limit <limit>]
    [--marker <ID>]
--sort-column SORT_COLUMN

specify the column(s) to sort the data (columns specified first have a priority, non-existing columns are ignored), can be repeated

--sort-ascending

sort the column(s) in ascending order

--sort-descending

sort the column(s) in descending order

--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.

This command is provided by the python-troveclient plugin.

database configuration parameter list

Lists available parameters for a configuration group.

openstack database configuration parameter list
    [--sort-column SORT_COLUMN]
    [--sort-ascending | --sort-descending]
    [--datastore <datastore>]
    <datastore_version>
--sort-column SORT_COLUMN

specify the column(s) to sort the data (columns specified first have a priority, non-existing columns are ignored), can be repeated

--sort-ascending

sort the column(s) in ascending order

--sort-descending

sort the column(s) in descending order

--datastore <datastore>

ID or name of the datastore to list configurationparameters for. Optional if the ID of thedatastore_version is provided.

datastore_version

Datastore version name or ID assigned to the configuration group. ID is preferred if more than one datastore versions have the same name.

This command is provided by the python-troveclient plugin.

database configuration parameter set

Change parameters for a configuration group.

openstack database configuration parameter set
    configuration_group_id
    <values>
configuration_group_id

Configuration group ID.

values

Dictionary of the new values to set.

This command is provided by the python-troveclient plugin.

database configuration parameter show

Shows details of a database configuration parameter.

openstack database configuration parameter show
    [--datastore <datastore>]
    <datastore_version>
    <parameter>
--datastore <datastore>

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

datastore_version

Datastore version name or ID assigned to the configuration group. ID is preferred if more than one datastore versions have the same name.

parameter

Name of the configuration parameter.

This command is provided by the python-troveclient plugin.

database configuration set

Update a configuration group.

openstack database configuration set
    [--name <name>]
    [--description <description>]
    configuration_group_id
    <values>
--name <name>

New name of the configuration group.

--description <description>

An optional description for the configuration group.

configuration_group_id

Configuration group ID.

values

Dictionary of the values to set.

This command is provided by the python-troveclient plugin.

database configuration show

Shows details of a database configuration group.

openstack database configuration show <configuration_group>
configuration_group

ID or name of the configuration group

This command is provided by the python-troveclient plugin.

database db create

Creates a database on an instance.

openstack database db create
    [--character_set <character_set>]
    [--collate <collate>]
    <instance>
    <name>
--character_set <character_set>

Optional character set for database.

--collate <collate>

Optional collation type for database.

instance

ID or name of the instance.

name

Name of the database.

This command is provided by the python-troveclient plugin.

database db delete

Deletes a database from an instance.

openstack database db delete <instance> <database>
instance

ID or name of the instance.

database

Name of the database.

This command is provided by the python-troveclient plugin.

database db list

Get a list of all Databases from the instance.

openstack database db list
    [--sort-column SORT_COLUMN]
    [--sort-ascending | --sort-descending]
    <instance>
--sort-column SORT_COLUMN

specify the column(s) to sort the data (columns specified first have a priority, non-existing columns are ignored), can be repeated

--sort-ascending

sort the column(s) in ascending order

--sort-descending

sort the column(s) in descending order

instance

ID or name of the instance.

This command is provided by the python-troveclient plugin.

database flavor list

List database flavors

openstack database flavor list
    [--sort-column SORT_COLUMN]
    [--sort-ascending | --sort-descending]
    [--datastore-type <datastore-type>]
    [--datastore-version-id <datastore-version-id>]
--sort-column SORT_COLUMN

specify the column(s) to sort the data (columns specified first have a priority, non-existing columns are ignored), can be repeated

--sort-ascending

sort the column(s) in ascending order

--sort-descending

sort the column(s) in descending order

--datastore-type <datastore-type>

Type of the datastore. For eg: mysql.

--datastore-version-id <datastore-version-id>

ID of the datastore version.

This command is provided by the python-troveclient plugin.

database flavor show

Shows details of a database flavor

openstack database flavor show <flavor>
flavor

ID or name of the flavor

This command is provided by the python-troveclient plugin.

database instance create

Creates a new database instance.

openstack database instance create
    [--flavor <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>]
    [--datastore-version-number DATASTORE_VERSION_NUMBER]
    [--nic <net-id=<net-uuid>,subnet-id=<subnet-uuid>,ip-address=<ip-address>>]
    [--configuration <configuration>]
    [--replica-of <source_instance>]
    [--replica-count <count>]
    [--module <module>]
    [--locality <policy>]
    [--is-public]
    [--allowed-cidr ALLOWED_CIDRS]
    <name>
--flavor <flavor>

Flavor to create the instance (name or ID). Flavor is not required when creating replica instances.

--size <size>

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

--volume-type <volume_type>

Volume type. Optional when volume support is enabled.

--databases <database>

Optional list of databases.

--users <user:password>

Optional list of users.

--backup <backup>

A backup name or 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.

--datastore-version-number <DATASTORE_VERSION_NUMBER>

The version number for the database. The version number is needed for the datastore versions with the same name.

--nic <net-id=<net-uuid>,subnet-id=<subnet-uuid>,ip-address=<ip-address>>

Create instance in the given Neutron network. This information is used for creating user-facing port for the instance. Either network ID or subnet ID (or both) should be specified, IP address is optional

--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 if replica_of specified).

--module <module>

ID or name of the module to apply. Specify multiple times to apply multiple modules.

--locality <policy>

Locality policy to use when creating replicas. Choose one of %(choices)s.

--is-public

Whether or not to make the instance public.

--allowed-cidr <ALLOWED_CIDRS>

The IP CIDRs that are allowed to access the database instance. Repeat for multiple values

name

Name of the instance.

This command is provided by the python-troveclient plugin.

database instance delete

Deletes an instance.

openstack database instance delete [--force] instance [instance ...]
--force

Force delete the instance, will reset the instance status before deleting.

instance

Id or name of instance(s).

This command is provided by the python-troveclient plugin.

database instance detach

Detaches a replica instance from its replication source.

openstack database instance detach <instance>
instance

ID or name of the instance.

This command is provided by the python-troveclient plugin.

database instance eject

Ejects a replica source from its set.

openstack database instance eject <instance>
instance

ID or name of the instance.

This command is provided by the python-troveclient plugin.

database instance force delete

Force delete an instance.

openstack database instance force delete <instance>
instance

ID or name of the instance

This command is provided by the python-troveclient plugin.

database instance list

List database instances

openstack database instance list
    [--sort-column SORT_COLUMN]
    [--sort-ascending | --sort-descending]
    [--limit <limit>]
    [--marker <ID>]
    [--include_clustered]
    [--all-projects]
    [--project-id PROJECT_ID]
--sort-column SORT_COLUMN

specify the column(s) to sort the data (columns specified first have a priority, non-existing columns are ignored), can be repeated

--sort-ascending

sort the column(s) in ascending order

--sort-descending

sort the column(s) in descending order

--limit <limit>

Limit the number of results displayed.

--marker <ID>

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

--include_clustered, --include-clustered

Include instances that are part of a cluster (default %(default)s). –include-clustered may be deprecated in the future, retaining just –include_clustered.

--all-projects

Include database instances of all projects (admin only)

--project-id <PROJECT_ID>

Include database instances of a specific project (admin only)

This command is provided by the python-troveclient plugin.

database instance promote

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

openstack database instance promote <instance>
instance

ID or name of the instance.

This command is provided by the python-troveclient plugin.

database instance reboot

Reboots an instance(the Nova server).

openstack database instance reboot <instance>
instance

ID or name of the instance.

This command is provided by the python-troveclient plugin.

database instance rebuild

Rebuilds an instance(the Nova server).

openstack database instance rebuild <instance> <image-id>
instance

ID or name of the instance.

image-id

ID of the new guest image.

This command is provided by the python-troveclient plugin.

database instance reset status

Set instance service status to ERROR and clear the current task status. Mark any running backup operations as FAILED.

openstack database instance reset status <instance>
instance

ID or name of the instance

This command is provided by the python-troveclient plugin.

database instance resize flavor

Resize an instance with a new flavor

openstack database instance resize flavor <instance> flavor
instance

ID or name of the instance

flavor

ID or name of the new flavor.

This command is provided by the python-troveclient plugin.

database instance resize volume

Resizes the volume size of an instance.

openstack database instance resize volume <instance> <size>
instance

ID or name of the instance.

size

New size of the instance disk volume in GB.

This command is provided by the python-troveclient plugin.

database instance restart

Restarts an instance.

openstack database instance restart <instance>
instance

ID or name of the instance.

This command is provided by the python-troveclient plugin.

database instance show

Show instance details

openstack database instance show <instance>
instance

Instance (name or ID)

This command is provided by the python-troveclient plugin.

database instance update

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

openstack database instance update
    [--name <name>]
    [--configuration <configuration>]
    [--detach-replica-source]
    [--remove-configuration]
    [--is-public | --is-private]
    [--allowed-cidr ALLOWED_CIDRS]
    <instance>
--name <name>

ID or name of the instance.

--configuration <configuration>

ID of the configuration reference to attach.

--detach-replica-source, --detach_replica_source

Detach the replica instance from its replication source. –detach-replica-source may be deprecated in the future in favor of just –detach_replica_source

--remove-configuration, --remove_configuration

Drops the current configuration reference.

--is-public

Make the database instance accessible to public.

--is-private

Make the database instance inaccessible to public.

--allowed-cidr <ALLOWED_CIDRS>

The IP CIDRs that are allowed to access the database instance. Repeat for multiple values

instance

ID or name of the instance.

This command is provided by the python-troveclient plugin.

database instance upgrade

Upgrades an instance to a new datastore version.

openstack database instance upgrade <instance> <datastore_version>
instance

ID or name of the instance.

datastore_version

ID or name of the datastore version.

This command is provided by the python-troveclient plugin.

database limit list

List database limits

openstack database limit list
    [--sort-column SORT_COLUMN]
    [--sort-ascending | --sort-descending]
--sort-column SORT_COLUMN

specify the column(s) to sort the data (columns specified first have a priority, non-existing columns are ignored), can be repeated

--sort-ascending

sort the column(s) in ascending order

--sort-descending

sort the column(s) in descending order

This command is provided by the python-troveclient plugin.

database log list

Lists the log files available for instance.

openstack database log list
    [--sort-column SORT_COLUMN]
    [--sort-ascending | --sort-descending]
    <instance>
--sort-column SORT_COLUMN

specify the column(s) to sort the data (columns specified first have a priority, non-existing columns are ignored), can be repeated

--sort-ascending

sort the column(s) in ascending order

--sort-descending

sort the column(s) in descending order

instance

ID or name of the instance.

This command is provided by the python-troveclient plugin.

database log save

Save the log file.

openstack database log save [--file FILE] <instance> <log_name>
--file <FILE>

Path of file to save log to for instance.

instance

Id or Name of the instance.

log_name

Name of log to operate.

This command is provided by the python-troveclient plugin.

database log set

Instructs Trove guest to operate logs.

openstack database log set
    [--enable]
    [--disable]
    [--publish]
    [--discard]
    <instance>
    <log_name>
--enable

Whether or not to enable log collection.

--disable

Whether or not to disable log collection.

--publish

Whether or not to publish log files to the backend storage for logs(Swift by default).

--discard

Whether or not to discard the existing logs before publish.

instance

Id or Name of the instance.

log_name

Name of log to operate.

This command is provided by the python-troveclient plugin.

database log show

Show information of given log name for the database instance.

openstack database log show <instance> <log_name>
instance

Id or Name of the instance.

log_name

Name of log to operate.

This command is provided by the python-troveclient plugin.

database log tail

Show the content of log file.

openstack database log tail [--lines LINES] <instance> <log_name>
--lines <LINES>

The number of log lines can be shown in batch.

instance

Id or Name of the instance.

log_name

Name of log to operate.

This command is provided by the python-troveclient plugin.

database quota show

Show quotas for a project.

openstack database quota show
    [--sort-column SORT_COLUMN]
    [--sort-ascending | --sort-descending]
    project
--sort-column SORT_COLUMN

specify the column(s) to sort the data (columns specified first have a priority, non-existing columns are ignored), can be repeated

--sort-ascending

sort the column(s) in ascending order

--sort-descending

sort the column(s) in descending order

project

Id or name of the project.

This command is provided by the python-troveclient plugin.

database quota update

Update quotas for a project.

openstack database quota update project <resource> <limit>
project

Id or name of the project.

resource

Resource name.

limit

New limit to set for the named resource.

This command is provided by the python-troveclient plugin.

database root disable

Disables root for an instance.

openstack database root disable <instance>
instance

ID or name of the instance.

This command is provided by the python-troveclient plugin.

database root enable

Enables root for an instance and resets if already exists.

openstack database root enable
    [--root_password <root_password>]
    <instance_or_cluster>
--root_password <root_password>

Root password to set.

instance_or_cluster

ID or name of the instance or cluster.

This command is provided by the python-troveclient plugin.

database root show

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

openstack database root show <instance_or_cluster>
instance_or_cluster

ID or name of the instance or cluster.

This command is provided by the python-troveclient plugin.

database user create

Creates a user on an instance.

openstack database user create
    [--host <host>]
    [--databases <databases> [<databases> ...]]
    <instance>
    <name>
    <password>
--host <host>

Optional host of user.

--databases <databases>

Optional list of databases.

instance

ID or name of the instance.

name

Name of user.

password

Password of user.

This command is provided by the python-troveclient plugin.

database user delete

Deletes a user from an instance.

openstack database user delete [--host <host>] <instance> <name>
--host <host>

Optional host of user.

instance

ID or name of the instance.

name

Name of user.

This command is provided by the python-troveclient plugin.

database user grant access

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

openstack database user grant access
    [--host <host>]
    <instance>
    <name>
    <databases>
    [<databases> ...]
--host <host>

Optional host of user.

instance

ID or name of the instance.

name

Name of user.

databases

List of databases.

This command is provided by the python-troveclient plugin.

database user list

Lists the users for an instance.

openstack database user list
    [--sort-column SORT_COLUMN]
    [--sort-ascending | --sort-descending]
    <instance>
--sort-column SORT_COLUMN

specify the column(s) to sort the data (columns specified first have a priority, non-existing columns are ignored), can be repeated

--sort-ascending

sort the column(s) in ascending order

--sort-descending

sort the column(s) in descending order

instance

ID or name of the instance.

This command is provided by the python-troveclient plugin.

database user revoke access

Revokes access to a database for a user.

openstack database user revoke access
    [--host <host>]
    <instance>
    <name>
    <databases>
--host <host>

Optional host of user.

instance

ID or name of the instance.

name

Name of user.

databases

A single database.

This command is provided by the python-troveclient plugin.

database user show

Shows details of a database user of an instance.

openstack database user show [--host <host>] <instance> <name>
--host <host>

Optional host of user.

instance

ID or name of the instance.

name

Name of user.

This command is provided by the python-troveclient plugin.

database user show access

Shows access details of a user of an instance.

openstack database user show access
    [--sort-column SORT_COLUMN]
    [--sort-ascending | --sort-descending]
    [--host <host>]
    <instance>
    <name>
--sort-column SORT_COLUMN

specify the column(s) to sort the data (columns specified first have a priority, non-existing columns are ignored), can be repeated

--sort-ascending

sort the column(s) in ascending order

--sort-descending

sort the column(s) in descending order

--host <host>

Optional host of user.

instance

ID or name of the instance.

name

Name of user.

This command is provided by the python-troveclient plugin.

database user update attributes

Updates a user’s attributes on an instance.At least one optional argument must be provided.

openstack database user update attributes
    [--host <host>]
    [--new_name <new_name>]
    [--new_password <new_password>]
    [--new_host <new_host>]
    <instance>
    <name>
--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.

instance

ID or name of the instance.

name

Name of user.

This command is provided by the python-troveclient plugin.

datastore delete

Deletes a datastore

openstack datastore delete <datastore>
datastore

ID or name of the datastore

This command is provided by the python-troveclient plugin.

datastore list

List available datastores

openstack datastore list
    [--sort-column SORT_COLUMN]
    [--sort-ascending | --sort-descending]
--sort-column SORT_COLUMN

specify the column(s) to sort the data (columns specified first have a priority, non-existing columns are ignored), can be repeated

--sort-ascending

sort the column(s) in ascending order

--sort-descending

sort the column(s) in descending order

This command is provided by the python-troveclient plugin.

datastore show

Shows details of a datastore

openstack datastore show <datastore>
datastore

ID of the datastore

This command is provided by the python-troveclient plugin.

datastore version create

Creates a datastore version.

openstack datastore version create
    [--active]
    [--image-tags IMAGE_TAGS]
    [--default]
    [--version-number VERSION_NUMBER]
    version_name
    datastore_name
    datastore_manager
    image_id
--active

Enable the datastore version.

--image-tags <IMAGE_TAGS>

List of image tags separated by comma, e.g. trove,mysql

--default

If set the datastore version as default.

--version-number <VERSION_NUMBER>

The version number for the database. If not specified, use the version name as the default value.

version_name

Datastore version name.

datastore_name

Datastore name. The datastore is created automatically if does not exist.

datastore_manager

Datastore manager, e.g. mysql

image_id

ID of the datastore image in Glance. This can be empty string if –image-tags is specified.

This command is provided by the python-troveclient plugin.

datastore version delete

Deletes a datastore version.

openstack datastore version delete <datastore_version>
datastore_version

ID of the datastore version.

This command is provided by the python-troveclient plugin.

datastore version list

Lists available versions for a datastore

openstack datastore version list
    [--sort-column SORT_COLUMN]
    [--sort-ascending | --sort-descending]
    <datastore>
--sort-column SORT_COLUMN

specify the column(s) to sort the data (columns specified first have a priority, non-existing columns are ignored), can be repeated

--sort-ascending

sort the column(s) in ascending order

--sort-descending

sort the column(s) in descending order

datastore

ID or name of the datastore

This command is provided by the python-troveclient plugin.

datastore version set

Updates a datastore version.

openstack datastore version set
    [--datastore-manager DATASTORE_MANAGER]
    [--image IMAGE]
    [--image-tags IMAGE_TAGS]
    [--version-name VERSION_NAME]
    [--enable | --disable]
    [--default | --non-default]
    datastore_version_id
--datastore-manager <DATASTORE_MANAGER>

Datastore manager name.

--image <IMAGE>

ID of the datastore image in Glance.

--image-tags <IMAGE_TAGS>

List of image tags separated by comma, e.g. trove,mysql

--version-name <VERSION_NAME>

New datastore version name.

--enable
--disable
--default
--non-default
datastore_version_id

Datastore version ID.

This command is provided by the python-troveclient plugin.

datastore version show

Shows details of a datastore version.

openstack datastore version show
    [--datastore <datastore>]
    <datastore_version>
--datastore <datastore>

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

datastore_version

ID or name of the datastore version.

This command is provided by the python-troveclient plugin.