验证

主服务器

从服务器

在从服务器上，你应该可以看到相同的变化。

拓展知识

GRANT REPLICATION SLAVE

The REPLICATION SLAVE privilege should be granted to accounts that are used by slave servers to connect to the current server as their master. Without this privilege, the slave cannot request updates that have been made to databases on the master server.

Rules for Read Lock

The session that holds the lock can read the table (but not write it).

Multiple sessions can acquire a READ lock for the table at the same t ime.

Other sessions can read the table without explicitly acquiring a READ lock.

Rules for Write Lock

The session that holds the lock can read and write the table.

Only the session that holds the lock can access the table. No other session can access it until the lock is released.

Lock requests for the table by other sessions block while the WRITE lock is held.