Put all hostname Ip address in the hosts.text file-
for x in `cat hosts.txt`; do echo $x; ssh -t $x “mysqlcheck -uroot -paSSw0rd -A –auto-repair –all-databases | grep -v OK”; done
It will ssh to all hosts and repair mariaDB database
Put all hostname Ip address in the hosts.text file-
for x in `cat hosts.txt`; do echo $x; ssh -t $x “mysqlcheck -uroot -paSSw0rd -A –auto-repair –all-databases | grep -v OK”; done
It will ssh to all hosts and repair mariaDB database