Bug 2034638 - MySQLServerOptions are only defined for standalone MySQL service
Summary: MySQLServerOptions are only defined for standalone MySQL service
Keywords:
Status: CLOSED WONTFIX
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-tripleo-heat-templates
Version: 16.2 (Train)
Hardware: All
OS: All
low
medium
Target Milestone: ---
: ---
Assignee: OSP Team
QA Contact: Joe H. Rahme
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2021-12-21 15:13 UTC by Alex Stupnikov
Modified: 2023-07-24 05:28 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2023-07-24 05:28:06 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Launchpad 1955490 0 None None None 2021-12-21 15:47:53 UTC
Red Hat Issue Tracker OSP-11911 0 None None None 2021-12-21 15:17:32 UTC
Red Hat Knowledge Base (Solution) 5045321 0 None None None 2021-12-21 15:14:18 UTC

Description Alex Stupnikov 2021-12-21 15:13:46 UTC 
Description of problem:

RHOSP overcloud is shipped with Galera cluster. For overcloud nodes OS::TripleO::Services::MySQL composable service points to ../deployment/database/mysql-pacemaker-puppet.yaml. There is no MySQLServerOptions parameter available there, so customers need to use tripleo::profile::base::database::mysql::mysql_server_options hiera parameter to customize MySQL server configuration.

In upstream OS::TripleO::Services::MySQL composable service points to deployment/database/mysql-container-puppet.yaml by default. There is MySQLServerOptions parameter there, so customers can use it to customize MySQL server configuration.

Version-Release number of selected component (if applicable):
RHOSP 16.1.
Comment 1 Alex Stupnikov 2021-12-21 15:19:29 UTC 
I am reporting this as a bug because this situation is misleading and some customers are trying to use MySQLServerOptions instead of puppet hieradata.
Comment 3 Luca Miccini 2023-07-24 05:28:06 UTC 
we won't be able to fix properly in THT, probably worth a kcs.
Note You need to log in before you can comment on or make changes to this bug.