Enable innodb_buffer_pool_size configuration

Adds a hiera-enabled setting for mysql.pp to
allow configuration of innodb_buffer_pool_size, a key
configurational element for MySQL performance tuning.

Change-Id: Iabdcb6f76510becb98cba35c95db550ffce44ff3
Closes-bug: #1704978
(cherry picked from commit 54532632aa)
This commit is contained in:
Mike Bayer 2017-08-02 10:38:45 -04:00
parent fd9fbf070b
commit 3d67149de1
2 changed files with 18 additions and 8 deletions

View File

@ -53,6 +53,10 @@
# variable.
# Defaults to hiera('generate_service_certificate', false).
#
# [*innodb_buffer_pool_size*]
# (Optional) Configure the size of the MySQL buffer pool.
# Defaults to hiera('innodb_buffer_pool_size', undef)
#
# [*manage_resources*]
# (Optional) Whether or not manage root user, root my.cnf, and service.
# Defaults to true
@ -83,6 +87,7 @@ class tripleo::profile::base::database::mysql (
$enable_internal_tls = hiera('enable_internal_tls', false),
$generate_dropin_file_limit = false,
$generate_service_certificates = hiera('generate_service_certificates', false),
$innodb_buffer_pool_size = hiera('innodb_buffer_pool_size', undef),
$manage_resources = true,
$mysql_server_options = {},
$mysql_max_connections = hiera('mysql_max_connections', undef),
@ -130,14 +135,15 @@ class tripleo::profile::base::database::mysql (
# MysqlNetwork and ControllerHostnameResolveNetwork in ServiceNetMap
$mysql_server_default = {
'mysqld' => {
'bind-address' => $bind_address,
'max_connections' => $mysql_max_connections,
'open_files_limit' => '-1',
'innodb_file_per_table' => 'ON',
'ssl' => $enable_internal_tls,
'ssl-key' => $tls_keyfile,
'ssl-cert' => $tls_certfile,
'ssl-ca' => undef,
'bind-address' => $bind_address,
'max_connections' => $mysql_max_connections,
'open_files_limit' => '-1',
'innodb_buffer_pool_size' => $innodb_buffer_pool_size,
'innodb_file_per_table' => 'ON',
'ssl' => $enable_internal_tls,
'ssl-key' => $tls_keyfile,
'ssl-cert' => $tls_certfile,
'ssl-ca' => undef,
}
}
$mysql_server_options_real = deep_merge($mysql_server_default, $mysql_server_options)

View File

@ -0,0 +1,4 @@
---
features:
- |
Enable innodb_buffer_pool_size configuration for all MySQL databases.