Upgrade datastore¶

You can upgrade the datastore version of the database instance. When you perform an upgrade, the system automatically manages data and configuration files of your database.

To perform datastore upgrade, you need:

A guest image with the target datastore version.
A Trove database instance to be upgrade.

This example shows you how to upgrade Redis datastore (version 3.2.6) for a single instance database.

Note

Before upgrading, make sure that:

Your target datastore is binary compatible with the current datastore. Each database provider has its own compatibilty policy. Usually there shouldn’t be any problem when performing an upgrade within minor versions.
You do not downgrade your datastore.
Target versions is supported by Trove. For instance, Trove doesn’t support Cassandra >=2.2 at this moment so you shouldn’t perform an upgrade from 2.1 to 2.2.

Upgrading datastore¶

Check instance status

Make sure the instance status is HEALTHY before upgrading.

$ openstack database instance list
+--------------------------------------+------------+-----------+-------------------+---------+-----------+-----------+------+-----------+
| ID                                   | Name       | Datastore | Datastore Version | Status  | Addresses | Flavor ID | Size | Region    |
+--------------------------------------+------------+-----------+-------------------+---------+-----------+-----------+------+-----------+
| 55411e95-1670-497f-8d92-0179f3b4fdd4 | redis_test | redis     | 3.2.6             | HEALTHY | 10.1.0.25 |  6        |    1 | RegionOne |
+--------------------------------------+------------+-----------+-------------------+---------+-----------+-----------+------+-----------+

Check if target version is available

Use openstack datastore version list command to list all available versions your datastore.

$ openstack datastore version list redis
+--------------------------------------+-------+
| ID                                   | Name  |
+--------------------------------------+-------+
| 483debec-b7c3-4167-ab1d-1765795ed7eb | 3.2.6 |
| 507f666e-193c-4194-9d9d-da8342dcb4f1 | 3.2.7 |
+--------------------------------------+-------+

Run upgrade

Use openstack database instance upgrade command to upgrade the datastore of the instance.
```
$ openstack database instance 55411e95-1670-497f-8d92-0179f3b4fdd4 3.2.7
```

Wait until status changes from UPGRADE to HEALTHY

Use openstack database instance list to check the current status.

$ openstack database instance list
+--------------------------------------+------------+-----------+-------------------+---------+-----------+-----------+------+-----------+
| ID                                   | Name       | Datastore | Datastore Version | Status  | Addresses | Flavor ID | Size | Region    |
+--------------------------------------+------------+-----------+-------------------+---------+-----------+-----------+------+-----------+
| 55411e95-1670-497f-8d92-0179f3b4fdd4 | redis_test | redis     | 3.2.7             | UPGRADE | 10.1.0.25 | 6         |    5 | RegionOne |
+--------------------------------------+------------+-----------+-------------------+---------+-----------+-----------+------+-----------+
$ openstack database instance list
+--------------------------------------+------------+-----------+-------------------+---------+-----------+-----------+------+-----------+
| ID                                   | Name       | Datastore | Datastore Version | Status  | Addresses | Flavor ID | Size | Region    |
+--------------------------------------+------------+-----------+-------------------+---------+-----------+-----------+------+-----------+
| 55411e95-1670-497f-8d92-0179f3b4fdd4 | redis_test | redis     | 3.2.7             | HEALTHY | 10.1.0.25 | 6         |    5 | RegionOne |
+--------------------------------------+------------+-----------+-------------------+---------+-----------+-----------+------+-----------+

Other datastores¶

Upgrade for other datastores works in the same way. Currently Trove supports upgrades for the following datastores:

MySQL
MariaDB
Redis