Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server:
Master:

Slave:
http://www.cndba.cn/hbhe0316/article/22766

There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?
A. The log_bin variable is set to OFF on the slave.
B. server_id is not unique.
C. The max_connections variable on the slave needs to be increased.
D. The shared_memory_base_name variable must match the master.
E. The version of the slave is newer that the version of the master.
Answer: B

主节点和从节点的server_id都是2，不满足。

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL