Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Mysql 5.6Multiinstance mysqld_multi stop failed to shut down the database

2025-04-04 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Description

According to the needs of the business, from the perspective of rational use of hardware resources, production database preparation part of the business to run multiple instances, encountered a small problem in the process of testing, record it.

2.vi / etc/my.cnf

[mysqld_multi] mysqld=/usr/bin/mysqld_safemysqladmin=/usr/bin/mysqladminuser = rootpassword = rootlog=/tmp/multi.log..

3. Error message

# mysqld_multi stop 3307-3307 stands for GNR Group numbers

When shutting down the database, the user, password, and permissions are all OK.

Warning: Using a password on the command line interface can be insecure./usr/bin/mysqladmin: connect to server at 'localhost' failederror:' Access denied for user 'root'@'localhost' (using password: YES)' mysqld_multi log file version 2.16; run: Wed Dec 14 15:31:32 2016

4. Treatment method

# which mysqld_multi/usr/bin/mysqld_multi# vi / usr/bin/mysqld_multimy $com= join', 'my_print_defaults', @ defaults_options, $group; replace with: my $com= join', 'my_print_defaults-slots, @ defaults_options, $group

5. Re-execution successful

# mysqld_multi stop 3307# mysqld_multi reportReporting MySQL serversMySQL server from group: mysqld3307 is not running

The mainframe server resources of most companies are relatively free, especially the database server, how to ensure the normal business for the company

Saving money is a problem that needs to be considered, and all departments need to consider it. If you have money, you will live the life of the rich; if you have no money, you will live the life of ordinary people.

In other words, the business pressure has come up, and it is likely that the company's ability to make money has also come up, and it is not too late to make adjustments at that time, step by step, so is the architectural design. Continuous improvement and evolution is reasonable.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report