Nearly every job advertisement for MySQL DBA positions asks for
’shell scripting’, so I decided to investigate what it is. I
remembered some performance training, where I was told how
forking is bad, and one should attempt to use shell features as
much as possible (like, avoid paths to something, what can be
used by builtin (e.g. don’t use /usr/bin/[, just
pure [ instead )
I tried to automate one MySQL DBA task (reinitializing slave after relay log corruption or after copying in cloned dataset from other server) using just bash - and it kind of worked. From now on I can put 'Shell scripting' proudly on my resume :-)
Next step - learn JCL (some people think this is funny :)
What was your most complicated task solved with shell scripts? :)
#!/bin/bash HOST=$1 RPASS=$(<passwordfile) IFS=" " …[Read more]