forked from rgevaert/puppet-mysql
-
Notifications
You must be signed in to change notification settings - Fork 2
/
README
59 lines (47 loc) · 1.18 KB
/
README
1
2
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
This module manages MySQL. It gives you the choice MySQL
server you want to use: Oracle, MariaDB or Percona
Only tested on (and probably only works on) Ubuntu
Parameters, first one is the default:
- type : oracle|mariadb|percona
- multi: false|true
Requires: puppetlabs/apt
Sample Usages:
1) Install mariadb MySQL server:
class {
'mysql':
type => 'mariadb';
}
2) Install Oracle MySQL that come with the Debian
repositories. Setup multiple MySQL instance with
MySQLd_multi.
class {
'mysql':
multi => true;
}
mysql::multi::instance{
'mysqld1':
groupnr => 1,
bind_address => '0.0.0.0',
port => 3307;
'mysqld2':
groupnr => 2,
bind_address => '0.0.0.0',
port => 3308;
'mysqld3':
groupnr => 3,
bind_address => '0.0.0.0',
port => 3309,
ensure => 'stopped';
}
3) Change a setting in your MySQL configuration.
mysql::config::param {
'bind-address':
section => 'mysqld',
value => '0.0.0.0';
}
mysql::config::param {
'bind-address1':
section => 'mysqld1',
param => 'bind-address',
value => '0.0.0.0';
}