KERNEL - Linux

LINUS --> KERNEL = LINUX (LINUS+UNIX) --> GNU / GPL

GNU LINUX = KERNEL + PACOTES GNU /  FSF

REDES - Interface eth e wlan

Qual é o caminho?

cat /etc/udev/rules.d/70-persistent-net.rules

# This file was automatically generated by the /lib/udev/write_net_rules
# program, run by the persistent-net-generator.rules rules file.
#
# You can modify it, as long as you keep each rule on a single
# line, and change only the value of the NAME= key.

# PCI device 0x10ec:0x8168 (r8169)
SUBSYSTEM=="net", ACTION=="add", DRIVERS=="?*", ATTR{address}=="30:1f:06:62:29:e6", ATTR{dev_id}=="0x0", ATTR{type}=="1", KERNEL=="eth*", NAME="eth0"

# PCI device 0x1814:0x3090 (rt2800pci)
SUBSYSTEM=="net", ACTION=="add", DRIVERS=="?*", ATTR{address}=="81:3f:5e:01:1e:67", ATTR{dev_id}=="0x0", ATTR{type}=="1", KERNEL=="wlan*", NAME="wlan0"

MEMCACHED

Como dar start no memcached:

/usr/local/memcached/bin/memcached -p 11211 -U 11211 -u memcached -m 1024 -c 2048 -P /var/run/memcached/memcached.pid -d

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;