Puppet Class: mistral::db

Defined in:
manifests/db.pp

Overview

Class: mistral::db

Configure the Mistral database

Parameters

database_connection

Url used to connect to database. (Optional) Defaults to ‘sqlite:////var/lib/mistral/mistral.sqlite’

database_connection_recycle_time

Timeout when db connections should be reaped. (Optional) Defaults to $::os_service_default

database_max_pool_size

Maximum number of SQL connections to keep open in a pool. (Optional) Defaults to $::os_service_default

database_max_retries

Maximum db connection retries during startup. Setting -1 implies an infinite retry count. (Optional) Defaults to $::os_service_default

database_retry_interval

Interval between retries of opening a sql connection. (Optional) Defaults to $::os_service_default

database_max_overflow

If set, use this value for max_overflow with sqlalchemy. (Optional) Defaults to $::os_service_default

database_pool_timeout

(Optional) If set, use this value for pool_timeout with SQLAlchemy. Defaults to $::os_service_default

mysql_enable_ndb

(Optional) If True, transparently enables support for handling MySQL Cluster (NDB). Defaults to $::os_service_default

database_db_max_retries

(Optional) Maximum retries in case of connection error or deadlock error before error is raised. Set to -1 to specify an infinite retry count. Defaults to $::os_service_default

DEPRECATED PARAMETERS

database_min_pool_size

Minimum number of SQL connections to keep open in a pool. (Optional) Defaults to undef

Parameters:

  • database_connection (Any) (defaults to: 'sqlite:////var/lib/mistral/mistral.sqlite')
  • database_connection_recycle_time (Any) (defaults to: $::os_service_default)
  • database_max_pool_size (Any) (defaults to: $::os_service_default)
  • database_max_retries (Any) (defaults to: $::os_service_default)
  • database_retry_interval (Any) (defaults to: $::os_service_default)
  • database_max_overflow (Any) (defaults to: $::os_service_default)
  • database_pool_timeout (Any) (defaults to: $::os_service_default)
  • mysql_enable_ndb (Any) (defaults to: $::os_service_default)
  • database_db_max_retries (Any) (defaults to: $::os_service_default)
  • database_min_pool_size (Any) (defaults to: undef)


52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
# File 'manifests/db.pp', line 52

class mistral::db (
  $database_connection              = 'sqlite:////var/lib/mistral/mistral.sqlite',
  $database_connection_recycle_time = $::os_service_default,
  $database_max_pool_size           = $::os_service_default,
  $database_max_retries             = $::os_service_default,
  $database_retry_interval          = $::os_service_default,
  $database_max_overflow            = $::os_service_default,
  $database_pool_timeout            = $::os_service_default,
  $mysql_enable_ndb                 = $::os_service_default,
  $database_db_max_retries          = $::os_service_default,
  # DEPRECATED PARAMETERS
  $database_min_pool_size           = undef,
) {

  include mistral::deps

  if $database_min_pool_size {
    warning('The database_min_pool_size parameter is deprecated, and will be removed in a future release.')
  }

  # NOTE(spredzy): In order to keep backward compatibility we rely on the pick function
  # to use mistral::<myparam> if mistral::db::<myparam> isn't specified.
  $database_connection_real              = pick($::mistral::database_connection,$database_connection)
  $database_connection_recycle_time_real = pick($::mistral::database_idle_timeout, $database_connection_recycle_time)
  $database_max_pool_size_real           = pick($::mistral::database_max_pool_size,$database_max_pool_size)
  $database_max_retries_real             = pick($::mistral::database_max_retries,$database_max_retries)
  $database_retry_interval_real          = pick($::mistral::database_retry_interval,$database_retry_interval)
  $database_max_overflow_real            = pick($::mistral::database_max_overflow,$database_max_overflow)

  oslo::db { 'mistral_config':
    connection              => $database_connection_real,
    connection_recycle_time => $database_connection_recycle_time_real,
    max_pool_size           => $database_max_pool_size_real,
    max_retries             => $database_max_retries_real,
    retry_interval          => $database_retry_interval_real,
    max_overflow            => $database_max_overflow_real,
    pool_timeout            => $database_pool_timeout,
    mysql_enable_ndb        => $mysql_enable_ndb,
    db_max_retries          => $database_db_max_retries,
  }

}