CLUSTER - Servidor SLAVE com o DB corrompido.

Como recuperar a slave com base em outra slave funcional.

##############################################################################

PREPARANDO O DUMP

obs.: conferir se o server slave queComo recuperar a slave com base em outra slave funcional. serbirá de suporte tem a mesma MASTER da slave defeituosa.

# servidor de apoio 192.168.0.3
[root@mcp003~]# cat /usr/local/mysql/data/master.info

14
mcp003-bin.000007
257319864
192.168.0.1
root
<senha do DB>
3306
60
0

# servidor com DB corrompido 192.168.0.2
[root@mcp002~]# cat /usr/local/mysql/data/master.info

10
mcp002-bin.000003
2573123457
192.168.0.1
root
<senha do DB>
3306
60
0

obs.: ambos tem o master como 192.168.0.1

cd ~

cp /usr/local/mysql/data/master.info `date +%Y%m%d.%H%M%S`.master.info .

/usr/local/mysql/bin/mysqldump -uroot -p<senha> --all-databases  | pbzip2 -p$(cat /proc/cpuinfo | grep ^processor | wc -l) -c > ~/`date +%Y%m%d.%H%M%S`.dump.`hostname -s`.bz2 &

##############################################################################

CORRIGINDO O DB

#Parando o mysql
/usr/local/mysql/bin/mysqladmin -uroot -pxxxxxxxx shutdown

scp user@192.168.0.3:/home/teste/<data>.* .

cd /usr/local/mysql/

mv  data/ `date +%Y%m%d.%H%M%S`.data &
 
mkdir data

cd data/

cp -r ../<data do bkp>.data/mysql .

cd ~

/usr/local/mysql/bin/mysqld -uroot --skip-slave-start &

pbunzip2 -p$(cat /proc/cpuinfo | grep ^processor | wc -l) -c <data>.dump.mcp003.bz2 | /usr/local/mysql/bin/mysql -uroot -pxxxxxxxx &

cat /home/teste/<data>master.info

14
mcp003-bin.000007
257319864
192.168.0.1
root
<senha do DB>
3306
60
0

/usr/local/mysql/bin/mysqld -uroot -p

show slave status\G;

CHANGE MASTER TO master_host="192.168.0.1",master_log_pos=257319864,master_log_file='mcp003-bin.000007';

start slave;

show slave status\G;

quit;