Examine these InnoDB Cluster parameter settings: Now examine the partial status: A permanent network failure isolates host3. Which two statements are true? (Choose two.)
A.
The instance deployed on host2 is elected as the new primary instance.
B.
The instance deployed on host3 is expelled from the cluster and must be rejoined using cluster.addInstance ('host3:3377')
C.
The instance deployed on host3 will automatically rejoin the cluster when connectivity is re-established.
D.
Failure of the instance deployed on host1 provokes an outage.
E.
The issuing command cluster.switchToMuitiPrimaryMode() will fail to enable multi-primary mode.
F.
The primary instance can be specified by using the command cluster.setPrimaryInstance(<host>:<port>).
I created the 3 instances to test this case.
A – Incorrect: Host2 is not elected as primary, but rather Host1 due to its greater weight.
B – Incorrect: The instance, even with the ABORT_SERVER configuration, was not expelled from the cluster after the interruption.
C – Correct: After starting the host3 instance, it was reintegrated into the cluster again.
D – Incorrect: Failure on host1 will not cause an interruption, host2 will still be functioning as primary.
E – Correct: The command “cluster.switchToMultiPrimaryMode()” will fail, since it requires all members of the cluster to be ONLINE.
F – Incorrect: The command “cluster.setPrimaryInstance(<host>:<port>)” will cause an error because it also requires all members to be ONLINE.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
lucasnojimoto
1Â week, 1Â day agomarklv
9Â months, 3Â weeks agoDhanushka
1Â year, 2Â months ago