{"id":810,"date":"2024-01-09T13:36:13","date_gmt":"2024-01-09T05:36:13","guid":{"rendered":"https:\/\/www.anger.ltd\/?p=810"},"modified":"2024-01-30T15:38:12","modified_gmt":"2024-01-30T07:38:12","slug":"%e8%87%aa%e5%8a%a8%e9%83%a8%e7%bd%b2mysql%e5%ae%b9%e5%99%a8%e7%9a%84shell%e8%84%9a%e6%9c%ac","status":"publish","type":"post","link":"https:\/\/www.anger.ltd\/index.php\/2024\/01\/09\/%e8%87%aa%e5%8a%a8%e9%83%a8%e7%bd%b2mysql%e5%ae%b9%e5%99%a8%e7%9a%84shell%e8%84%9a%e6%9c%ac\/","title":{"rendered":"\u81ea\u52a8\u90e8\u7f72MySQL\u5bb9\u5668\u7684shell\u811a\u672c"},"content":{"rendered":"\n

\u5199\u5728\u524d\u9762<\/h4>\n\n\n\n

\u6700\u8fd1\u7ecf\u5e38\u9700\u8981\u901a\u8fc7Docker\u90e8\u7f72\u5355\u8282\u70b9\u6216\u96c6\u7fa4\u7684MySQL\uff0c\u6240\u4ee5\u7b80\u5355\u5199\u4e86\u4e00\u4e2a\u90e8\u7f72\u811a\u672c<\/p>\n\n\n\n

\u521b\u5efa\u811a\u672c<\/h4>\n\n\n\n

\u521b\u5efa\u76ee\u5f55<\/p>\n\n\n\n

#\u521b\u5efa\u76ee\u5f55\nmkdir \/opt\/mysql && cd \/opt\/mysql\n#\u7f16\u8f91\u6587\u4ef6\nvim run.sh<\/code><\/pre>\n\n\n\n
#!\/bin\/bash\n#author: Anger\n#\u81ea\u52a8\u90e8\u7f72MySQL\u5bb9\u5668\u811a\u672c\n\ndocker version > \/dev\/null 2>&1\n\n#\u5224\u65ad\u662f\u5426\u5b89\u88c5docker\nif [ $? != 0 ];then\n        echo \"\u6ca1\u5b89\u88c5docker\uff0c\u8bf7\u5b89\u88c5docker\u540e\u518d\u6267\u884c\"\n        exit 1\nfi\n\n#\u914d\u7f6e\u9ed8\u8ba4\u503c\npassword=mysql123456\nport=3306\n\n#\u8f93\u5165\u65b0\u53d8\u91cf\nread -p \"\u8f93\u5165\u4e00\u4e2a\u5bc6\u7801(\u9ed8\u8ba4\u5bc6\u7801\uff1amysql123456)\" repass\n\nread -p \"\u8f93\u5165\u5bb9\u5668\u7aef\u53e3(\u9ed8\u8ba4\u4e3a3306)\" report\n\n#\u5982\u679c\u53d8\u91cf\u4e0d\u4e3a\u7a7a\uff0c\u5219\u91cd\u65b0\u8d4b\u503c\u7ed9\u9ed8\u8ba4\u53d8\u91cf\nif [ -n \"${repass}\" ];then\n        password=${repass}\nfi\n\nif [ -n \"${report}\" ];then\n        port=${report}\nfi\n\n#\u4e0a\u9762\u7684\u5224\u65ad\u4e5f\u53ef\u4ee5\u5199\u6210\u8fd9\u6837\n#[ -n \"${repass}\" ] && password=${repass}\n#[ -n \"${report}\" ] && port=${report}\n\n#\u521b\u5efa\u6301\u4e45\u5316\u76ee\u5f55\nmkdir -p \/data\/mysql\/{data,conf,log}\n\n#\u590d\u5236\u6587\u4ef6\u5230\u6301\u4e45\u5316\u76ee\u5f55\ncp .\/my.cnf \/data\/mysql\/conf\n\n#\u542f\u52a8\u5bb9\u5668\ndocker run -d --name=mysql -p ${port}:3306 -v \/data\/mysql\/data:\/var\/lib\/mysql -v \/data\/mysql\/log:\/var\/log\/mysql -v \/data\/mysql\/conf:\/etc\/mysql -e MYSQL_ROOT_PASSWORD=${password} -e TZ=Asia\/Shanghai mysql:5.7\n\nipadd=$(ip addr show eth0<\/mark> | grep -oP '(?<=inet\\s)\\d+(\\.\\d+){3}';)\n\n#\u8f93\u51fa\u4fe1\u606f\necho \"\u90e8\u7f72\u5b8c\u6210,\u5730\u5740\u4e3a\uff1a${ipadd},\u9ed8\u8ba4\u7528\u6237\u540d\uff1aroot,\u5bc6\u7801\u4e3a\uff1a${password},\u7aef\u53e3\u4e3a\uff1a${port}\"<\/code><\/pre>\n\n\n\n
\n
\u5907\u6ce8\uff1a<\/p>\n\u83b7\u53d6\u7f51\u5361\u7684\u4f4d\u7f6e\u6709\u53ef\u80fd\u4f1a\u62a5\u9519\uff0c\u56e0\u4e3a\u6709\u4e9b\u865a\u62df\u673a\u7684\u9ed8\u8ba4\u7f51\u5361\u4e0d\u662feth0\uff0c\u53ef\u6839\u636e\u5b9e\u9645\u60c5\u51b5\u66f4\u6539<\/cite><\/blockquote>\n\n\n\n
\u521b\u5efamy.cnf<\/p>\n\n\n\n
#\u7f16\u8f91\u6587\u4ef6\nvim my.cnf<\/code><\/pre>\n\n\n\n
[mysqld]\nport = 3306\nbind-address = 0.0.0.0\nserver-id = 1\n\n#basedir = \/var\/lib\/mysql\n#datadir = \/var\/lib\/mysql\/data\n\ncharacter-set-server = utf8mb4\n\nskip-name-resolve\nback_log = 300\n\nmax_connections = 1000\nmax_connect_errors = 6000\nopen_files_limit = 65535\ntable_open_cache = 128\nmax_allowed_packet = 500M\nbinlog_cache_size = 1M\nmax_heap_table_size = 8M\ntmp_table_size = 16M\n\nread_buffer_size = 2M\nread_rnd_buffer_size = 8M\nsort_buffer_size = 8M\njoin_buffer_size = 8M\nkey_buffer_size = 4M\n\nthread_cache_size = 8\n\nquery_cache_type = 1\nquery_cache_size = 8M\nquery_cache_limit = 2M\n\nft_min_word_len = 4\n\nlog_bin = mysql-bin\nbinlog_format = mixed\nexpire_logs_days = 7\n\nperformance_schema = 0\nexplicit_defaults_for_timestamp\n\nskip-external-locking\n\ndefault_storage_engine = InnoDB\ninnodb_file_per_table = 1\ninnodb_open_files = 500\ninnodb_buffer_pool_size = 64M\ninnodb_write_io_threads = 4\ninnodb_read_io_threads = 4\ninnodb_thread_concurrency = 0\ninnodb_purge_threads = 1\ninnodb_flush_log_at_trx_commit = 2\ninnodb_log_buffer_size = 2M\ninnodb_log_file_size = 32M\ninnodb_log_files_in_group = 3\ninnodb_max_dirty_pages_pct = 90\ninnodb_lock_wait_timeout = 120\n\nbulk_insert_buffer_size = 8M\nmyisam_sort_buffer_size = 8M\nmyisam_max_sort_file_size = 10G\nmyisam_repair_threads = 1\n\ninteractive_timeout = 28800\nwait_timeout = 28800\n\nlower_case_table_names = 1\n\n#sql_mode =\nbinlog-ignore-db=mysql\nlog-bin=mysql-bin\nexpire-logs-days=10\nslave_skip_errors=1062\n#skip-grant-tables\n[mysqldump]\nquick<\/code><\/pre>\n\n\n\n
\u7f16\u8f91\u5b8c\u6210\u540e\uff0c\u4e3a\u6587\u4ef6\u8d4b\u53ef\u6267\u884c\u6743\u9650\u548c\u53ef\u8bfb\u53d6\u6743\u9650<\/p>\n\n\n\n
chmod +x run.sh && chmod 644 my.cnf<\/code><\/pre>\n\n\n\n
\u6267\u884c\u90e8\u7f72<\/h4>\n\n\n\n
\u63a5\u7740\u6267\u884c\u811a\u672c\u5373\u53ef\u81ea\u52a8\u90e8\u7f72MySQL\u5bb9\u5668<\/p>\n\n\n\n
bash run.sh<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
\u5199\u5728\u524d\u9762 \u6700\u8fd1\u7ecf\u5e38\u9700\u8981\u901a\u8fc7Docker\u90e8\u7f72\u5355\u8282\u70b9\u6216\u96c6\u7fa4\u7684MySQL\uff0c\u6240\u4ee5\u7b80\u5355\u5199\u4e86\u4e00\u4e2a\u90e8\u7f72\u811a\u672c \u521b\u5efa\u811a\u672c \u521b\u5efa\u76ee\u5f55 \u5907\u6ce8\uff1a \u83b7\u53d6\u7f51\u5361\u7684\u4f4d\u7f6e\u6709\u53ef\u80fd\u4f1a\u62a5\u9519\uff0c\u56e0\u4e3a\u6709\u4e9b\u865a\u62df\u673a\u7684\u9ed8\u8ba4\u7f51\u5361\u4e0d\u662feth0\uff0c\u53ef\u6839\u636e\u5b9e\u9645\u60c5\u51b5\u66f4\u6539 \u521b …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-810","post","type-post","status-publish","format-standard","hentry","category-3"],"_links":{"self":[{"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/posts\/810","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/comments?post=810"}],"version-history":[{"count":5,"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/posts\/810\/revisions"}],"predecessor-version":[{"id":819,"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/posts\/810\/revisions\/819"}],"wp:attachment":[{"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/media?parent=810"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/categories?post=810"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.anger.ltd\/index.php\/wp-json\/wp\/v2\/tags?post=810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}