pre_freeze script (MySQL)

#!/bin/sh
#pre-freeze-script
date >> '/scripts/pre_root.log'
echo -e "\n attempting to run pre-freeze script for MySQL as root user\n" >> /scripts/pre_root.log
if [ "$(id -u)" -eq "0" ]; then
python '/scripts/quiesce.py'
if [ $? -ne 0 ]
then
  echo -e "\n Unable to quiesce MySQL DB\n" >> /scripts/pre-freeze.log
  exit 1
fi
echo -e "\n executing query flush tables with read lock to quiesce the database\n" >> /scripts/pre-freeze.log
echo -e "\n Database is in quiesce mode now\n" >> /scripts/pre-freeze.log
else
date >> '/scripts/pre_root.log'
echo -e "not root user\n" >> '/scripts/pre_root.log'
fi

Loading...