Bug 1326523

Summary: [RFE] Add max_allowed_packet as an Environment Variable to the MySQL Images
Product: OpenShift Container Platform Reporter: Eric Jones <erjones>
Component: RFEAssignee: Ben Parees <bparees>
Status: CLOSED ERRATA QA Contact: Wenjing Zheng <wzheng>
Severity: high Docs Contact:
Priority: low    
Version: 3.1.0CC: adellape, aos-bugs, erich, jokerman, mmccomas, sdodson
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
This bug fix adds the MYSQL_MAX_ALLOWED_PACKET environment variable to the MySQL image, for setting the maximum size of one packet or any generated or intermediate string (default: 200M).
 Story Points: ---
Clone Of: Environment:
Last Closed: 2016-06-27 15:06:02 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Eric Jones 2016-04-12 22:18:18 UTC 
- What is the nature and description of the request? 
As an developer I require the ability to persistently modify the `max_allowed_packet` variable in a MySQL image.

- Why does the customer need this? (List the business requirements here) 
So that they have persistent control over the max_allowed_packets in MySQL.

- How would the customer like to achieve this? (List the functional requirements here) 
Add the variable to the template [0] that we build our image off of.

[0] https://github.com/openshift/mysql/blob/master/5.6/root/usr/share/container-scripts/mysql/my-paas.cnf.template

- For each functional requirement listed, specify how Red Hat and the customer can test to confirm the requirement is successfully implemented.
Deploy a MySQL pod and use `oc env` to specify that variable.

- Is there already an existing RFE upstream or in Red Hat Bugzilla?
Not that I could find.
Comment 2 Ben Parees 2016-05-05 22:34:32 UTC 
this is done now:
https://github.com/openshift/mysql/commit/7b777d5703781ae29db02b2ab8bfa502b63904e7#diff-fcfa02ed838e2c5a90404c032384ffa0R30

will be in the next spin of the rhel images, but it's in centos already.
Comment 10 errata-xmlrpc 2016-06-27 15:06:02 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHBA-2016:1343