shell-mysql-slave

[root@VM_0_5_centos shell]# cat mysql-slave.sh
#!/bin/bash
f=$(mysql -uslave -p123 -h10.0.0.45 -e 'show master status;' | sed -n '2p' | awk '{print $1}')
p=$(mysql -uslave -p123 -h10.0.0.45 -e 'show master status;' | sed -n '2p' | awk '{print $2}')
yum -y install mariadb mariadb-server
sed -i '10i\server-id=2' /etc/my.cnf
sed -i '11i\relay_log=relay-logs' /etc/my.cnf
sed -i '12i\log-bin=mysql-bin' /etc/my.cnf
systemctl start mariadb
mysql -e "change master to master_host='10.0.0.45',master_user='slave',master_password='123',master_log_file='$f',master_log_pos=$p;"
mysql -e "start slave;"
mysql -e "show slave status \G;"