Puppet Class: xdmod::database

Defined in:
manifests/database.pp

Summary

Manage XDMoD databases

Overview



3
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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
# File 'manifests/database.pp', line 3

class xdmod::database {
  include mysql::server

  Mysql::Db {
    ensure    => 'present',
    user      => $xdmod::database_user,
    password  => $xdmod::database_password,
    host      => $xdmod::web_host,
    charset   => 'latin1',
    collate   => 'latin1_swedish_ci',
    grant     => ['ALL'],
  }

  mysql::db { 'mod_hpcdb': }
  mysql::db { 'mod_logger': }
  mysql::db { 'mod_shredder': }
  mysql::db { 'moddb': }
  mysql::db { 'modw': }
  mysql::db { 'modw_aggregates': }
  mysql::db { 'modw_filters': }
  if $xdmod::enable_cloud_realm {
    mysql::db { 'modw_cloud': }
  }
  if $xdmod::enable_ondemand {
    mysql::db { 'modw_ondemand': }
  }

  if $xdmod::enable_appkernel {
    mysql::db { 'mod_appkernel':
      user     => $xdmod::akrr_database_user,
      password => $xdmod::akrr_database_password,
      host     => $xdmod::akrr_host,
    }

    mysql::db { 'mod_akrr':
      user     => $xdmod::akrr_database_user,
      password => $xdmod::akrr_database_password,
      host     => $xdmod::akrr_host,
    }

    mysql::db { 'modw-akrr':
      dbname   => 'modw',
      user     => $xdmod::akrr_database_user,
      password => $xdmod::akrr_database_password,
      host     => $xdmod::akrr_host,
      grant    => ['SELECT'],
      require  => Mysql::Db['modw'],
    }

    if $xdmod::web_host != $xdmod::akrr_host {
      mysql::db { 'mod_appkernel-xdmod':
        dbname   => 'mod_appkernel',
        user     => $xdmod::akrr_database_user,
        password => $xdmod::akrr_database_password,
      }

      mysql::db { 'mod_akrr-xdmod':
        dbname   => 'mod_akrr',
        user     => $xdmod::akrr_database_user,
        password => $xdmod::akrr_database_password,
      }
    }
  }

  if $xdmod::enable_supremm {
    mysql::db { 'modw_etl': }
    mysql::db { 'modw_supremm':
      charset => 'utf8',
      collate => 'utf8_general_ci',
    }
    mysql::db { 'modw_jobefficiency': }
  }
}