mysql 多執行個體關閉、啟動、查看狀態

標籤：innodb   ima   date   ipo   epo   safe   close   stop   group   

一、my.cnf設定檔

[mysqld]########basic settings#########user = mysql#bind_address =#autocommit = 0socket = /tmp/mysqld.sockcharacter_set_server=utf8mb4skip_name_resolve = 1max_connections = 1000max_connect_errors = 300transaction_isolation = READ-COMMITTEDexplicit_defaults_for_timestamp = 1join_buffer_size = 134217728tmp_table_size = 167108864tmpdir = /tmpmax_allowed_packet = 16777216sql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER"interactive_timeout = 1800wait_timeout = 1800read_buffer_size = 16777216read_rnd_buffer_size = 33554432sort_buffer_size = 33554432lower_case_table_names=1########log settings########log_error = error.logslow_query_log = 1slow_query_log_file = slow.loglog_queries_not_using_indexes = 1log_slow_admin_statements = 1log_slow_slave_statements = 1log_throttle_queries_not_using_indexes = 10expire_logs_days = 90long_query_time = 2min_examined_row_limit = 100########replication settings########master_info_repository = TABLErelay_log_info_repository = TABLElog_bin = bin.logsync_binlog = 1gtid_mode = onenforce_gtid_consistency = 1log_slave_updatesbinlog_format = row relay_log = relay.logrelay_log_recovery = 1binlog_gtid_simple_recovery = 1slave_skip_errors = ddl_exist_errors########innodb settings########innodb_page_size = 16384innodb_buffer_pool_size = 3Ginnodb_buffer_pool_instances = 8innodb_buffer_pool_load_at_startup = 1innodb_buffer_pool_dump_at_shutdown = 1innodb_lru_scan_depth = 2000innodb_lock_wait_timeout = 50innodb_io_capacity = 4000innodb_io_capacity_max = 8000innodb_flush_method = O_DIRECTinnodb_file_format = Barracudainnodb_file_format_max = Barracuda#innodb_log_group_home_dir = /usr/local/redolog/#innodb_undo_directory = /usr/local/undolog/#innodb_undo_logs = 128#innodb_undo_tablespaces = 3innodb_flush_neighbors = 1innodb_log_file_size = 2Ginnodb_log_buffer_size = 16777216innodb_purge_threads = 4innodb_large_prefix = 1innodb_thread_concurrency = 64innodb_print_all_deadlocks = 1innodb_strict_mode = 1innodb_sort_buffer_size = 67108864 ########semi sync replication settings########plugin_dir=/usr/local/mysql/lib/pluginplugin_load = "rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so"loose_rpl_semi_sync_master_enabled = 1loose_rpl_semi_sync_slave_enabled = 1loose_rpl_semi_sync_master_timeout = 5000[mysqld-5.7]innodb_buffer_pool_dump_pct = 40innodb_page_cleaners = 4innodb_undo_log_truncate = 1innodb_max_undo_log_size = 1Ginnodb_purge_rseg_truncate_frequency = 128binlog_gtid_simple_recovery=1log_timestamps=systemtransaction_write_set_extraction=MURMUR32show_compatibility_56=on[mysqld_multi]mysqld = /usr/local/mysql/bin/mysqld_safemysqladmin = /usr/local/mysql/bin/mysqladminlog =/var/log/mysqld_multi.loguser=rootpassword=lianyu2016[mysqld1]server-id = 111datadir = /mnt/ipower365/lishu/mysqldatasocket = /mnt/ipower365/lishu/mysqldata/mysqld.sockport = 3306pid-file = /mnt/ipower365/lishu/mysqldata/mysqld.pidlog_error = error.log[mysqld2]server-id = 112socket = /mnt/ipower365/lishu/mysqldata3307/mysqld.sockport = 3307pid-file = /mnt/ipower365/lishu/mysqldata3307/mysqld.piddatadir = /mnt/ipower365/lishu/mysqldata3307log_error = error.log[mysqld3]server-id = 113socket = /mnt/ipower365/lishu/mysqldata3308/mysqld.sockport = 3308pid-file = /mnt/ipower365/lishu/mysqldata3308/mysqld.piddatadir = /mnt/ipower365/lishu/mysqldata3308log_error = error.log

my.cnf二、多執行個體操作1、查看狀態

mysqld_multi report#輸出Reporting MySQL serversMySQL server from group: mysqld1 is runningMySQL server from group: mysqld2 is runningMySQL server from group: mysqld3 is running

2、關閉

說明：3表示my.cnf設定檔中mysqld3

mysqld_multi stop 3

3、啟動

mysqld_multi start 3 

三、查看配置資訊1、查看某個mysqld執行個體配置傳遞資訊

說明：沒有加s的效果

my_print_defaults mysqld_multi mysqld3#輸出--mysqld=/usr/local/mysql/bin/mysqld_safe--mysqladmin=/usr/local/mysql/bin/mysqladmin--log=/var/log/mysqld_multi.log--user=root--password=*****  #指令碼錯誤，沒有加參數s，傳遞的是5個*--server-id=113--socket=/mnt/ipower365/lishu/mysqldata3308/mysqld.sock--port=3308--pid-file=/mnt/ipower365/lishu/mysqldata3308/mysqld.pid--datadir=/mnt/ipower365/lishu/mysqldata3308--log_error=error.log

2、查看某個mysqld執行個體配置傳遞資訊

說明：加s的效果

my_print_defaults mysqld_multi -s  mysqld3#輸出--mysqld=/usr/local/mysql/bin/mysqld_safe--mysqladmin=/usr/local/mysql/bin/mysqladmin--log=/var/log/mysqld_multi.log--user=root--password=lianyu2016  #加s，顯示的是s的。--server-id=113--socket=/mnt/ipower365/lishu/mysqldata3308/mysqld.sock--port=3308--pid-file=/mnt/ipower365/lishu/mysqldata3308/mysqld.pid--datadir=/mnt/ipower365/lishu/mysqldata3308--log_error=error.log

3、指令碼路徑

[[email protected] ipower365]# which mysqld_multi/usr/local/mysql/bin/mysqld_multi[[email protected] ipower365]# vim /usr/local/mysql/bin/mysqld_multi

 搜尋：/my_print_defaults，看看後面參數是不是少了一個 -s，下面是正確的寫法，

4、查看記錄檔

tailf /var/log/mysqld_multi.log 

 

mysql 多執行個體關閉、啟動、查看狀態