Master-slave synchronization: Add a new database under the specified database, and synchronize the new database.

I have two master databases, A and B.

For historical reasons, database a only allows synchronization of database AA and database BB, that is, database A creates a new database, and database B does not synchronize data.

OK. Start.

1 A: Remove BINLOG-do-db. I don't want to operate it later! The new database is ccbinlog-do-DB.

2. Restart A. This is for CC synchronization.

3 flush tables with read lock; lock the table to stop new data insertion

4. Check the B show slave status. If all the data has been synchronized, stop slave;

5. Dump data on A. mysqldump-uroot-p -- Single-transaction -- master-data-A>/home/good2. SQL

Unlock tables immediately after dump; this is to reduce service time, and then synchronize to B

6. import data from mysql-uroot-P <good2. SQL

7. Restart B and start slave. Log tracing is complete!

Amount. I am a cainiao and I use dump =. =

Master-slave synchronization: Add a new database under the specified database, and synchronize the new database.