mysql有多个my.cnf文件，启动时默认用那个呢？

yybmsrs

mysql目录下面有好几个my.cnf文件，启动mysqld_safe或者/etc/init.d/mysqld start时，它调用的是哪个cnf文件呢？

其他的几个参数如basedir，socket，pid_file等等是怎么指定的呢？

justin033

回复 1# yybmsrs


  
启动时用mysqld_safe --defaults-file=xxxx --users=mysql &
关闭用mysqladmin吧


你CU头像不错，也喜欢看FLASH啊


mysqld搜索.cnf文件，从mysqld命令所在的PWD目录，再从/etc目录下，再从用户主目录下。大概是这样吧。你可以查查手册

yybmsrs

回复 2# justin033


    thanks

ruochen

可以看看他们的启动脚本来确定

yybmsrs

回复 4# ruochen


    启动脚本就是一个./mysqld_safe --port 1234

yybmsrs

在mysqld --verbose --help中找到了一句：
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf

Coolriver

看你的/etc/init.d/mysql 里对conf 的定义。

justin033

回复 6# yybmsrs


你看过FLASH：云端的日子。。。。。。。。。。。。。。。。。


我这边有个非常简单的脚本，可以管理多个mysqld。献丑了。。。

1. [root@popgo-web2svr ~]# cat mysql_manager.sh
   
2. #!/bin/sh
   
3. 
   
4. username="mysql"
   
5. 
   
6. port_3306="3306"
   
7. username_3306="root"
   
8. password_3306="q"
   
9. socket_3306="/data01/mysql/mysql.sock"
   
10. 
    
11. port_3307="3307"
    
12. username_3307="root"
    
13. password_3307="justin"
    
14. socket_3307="/data02/mysql/mysql.sock"
    
15. 
    
16. 
    
17. function_start_mysql_3306()
    
18. {
    
19.     printf "Starting MySQL on port 3306...\n"
    
20.     /bin/sh /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/"my${port_3306}.cnf" --user=${username} 2>&1 > /dev/null &
    
21. }
    
22. 
    
23. function_start_mysql_3307()
    
24. {
    
25.     printf "Starting MySQL on port 3307...\n"
    
26.     /bin/sh /usr/local/mysql5139/bin/mysqld_safe --defaults-file=/etc/"my${port_3307}.cnf" --user=${username} 2>&1 > /dev/null &
    
27. }
    
28. 
    
29. function_stop_mysql_3306()
    
30. {
    
31.     printf "Stoping MySQL on port 3306...\n"
    
32.     /usr/local/mysql/bin/mysqladmin -u${username_3306} -p${password_3306} -S${socket_3306} shutdown
    
33. }
    
34. 
    
35. function_stop_mysql_3307()
    
36. {
    
37.     printf "Stoping MySQL on port 3307...\n"
    
38.     /usr/local/mysql5139/bin/mysqladmin -u${username_3307} -p${password_3307} -S${socket_3307} shutdown
    
39. }
    
40. 
    
41. function_restart_mysql_3306()
    
42. {
    
43.     printf "Restarting MySQL on port 3306...\n"
    
44.     function_stop_mysql_3306
    
45.     function_start_mysql_3306
    
46. }
    
47. 
    
48. function_restart_mysql_3307()
    
49. {
    
50.     printf "Restarting MySQL on port 3307...\n"
    
51.     function_stop_mysql_3307
    
52.     sleep 10s
    
53.     function_start_mysql_3307
    
54. }
    
55. 
    
56. function_kill_mysql_3306()
    
57. {
    
58.     kill -9 $(ps -ef | grep "bin/mysqld_safe" | grep "${port_3306}" | awk '{printf $2}')
    
59.     kill -9 $(ps -ef | grep "libexec/mysqld" | grep "${port_3306}" | awk '{printf $2}')
    
60. }
    
61. 
    
62. function_kill_mysql_3307()
    
63. {
    
64.     kill -9 $(ps -ef | grep "bin/mysqld_safe" | grep "${port_3307}" | awk '{printf $2}')
    
65.     kill -9 $(ps -ef | grep "libexec/mysqld" | grep "${port_3307}" | awk '{printf $2}')
    
66. }
    
67. 
    
68. if [ "$1" = "start" ] && [ "$2" = "3306" ] ; then
    
69.     function_start_mysql_3306
    
70. elif [ "$1" = "start" ] && [ "$2" = "3307" ] ; then
    
71.     function_start_mysql_3307
    
72. elif [ "$1" = "stop" ] && [ "$2" = "3306" ] ; then
    
73.     function_stop_mysql_3306
    
74. elif [ "$1" = "stop" ] && [ "$2" = "3307" ] ; then
    
75.     function_stop_mysql_3307
    
76. elif [ "$1" = "restart" ] && [ "$2" = "3306" ] ; then
    
77.     function_restart_mysql_3306
    
78. elif [ "$1" = "restart" ] && [ "$2" = "3307" ] ; then
    
79.     function_restart_mysql_3307
    
80. elif [ "$1" = "kill" ] && [ "$2" = "3306" ] ; then
    
81.     function_kill_mysql_3306
    
82. elif [ "$1" = "kill" ] && [ "$2" = "3307" ] ; then
    
83.     function_kill_mysql_3307
    
84. else
    
85.     printf "Usage: /root/mysql_manager {start|stop|restart|kill} ${port_3306}\n"
    
86.     printf "    Or /root/mysql_manager {start|stop|restart|kill} ${port_3307}\n"
    
87. fi

复制代码

yybmsrs

回复 8# justin033


    十分感谢  对mysql还处于学习阶段

ruochen

我比较喜欢用mysqld_multi 来控制多个mysql

1. 配置/etc/my.cnf参数文件:
   
2. [mysqld5129]
   
3. port=5506
   
4. socket=/tmp/mysql5129.sock
   
5. basedir=/opt/MySQL5129
   
6. datadir=/opt/MySQL5129/var
   
7. user=mysql
   
8. log-error=/var/log/mysqld5129.log
   
9. pid-file=/tmp/mysqld5129.pid
   
10. 
    
11. [mysqld607]
    
12. port=5507
    
13. socket=/tmp/mysql607.sock
    
14. basedir=/opt/MySQL607
    
15. datadir=/opt/MySQL607/var
    
16. user=mysql
    
17. log-error=/var/log/mysqld607.log
    
18. pid-file=/tmp/mysqld607.pid
    
19. 
    
20. 
    
21. 
    
22. 启动数据库：
    
23. /opt/MySQL5129/bin/mysqld_multi start|stop  5129
    
24. /opt/MySQL607/bin/mysqld_multi start|stop  607
    

复制代码