Verify operation

Verify operation of the Database service.

Note

Perform these commands on the node where you installed trove.

  1. Source the admin tenant credentials:

    $ . admin-openrc

  2. Run the trove list command. You should see output similar to this:

    $ trove list
+----+------+-----------+-------------------+--------+-----------+------+
| id | name | datastore | datastore_version | status | flavor_id | size |
+----+------+-----------+-------------------+--------+-----------+------+
+----+------+-----------+-------------------+--------+-----------+------+

  3. Add a datastore to trove:

    • Create a trove image.

      Create an image for the type of database you want to use, for example, MySQL, MongoDB, Cassandra.

      This image must have the trove guest agent installed.

    • Upload the image to glance. Example:

      $ glance image-create --name "mysqlTest" --disk-format qcow2 \
  --container-format bare \
  --file mysql-5.6.qcow2
+------------------+--------------------------------------+
| Property         | Value                                |
+------------------+--------------------------------------+
| checksum         | 51a8e6e5ff10b08f2c2ec2953f0a8086     |
| container_format | bare                                 |
| created_at       | 2016-04-08T15:15:41Z                 |
| disk_format      | qcow2                                |
| id               | 5caa76dd-f44b-4d01-a3b4-a111e27896be |
| min_disk         | 0                                    |
| min_ram          | 0                                    |
| name             | mysqlTest                            |
| owner            | 0c0bd5e850c24893b48c4cc01e2a7986     |
| protected        | False                                |
| size             | 533790720                            |
| status           | active                               |
| tags             | []                                   |
| updated_at       | 2016-04-08T15:15:51Z                 |
| virtual_size     | None                                 |
| visibility       | private                              |
+------------------+--------------------------------------+

    • An alternate method of launching trove guests is to use an existing Linux distro image and configure the trove guest using Cloud-init . This saves the effort of creating a customized image, but at the cost of a slower startup time.

    • Create a datastore. You need to create a separate datastore for each type of database you want to use, for example, MySQL, MongoDB, Cassandra. This example shows you how to create a datastore for a MySQL database:

      # su -s /bin/sh -c "trove-manage \
  --config-file /etc/trove/trove.conf \
  datastore_update mysql ''" trove
...
Datastore 'mysql' updated.

  4. Update the datastore to use the new image.

    This example shows you how to update a MySQL 5.6 datastore:

    # su -s /bin/sh -c "trove-manage --config-file /etc/trove/trove.conf \
  datastore_version_update \
  mysql mysql-5.6 mysql glance_image_ID '' 1" trove
...
Datastore version 'mysql-5.6' updated.

  5. Create a database instance.