mysql中自动添加mysql从库思路
1、自动安装部署mysql,若已经安装了mysql得先判断版本是否比主库低(存在向下兼容问题)
2、获取主库的备份文件及binlog信息(binary logfile,binary position)
3、修改从服务器的配置文件信息
server-id不能重复
replicate-wild-do-table=xxx.%
replicate-wild-ignore-table=mysql.%
4、导入主库的备份文件
5、在主库中添加从库的授权信息
GRANT REPLICATION SLAVE ON *.* TO ‘backup’@’10.144.32.119′ IDENTIFIED BY PASSWORD ‘*CC9860AEF70E1F48CCA5505EC1DC943085A4AEBB’;
6、设置连接主库的信息
CHANGE MASTER TO
MASTER_HOST=’10.163.167.7′,
MASTER_USER=’backup’,
MASTER_PASSWORD=’backup’,
MASTER_PORT=3306,
MASTER_LOG_FILE=’mysql-bin.000010′,
MASTER_LOG_POS=399387901,
MASTER_CONNECT_RETRY=10;
7、开启复制
start slave;