Mariadb多实例启动脚本

1. #!/bin/bash
3. port=3306
4. mysql_user="root"
5. mysql_pwd="centos"
6. cmd_path="/app/mysql/bin"
7. mysql_basedir="/mysqldb"
8. mysql_sock="${mysql_basedir}/${port}/socket/mysql.sock"
10. function_start_mysql()
11. {
12. if [ ! -e "$mysql_sock" ];then
13. printf "Starting MySQL...\n"
14. ${cmd_path}/mysqld_safe --defaults-file=${mysql_basedir}/${port}/etc/my.cnf &> /dev/null &
15. else
16. printf "MySQL is running...\n"
17. exit
18. fi
19. }
22. function_stop_mysql()
23. {
24. if [ ! -e "$mysql_sock" ];then
25. printf "MySQL is stopped...\n"
26. exit
27. else
28. printf "Stoping MySQL...\n"
29. ${cmd_path}/mysqladmin -u ${mysql_user} -p${mysql_pwd} -S ${mysql_sock} shutdown
30. fi
31. }
34. function_restart_mysql()
35. {
36. printf "Restarting MySQL...\n"
37. function_stop_mysql
38. sleep 2
39. function_start_mysql
40. }
42. case $1 in
43. start)
44. function_start_mysql
45. ;;
46. stop)
47. function_stop_mysql
48. ;;
49. restart)
50. function_restart_mysql
51. ;;
52. *)
53. printf "Usage: ${mysql_basedir}/${port}/bin/mysqld {start|stop|restart}\n"
54. esac