mysql 关闭一个实例_mysql 多实例关闭、启动、查看状态

一、my.cnf配置文件

[mysqld]########basic settings#########user = mysql#bind_address =#autocommit = 0

socket = /tmp/mysqld.sock

character_set_server=utf8mb4

skip_name_resolve= 1max_connections= 1000max_connect_errors= 300transaction_isolation= READ-COMMITTED

explicit_defaults_for_timestamp= 1join_buffer_size= 134217728tmp_table_size= 167108864tmpdir= /tmp

max_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.log

slow_query_log= 1slow_query_log_file=slow.log

log_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 =TABLE

relay_log_info_repository=TABLE

log_bin=bin.log

sync_binlog= 1gtid_mode=on

enforce_gtid_consistency= 1log_slave_updates

binlog_format=row

relay_log=relay.log

relay_log_recovery= 1binlog_gtid_simple_recovery= 1slave_skip_errors=ddl_exist_errors########innodb settings########

innodb_page_size = 16384innodb_buffer_pool_size=3G

innodb_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_DIRECT

innodb_file_format=Barracuda

innodb_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 = 3

innodb_flush_neighbors = 1innodb_log_file_size=2G

innodb_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/plugin

plugin_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=1G

innodb_purge_rseg_truncate_frequency= 128binlog_gtid_simple_recovery=1log_timestamps=system

transaction_write_set_extraction=MURMUR32

show_compatibility_56=on

[mysqld_multi]

mysqld= /usr/local/mysql/bin/mysqld_safe

mysqladmin= /usr/local/mysql/bin/mysqladmin

log=/var/log/mysqld_multi.log

user=root

password=lianyu2016

[mysqld1]

server-id = 111datadir= /mnt/ipower365/lishu/mysqldata

socket= /mnt/ipower365/lishu/mysqldata/mysqld.sock

port= 3306pid-file = /mnt/ipower365/lishu/mysqldata/mysqld.pid

log_error=error.log

[mysqld2]

server-id = 112socket= /mnt/ipower365/lishu/mysqldata3307/mysqld.sock

port= 3307pid-file = /mnt/ipower365/lishu/mysqldata3307/mysqld.pid

datadir= /mnt/ipower365/lishu/mysqldata3307

log_error=error.log

[mysqld3]

server-id = 113socket= /mnt/ipower365/lishu/mysqldata3308/mysqld.sock

port= 3308pid-file = /mnt/ipower365/lishu/mysqldata3308/mysqld.pid

datadir= /mnt/ipower365/lishu/mysqldata3308

log_error= error.log

my.cnf

二、多实例操作

1、查看状态

mysqld_multi report

#输出

Reporting MySQL servers

MySQL server from group: mysqld1 is running

MySQL server from group: mysqld2 is running

MySQL 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、脚本路径

[root@aa ipower365]# which mysqld_multi

/usr/local/mysql/bin/mysqld_multi

[root@aa ipower365]# vim /usr/local/mysql/bin/mysqld_multi

搜索：/my_print_defaults，看看后面参数是不是少了一个 -s，下面是正确的写法，如图：

4、查看日志文件

tailf /var/log/mysqld_multi.log