Group Replication uses global transaction identifiers to track executed transactions and are fundamental in avoiding transaction conflict. Which additional three steps help in avoiding conflicts in group replication?
A. Set isolation level to be SERIALIZABLE.
B. Use the binary log row format.
C. Set isolation level to be READ COMMITTED.
D. Configure IPv6 network for hosts.
E. Guarantee a secondary index on every table.
F. Guarantee a primary key on every table.
G. Set multiple slave parallel worker threads.
Answer:BFG

组复制使用GTID来跟踪已经执行的事务，并以此来避免事务冲突。除此以外，还有哪三个步骤也是用来避免事务冲突的？
A．将隔离级别设置为串行化
B．使用ROW格式的binlog
C．将隔离级别设置为读提交
D．使用IPv6网络
E．确保每张表都有辅助索引
F．确保每张表都有主键索引
G．启用并行复制http://www.cndba.cn/hbhe0316/article/22789http://www.cndba.cn/hbhe0316/article/22789http://www.cndba.cn/hbhe0316/article/22789http://www.cndba.cn/hbhe0316/article/22789

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

MYSQL