多实例版mysql启动重启关闭脚本mysql.server

leo_ss_pku

MySQL自带了一个mysql.server脚本，用来启动、重启、关闭mysql服务

不过这个脚本监听默认的3306端口，以及只用/tmp/mysql.sock

在一台服务器上跑多个MySQL实例的情况下，使用这个脚本就会造成冲突。

对mysql.server脚本大概读了一下，将之修改成可以适用于一台服务器跑多个MySQL的环境

需要配置脚本中的开头basedir和datadir两个参数，脚本将优先从$datadir/my.cnf中读取配置，解析my.cnf中端口和socket配置，

my.cnf示例如下:

[mysqld]

port=3307

socket=/your/mysql/data/mysql.sock  #可以把mysql.sock放到$datadir所在目录中

1. 
   
2. #!/bin/sh
   
3. 
   
4. # Copyright Abandoned 1996 TCX DataKonsult AB & Monty Program KB & Detron HB
   
5. # This file is public domain and comes with NO WARRANTY of any kind
   
6. 
   
7. # MySQL daemon start/stop script.
   
8. 
   
9. # Usually this is put in /etc/init.d (at least on machines SYSV R4 based
   
10. # systems) and linked to /etc/rc3.d/S99mysql and /etc/rc0.d/K01mysql.
    
11. # When this is done the mysql server will be started when the machine is
    
12. # started and shut down when the systems goes down.
    
13. 
    
14. # Comments to support chkconfig on RedHat Linux
    
15. # chkconfig: 2345 64 36
    
16. # description: A very fast and reliable SQL database engine.
    
17. 
    
18. # Comments to support LSB init script conventions
    
19. ### BEGIN INIT INFO
    
20. # Provides: mysql
    
21. # Required-Start: $local_fs $network $remote_fs
    
22. # Should-Start: ypbind nscd ldap ntpd xntpd
    
23. # Required-Stop: $local_fs $network $remote_fs
    
24. # Default-Start:  2 3 4 5
    
25. # Default-Stop: 0 1 6
    
26. # Short-Description: start and stop MySQL
    
27. # Description: MySQL is a very fast and reliable SQL database engine.
    
28. ### END INIT INFO
    
29. 
    
30. # If you install MySQL on some other places than /usr/local/mysql, then you
    
31. # have to do one of the following things for this script to work:
    
32. #
    
33. # - Run this script from within the MySQL installation directory
    
34. # - Create a /etc/my.cnf file with the following information:
    
35. #   [mysqld]
    
36. #   basedir=<path-to-mysql-installation-directory>
    
37. # - Add the above to any other configuration file (for example ~/.my.ini)
    
38. #   and copy my_print_defaults to /usr/bin
    
39. # - Add the path to the mysql-installation-directory to the basedir variable
    
40. #   below.
    
41. #
    
42. # If you want to affect other MySQL variables, you should make your changes
    
43. # in the /etc/my.cnf, ~/.my.cnf or other MySQL configuration files.
    
44. 
    
45. # If you change base dir, you must also change datadir. These may get
    
46. # overwritten by settings in the MySQL configuration files.
    
47. 
    
48. basedir=/Data/apps/mysql-5.0.41-icc/
    
49. datadir=/Data/apps/mysql-5.0.41-icc/data_23301
    
50. 
    
51. # 脚本优先从$datadir所在目录中查找my.cnf
    
52. # port和socket将从my.cnf中解析
    
53. # [mysqld]
    
54. # port=3307
    
55. # socket=/your/mysql/data/mysql.sock  #可以把mysql.sock放到$datadir所在目录中
    
56. 
    
57. 
    
58. # Default value, in seconds, afterwhich the script should timeout waiting
    
59. # for server start.
    
60. # Value here is overriden by value in my.cnf.
    
61. # 0 means don't wait at all
    
62. # Negative numbers mean to wait indefinitely
    
63. service_startup_timeout=900
    
64. 
    
65. # The following variables are only set for letting mysql.server find things.
    
66. 
    
67. # Set some defaults
    
68. pid_file=mysql.pid
    
69. server_pid_file=mysql.pid
    
70. use_mysqld_safe=1
    
71. user=mysql
    
72. if test -z "$basedir"
    
73. then
    
74.   basedir=/usr/local/mysql
    
75.   bindir=./bin
    
76.   if test -z "$datadir"
    
77.   then
    
78.     datadir=/usr/local/mysql/data
    
79.   fi
    
80.   sbindir=./bin
    
81.   libexecdir=./bin
    
82. else
    
83.   bindir="$basedir/bin"
    
84.   if test -z "$datadir"
    
85.   then
    
86.     datadir="$basedir/data"
    
87.   fi
    
88.   sbindir="$basedir/sbin"
    
89.   libexecdir="$basedir/libexec"
    
90. fi
    
91. 
    
92. # datadir_set is used to determine if datadir was set (and so should be
    
93. # *not* set inside of the --basedir= handler.)
    
94. datadir_set=
    
95. 
    
96. #
    
97. # Use LSB init script functions for printing messages, if possible
    
98. #
    
99. lsb_functions="/lib/lsb/init-functions"
    
100. if test -f $lsb_functions ; then
     
101.   . $lsb_functions
     
102. else
     
103.   log_success_msg()
     
104.   {
     
105.     echo " SUCCESS! $@"
     
106.   }
     
107.   log_failure_msg()
     
108.   {
     
109.     echo " ERROR! $@"
     
110.   }
     
111. fi
     
112. 
     
113. PATH=/sbin:/usr/sbin:/bin:/usr/bin:$basedir/bin
     
114. export PATH
     
115. 
     
116. mode=$1    # start or stop
     
117. shift
     
118. other_args="$*"   # uncommon, but needed when called from an RPM upgrade action
     
119.            # Expected: "--skip-networking --skip-grant-tables"
     
120.            # They are not checked here, intentionally, as it is the resposibility
     
121.            # of the "spec" file author to give correct arguments only.
     
122. 
     
123. case `echo "testing\c"`,`echo -n testing` in
     
124.     *c*,-n*) echo_n=   echo_c=     ;;
     
125.     *c*,*)   echo_n=-n echo_c=     ;;
     
126.     *)       echo_n=   echo_c='\c' ;;
     
127. esac
     
128. 
     
129. parse_server_arguments() {
     
130.   for arg do
     
131.     case "$arg" in
     
132.       --basedir=*)  basedir=`echo "$arg" | sed -e 's/^[^=]*=//'`
     
133.                     bindir="$basedir/bin"
     
134.             if test -z "$datadir_set"; then
     
135.               datadir="$basedir/data"
     
136.             fi
     
137.             sbindir="$basedir/sbin"
     
138.             libexecdir="$basedir/libexec"
     
139.         ;;
     
140.       --datadir=*)  datadir=`echo "$arg" | sed -e 's/^[^=]*=//'`
     
141.             datadir_set=1
     
142.     ;;
     
143.       --user=*)  user=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;
     
144.       --port=*)  port=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;
     
145.       --socket=*)  socket=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;
     
146.       --pid-file=*) server_pid_file=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;
     
147.       --service-startup-timeout=*) service_startup_timeout=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;
     
148.       --use-mysqld_safe) use_mysqld_safe=1;;
     
149.       --use-manager)     use_mysqld_safe=0;;
     
150.     esac
     
151.   done
     
152. }
     
153. 
     
154. parse_manager_arguments() {
     
155.   for arg do
     
156.     case "$arg" in
     
157.       --pid-file=*) pid_file=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;
     
158.       --user=*)  user=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;
     
159.     esac
     
160.   done
     
161. }
     
162. 
     
163. wait_for_pid () {
     
164.   i=0
     
165.   while test $i -ne $service_startup_timeout ; do
     
166.     sleep 1
     
167.     case "$1" in
     
168.       'created')
     
169.         test -s $pid_file && i='' && break
     
170.         kill -0 $2 || break # if the program goes away, stop waiting
     
171.         ;;
     
172.       'removed')
     
173.         test ! -s $pid_file && i='' && break
     
174.         ;;
     
175.       *)
     
176.         echo "wait_for_pid () usage: wait_for_pid created|removed"
     
177.         exit 1
     
178.         ;;
     
179.     esac
     
180.     echo $echo_n ".$echo_c"
     
181.     i=`expr $i + 1`
     
182.   done
     
183. 
     
184.   if test -z "$i" ; then
     
185.     log_success_msg
     
186.     return 0
     
187.   else
     
188.     log_failure_msg
     
189.     return 1
     
190.   fi
     
191. }
     
192. 
     
193. # Get arguments from the my.cnf file,
     
194. # the only group, which is read from now on is [mysqld]
     
195. if test -x ./bin/my_print_defaults
     
196. then
     
197.   print_defaults="./bin/my_print_defaults"
     
198. elif test -x $bindir/my_print_defaults
     
199. then
     
200.   print_defaults="$bindir/my_print_defaults"
     
201. elif test -x $bindir/mysql_print_defaults
     
202. then
     
203.   print_defaults="$bindir/mysql_print_defaults"
     
204. else
     
205.   # Try to find basedir in /etc/my.cnf
     
206.   conf=/etc/my.cnf
     
207.   print_defaults=
     
208.   if test -r $conf
     
209.   then
     
210.     subpat='^[^=]*basedir[^=]*=\(.*\)$'
     
211.     dirs=`sed -e "/$subpat/!d" -e 's//\1/' $conf`
     
212.     for d in $dirs
     
213.     do
     
214.       d=`echo $d | sed -e 's/[     ]//g'`
     
215.       if test -x "$d/bin/my_print_defaults"
     
216.       then
     
217.         print_defaults="$d/bin/my_print_defaults"
     
218.         break
     
219.       fi
     
220.       if test -x "$d/bin/mysql_print_defaults"
     
221.       then
     
222.         print_defaults="$d/bin/mysql_print_defaults"
     
223.         break
     
224.       fi
     
225.     done
     
226.   fi
     
227. 
     
228.   # Hope it's in the PATH ... but I doubt it
     
229.   test -z "$print_defaults" && print_defaults="my_print_defaults"
     
230. fi
     
231. 
     
232. #
     
233. # Read defaults file from 'basedir'.   If there is no defaults file there
     
234. # check if it's in the old (depricated) place (datadir) and read it from there
     
235. #
     
236. 
     
237. extra_args=""
     
238. if test -r "$basedir/my.cnf"
     
239. then
     
240.   extra_args="-e $basedir/my.cnf"
     
241. else
     
242.   if test -r "$datadir/my.cnf"
     
243.   then
     
244.     extra_args="-e $datadir/my.cnf"
     
245.   fi
     
246. fi
     
247. 
     
248. parse_server_arguments `$print_defaults $extra_args mysqld server mysql_server mysql.server`
     
249. 
     
250. # Look for the pidfile
     
251. parse_manager_arguments `$print_defaults $extra_args manager`
     
252. 
     
253. #
     
254. # Set pid file if not given
     
255. #
     
256. if test -z "$pid_file"
     
257. then
     
258.   pid_file=$datadir/mysqlmanager-`/bin/hostname`.pid
     
259. else
     
260.   case "$pid_file" in
     
261.     /* ) ;;
     
262.     * )  pid_file="$datadir/$pid_file" ;;
     
263.   esac
     
264. fi
     
265. if test -z "$server_pid_file"
     
266. then
     
267.   server_pid_file=$datadir/`/bin/hostname`.pid
     
268. else
     
269.   case "$server_pid_file" in
     
270.     /* ) ;;
     
271.     * )  server_pid_file="$datadir/$server_pid_file" ;;
     
272.   esac
     
273. fi
     
274. 
     
275. # Safeguard (relative paths, core dumps..)
     
276. cd $basedir
     
277. 
     
278. case "$mode" in
     
279.   'start')
     
280.     # Start daemon
     
281. 
     
282.     manager=$bindir/mysqlmanager
     
283.     if test -x $libexecdir/mysqlmanager
     
284.     then
     
285.       manager=$libexecdir/mysqlmanager
     
286.     elif test -x $sbindir/mysqlmanager
     
287.     then
     
288.       manager=$sbindir/mysqlmanager
     
289.     fi
     
290. 
     
291.     echo $echo_n "Starting MySQL"
     
292.     if test -x $manager -a "$use_mysqld_safe" = "0"
     
293.     then
     
294.       if test -n "$other_args"
     
295.       then
     
296.         log_failure_msg "MySQL manager does not support options '$other_args'"
     
297.         exit 1
     
298.       fi
     
299.       # Give extra arguments to mysqld with the my.cnf file. This script may
     
300.       # be overwritten at next upgrade.
     
301.       $manager --user=$user --pid-file=$pid_file >/dev/null 2>&1 &
     
302.       wait_for_pid created $!; return_value=$?
     
303. 
     
304.       # Make lock for RedHat / SuSE
     
305.       if test -w /var/lock/subsys
     
306.       then
     
307.         touch /var/lock/subsys/mysqlmanager
     
308.       fi
     
309.       exit $return_value
     
310.     elif test -x $bindir/mysqld_safe
     
311.     then
     
312.       # Give extra arguments to mysqld with the my.cnf file. This script
     
313.       # may be overwritten at next upgrade.
     
314.       pid_file=$server_pid_file
     
315.       #echo "$bindir/mysqld_safe --datadir=$datadir --port=$port --pid-file=$server_pid_file $other_args >/dev/null 2>&1 &"
     
316.       $bindir/mysqld_safe --datadir=$datadir --port=$port --socket=$socket --pid-file=$server_pid_file $other_args >/dev/null 2>&1 &
     
317.       wait_for_pid created $!; return_value=$?
     
318. 
     
319.       # Make lock for RedHat / SuSE
     
320.       if test -w /var/lock/subsys
     
321.       then
     
322.         touch /var/lock/subsys/mysql
     
323.       fi
     
324.       exit $return_value
     
325.     else
     
326.       log_failure_msg "Couldn't find MySQL manager or server"
     
327.     fi
     
328.     ;;
     
329. 
     
330.   'stop')
     
331.     # Stop daemon. We use a signal here to avoid having to know the
     
332.     # root password.
     
333. 
     
334.     # The RedHat / SuSE lock directory to remove
     
335.     lock_dir=/var/lock/subsys/mysqlmanager
     
336. 
     
337.     # If the manager pid_file doesn't exist, try the server's
     
338.     if test ! -s "$pid_file"
     
339.     then
     
340.       pid_file=$server_pid_file
     
341.       lock_dir=/var/lock/subsys/mysql
     
342.     fi
     
343. 
     
344.     if test -s "$pid_file"
     
345.     then
     
346.       mysqlmanager_pid=`cat $pid_file`
     
347.       echo $echo_n "Shutting down MySQL"
     
348.       kill $mysqlmanager_pid
     
349.       # mysqlmanager should remove the pid_file when it exits, so wait for it.
     
350.       wait_for_pid removed; return_value=$?
     
351. 
     
352.       # delete lock for RedHat / SuSE
     
353.       if test -f $lock_dir
     
354.       then
     
355.         rm -f $lock_dir
     
356.       fi
     
357.       exit $return_value
     
358.     else
     
359.       log_failure_msg "MySQL manager or server PID file could not be found!"
     
360.     fi
     
361.     ;;
     
362. 
     
363.   'restart')
     
364.     # Stop the service and regardless of whether it was
     
365.     # running or not, start it again.
     
366.     script_full_path=$(cd "$(dirname "$0")"; pwd)
     
367.     if $0 stop  $other_args; then
     
368.       $0 start $other_args
     
369.     #if $script_full_path stop  $other_args; then
     
370.     #  $script_full_path start $other_args
     
371.     else
     
372.       log_failure_msg "Failed to stop running server, so refusing to try to start."
     
373.       exit 1
     
374.     fi
     
375.     ;;
     
376. 
     
377.   'reload')
     
378.     if test -s "$server_pid_file" ; then
     
379.       mysqld_pid=`cat $server_pid_file`
     
380.       kill -HUP $mysqld_pid && log_success_msg "Reloading service MySQL"
     
381.       touch $server_pid_file
     
382.     else
     
383.       log_failure_msg "MySQL PID file could not be found!"
     
384.     fi
     
385.     ;;
     
386. 
     
387.   *)
     
388.     # usage
     
389.     echo "Usage: $0  {start|stop|restart|reload}  [ MySQL server options ]"
     
390.     exit 1
     
391.     ;;
     
392. esac
     
393. 
     
394. exit 0
     

复制代码

最后在每个MySQL实例的data目录下配置一个相应的my.cnf
然后再扔一个这个脚本，改一下脚本开头的datadir、basedir，就可以用这个脚本进行启动、重启、关闭了。

已知问题：
在当前目录下运行重启会报脚本找不着，而启动和关闭没问题。脚本所在目录执行也不会有报错。
如: ./mysql.3307.server restart 报错
./data_3307/mysql.3307.server 正常

[ 本帖最后由 leo_ss_pku 于 2009-8-26 18:50 编辑 ]

mouzhi

这样更简单：
/usr/local/mysql/bin/mysqladmin -h 127.0.0.1 -u root -p -P 3410 shutdown