Changing the database from DB2 (default) to MySQL

You can change the database that is used by OpenStack from DB2® (default) to MySQL.

Before you begin

To use IBM® Cloud Manager with OpenStack to deploy a cloud environment that uses MySQL, you must first set up a MySQL yum repository. If your company policies allow, you can access the community yum repository. Otherwise, manually configure a yum repository for MySQL.
Note: The mysql community yum repository only supports x86_64; the ppc64 platform is unsupported.

About this task

The following information provides details about supported options.

Table 1. Summary of support details
Support options Details
Supported hypervisor types? All
Support for post-deployment customization? No
Supported topologies? All, except HA controller +n compute

Procedure

Depending on the deployment method that you choose, complete the following configuration settings:
  • Advanced deployment: Update the following JSON attributes in your environment file, your-environment-name.json. The attributes are located in the override_attributes section of the environment file.
    • openstack.db.service_type: Set to mysql.
    • openstack.db.telemetry.nosql.used: Set to false.
    • openstack.endpoints.db.port: Remove this attribute from the environment file.
    • openstack.db.telemetry.port: Remove this attribute from the environment file.
    • yum.mysql55-community.enabled: true
    • yum.mysql55-community.baseurl: YOUR_mysql_yum repository_url
  • Prescribed deployment: Set the following value in your cloud.yaml cloud section:
    • database_service_type: mysql
    Set the following override_attributes in your cloud.yaml environment section:
    • yum.mysql55-community.enabled: true
    • yum.mysql55-community.baseurl: YOUR_mysql_yum repository_url
  • IBM Cloud Manager - Deployer: On the configuration page, add YOUR_mysql_yum repository_url.

What to do next

When complete, return to the relevant topology deployment process and complete the remaining steps.