金华建设局政务网站,包头做网站企业,看空间,大连网站设计哪个最好docker封装mysql镜像发布时间#xff1a;2020-03-13 12:18:07编辑#xff1a;admin阅读(967)一、概述直接使用官方的镜像docker pull mysql:5.7但是mysqld.cnf并没有优化#xff0c;还是默认的。二、封装镜像创建目录# dockerfile目录mkdir -p /opt/dockerfile/mysql# 持久化…docker封装mysql镜像发布时间2020-03-13 12:18:07编辑admin阅读(967)一、概述直接使用官方的镜像docker pull mysql:5.7但是mysqld.cnf并没有优化还是默认的。二、封装镜像创建目录# dockerfile目录mkdir -p /opt/dockerfile/mysql# 持久化目录mkdir -p /data/mysql/data/opt/dockerfile/mysql 目录结构如下./├── dockerfile├── mysqld.cnf└── run.shdockerfileFROM mysql:5.7ADD mysqld.cnf /etc/mysql/mysql.conf.d/mysqld.cnfmysqld.cnf[client]port3306socket /var/run/mysqld/mysqld.sock[mysql]no-auto-rehashauto-rehashdefault-character-setutf8mb4[mysqld]###basic settingsserver-id 2pid-file /var/run/mysqld/mysqld.pidsocket /var/run/mysqld/mysqld.sockdatadir /var/lib/mysql#log-error /var/lib/mysql/error.log# By default we only accept connections from localhost#bind-address 127.0.0.1# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links0character-set-server utf8mb4sql_modeNO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTIONdefault-storage-engineINNODBtransaction_isolation READ-COMMITTEDauto_increment_offset 1connect_timeout 20max_connections 3500wait_timeout86400interactive_timeout86400interactive_timeout 7200log_bin_trust_function_creators 1wait_timeout 7200sort_buffer_size 32Mjoin_buffer_size 128Mmax_allowed_packet 1024Mtmp_table_size 2097152explicit_defaults_for_timestamp 1read_buffer_size 16Mread_rnd_buffer_size 32Mquery_cache_type 1query_cache_size 2Mtable_open_cache 1500table_definition_cache 1000thread_cache_size 768back_log 3000open_files_limit 65536skip-name-resolve########log settings########log-outputFILEgeneral_log ONgeneral_log_file/var/lib/mysql/general.logslow_query_log ONslow_query_log_file/var/lib/mysql/slowquery.loglong_query_time10#log-error/var/lib/mysql/error.loglog_queries_not_using_indexes OFFlog_throttle_queries_not_using_indexes 0#expire_logs_days 120min_examined_row_limit 100########innodb settings########innodb_io_capacity 4000innodb_io_capacity_max 8000innodb_buffer_pool_size 6144Minnodb_file_per_table oninnodb_buffer_pool_instances 20innodb_buffer_pool_load_at_startup 1innodb_buffer_pool_dump_at_shutdown 1innodb_log_file_size 300Minnodb_log_files_in_group 2innodb_log_buffer_size 16Minnodb_undo_logs 128#innodb_undo_tablespaces 3#innodb_undo_log_truncate 1#innodb_max_undo_log_size 2Ginnodb_flush_method O_DIRECTinnodb_flush_neighbors 1innodb_purge_threads 4innodb_large_prefix 1innodb_thread_concurrency 64innodb_print_all_deadlocks 1innodb_strict_mode 1innodb_sort_buffer_size 64Minnodb_flush_log_at_trx_commit1innodb_autoextend_increment64innodb_concurrency_tickets5000innodb_old_blocks_time1000innodb_open_files65536innodb_stats_on_metadata0innodb_file_per_table1innodb_checksum_algorithm0#innodb_data_file_pathibdata1:60M;ibdata2:60M;autoextend:max:1Ginnodb_data_file_path ibdata1:12M:autoextend#innodb_temp_data_file_path ibtmp1:500M:autoextend:max:20G#innodb_buffer_pool_dump_pct 40#innodb_page_cleaners 4#innodb_purge_rseg_truncate_frequency 128binlog_gtid_simple_recovery1#log_timestampssystem##############delayed_insert_limit 100delayed_insert_timeout 300delayed_queue_size 1000delay_key_write ONdisconnect_on_expired_password ONdiv_precision_increment 4end_markers_in_json OFFeq_range_index_dive_limit 10innodb_adaptive_flushing ONinnodb_adaptive_hash_index ONinnodb_adaptive_max_sleep_delay 150000#innodb_additional_mem_pool_size 2097152innodb_autoextend_increment 64innodb_autoinc_lock_mode 1run.sh#!/bin/bashdocker run -d --name mysqld_prod --restartalways -e MYSQL_ROOT_PASSWORD123456 -p 3306:3306 -v /data/mysql/data:/var/lib/mysql mysqld_prod:5.7 --character-set-serverutf8mb4 --collation-serverutf8mb4_unicode_ci生成镜像cd /opt/dockerfile/mysqldocker build -t mysqld_prod:5.7 .启动镜像bash run.sh三、测试连接连接测试关键字
