Test one: RDS Master RDS from only need to create an RDS DB Instance 1. Version rds:5.6.21 2. Operation procedure Select the data---to be manipulated click Instance Action----Create a read replica---setting has a DB instance identifier, which is the name of the synchronization with slave Complete the creation, wait for a while, the new Rds-slave appears, the synchronization operation is completed
Test two: RDS Master RDS from EC2 from
One, version rds:5.6.21 two, the Operation Step 1. Select the data---to be manipulated click instance----Create a read replica---setting has a DB instance identifier, which is synchronized with the name of the slave to complete the creation, wait a while, the new rds-slave appears , the synchronization operation completes 2. After you create the rds-slave, you need to set up automatic backups on this read from the library. 3. Build non-rds-mysql, test for rpm5.6.22 version, the only thing to note is that MySQL and Performance_schema, INFORMATION_SCHEMA Library Limited by the RDS user's rights, is not synchronized. Therefore, it is recommended to use REPLICATE-DO-DB,REPLICATE-IGNORE-DB to specify or omit the library 4 in the non-RDS MySQL my.cnf. Stop the Rds-mysql slave process, call the stored procedure called Mysql.rds _stop_replication 5. The remaining only needs to be viewed with the values of Rds-slave Relay_master_log_file and Exec_master_log_pos 6. Non-RDS-MYSQ join to the cluster change Master to Master_host = ' hostname ', master_port = 3306,master_user = ' repl ', master_password= ' password ', master_log_file= ' Master-bin.000002 ', master_log_pos=730039; 7. Start non-rds-mysqlstart slave;
Rds--mysql Master