Summary of issues encountered by MySQL master-slave replication

1, master-slave replication is not the case of full-Library replication

For example, just copy the DB1 library from the library: replicate_do_db =DB1

Note: In this case do not under the main library DB1, perform other operations related to other libraries, or the library will be blocked by error

Or do not use a tool attached to the DB1 library, the following statement

Use DB1;

CREATE TABLE db2.test (ID int, name username);

If you get an error, you need to skip from the library.

2, jumping from the library method

3. How to speed up copy from library

This article from "Small Fish Blog" blog, declined reprint!

Summary of issues encountered by MySQL master-slave replication