#! /bin/bash


set user=epullum
set mysqluser=opsmonitor
set mysqlpass=0psm0n1
set folder=/root/Desktop/opsource/mysql_automation/serverlist
let ipaddress
let i

function mysql_running
{
    echo "$global_ipaddress"
    ssh -l "$user" "$ipaddress" "pidof mysqld"
    let thepid = ssh-l "user" "ipaddress" "pidof mysqld"
    mysql --user="$mysqluser" --password="$mysqlpass" --host="ipaddress" -e "show global variables like 'innodb_buffer_pool_size';"
}


function mysql_down
{
    echo please verify that all the rpm has been installed and install the reqired rpms.
    ssh -l "$user" "$ipaddress" "rpm -qa | grep mysql" echo
}



let amount='sed -n '$=' "$folder"'

for ((i=0;i-eq"$amount";i++ ));
do
    $global_ipaddress='sed -n $ip "$folder"'
    echo "$ipaddress"
    if [ ssh -l "$user" "$ipaddress" "ps aux | grep mysqld | awk '{print $9}'" -eq null ]
    then
        mysql_running
    else
        mysql_down
    fi
done