Skip to main content

Posts

Featured

mySQL 8 post flip validation script

mySQL 8 post flip  validation script  #!/bin/bash # MySQL credentials (modify as needed) MYSQL_USER="your_mysql_user" MYSQL_PASSWORD="your_mysql_ password" MYSQL_PORT="3306"  # Replace with your MySQL port if necessary # Get current hostname CURRENT_HOST=$(hostname) # Function to execute MySQL queries execute_mysql_query() {     mysql -u"$MYSQL_USER" -p"$MYSQL_PASSWORD" -h"$CURRENT_HOST" -P"$MYSQL_PORT" -e "$1" } # Function to get parameter value from my.cnf file get_param_from_cnf() {     local param_name="$1"     local cnf_file="/etc/mysql/my.cnf"  # Adjust path as necessary     if [ -f "$cnf_file" ]; then         local value=$(grep -i "^$param_name\s*=" "$cnf_file" | awk -F "=" '{gsub(/^[ \t]+/, "", $2); print $2}')         echo "$value"     else         echo "my.cnf not found at $cnf_file"     fi } # Check

Latest Posts

Flush a Sql from shared pool

RMAN Nohup

ASM Space

SQL Health query