mysql having ct_GitHub - ct1104/mysqltools: 一个用于快速构建大规模，高质量，全自动化的 mysql分布式集群环境的工具；包含mysql 安装、备份、监控、高...

谈谈mysqltools如何实现高质量

1、mysqltools是流程化的，如上面的安装MySQL就包含20+的小步骤，尽量做到面面俱到

2、mysqltools尽可能的在各个小步骤中都保持高的质量、比如/etc/my.cnf各个参数的配置都会根据主机当前的cpu & 内存进行配置

以下是一个host_132的/etc/my.cnf 这些都是由mysqltools针对单机环境动态生成的

[mysql]

auto-rehash

[mysqld]

####: for global

user =mysql # mysql

basedir =/usr/local/mysql/ # /usr/local/mysql/

datadir =/database/mysql/data/3306 # /usr/local/mysql/data

server_id =653 # 0

port =3306 # 3306

character_set_server =utf8 # latin1

explicit_defaults_for_timestamp =off # off

log_timestamps =system # utc

socket =/tmp/mysql.sock # /tmp/mysql.sock

read_only =0 # off

skip_name_resolve =1 # 0

auto_increment_increment =1 # 1

auto_increment_offset =1 # 1

lower_case_table_names =1 # 0

secure_file_priv = # null

open_files_limit =65536 # 1024

max_connections =256 # 151

thread_cache_size =128 # 9

table_open_cache =4096 # 2000

table_definition_cache =2000 # 1400

table_open_cache_instances =32 # 16

####: for binlog

binlog_format =row # row

log_bin =mysql-bin # off

binlog_rows_query_log_events =on # off

log_slave_updates =on # off

expire_logs_days =7 # 0

binlog_cache_size =65536 # 65536(64k)

binlog_checksum =none # CRC32

sync_binlog =1 # 1

slave-preserve-commit-order =ON #

####: for error-log

log_error =err.log # /usr/local/mysql/data/localhost.localdomain.err

general_log =off # off

general_log_file =general.log # hostname.log

####: for slow query log

slow_query_log =on # off

slow_query_log_file =slow.log # hostname.log

log_queries_not_using_indexes =on # off

long_query_time =2.000000 # 10.000000

####: for gtid

gtid_executed_compression_period =1000 # 1000

gtid_mode =on # off

enforce_gtid_consistency =on # off

####: for replication

skip_slave_start =0 #

master_info_repository =table # file

relay_log_info_repository =table # file

slave_parallel_type =logical_clock # database | LOGICAL_CLOCK

slave_parallel_workers =4 # 0

rpl_semi_sync_master_enabled =1 # 0

rpl_semi_sync_slave_enabled =1 # 0

rpl_semi_sync_master_timeout =1000 # 1000(1 second)

plugin_load_add =semisync_master.so #

plugin_load_add =semisync_slave.so #

binlog_group_commit_sync_delay =500 # 500(0.05%秒)、默认值0

binlog_group_commit_sync_no_delay_count = 13 # 0

####: for innodb

default_storage_engine =innodb # innodb

default_tmp_storage_engine =innodb # innodb

innodb_data_file_path =ibdata1:64M:autoextend # ibdata1:12M:autoextend

innodb_temp_data_file_path =ibtmp1:12M:autoextend # ibtmp1:12M:autoextend

innodb_buffer_pool_filename =ib_buffer_pool # ib_buffer_pool

innodb_log_group_home_dir =./ # ./

innodb_log_files_in_group =8 # 2

innodb_log_file_size =128M # 50331648(48M)

innodb_file_per_table =on # on

innodb_online_alter_log_max_size =128M # 134217728(128M)

innodb_open_files =65535 # 2000

innodb_page_size =16k # 16384(16k)

innodb_thread_concurrency =0 # 0

innodb_read_io_threads =4 # 4

innodb_write_io_threads =4 # 4

innodb_purge_threads =4 # 4

innodb_print_all_deadlocks =on # off

innodb_deadlock_detect =on # on

innodb_lock_wait_timeout =50 # 50

innodb_spin_wait_delay =6 # 6

innodb_autoinc_lock_mode =2 # 1

innodb_io_capacity =200 # 200

innodb_io_capacity_max =2000 # 2000

#--------Persistent Optimizer Statistics

innodb_stats_auto_recalc =on # on

innodb_stats_persistent =on # on

innodb_stats_persistent_sample_pages =20 # 20

innodb_buffer_pool_instances =1

innodb_adaptive_hash_index =on # on

innodb_change_buffering =all # all

innodb_change_buffer_max_size =25 # 25

innodb_flush_neighbors =1 # 1

#innodb_flush_method = #

innodb_doublewrite =on # on

innodb_log_buffer_size =128M # 16777216(16M)

innodb_flush_log_at_timeout =1 # 1

innodb_flush_log_at_trx_commit =1 # 1

innodb_buffer_pool_size =1152M # 134217728(128M)

autocommit =1 # 1

#--------innodb scan resistant

innodb_old_blocks_pct =37 # 37

innodb_old_blocks_time =1000 # 1000

#--------innodb read ahead

innodb_read_ahead_threshold =56 # 56 (0..64)

innodb_random_read_ahead =OFF # OFF

#--------innodb buffer pool state

innodb_buffer_pool_dump_pct =25 # 25

innodb_buffer_pool_dump_at_shutdown =ON # ON

innodb_buffer_pool_load_at_startup =ON # ON

#### for performance_schema

performance_schema =on # on

performance_schema_consumer_global_instrumentation =on # on

performance_schema_consumer_thread_instrumentation =on # on

performance_schema_consumer_events_stages_current =on # off

performance_schema_consumer_events_stages_history =on # off

performance_schema_consumer_events_stages_history_long =off # off

performance_schema_consumer_statements_digest =on # on

performance_schema_consumer_events_statements_current =on # on

performance_schema_consumer_events_statements_history =on # on

performance_schema_consumer_events_statements_history_long =off # off

performance_schema_consumer_events_waits_current =on # off

performance_schema_consumer_events_waits_history =on # off

performance_schema_consumer_events_waits_history_long =off # off

performance-schema-instrument ='memory/%=COUNTED'

由上面的内容可以看到mysqltools生成的/etc/my.cnf在各个方面都是比较全面的(配置是在一个2core 2G的vm虚拟机上复制出来的)