Puppet Class: mysql

Defined in:: manifests/database/sql/mysql.pp

Overview

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless optional by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

MySQL Galera Node

Parameters

api_eth: (optional) Hostname or IP to bind MySQL daemon. Defaults to '127.0.0.1'
galera_master_name: (optional) Hostname or IP of the Galera master node, databases and users resources are created on this node and propagated on the cluster. Defaults to 'mgmt001'
galera_internal_ips: (optional) Array of internal ip of the galera nodes. Defaults to ['127.0.0.1']
galera_gcache: (optional) Size of the Galera gcache wsrep_provider_options, for master/slave mode Defaults to '1G'
keystone_db_host: (optional) Host where user should be allowed all privileges for database. Defaults to 127.0.0.1
keystone_db_user: (optional) Name of keystone DB user. Defaults to trove
keystone_db_password: (optional) Password that will be used for the Keystone db user. Defaults to 'keystonepassword'
keystone_db_allowed_hosts: (optional) Hosts allowed to use the database Defaults to ['127.0.0.1']
cinder_db_host: (optional) Host where user should be allowed all privileges for database. Defaults to 127.0.0.1
cinder_db_user: (optional) Name of cinder DB user. Defaults to trove
cinder_db_password: (optional) Password that will be used for the cinder db user. Defaults to 'cinderpassword'
cinder_db_allowed_hosts: (optional) Hosts allowed to use the database Defaults to ['127.0.0.1']
glance_db_host: (optional) Host where user should be allowed all privileges for database. Defaults to 127.0.0.1
glance_db_user: (optional) Name of glance DB user. Defaults to trove
glance_db_password: (optional) Password that will be used for the glance db user. Defaults to 'glancepassword'
glance_db_allowed_hosts: (optional) Hosts allowed to use the database Defaults to ['127.0.0.1']
heat_db_host: (optional) Host where user should be allowed all privileges for database. Defaults to 127.0.0.1
heat_db_user: (optional) Name of heat DB user. Defaults to trove
heat_db_password: (optional) Password that will be used for the heat db user. Defaults to 'heatpassword'
heat_db_allowed_hosts: (optional) Hosts allowed to use the database Defaults to ['127.0.0.1']
nova_db_host: (optional) Host where user should be allowed all privileges for database. Defaults to 127.0.0.1
nova_db_user: (optional) Name of nova DB user. Defaults to trove
nova_db_password: (optional) Password that will be used for the nova db user. Defaults to 'novapassword'
nova_db_allowed_hosts: (optional) Hosts allowed to use the database Defaults to ['127.0.0.1']
neutron_db_host: (optional) Host where user should be allowed all privileges for database. Defaults to 127.0.0.1
neutron_db_user: (optional) Name of neutron DB user. Defaults to trove
neutron_db_password: (optional) Password that will be used for the neutron db user. Defaults to 'neutronpassword'
neutron_db_allowed_hosts: (optional) Hosts allowed to use the database Defaults to ['127.0.0.1']
trove_db_host: (optional) Host where user should be allowed all privileges for database. Defaults to 127.0.0.1
trove_db_user: (optional) Name of trove DB user. Defaults to trove
trove_db_password: (optional) Password that will be used for the trove db user. Defaults to 'trovepassword'
trove_db_allowed_hosts: (optional) Hosts allowed to use the database Defaults to ['127.0.0.1']
mysql_root_password: (optional) The MySQL root password. Puppet will attempt to set the root password and update `/root/.my.cnf` with it. Defaults to 'rootpassword'
mysql_sys_maint_password: (optional) The MySQL debian-sys-maint password. Debian only parameter. Defaults to 'sys_maint'
galera_clustercheck_dbuser: (optional) The MySQL username for Galera cluster check (using monitoring database) Defaults to 'clustercheck'
galera_clustercheck_dbpassword: (optional) The MySQL password for Galera cluster check Defaults to 'clustercheckpassword'
galera_clustercheck_ipaddress: (optional) The name or ip address of host running monitoring database (clustercheck) Defaults to '127.0.0.1'
open_files_limit: (optional) An integer that specifies the open_files_limit for MySQL Defaults to 65535
max_connections: (optional) An integer that specifies the max_connections for MySQL Defaults to 4096
mysql_systemd_override_settings: (optional) An hash of setting to override for MariaDB unit file. Defaults to {} Example : { 'LimitNOFILE' => 'infinity', 'LimitNPROC' => 4, 'TimeoutSec' => '30' }
firewall_settings: (optional) Allow to add custom parameters to firewall rules Should be an hash. Default to {}

Parameter Summary

api_eth (Any) => '127.0.0.1'
galera_master_name (Any) => 'mgmt001'
galera_internal_ips (Any) => ['127.0.0.1']
galera_gcache (Any) => '1G'
keystone_db_host (Any) => '127.0.0.1'
keystone_db_user (Any) => 'keystone'
keystone_db_password (Any) => 'keystonepassword'
keystone_db_allowed_hosts (Any) => ['127.0.0.1']
cinder_db_host (Any) => '127.0.0.1'
cinder_db_user (Any) => 'cinder'
cinder_db_password (Any) => 'cinderpassword'
cinder_db_allowed_hosts (Any) => ['127.0.0.1']
glance_db_host (Any) => '127.0.0.1'
glance_db_user (Any) => 'glance'
glance_db_password (Any) => 'glancepassword'
glance_db_allowed_hosts (Any) => ['127.0.0.1']
heat_db_host (Any) => '127.0.0.1'
heat_db_user (Any) => 'heat'
heat_db_password (Any) => 'heatpassword'
heat_db_allowed_hosts (Any) => ['127.0.0.1']
nova_db_host (Any) => '127.0.0.1'
nova_db_user (Any) => 'nova'
nova_db_password (Any) => 'novapassword'
nova_db_allowed_hosts (Any) => ['127.0.0.1']
neutron_db_host (Any) => '127.0.0.1'
neutron_db_user (Any) => 'neutron'
neutron_db_password (Any) => 'neutronpassword'
neutron_db_allowed_hosts (Any) => ['127.0.0.1']
trove_db_host (Any) => '127.0.0.1'
trove_db_user (Any) => 'trove'
trove_db_password (Any) => 'trovepassword'
trove_db_allowed_hosts (Any) => ['127.0.0.1']
mysql_root_password (Any) => 'rootpassword'
mysql_sys_maint_password (Any) => 'sys_maint'
galera_clustercheck_dbuser (Any) => 'clustercheck'
galera_clustercheck_dbpassword (Any) => 'clustercheckpassword'
galera_clustercheck_ipaddress (Any) => '127.0.0.1'
open_files_limit (Any) => 65535
max_connections (Any) => 4096
mysql_systemd_override_settings (Any) => {}
firewall_settings (Any) => {}