x/compass-adapters
Code Issues Proposed changes
compass-adapters/chef/cookbooks/mysql/attributes/server.rb
xiaodongwang ddb0e1af4f add chef support to install openstack in sle11sp3 
Change-Id: I8c12083d5e46f3b43a8df069f77058e3ee965689
2015-04-02 22:12:58 -07:00

180 lines
9.3 KiB
Ruby
Raw Permalink Blame History

#
# Cookbook Name:: mysql
# Attributes:: server
#
# Copyright 2008-2013, Opscode, Inc.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#
# Probably driven from wrapper cookbooks, environments, or roles.
# Keep in this namespace for backwards compat
default['mysql']['bind_address'] = node.attribute?('cloud') && node['cloud']['local_ipv4'] ? node['cloud']['local_ipv4'] : node['ipaddress']
default['mysql']['port'] = 3306
default['mysql']['nice'] = 0
# eventually remove? where is this used?
if attribute?('ec2')
default['mysql']['ec2_path'] = '/mnt/mysql'
default['mysql']['ebs_vol_dev'] = '/dev/sdi'
default['mysql']['ebs_vol_size'] = 50
end
# actual configs start here
default['mysql']['auto-increment-increment'] = 1
default['mysql']['auto-increment-offset'] = 1
default['mysql']['allow_remote_root'] = false
default['mysql']['remove_anonymous_users'] = false
default['mysql']['remove_test_database'] = false
default['mysql']['root_network_acl'] = nil
default['mysql']['tunable']['character-set-server'] = 'utf8'
default['mysql']['tunable']['collation-server'] = 'utf8_general_ci'
default['mysql']['tunable']['lower_case_table_names'] = nil
default['mysql']['tunable']['back_log'] = '128'
default['mysql']['tunable']['key_buffer_size'] = '256M'
default['mysql']['tunable']['myisam_sort_buffer_size'] = '8M'
default['mysql']['tunable']['myisam_max_sort_file_size'] = '2147483648'
default['mysql']['tunable']['myisam_repair_threads'] = '1'
default['mysql']['tunable']['myisam-recover'] = 'BACKUP'
default['mysql']['tunable']['max_allowed_packet'] = '16M'
default['mysql']['tunable']['max_connections'] = '3000'
default['mysql']['tunable']['max_connect_errors'] = '10'
default['mysql']['tunable']['concurrent_insert'] = '2'
default['mysql']['tunable']['connect_timeout'] = '60'
default['mysql']['tunable']['tmp_table_size'] = '32M'
default['mysql']['tunable']['max_heap_table_size'] = node['mysql']['tunable']['tmp_table_size']
default['mysql']['tunable']['bulk_insert_buffer_size'] = node['mysql']['tunable']['tmp_table_size']
default['mysql']['tunable']['net_read_timeout'] = '30'
default['mysql']['tunable']['net_write_timeout'] = '30'
default['mysql']['tunable']['table_cache'] = '128'
default['mysql']['tunable']['table_open_cache'] = node['mysql']['tunable']['table_cache'] # table_cache is deprecated
# in favor of table_open_cache
default['mysql']['tunable']['thread_cache_size'] = 8
default['mysql']['tunable']['thread_concurrency'] = 10
default['mysql']['tunable']['thread_stack'] = '256K'
default['mysql']['tunable']['sort_buffer_size'] = '2M'
default['mysql']['tunable']['read_buffer_size'] = '128k'
default['mysql']['tunable']['read_rnd_buffer_size'] = '256k'
default['mysql']['tunable']['join_buffer_size'] = '128k'
default['mysql']['tunable']['wait_timeout'] = '180'
default['mysql']['tunable']['open-files-limit'] = '1024'
default['mysql']['tunable']['sql_mode'] = nil
default['mysql']['tunable']['skip-character-set-client-handshake'] = false
default['mysql']['tunable']['skip-name-resolve'] = false
default['mysql']['tunable']['slave_compressed_protocol'] = 0
default['mysql']['tunable']['server_id'] = nil
default['mysql']['tunable']['log_bin'] = nil
default['mysql']['tunable']['log_bin_trust_function_creators'] = false
default['mysql']['tunable']['relay_log'] = nil
default['mysql']['tunable']['relay_log_index'] = nil
default['mysql']['tunable']['log_slave_updates'] = false
default['mysql']['tunable']['replicate_do_db'] = nil
default['mysql']['tunable']['replicate_do_table'] = nil
default['mysql']['tunable']['replicate_ignore_db'] = nil
default['mysql']['tunable']['replicate_ignore_table'] = nil
default['mysql']['tunable']['replicate_wild_do_table'] = nil
default['mysql']['tunable']['replicate_wild_ignore_table'] = nil
default['mysql']['tunable']['sync_binlog'] = 0
default['mysql']['tunable']['skip_slave_start'] = false
default['mysql']['tunable']['read_only'] = false
default['mysql']['tunable']['log_error'] = nil
default['mysql']['tunable']['log_warnings'] = false
default['mysql']['tunable']['log_queries_not_using_index'] = true
default['mysql']['tunable']['log_bin_trust_function_creators'] = false
default['mysql']['tunable']['innodb_log_file_size'] = '5M'
# default['mysql']['tunable']['innodb_buffer_pool_size'] = '128M'
default['mysql']['tunable']['innodb_buffer_pool_size'] = (node['memory']['total'].to_i/1024) < 4096 ? '128M' : '4096M'
default['mysql']['tunable']['innodb_buffer_pool_instances'] = '4'
default['mysql']['tunable']['innodb_additional_mem_pool_size'] = '8M'
default['mysql']['tunable']['innodb_data_file_path'] = 'ibdata1:10M:autoextend'
default['mysql']['tunable']['innodb_flush_method'] = false
default['mysql']['tunable']['innodb_log_buffer_size'] = '8M'
default['mysql']['tunable']['innodb_write_io_threads'] = '4'
default['mysql']['tunable']['innodb_io_capacity'] = '200'
default['mysql']['tunable']['innodb_file_per_table'] = true
default['mysql']['tunable']['innodb_lock_wait_timeout'] = '60'
default['mysql']['tunable']['innodb_rollback_on_timeout'] = false
if node['cpu'].nil? || node['cpu']['total'].nil?
default['mysql']['tunable']['innodb_thread_concurrency'] = '8'
default['mysql']['tunable']['innodb_commit_concurrency'] = '8'
default['mysql']['tunable']['innodb_read_io_threads'] = '8'
else
default['mysql']['tunable']['innodb_thread_concurrency'] = (node['cpu']['total'].to_i * 2).to_s
default['mysql']['tunable']['innodb_commit_concurrency'] = (node['cpu']['total'].to_i * 2).to_s
default['mysql']['tunable']['innodb_read_io_threads'] = (node['cpu']['total'].to_i * 2).to_s
end
default['mysql']['tunable']['innodb_flush_log_at_trx_commit'] = '1'
default['mysql']['tunable']['innodb_support_xa'] = true
default['mysql']['tunable']['innodb_table_locks'] = true
default['mysql']['tunable']['skip-innodb-doublewrite'] = false
default['mysql']['tunable']['transaction-isolation'] = nil
default['mysql']['tunable']['query_cache_limit'] = '1M'
default['mysql']['tunable']['query_cache_size'] = '16M'
default['mysql']['tunable']['long_query_time'] = 2
default['mysql']['tunable']['expire_logs_days'] = 10
default['mysql']['tunable']['max_binlog_size'] = '100M'
default['mysql']['tunable']['binlog_cache_size'] = '32K'
default['mysql']['tmpdir'] = ['/tmp']
# default['mysql']['log_dir'] = node['mysql']['data_dir']
default['mysql']['log_files_in_group'] = false
default['mysql']['innodb_status_file'] = false
unless node['platform_family'] == 'rhel' && node['platform_version'].to_i < 6
# older RHEL platforms don't support these options
default['mysql']['tunable']['event_scheduler'] = 0
default['mysql']['tunable']['binlog_format'] = 'statement' if node['mysql']['tunable']['log_bin']
end
default['mysql']['version'] = '5.1'
if node['platform_family'] == 'rhel' && node['platform_version'].to_i > 6
# mysql version is 5.6 on el7
default['mysql']['version'] = '5.6'
end
if node['platform_family'] == 'suse' && node['platform_version'].to_i >= 11
# mysql version is 5.6 on sles11sp3
default['mysql']['version'] = '5.6'
end
# security options
# @see http://www.symantec.com/connect/articles/securing-mysql-step-step
# @see http://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_chroot
default['mysql']['security']['chroot'] = nil
# @see http://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_safe-user-create
default['mysql']['security']['safe_user_create'] = nil
# @see http://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_secure-auth
default['mysql']['security']['secure_auth'] = nil
# @see http://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_symbolic-links
default['mysql']['security']['skip_symbolic_links'] = nil
# @see http://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_secure-file-priv
default['mysql']['security']['secure_file_priv'] = nil
# @see http://dev.mysql.com/doc/refman/5.7/en/server-options.html#option_mysqld_skip-show-database
default['mysql']['security']['skip_show_database'] = nil
# @see http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_local_infile
default['mysql']['security']['local_infile'] = nil
View Git Blame Copy Permalink