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