1Z0-908: MySQL 8.0 Database AdministratorDemo

By Oracle · Question Mode

QuestionQ111

Architecture

Four nodes are configured for circular replication.

Review these configuration parameters on every node:

Question Image

Which statement is correct?

  • A Each slave thread is responsible for updating a specific database.
  • B Cross-database constraints can cause database inconsistency.
  • C Increasing slave_parallel_workers will improve high availability.
  • D Setting slave_preserve_commit_order to on will improve data consistency.
  • E Setting slave_parallel_type=DATABASE won't work for circular replication; it should be set to LOGICAL_CLOCK.
  • F Setting transaction_allow_batching to on will improve data consistency.
Explanation

With slave_parallel_type=DATABASE, transactions affecting separate databases can be applied concurrently by replica worker threads. This policy requires independently updated databases; cross-database constraints can be violated on the replica and can therefore result in database inconsistency.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!