Enterprise Scenario One master many from downtime to solve from the library

Solution Ideas:

1. Log in from the library

Mysql-uroot-p123456-s/application/mysql-5.6.20/mysql.sock

2. Stop slave Service

Mysql>stop slave;

3. Fully backup the synchronized data from the library or the main library, and determine the synchronization file and synchronization location

Mysqldump-uroot-p123456-s/application/mysql-5.6.20/mysql.sock-a-B--events|gzip >/opt/rep.sql.gz

4. Pour the data into the library

#gunzip Rep.sql.gz>rep.sql

#mysql-uroot-p ' pwd123 '-s/application/mysql-5.6.20//mysql.sock < Rep.sql

5. Perform synchronous commands

Mysql>change Master to master_host= ' 10.0.0.7 ', master_user= ' repl ',

Master_password= ' Slavepass ', master_log_file= ' mysql-bin.001440 ',

master_log_pos=68824;

6. Turn on the sync service Services

Mysql>start slave

This article from "Flat Light is true" blog, please be sure to keep this source http://ucode.blog.51cto.com/10837891/1747084

Enterprise Scenario One master many from downtime to solve from the library