高端科技产品网站建设,简述网络营销的概念与特点,旅游网站有哪些?,厦门做网站价格mysqld_multi 的使用方法:官方文档#xff1a;https://dev.mysql.com/doc/refman/5.7/en/mysqld-multi.html 【文档有些问题#xff0c;按照它的这个配置#xff0c;mysqld_multi无法关闭实例】mysqld_multi无法关闭实例的解决方法#xff1a;https://bugs.mysql.com/bug…mysqld_multi 的使用方法:官方文档https://dev.mysql.com/doc/refman/5.7/en/mysqld-multi.html 【文档有些问题按照它的这个配置mysqld_multi无法关闭实例】mysqld_multi无法关闭实例的解决方法https://bugs.mysql.com/bug.php?id77227I have the same problem. After adding some traces in mysqld_multi, I have found the problem : since 5.6.25, my_print_defaults no longer returns password in readable form (we have to use the --show option to obtain it). mysqld_multi call my_print_default to obtain the user and password to use with mysqladmin.Also, to be able to stop instances with mysqld_multi, I have made a modification in the defaults_for_group function of mysqld_multi. I have changed the following line :my $com join , my_print_defaults, defaults_options, $group;with :my $com join , my_print_defaults -s, defaults_options, $group;直接贴操作笔记mkdir /data/mysqlcd /data/mysqlmkdir 3306/{data,tmp} -pvmkdir 3307/{data,tmp} -pv/etc/my.cnf 配置文件[client]port 3306socket /tmp/mysql.sockuser root[mysql]no-auto-rehash#safe-updatesprompt[\\d] [mysqld_multi]mysqld /usr/local/mysql/bin/mysqld_safemysqladmin /usr/local/mysql/bin/mysqladminlog /var/log/mysqld_multi.loguser multi_adminpassword 123456[mysqld]character-set-server utf8default_storage_engine InnoDBtransaction_isolation READ-COMMITTEDskip_name_resolve ONskip_external_lockingmax_connections 1500sort_buffer_size 512Kread_buffer_size 512Kread_rnd_buffer_size 512Kjoin_buffer_size 256Kthread_stack 256Kbinlog_cache_size 2Mconnect_timeout 20wait_timeout 14400interactive_timeout 14400net_write_timeout 180lock_wait_timeout 120thread_cache_size 64open_files_limit 65535innodb_open_files 4000skip-innodb_adaptive_hash_indexquery_cache_type OFFquery_cache_size 0expire_logs_days 5sync_binlog 1innodb_support_xa 1relay-log-purge1relay_log_info_repository TABLErelay_log_recovery ONmaster_info_repository TABLEslave_net_timeout 30skip-slave-start ONlog_slave_updates ONinnodb_use_native_aio ONinnodb_file_per_table ONinnodb_flush_log_at_trx_commit 1innodb_flush_methodO_DIRECTinnodb_max_dirty_pages_pct 50innodb_lock_wait_timeout 50innodb_stats_persistent ONinnodb_stats_persistent_sample_pages 64sql_modeNO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES[mysqld3306]socket /tmp/mysql.sock3306port 3306pid-file /data/mysql/3306/data/mysql.pid3306datadir /data/mysql/3306/datatmpdir /data/mysql/3306/tmp/user rootserver-id 111log-bin mysql-binbinlog_format ROWmax_binlog_size 256Mlog_bin_trust_function_creators ON[mysqld3307]socket /tmp/mysql.sock3307port 3307pid-file /data/mysql/3307/data/mysql.pid3307datadir /data/mysql/3307/datatmpdir /data/mysql/3307/tmp/user rootserver-id 222log-bin mysql-binbinlog_format ROWmax_binlog_size 256Mlog_bin_trust_function_creators ON初始化实例的时候我们先造2个模板文件/data/3307.cnf /data/3306.cnf 写上3307和3306实例需要的配置文件(或者不要模板文件直接初始化也行但是不建议这么做)然后初始化:/usr/local/mysql/scripts/mysql_install_db --defaults-file/data/3307.cnf --usermysql --basedir/usr/local/mysql --datadir/data/mysql/3307/data/usr/local/mysql/scripts/mysql_install_db --defaults-file/data/3306.cnf --usermysql --basedir/usr/local/mysql --datadir/data/mysql/3306/data启动2个实例mysqld_multi reportmysqld_multi start 3307mysqld_multi start 3306# 创建mysql关闭用的账号mysql -uroot -S /tmp/mysql.sock3307CREATE USER multi_adminlocalhost IDENTIFIED BY 123456;GRANT SHUTDOWN ON *.* TO multi_adminlocalhost;mysql -uroot -S /tmp/mysql.sock3306CREATE USER multi_adminlocalhost IDENTIFIED BY 123456;GRANT SHUTDOWN ON *.* TO multi_adminlocalhost;操作至此我们mysqld_multi能启动mysql实例了但是却无法关闭实例。原因如下# 输出明细(注意对比下面2个的输出结果)# my_print_defaults mysqld_multi mysql3307--mysqld/usr/local/mysql/bin/mysqld_safe--mysqladmin/usr/local/mysql/bin/mysqladmin--log/var/log/mysql/mysqld_multi.log--usermulti_admin--password*****# my_print_defaults mysqld_multi mysql3307 -s--mysqld/usr/local/mysql/bin/mysqld_safe--mysqladmin/usr/local/mysql/bin/mysqladmin--log/var/log/mysql/mysqld_multi.log--usermulti_admin--password123456 ---- 可看到这里密码能显示出来了vim /usr/local/mysql/bin/mysqld_multi 216 , 在my_print_defaults 后面加一个 -s 然后保存退出。my $com join , my_print_defaults -s, defaults_options, $group;然后 执行下mysqld_multi stop 3307mysqld_multi report可以看到3307实例已经关闭了。同样的方法我们还可以启停其他的实例。
