创建用户(主库) ```sql mysql> CREATE USER 'repl'@'%' IDENTIFIED BY 'xxxxxx'; mysql> GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%' ; mysql> flush privileges; ``` 创建备份文件(主库) `方式一:备份生成GTID` ```bash mysqldump -hxxxxx.mysql.rds.aliyuncs.com -uroot -pxxxxxx --databases db1 db2 db3 >db.sql ``` `方式一:备份生成binlog位置` ```bash mysqldump -hxxxxx.mysql.rds.aliyuncs.com --master-data=2 --set-gtid-purged=OFF -uroot -pxxxxxx --databases db1 db2 db3 >db.sql ``` 还原备份(从库) ```sql mysql> source db.sql ``` 创建同步(从库) `方式一:备份生成GTID方式` ```sql mysql> CHANGE MASTER TO MASTER_HOST='xxxxx.mysql.rds.aliyuncs.com', MASTER_USER='repl', MASTER_PASSWORD='xxxxxx', master_auto_position=1 FOR CHANNEL "test"; ``` `方式二:备份生成binlog位置方式` ```sql mysql> CHANGE MASTER TO MASTER_HOST='xxxxx.mysql.rds.aliyuncs.com', MASTER_USER='repl', MASTER_PASSWORD='xxxxxx', MASTER_LOG_FILE='mysql-bin.xxxx', MASTER_LOG_POS=xxxxx FOR CHANNEL "test"; ``` 启动同步(从库) ```bash mysql> START SLAVE FOR CHANNEL "test"; mysql> show slave status FOR CHANNEL "test"\G ```