In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.