shell脚本mysql主从

环境准备：

[root@master1 admin]# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.100.16 master1
192.168.100.17 slave1

【master1节点】

#!/bin/bash
mysql -hmaster1 -uroot -p123456 << EOF   #方法2实例
create database tianyun;
create table tianyun.t1(id int,name varchar(50));
insert into tianyun.t1 values(1,'yang');
insert into tianyun.t1 values(2,'tom');
select * from tianyun.t1;
EOF
sed -i "/\[mysqld\]/a\log-bin"  /etc/my.cnf
sed -i "/\[mysqld\]/a\server-id=1"  /etc/my.cnf
mysql -hmaster1 -uroot -p123456 << EOF
grant replication slave on *.* to 'rep'@'192.168.100.%' identified by '123456';
flush privileges;
EOF
aa=`date +%F`
mysqldump -p'123456' --all-databases --single-transaction --master-data=1 --flush-logs > ${aa}-mysql-all.sql
bb=`ls 20*sql`
scp -r ${bb} slave1:/root

【slave1】

ee=`ls /root/20*sql`
chmod -R 777 ${ee}
sed -i "/\[mysqld\]/a\server-id=2"  /etc/my.cnf
systemctl restart mysqld
mysql -p123456 << EOF 
set sql_log_bin=0;
source /root/${ee};
change master to master_host='master1',master_user='rep',master_password='123456';
start slave;
show slave status \G;  
EOF
ls