Realize the start and stop of MYSQL through simple script

This article mainly introduces to you through a simple script to achieve the start and stop of MYSQL, the contents of the article are carefully selected and edited by the author, with a certain pertinence, for everyone's reference significance is still relatively great, the following with the author to understand the start and stop of MYSQL through a simple script.

For MYSQL with multiple instance installations, the start and stop process is relatively complex, and some simple scripts can be defined to simplify day-to-day management.

Environment variable script

[mysql@mysql01 scripts] $cat mysql_env.ini#set envMYSQL_USER=rootMYSQL_PASS='password123' # password saved in plaintext, of course, cannot be used in the production library. COPYDIR='/opt/mysql'BASEDIR='/data/mysqldata'#check parameterif [$#-eq 0] then MYSQL_PORT=3306else MYSQL_PORT=$ 1fi [MySQL @ mysql01 scripts] $

MYSQL startup script

[mysql@mysql01 scripts] $cat mysqlstarted startup.shangxue binram bashsource / data/mysqldata/scripts/mysql_env.iniecho "Startup MySQL Service: localhost_" ${MYSQL_PORT} ${COPYDIR} / bin/mysqld_safe-- defaults-file=$ {BASEDIR} / ${MYSQL_PORT} / my.cnf & [mysql@mysql01 scripts] $

Stop script for MYSQL

[mysql@mysql01 scripts] $cat mysqlstores shutdown.shangxinxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Quick landing

[mysql@mysql01 scripts] $cat mysqlcmd.shangxinxinxinxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

"establish a soft connection

[mysql@mysql01 scripts] $pwd/data/mysqldata/scripts [mysql@mysql01 scripts] $ln-s mysqlcmd.sh mysqlcmd [mysql@mysql01 scripts] $ln-s mysql_startup.sh mysqlstart [mysql@mysql01 scripts] $ln-s mysql_shutdown.sh mysqlstop [mysql@mysql01 scripts] $ls-ralttotal 32drwxr-xr-x. 5 mysql mysql 44 Aug 27 03:33.-rwxrw-r--. 1 mysql mysql 189 Aug 28 20:14 mysql_startup.sh-rwxrw-r--. 1 mysql mysql 220 Aug 28 20:19 mysql_shutdown.sh-rwxrw-r--. 1 mysql mysql 202 Aug 28 20:23 mysqlcmd.sh-rw-r--r--. 1 mysql mysql 12288 Aug 28 20:26 .mysql _ shutdown.sh.swp-rw-rw----. 1 mysql mysql 176 Aug 28 20:26 mysql_env.inilrwxrwxrwx. 1 mysql mysql 11 Aug 28 20:30 mysqlcmd-> mysqlcmd.shlrwxrwxrwx. 1 mysql mysql 16 Aug 28 20:30 mysqlstart-> mysql_startup.shlrwxrwxrwx. 1 mysql mysql 17 Aug 28 20:31 mysqlstop-> mysql_shutdown.sh

The process of using

6. Identify the currently running MYSQL instances, divided by port

[mysql@mysql01 scripts] $netstat-lnt | grep 330tcp6 0 0:: 3306: * LISTEN

You can see that 3306 is currently running, stop 3306

6. Stop MYSQL

[mysql@mysql01 scripts] $mysqlstop 3306Shutdown MySQL Service: localhost_3306Warning: Using a password on the command line interface can be insecure. [mysql@mysql01 scripts] $

6. Launch MYSQL

[mysql@mysql01 scripts] $mysqlstart 3306Startup MySQL Service: localhost_3306 [mysql@mysql01 scripts] $180828 21:33:49 mysqld_safe Logging to'/ data/mysqldata/3306/data/../mysql-error.log'.180828 21:33:49 mysqld_safe Starting mysqld daemon with databases from / data/mysqldata/3306/data [mysql@mysql01 scripts] $

6. Using MYSQL

[mysql@mysql01 scripts] $mysqlcmd 3306Startup MySQL CMD: localhost_3306Warning: Using a password on the command line interface can be insecure.Welcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 1Server version: 5.6.31-log Source distributionCopyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.

(root@localhost) [(none)] >

After reading the above about the start and stop of MYSQL through a simple script, many readers must have some understanding. If you need to get more industry knowledge and information, you can continue to follow our industry information column.