A master-slave replication setup has the slave showing this error:
http://www.cndba.cn/hbhe0316/article/22764

What could explain this error? (Choose two.)
A. binlog_cache_size=1024 is too small and transactions are lost.
B. binlog_format=STATEMENT and a non-deterministic query was executed.
C. enforce_gtid_consistency=ON and consistency is broken between the master and the slave.
D. The sync_relay_log=1000 setting on the slave is too small.
E. sync_binlog=0 and the master server crashed.
Answer: CE
如果是单选，只选Ehttp://www.cndba.cn/hbhe0316/article/22764

What could explain this error? (Choose two.)
什么能解释这个错误？（选择两个。）
A. binlog_cache_size=1024 is too small and transactions are lost.
binlog_cache_size=1024太小，事务丢失。
B. binlog_format=STATEMENT and a non-deterministic query was executed.
B.binlog_format= STATEMENT，执行了一个不确定的查询。
C. enforce_gtid_consistency=ON and consistency is broken between the master and the slave.
C.enforce_gtid_consistency=打开，主设备和从设备之间的一致性被破坏。
D. The sync_relay_log=1000 setting on the slave is too small.
D.从机上的sync_relay_log=1000设置太小。
E. sync_binlog=0 and the master server crashed.
E.sync_binlog=0，主服务器崩溃。http://www.cndba.cn/hbhe0316/article/22764http://www.cndba.cn/hbhe0316/article/22764http://www.cndba.cn/hbhe0316/article/22764

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

MYSQL