mysqld/0000770000014600001470000000000012511177017011767 5ustar mysqldmysqldmysqld/my.cnf0000660000014600001470000000004012461434251013077 0ustar mysqldmysqld!includedir /etc/mysqld/conf.d/ mysqld/conf.d/0000770000014600001470000000000012510762272013140 5ustar mysqldmysqldmysqld/conf.d/05-ssd.cnf.template0000660000014600001470000000033612460201511016444 0ustar mysqldmysqld############################################################ ################### MAINTAINED BY PUPPET ################### ############################################################ [mysqld] innodb_flush_neighbors = 0 mysqld/conf.d/02-master.cnf0000777000014600001470000000000012510760047021511 2./02-master.cnf.templateustar mysqldmysqldmysqld/conf.d/98-prompt.cnf0000660000014600001470000000034312510760047015406 0ustar mysqldmysqld############################################################ ################### MAINTAINED BY PUPPET ################### ############################################################ [mysql] prompt = (\u@dcs3-lab) [\d]>\_ mysqld/conf.d/99-local.cnf0000660000014600001470000000051712510762272015165 0ustar mysqldmysqld[mysqld] explicit_defaults_for_timestamp = OFF max_user_connections = 200 innodb_buffer_pool_size = 3G interactive-timeout = 188000 net_write_timeout = 36000 net_read_timeout = 36000 innodb_lock_wait_timeout = 1200 max_allowed_packet = 32M wait_timeout = 3600 skip-slave-start #skip-grant-tables server-id = 99022 mysqld/conf.d/01-global.cnf0000660000014600001470000000462212510762262015312 0ustar mysqldmysqld############################################################ ################### MAINTAINED BY PUPPET ################### ############################################################ [client] socket = /tmp/mysql.sock port = 3306 [mysqld_safe] pid-file = /tmp/mysql.pid socket = /tmp/mysql.sock [mysqld] basedir = /usr datadir = /data/sql tmpdir = /data/tmp pid-file = /tmp/mysql.pid socket = /tmp/mysql.sock log_error = /var/log/mysqld/mysqld.err general_log_file = /var/log/mysqld/general.log user = mysqld port = 3306 character_set_server = utf8 collation_server = utf8_general_ci init_connect = 'SET collation_connection = utf8_general_ci' optimizer_switch = 'index_merge_intersection=off' explicit_defaults_for_timestamp = ON ### Slow log ### slow_query_log_file = /data/tmp-mysql/mysqld.long long_query_time = 0 ### Fail safe ### sync_binlog = 10000 sync_master_info = 10000 sync_relay_log = 10000 sync_relay_log_info = 10000 master_info_repository = TABLE relay_log_info_repository = TABLE ### Tunning ### back_log = 1024 interactive_timeout = 20 join_buffer_size = 2M key_buffer_size = 512K max_allowed_packet = 16M max_connect_errors = 1844674407370954751 max_connections = 800 max_user_connections = 50 myisam_sort_buffer_size = 512K query_cache_size = 0 query_cache_type = 0 read_buffer_size = 512K sort_buffer_size = 256K thread_cache_size = 32 wait_timeout = 20 slave_net_timeout = 30 ### InnoDB ### innodb_file_format = Barracuda innodb_flush_method = O_DIRECT innodb_data_file_path = ibdata1:21M:autoextend innodb_buffer_pool_size = 1G innodb_log_file_size = 200M innodb_log_buffer_size = 16M innodb_lock_wait_timeout = 50 innodb_flush_log_at_trx_commit = 1 innodb_file_per_table = ON innodb_autoinc_lock_mode = 0 innodb_open_files = 2000 ### Replication ### server_id = 0 expire_logs_days = 2 max_binlog_size = 500M binlog_ignore_db = mysql relay_log = /data/mysql_binary/mysql-relay-bin relay_log_space_limit = 5G replicate_ignore_db = mysql [mysql] connect_timeout = 2 no-auto-rehash [mysqldump] max_allowed_packet = 16M quick = ON [isamchk] key_buffer = 128M sort_buffer = 128M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 128M sort_buffer = 128M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout = ON mysqld/conf.d/03-slave.cnf0000777000014600001470000000000012460201511021002 203-slave.cnf.templateustar mysqldmysqldmysqld/conf.d/02-master.cnf.template0000660000014600001470000000044212460201511017141 0ustar mysqldmysqld############################################################ ################### MAINTAINED BY PUPPET ################### ############################################################ [mysqld] log_bin = /data/mysql_binary/mysql-bin.log binlog_format = MIXED log_slave_updates = ON mysqld/conf.d/04-slowlog.cnf.template0000660000014600001470000000037012460201511017336 0ustar mysqldmysqld############################################################ ################### MAINTAINED BY PUPPET ################### ############################################################ [mysqld] slow_query_log = ON log_slow_slave_statements = ON mysqld/conf.d/03-slave.cnf.template0000660000014600001470000000032312460201511016757 0ustar mysqldmysqld############################################################ ################### MAINTAINED BY PUPPET ################### ############################################################ [mysqld] read_only = ON