1Z0-908: MySQL 8.0 Database AdministratorDemo

By Oracle · Question Mode

QuestionQ165

Architecture

You have deployed an InnoDB Cluster in production.

Examine this command and its output:

Question Image

Which statement is correct?

  • A The cluster status reports that there are enough members for a quorum but there is no redundancy.
  • B The cluster lost its quorum as mymysql02 node status is MISSING.
  • C The cluster lost its quorum as statusText says Cluster is NOT tolerant to any failures. 1 member is not active.
  • D The cluster status is equivalent to status: OK_PARTIAL as one or more members are unavailable.
Explanation

With two ONLINE members out of three, the cluster still has a majority and therefore retains quorum, but it has no remaining redundancy or failure tolerance. OK_NO_TOLERANCE indicates that the cluster is not tolerant of any further failures; NO_QUORUM would require a majority of the replication group to be unavailable.

Learn more

Community Discussion

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