Allow clients to make adjustments to two MySQL configuration settings

[rbogle]

Adjustments to two MySQL configuration settings

This request is for Cloud Support (or the Application Development team) to get more information about the ability to adjust the following configuration settings that are currently restricted to users with SYSTEM_VARIABLE_ADMIN privileges. Our team would like the ability to configure these settings on our own, but if that’s not possible, we would like to know our options for if these kind of settings can be adjusted via a request to cloud.gov.

1. General_log setting

• Request to update this setting to enable auditing of all actions and queries performed in MySQL. This prevents the need for custom code to try and capture all of these events.
• While application logging currently allows our team to understand the context of database queries, it was not designed to capture every single query that is run for auditing and troubleshooting purposes.
• The business benefit of this request is that it will provide more efficient troubleshooting support to end users, and allow the team to return to development activities that add business value more quickly.
• https://dev.mysql.com/doc/refman/8.0/en/query-log.html

2. Transaction_isolation setting

• Request to be adjusted to “tune” performance of the database. A more performant setting such as “READ-COMMITTED” can be used to troubleshooting deadlocked queries.
• https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-isolation-levels.html

Acceptance Criteria

• GIVEN [a precondition]
  AND [another precondition]
  WHEN [test step]
  AND [test step]
  THEN [verification step]
  AND [verification step]

---

Security considerations

[note any potential changes to security boundaries, practices, documentation, risk that arise directly from this story]

Implementation sketch

[links to background notes, sketches, and/or relevant documentation

• [first thing to do]
• [another thing to do]