This procedure installs the Database module on the controller node.
Prerequisites. This chapter assumes that you already have a working OpenStack environment with at least the following components installed: Compute, Image Service, Identity.
To install the Database module on the controller:
Install required packages:
# apt-get install python-trove python-troveclient python-glanceclient \ trove-common trove-api trove-taskmanager
Prepare OpenStack:
Source the
admin-openrc.sh
file.$ source ~/admin-openrc.sh
Edit the following configuration files, taking the below actions for each file:
trove.conf
trove-taskmanager.conf
trove-conductor.conf
Edit the
[DEFAULT]
section of each file and set appropriate values for the OpenStack service URLs, logging and messaging configuration, and SQL connections:[DEFAULT] log_dir = /var/log/trove trove_auth_url = http://
controller
:5000/v2.0 nova_compute_url = http://controller
:8774/v2 cinder_url = http://controller
:8776/v1 swift_url = http://controller
:8080/v1/AUTH_ sql_connection = trove:TROVE_DBPASS@controller
/trove notifier_queue_hostname =controller
Edit the
[filter:authtoken]
section of theapi-paste.ini
file so it matches the listing shown below:[filter:authtoken] auth_host =
controller
auth_port = 35357 auth_protocol = http admin_user = trove admin_password =ADMIN_PASS
admin_token =ADMIN_TOKEN
admin_tenant_name = service signing_dir = /var/cache/troveEdit the
trove.conf
file so it includes appropriate values for the default datastore and network label regex as shown below:[DEFAULT] default_datastore = mysql .... # Config option for showing the IP address that nova doles out add_addresses = True network_label_regex = ^NETWORK_LABEL$ ....
Edit the
trove-taskmanager.conf
file so it includes the appropriate service credentials required to connect to the OpenStack Compute service as shown below:[DEFAULT] .... # Configuration options for talking to nova via the novaclient. # These options are for an admin user in your keystone config. # It proxy's the token received from the user to send to nova via this admin users creds, # basically acting like the client via that proxy token. nova_proxy_admin_user = admin nova_proxy_admin_pass =
ADMIN_PASS
nova_proxy_admin_tenant_name = service ...Prepare the trove admin database:
$ mysql -u root -p mysql> CREATE DATABASE trove; mysql> GRANT ALL PRIVILEGES ON trove.* TO trove@'localhost' IDENTIFIED BY 'TROVE_DBPASS'; mysql> GRANT ALL PRIVILEGES ON trove.* TO trove@'%' IDENTIFIED BY 'TROVE_DBPASS';
Prepare the Database service:
Initialize the database:
# su -s /bin/sh -c "trove-manage db_sync" trove
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 datastore_update mysql ''" 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, and it must have the
trove-guestagent.conf
file configured to connect to your OpenStack environment. To correctly configure thetrove-guestagent.conf
file, follow these steps on the guest instance you are using to build your image:Add the following lines to
trove-guestagent.conf
:rabbit_host =
controller
rabbit_password =RABBIT_PASS
nova_proxy_admin_user = admin nova_proxy_admin_pass =ADMIN_PASS
nova_proxy_admin_tenant_name = service trove_auth_url = http://controller
:35357/v2.0
Update the datastore to use the new image, using the trove-manage command.
This example shows you how to create a MySQL 5.5 datastore:
# trove-manage --config-file=/etc/trove/trove.conf datastore_version_update \ mysql mysql-5.5 mysql
glance_image_ID
mysql-server-5.5 1