Script Help!!


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Script Help!!
# 1  
Old 09-05-2011
Script for mysql slave

Varialbes

NOTIFY="No"

#Check if the slaves are running

SLAVE="$(mysql -uroot -e 'show slave status \G;' | egrep "Slave_IO_Running|Slave_SQL_Running" | awk -F "[:]" '{ print $2 }' | cut -d, -f1)"

Yes
Yes

#Compare SLAVE to Notify

if (("$SLAVE" > "$NOTIFY)); then

#IT should stop the slave

mysql -uroot -e'stop slave;'

but the problem is that my output for SLAVE is two lines

Yes
Yes

Now it seems like it doesnt recognizes the output of SLAVE when comparing to NOTIFY

Now how will i do that it will matches the YES to No.

TOmake it clear here's how i want the script to work

1. Check the status of slave by getting the Slave_IO_Running and Slave_IO_Running if it is in YES state.
Code:
mysql -uroot -e 'show slave status \G;' | egrep "Slave_IO_Running|Slave_SQL_Running" | awk -F "[:]" '{ print $2 }' | cut -d, -f1
Yes
Yes

Slave_IO_Running: Yes
Slave_SQL_Running: Yes

2. IF the status is YES then it will compare to notify and do nothing
Code:
if (("$SLAVE" == "$NOTIFY)); then

But if it matches with NO then it will run the next command which is

Code:
mysql -uroot -e 'stop slave';


Now the problem is it seems like it SLAVE and NOTIFY is not comparing correctly.

Please help me guys to fix this.

thanks

Last edited by redtred; 09-05-2011 at 12:27 PM..
# 2  
Old 09-05-2011
Do not post classroom or homework problems in the main forums. Homework and coursework questions can only be posted in this forum under special homework rules.

Please review the rules, which you agreed to when you registered, if you have not already done so.

More-than-likely, posting homework in the main forums has resulting in a forum infraction. If you did not post homework, please explain the company you work for and the nature of the problem you are working on.

If you did post homework in the main forums, please review the guidelines for posting homework and repost.

Thank You.

The UNIX and Linux Forums.
Login or Register to Ask a Question

Previous Thread | Next Thread

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to block first bash script until second bash script script launches web server/site?

I'm new to utilities like socat and netcat and I'm not clear if they will do what I need. I have a "compileDeployStartWebServer.sh" script and a "StartBrowser.sh" script that are started by emacs/elisp at the same time in two different processes. I'm using Cygwin bash on Windows 10. My... (3 Replies)
Discussion started by: siegfried
3 Replies

2. Shell Programming and Scripting

Shell script works fine as a standalone script but not as part of a bigger script

Hello all, I am facing a weird issue while executing a code below - #!/bin/bash cd /wload/baot/home/baotasa0/sandboxes_finance/ext_ukba_bde/pset sh UKBA_publish.sh UKBA 28082015 3 if then echo "Param file conversion for all the areas are completed, please check in your home directory"... (2 Replies)
Discussion started by: ektubbe
2 Replies

3. UNIX for Dummies Questions & Answers

Calling a script from master script to get value from called script

I am trying to call a script(callingscript.sh) from a master script(masterscript.sh) to get string type value from calling script to master script. I have used scripts mentioned below. #masterscript.sh ./callingscript.sh echo $fileExist #callingscript.sh echo "The script is called"... (2 Replies)
Discussion started by: Raj Roy
2 Replies

4. Shell Programming and Scripting

Script will keep checking running status of another script and also restart called script at night

I am using blow script :-- #!/bin/bash FIND=$(ps -elf | grep "snmp_trap.sh" | grep -v grep) #check snmp_trap.sh is running or not if then # echo "process found" exit 0; else echo "process not found" exec /home/Ketan_r /snmp_trap.sh 2>&1 & disown -h ... (1 Reply)
Discussion started by: ketanraut
1 Replies

5. Shell Programming and Scripting

create a shell script that calls another script and and an awk script

Hi guys I have a shell script that executes sql statemets and sends the output to a file.the script takes in parameters executes sql and sends the result to an output file. #!/bin/sh echo " $2 $3 $4 $5 $6 $7 isql -w400 -U$2 -S$5 -P$3 << xxx use $4 go print"**Changes to the table... (0 Replies)
Discussion started by: magikminox
0 Replies
Login or Register to Ask a Question