As I discussed in the last post there is a virtual requirement for scripting ability in a large scale environment. The following is a simple script that could be used deploy scripts to pool of server.
--------------------------------------------------
#!/bin/bash
script=path/to/script/file.sql
for i in {1..100}
do
(
for dc in 'chi' 'la' 'sf'
do
for db in `mysql -u dba -h mysql${i}-${dc} -e
"SHOW DATABASES"`
do
if [[ -z `mysql -u dba -s -rB
-h mysql${i}-${dc} $db < $script` >>
output/mysql.success ]]
then echo p-cs${i}-${dc} $db
>> output/mysql.broken;
fi
done;
done;
)&
done;
This isn't …
[Read more]