-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy path02_mysql.rb
28 lines (28 loc) · 1.21 KB
/
02_mysql.rb
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
## MySQL
default[:mysql][:enabled] = true
default[:mysql][:packages] = %w{
Percona-Server-server-56
Percona-Server-client-56
Percona-Server-shared-56
}
default[:mysql][:service_action] = [:disable, :stop]
if node[:mysql][:enabled]
default[:mysql][:service_action] = [:enable, :start]
end
default[:mysql][:config][:user] = 'mysql'
default[:mysql][:config][:group] = 'mysql'
default[:mysql][:config][:max_allowed_packet] = '1M'
default[:mysql][:config][:innodb_buffer_pool_size] = '64M'
default[:mysql][:config][:innodb_log_file_size] = '16M'
default[:mysql][:config][:innodb_buffer_pool_instances] = '1'
default[:mysql][:config][:innodb_file_format] = 'Barracuda'
default[:mysql][:config][:innodb_file_format_max] = node[:mysql][:config][:innodb_file_format]
default[:mysql][:config][:query_cache_size] = '64M'
default[:mysql][:config][:tmp_table_size] = '64M'
default[:mysql][:config][:table_open_cache] = '1024'
default[:mysql][:config][:max_connections] = '128'
default[:mysql][:config][:thread_cache] = '128'
default[:mysql][:config][:sort_buffer_size] = '512K'
default[:mysql][:config][:read_buffer_size] = '256K'
default[:mysql][:config][:read_rnd_buffer_size] = '256K'
default[:mysql][:config][:join_buffer_size] = '256K'