首页 试题详情
单选题


Choose the best answer.
Four nodes are configured to use circular replication. Examine these configuration parameters for each each node:
Slave_parallel_type=DATABASE ; slave_parallel_workers=4 slave_preserve_commit_order=0
Which statement is true?

AEach slave thread is responsible for updating a specific database.

BCross-database constraints can cause database inconsistency.

CSetting slave_parallel_type=DATABASE won‘t work for circular replication; it should be set to
LOGICAL_CLOCK.

DIncreasing slave_parallel_workers will improve high availability.

ESetting slave_preserve_commit_order to ON will improve data consistency.

FSetting transaction_allow_batching to ON will improve data consistency.

正确答案:A (备注:此答案有误)

相似试题

  • 判断题

    Employers often choose the best candidate.

    答案解析

  • 单选题

    [音频]Listen to the dialogue and choose the best answer to the question you hear.( )

    答案解析

  • 单选题

    Choose the best answer.Which statement is true about InnoDB persistent index statistics?

    答案解析

  • 单选题

    Choose the best answer.How can mysqld_multi be configured to allow MySQL instances to use the same port number?

    答案解析

  • 单选题

    Choose the best answer.Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?

    答案解析

热门题库