万答17，AWS RDS怎么搭建本地同步库

mysql> show slave status\G;
1.

mysql> call mysql.rds_stop_replication;
1.

mysql> call mysql.rds_set_configuration('binlog retention hours',168);
1.

mysql> mysqldump --single-transaction --default-character-set=utf8 -h 从aws的域名 -P从aws端口 -uroot -pGreatSQL -R -E -B 导出的库名 > /backup/导出的库名_时间.sql
1.

mysql> mysql -uroot -pGreatSQL -S /tmp/mysql.sock < /backup/导出的库名_时间.sql
1.

mysql> GRANT REPLICATION SLAVE ON *.* TO 'sync'@'%' IDENTIFIED BY 'GreatSQL';
mysql> flush privileges;
1.
2.

mysql> change master to master_host='主RDS域名',master_port=主RDS端口,master_user='sync',master_password='GreatSQL',master_log_file='前面步骤4Relay_Master_Log_File的值',master_log_pos=前面步骤4Exec_Master_Log_Pos的值;
mysql> start slave;
1.
2.

mysql> call mysql.rds_start_replication;
1.