nginx项目二

主机名	IP	作用	软件包
master	192.168.10.100	主节点	mha-manager+nginx+keepalived
backup	192.168.10.101	备份节点	mha-node+nginx+keepalived
node1	192.168.10.102	工作节点	mha-node+tomcat
node2	192.168.10.103	工作节点	mha-node+tomcat

cat >>name-01<<eof
#!/bin/bash
echo "===========genrsa===================="
expect <<EOF
spawn ssh-keygen -t rsa
expect {
    "*id_rsa):" { send "\n";exp_continue}
    "*passphrase):" { send "\n";exp_continue}
    "*again:" { send "\n"}
}
expect eof
EOF
eof

cat >>name-02<<eof
#!/bin/bash
echo "===========genrsa===================="
expect <<EOF
spawn ssh-keygen -t rsa
expect {
    "*id_rsa):" { send "\n";exp_continue}
    "*(y/n)?" { send "y\n";exp_continue}
    "*passphrase):" { send "\n";exp_continue}
    "*again:" { send "\n"}
}
expect eof
EOF
eof

rm -rf /etc/yum.repos.d/c*




for i in 100 101 102 103
do
  ssh-copy-id 192.168.10.$i
  echo "StrictHostKeyChecking no" >>/etc/ssh/ssh_config
done




for i in 100 101 102 103
do
  echo "192.168.10.$i" >> /etc/hosts
done

yum -y install epel-release

yum install -y perl-Config-Tiny epel-release perl-Log-Dispatch perl-Parallel-ForkManager perl-Time-HiRes

yum -y install perl-DBD-MySQL perl-Config-Tiny perl-Log-Dispatch perl-Parallel-ForkManager

yum -y install perl perl-DBD-MySQL perl-ExtUtils-CBuilder perl-ExtUtils-MakeMaker perl-CPAN

yum install -y perl-DBD-MySQL perl-Config-Tiny perl-Log-Dispatch perl-Parallel-ForkManager perl-Config-IniFiles perl-Time-HiRes

scp mysql-5.7.tar.gz backup:/root/

scp mysql-5.7.tar.gz node1:/root/

scp mysql-5.7.tar.gz node2:/root/

scp mha4mysql-node-0.57-0.el7.noarch.rpm backup:/root/

scp mha4mysql-node-0.57-0.el7.noarch.rpm node1:/root/

scp mha4mysql-node-0.57-0.el7.noarch.rpm node2:/root/

mkdir mysql;tar xf mysql-5.7.tar.gz -C mysql;cd mysql

yum -y install ./mysql*.rpm

systemctl restart mysqld && systemctl enable mysqld

echo "validate-password=OFF">> /etc/my.cnf

systemctl restart mysqld && systemctl enable mysqld 

grep 'password' /var/log/mysqld.log

mysql -u root -p

set password for root@localhost = password('123456'); 

flush privileges;

exit

systemctl restart mysqld

rpm -ivh mha4mysql-node-0.57-0.el7.noarch.rpm 

master操作：

rpm -ivh mha4mysql-manager-0.57-0.el7.noarch.rpm

cat>> /etc/my.cnf<<eof
server-id=1
log-bin=mysql-bin-master
binlog-do-db=test_db
eof

systemctl restart mysqld

mysql -uroot -p123456


create database test_db;

use test_db;

create table employee(ID int(12)not null primary key ,NAME varchar(8)not null,AGE int(3)not null);

desc employee;

create user mha identified by '123456';

create user slave identified by '123456';

grant replication slave on *.* to 'slave'@'192.168.10.%' identified by '123456';
 
grant all privileges on *.* to 'mha'@'192.168.10.%' identified by '123456';

flush privileges;

show master status\G

backup操作：

cat>> /etc/my.cnf<<eof
server-id=2
log-bin=mysql-bin-slave1
binlog-do-db=test_db
log-slave-updates=1
eof

systemctl restart mysqld

mysql -uroot -p123456

grant replicat