\u5728\u540c\u4e00\u53f0\u670d\u52a1\u5668\u4e0a\u53ef\u4ee5\u914d\u7f6emysql\u591a\u5b9e\u4f8b\uff0c\u63d0\u9ad8\u670d\u52a1\u5668\u7684\u4f7f\u7528\u7387<\/p>\n
\u8fd9\u91ccmysql\u7684\u76ee\u5f55\u4e3a\/usr\/local\/mysql\/\uff0c\u5f00\u4e24\u4e2a\u5b9e\u4f8b\uff0c\u5b58\u653e\u76ee\u5f55\u5206\u522b\u4e3a<\/p>\n
\/data\/db1\r\n\/data\/db2<\/pre>\n\u5206\u522b\u76d1\u542c3306, 3307<\/p>\n
\u63a5\u4e0b\u6765\u5199\u597d\/etc\/my.cnf\u5185\u5bb9\uff0c\u4e3b\u8981\u6ce8\u610fsock, pid, log<\/p>\n
[mysqld_multi]\r\nmysqld = \/usr\/local\/mysql\/bin\/mysqld_safe\r\nmysqladmin = \/usr\/local\/mysql\/bin\/mysqladmin\r\nuser = root\r\nlog = \/var\/log\/mysqld_multi.log\r\n\r\n[mysqld3306]\r\nport = 3306\r\nsocket = \/tmp\/mysql3306.sock\r\npid-file = \/var\/run\/mysql\/mysql3306.pid\r\ndatadir = \/data\/innodb\r\nuser=mysql\r\nlog-error=\/var\/log\/mysql_error3306.log\r\ndefault-storage-engine = INNODB\r\ninnodb_read_io_threads = 16\r\ninnodb_write_io_threads = 4\r\ninnodb_io_capacity = 4000\r\nback_log = 50\r\nmax_connections = 2000\r\nmax_prepared_stmt_count=500000\r\nmax_connect_errors = 10\r\ntable_open_cache = 2048\r\nmax_allowed_packet = 16M\r\nbinlog_cache_size = 16M\r\nmax_heap_table_size = 64M\r\nsort_buffer_size = 4M\r\njoin_buffer_size = 4M\r\nthread_cache_size = 1000\r\nquery_cache_size = 0\r\nquery_cache_type = 0\r\nthread_stack = 192K\r\ntmp_table_size = 64M\r\nserver-id = 10\r\nkey_buffer_size = 8M\r\nread_buffer_size = 1M\r\nread_rnd_buffer_size = 4M\r\nbulk_insert_buffer_size = 8M\r\nmyisam_sort_buffer_size = 8M\r\nmyisam_max_sort_file_size = 10G\r\nmyisam_repair_threads = 1\r\nmyisam_recover\r\n\r\n[mysqld3307]\r\nport = 3307\r\nsocket = \/tmp\/mysql3307.sock\r\npid-file = \/var\/run\/mysql\/mysql-3307.pid\r\ndatadir = \/data\/tokudb\r\nuser=mysql\r\nlog-error=\/var\/log\/mysql_error3307.log\r\nback_log = 50\r\nmax_connections = 2000\r\nmax_prepared_stmt_count=500000\r\nmax_connect_errors = 10\r\ntable_open_cache = 2048\r\nmax_allowed_packet = 16M\r\nbinlog_cache_size = 16M\r\nmax_heap_table_size = 64M\r\nsort_buffer_size = 4M\r\njoin_buffer_size = 4M\r\nthread_cache_size = 1000\r\nquery_cache_size = 0\r\nquery_cache_type = 0\r\nft_min_word_len = 4\r\nthread_stack = 192K\r\ntmp_table_size = 64M\r\nserver-id = 10\r\nkey_buffer_size = 8M\r\nread_buffer_size = 1M\r\nread_rnd_buffer_size = 4M\r\nbulk_insert_buffer_size = 8M\r\nmyisam_sort_buffer_size = 8M\r\nmyisam_max_sort_file_size = 10G\r\nmyisam_repair_threads = 1\r\nmyisam_recover<\/pre>\n\u5b89\u88c5\u6570\u636e\u6587\u4ef6<\/p>\n
cd \/usr\/local\/mysql\/\r\n.\/scripts\/mysql_install_db --datadir=\/data\/db1\/ --user=mysql\r\n.\/scripts\/mysql_install_db --datadir=\/data\/db2\/ --user=mysql<\/pre>\n\u521b\u5efa\u542f\u52a8\u811a\u672c<\/p>\n
cp \/usr\/local\/mysql\/support-files\/mysqld_multi.server \/etc\/init.d\/mysqld_multi\r\nchmod u+x \/etc\/init.d\/mysqld_multi<\/pre>\n\u4e3a\u65b9\u4fbf\u4f7f\u7528\uff0c\u5c06\/usr\/local\/mysql\/bin\u52a0\u5165\u5230PATH\u4e2d<\/p>\n
export PATH=\/usr\/local\/mysql\/bin:$PATH<\/pre>\n\u542f\u52a8\u5b9e\u4f8b<\/p>\n
\/etc\/init.d\/mysqld_multi start 3306\r\n\/etc\/init.d\/mysqld_multi start 3307<\/pre>\n\u67e5\u770b\u542f\u52a8\u7684\u60c5\u51b5<\/p>\n
netstat -tnlp<\/pre>\n","protected":false},"excerpt":{"rendered":"\u5728\u540c\u4e00\u53f0\u670d\u52a1\u5668\u4e0a\u53ef\u4ee5\u914d\u7f6emysql\u591a\u5b9e\u4f8b\uff0c\u63d0\u9ad8\u670d\u52a1\u5668\u7684\u4f7f\u7528\u7387 \u8fd9\u91ccmysql\u7684\u76ee\u5f55\u4e3a\/usr\/local\/mysql\/\uff0c\u5f00\u4e24\u4e2a\u5b9e\u4f8b\uff0c\u5b58\u653e\u76ee\u5f55\u5206\u522b\u4e3a \/data\/db1 \/data\/db2 \u5206\u522b\u76d1\u542c3306, 3307 \u63a5\u4e0b\u6765\u5199\u597d\/etc\/my.cnf\u5185\u5bb9\uff0c\u4e3b\u8981\u6ce8\u610fsock, pid, log [mysqld_multi] mysqld = \/usr\/local\/mysql\/bin\/mysqld_safe mysqladmin = \/usr\/local\/mysql\/bin\/mysqladmin user = root log = \/var\/log\/mysqld_multi.log [mysqld3306] port = 3306 socket = \/tmp\/mysql3306.sock pid-file = \/var\/run\/mysql\/mysql3306.pid datadir = \/data\/innodb user=mysql log-error=\/var\/log\/mysql_error3306.log default-storage-engine = INNODB innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 back_log = 50 max_connections = 2000 […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-5774","post","type-post","status-publish","format-standard","hentry","category-life"],"_links":{"self":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/5774","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5774"}],"version-history":[{"count":5,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/5774\/revisions"}],"predecessor-version":[{"id":5779,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/5774\/revisions\/5779"}],"wp:attachment":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5774"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5774"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}