Puppet Class: role::mariadb::labtestwikitech

Defined in:
modules/role/manifests/mariadb/labtestwikitech.pp

Overview

This class is used to host the labtestwikitech database

locally on labtestweb2xxx.  We're trying to keep
random labtest things off of the prod databases.


4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
# File 'modules/role/manifests/mariadb/labtestwikitech.pp', line 4

class role::mariadb::labtestwikitech {

    system::role { 'mariadb::wikitech':
        description => 'Wikitech Database',
    }

    include ::standard
    include ::profile::mariadb::grants::core
    include ::profile::mariadb::monitor
    include passwords::misc::scripts

    include mariadb::packages_wmf
    include mariadb::service

    class { 'mariadb::config':
        config  => 'role/mariadb/mysqld_config/wikitech.my.cnf.erb',
        datadir => '/srv/sqldata',
        basedir => '/opt/wmf-mariadb101',
        tmpdir  => '/srv/tmp',
    }

    # mysql monitoring and administration from root clients/tendril
    $mysql_root_clients = join($::network::constants::special_hosts['production']['mysql_root_clients'], ' ')
    ferm::service { 'mysql_admin_standard':
        proto  => 'tcp',
        port   => '3306',
        srange => "(${mysql_root_clients})",
    }
    ferm::service { 'mysql_admin_alternative':
        proto  => 'tcp',
        port   => '3307',
        srange => "(${mysql_root_clients})",
    }

    # mysql from deployment master servers and maintenance hosts (T98682, T109736)
    ferm::service { 'mysql_deployment_mwmaint':
        proto  => 'tcp',
        port   => '3306',
        srange => '($DEPLOYMENT_HOSTS $MAINTENANCE_HOSTS)',
    }

    service { 'mariadb':
        ensure  => running,
        require => Class['mariadb::packages_wmf', 'mariadb::config'],
    }
}