shell yum 自动mysql_使用shell脚本自动配置mysql主从

最新推荐文章于 2023-10-10 20:32:56 发布

林宇宙

最新推荐文章于 2023-10-10 20:32:56 发布

阅读量98

点赞数

文章标签： shell yum 自动mysql

本文链接：https://blog.csdn.net/weixin_42517963/article/details/113342258

版权

#!/bin/bash

export mysqlbinpath="/usr/bin" #mysql路径

#variables for master

export master_mysql_root_passwd="root" #mysql主数据库的root密码

export replication_user="copydb" #用于复制的mysql用户

export replication_passwd="123456" #mysql用户copydb的密码

export replication_db="centos" #需要同步的数据库名

export master_ip="8.8.8.8" #mysql主服务器IP

#variables for slave

export slave_mysql_root_passwd="123456" #mysql从数据库的root密码

export slave_ip="8.8.4.4" #从服务器IP地址

export slave_ssh_root_passwd="123456" #mysql从数据库的ssh的root密码

#create replication user

{

${mysqlbinpath}/mysql -uroot -p${master_mysql_root_passwd} <

CREATE USER '$replication_user'@'$slave_ip' IDENTIFIED BY '$replication_passwd';

GRANT REPLICATION SLAVE ON *.* TO '$replication_user'@'$slave_ip' IDENTIFIED BY '$replication_passwd';

FLUSH TABLES WITH READ LOCK;

select sleep(10);

EOF

} &

#export the database sql data.

${mysqlbinpath}/mysqldump -uroot -p${master_mysql_root_passwd} ${replication_db} > ${replication_db}.sql

#get the master status info.

export status=`${mysqlbinpath}/mysql -uroot -p${master_mysql_root_passwd} -e"show master status\G"`

export binlogname=`echo "$status" | grep "File" | awk '{print $2}'`

export position=`echo "$status" | grep "Position" | awk '{print $2}'`

#create database on slave server.

export createdb="${mysqlbinpath}/mysql -uroot -p${slave_mysql_root_passwd} -e'drop database if exists ${replication_db};create database ${replication_db};'"

#import database sql data on slave server.

export importsql="${mysqlbinpath}/mysql -uroot -p${slave_mysql_root_passwd} ${replication_db} < /root/${replication_db}.sql"

#deploy the slave mysql server.

export change_master="${mysqlbinpath}/mysql -uroot -p${slave_mysql_root_passwd} -e'stop slave;CHANGE MASTER TO MASTER_HOST=\"${master_ip}\",MASTER_USER=\"${replication_user}\",MASTER_PASSWORD=\"${replication_passwd}\",MASTER_PORT=3306,MASTER_LOG_FILE=\"${binlogname}\",MASTER_LOG_POS=${position},MASTER_CONNECT_RETRY=10;start slave;select sleep(3);show slave status\G'"

yum -y install expect

./slave.exp